Using LOAD DATA INFILE in ASP.NET 2005

[ITCraze]

Hello everyone,

I have used load data infile in my ASP.NET Project to import the csv file data to my database.

For ex: my database contains : name address id fields.

But my text file contains only name and address , so these two fields sucessfully get imported to the database but now what I have to do is to add id value for that imported row.

I have used:


MySqlCommand loadcmd = new MySqlCommand("LOAD DATA INFILE '" + txtfilename.Text + "' into Table temporarytable fields terminated by ','lines terminated by '\n'(name,address),cn);

//loadcmd.ExecuteNonQuery();


MySqlCommand updatecmd = new MySqlCommand("UPDATE temporarytable SET BranchId='"+ddlBranchName.SelectedItem.Value+"', cn);

loadcmd.ExecuteNonQuery();
//insertcmd.ExecuteNonQuery();
updatecmd.ExecuteNonQuery();

Actually I am stuck that in update query , that what I should use in Where clause. If you all can suggest that what should I do , please help.