Hi there, First off sorry for long wall of text, I just want to give as much context as possible so someone might be able to help me out. I am trying to create a simple helpdesk/ticket system using xampp/php/odbc/and a text file as my database the issue comes from updating tickets. First time I've done anything with databases. From what I found online I needed to use an ODBC driver to interface my xampp/php side with my text file database. I don't really understand what ODBC does after reading about it for awhile other then it lets various types …

Member Avatar
Member Avatar
+0 forum 4

Hi Is there any possibility to update tuples dynamically(in a :for loop" say) Else is there possiblity to dynamically create a new tuple? Thank you in advance

Member Avatar
Member Avatar
+0 forum 1

I have two fields in table, (i) section_from & (ii) section_to, both fields has Date datatype, these fields tells us that this law section is enforced From(section_from) this date To(section_to) this date. The problem is, the latest law sections (active law) which are issued by the government has no specific To(section_to) date, Means we don't know what is the life of this law section maybe it is never changed from start to up-to-day or maybe government thinks after two months that this law section should be omitted or changed. Question: Is there anyway that, i mark the rows by ( …

Member Avatar
Member Avatar
+0 forum 3

guys i need ur help i want to insert data directly into the sql table using c# here is my code all that i have been able to do is get the values from the table not insert them i tried to do it this way but apprently there is some thing wrong with this code plz help me out string sConnectionString = "Data Source=localhost;Initial Catalog=ScratchCardSystem2;Integrated Security=True;pooling=true"; SqlConnection objConn = new SqlConnection(sConnectionString); objConn.Open(); string query = "SELECT * FROM store_adj_note_detail_1"; SqlDataAdapter dAdapter = new SqlDataAdapter(query,objConn); SqlCommandBuilder cBuilder = new SqlCommandBuilder(dAdapter); DataTable dTable = new DataTable(); //fill the DataTable dAdapter.Fill(dTable); //the …

Member Avatar
Member Avatar
+0 forum 1

Hi, i am having problem in updating my database although i can upadate my dataset private void btnSave_Click(object sender, EventArgs e) { DataRow dRow = ds1.Tables["ContainerID"].NewRow(); dRow[1] = textBox1.Text; dRow[2] = textBox2.Text; dRow[3] = textBox3.Text; ds1.Tables["ContainerID"].Rows.Add(dRow); MaxRows = MaxRows + 1; inc = MaxRows - 1; MessageBox.Show("Entry Added"); } but while updating database it gives an error The ConnectionString property has not been initialized. private void btnSave_Click(object sender, EventArgs e) { System.Data.SqlClient.SqlCommandBuilder cb; cb = new System.Data.SqlClient.SqlCommandBuilder(da); DataRow dRow = ds1.Tables["ContainerID"].NewRow(); dRow[1] = textBox1.Text; dRow[2] = textBox2.Text; dRow[3] = textBox3.Text; ds1.Tables["ContainerID"].Rows.Add(dRow); MaxRows = MaxRows + 1; inc = MaxRows - …

Member Avatar
Member Avatar
+0 forum 5

Here I am Sending you my code ,wherein I want to have total of examfees(column),PromotionFees(column),Totalfees(column) and Balance(column).Examfees are paid in installment in my project The idea if single record is found then it doing calculation of balance=promotionfees-totlafees and if anywhere due to mistyping is value is higher then the respectively msgbox displays error.For single record it is working fine even when I update values in Datagridview.balance shown correctly. But issues is when there are multirecords:when I am doing total of all the row value in promotionfees(column) in totalfees(column) now balance also should show correctly that is happening fine.But when I …

Member Avatar
+0 forum 0

Bios update it is important?

Member Avatar
Member Avatar
+0 forum 2

i have a netbook .an hp mini 110-3713tu i've try to update the bios.the result was failed.now my netbook won't have a power due to the bios update failed.how to recover it?pls help me...

Member Avatar
Member Avatar
+0 forum 2

//When i click the update button to update record in database,i get following error : " String or binary data would be truncated. The statement has been terminated." plz help me to solve this problem using System; using System.Collections; using System.Configuration; using System.Web.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.Data.Sql; using System.Data.SqlTypes; public partial class UpdateCatA : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { FillList(); } } private void FillList() { DropDownList1.Items.Clear(); // Define the Select statement. // Three pieces …

Member Avatar
Member Avatar
+0 forum 3

void doc::add_title() { doc d; fstream f; int med_lic,flag=0; char new_title[20]; cout<<"\n\t\t\tADD NEW DOCTOR TITLE\n"; cout<<"\nEnter the Doctor's medical license number :\t"; cin>>med_lic; f.open("doctors.da t", ios::binary|ios::in|ios::out); while(f.read((char*)&d,sizeof(doc))&&flag==0) { if(d.ret_med_no()==med_lic) //d is an object of class doc { cout<<"\nEnter the new title:\t";//ret_med_no() is an accessor function used to return a value used to find a record. gets(new_title); strcat(title,new_title);//title is a private member of class doc.new title is to be added next to this one. int pos=(-1)*sizeof(doc); f.seekp(pos,ios::cur); f.write((char*)&d,sizeof(doc)); flag=1; } else f.write((char*)&d,sizeof(doc)); f.close(); if(flag==0) cout<<"\nRecord not found.\n"; } } # The concept # This function is a part of the program …

Member Avatar
Member Avatar
+0 forum 1

Alright so I was not sure exactly how to say this, but here is the idea. I have a graph or table I guess you could call that looks like this. [CODE] print ''' ----------------------------- | | | |x | | | |----------------------------- ''' [/CODE] Then I want to make a change to where x is for example moving it down twice. How would I go about this without having the first table appear?

Member Avatar
Member Avatar
+0 forum 8

How to deactivate updating of microsoft office 2010

Member Avatar
Member Avatar
+0 forum 2

Hi all, I wrote this somewhat simple script that is suppose to change and update polygon GRIDCODES based some rules. The shapefile is reclassified into likelihood of conversion. So the code is set up to get the GRIDCODE value of all adjacent polygons to the cursor polygon. I put these in a list, sort the codes, and assign a variable to the largest value. I then count the number of times this large variable occurs. If it occurred 4 or more times AND the large value is greater than the cursor gridcode, I want to update the cursor to the …

Member Avatar
Member Avatar
+0 forum 1

So this is my problem my fellow programmers: In my C# app, I have one button and a datagrid that is showing info from a sql table. Everytime I add a person into my datagrid, the data replicates instead of updating certain columns for that member. I need to somehow distinguish between inserting a new member, and updating an existing member inside my datagrid. Below is two methods that are called once the UPDATE button is clicked. Does anyone know how to solve this irritating issue/ see a problem with my code??? Thanks in advance! private void findMember() { sql …

Member Avatar
Member Avatar
+0 forum 4

The End.