i want to update perticular row of grid ....
means on save button i was written insert query but when i want to update then update query is also written in save button but it not update record...it generate new record....
so how can i check condition of insert or update???
plz help me.....
thanks in advance.
my code is:-
public void SysATPLProcSave()
{
string firstname = TxtATFistName.Text.Trim();
string middlename = TxtATMiddleName.Text.Trim();
string lastname = TxtATLastName.Text.Trim();
string mail = TxtATEmail.Text.Trim();
string homeaddress = TxtATHomeAddress.Text;
string homecity = TxtATHomeCity.Text.Trim();
string homestate = TxtATHomeState.Text.Trim();
string homezipcode = TxtATHomeZipcode.Text.Trim();
string homecountry = TxtATHomeCountry.Text.Trim();
string homephone = TxtATHomePhone.Text.Trim();
string homefax = TxtATHomeFax.Text.Trim();
string homemobile = TxtATHomeMobile.Text.Trim();
string businesscompany = TxtATBusinessCompany.Text.Trim();
string businessaddress = TxtATBusinessAddress.Text;
string businesscity = TxtATBusinessCity.Text.Trim();
string businesstate = TxtATBusinessState.Text.Trim();
string businesszip = TxtATBusinessZip.Text.Trim();
string businesscountry = TxtATBusinessCountry.Text.Trim();
string businessjob = TxtATBusinessJob.Text.Trim();
string businessdepartment = TxtATBusinessDepartment.Text.Trim();
string businessoffice = TxtATBusinessOffice.Text.Trim();
string businessphone = TxtATBusinessPhone.Text.Trim();
string businessfax = TxtATBusinessFax.Text.Trim();
string contactlist = "INSERT INTO QAFranchise.HDR_CONTACT_LIST(PROFILE_ID,CONTACT_LIST_ID,CONTACT_FIRST_NAME,CONTACT_MIDDLE_NAME,CONTACT_LAST_NAME,CONTACT_EMAIL,CONTACT_HOME_STREET_ADDRESS,CONTACT_HOME_CITY,CONTACT_HOME_STATE_PROVINCE,CONTACT_HOME_ZIP_CODE,CONTACT_COUNTRY_REGION,CONTACT_HOME_PHONE,CONTACT_HOME_FAX,CONTACT_HOME_MOBILE,CONTACT_COMPANY_NAME,CONTACT_BUSINESS_STREET_ADDRESS,CONTACT_BUSINESS_CITY,CONTACT_BUSINESS_STATE_PROVINCE,CONTACT_BUSINESS_ZIP_CODE,CONTACT_BUSINESS_COUNTRY_REGION,CONTACT_BUSINESS_JOB_TITLE,CONTACT_BUSINESS_DEPARTMENT,CONTACT_BUSINESS_OFFICE,CONTACT_BUSINESS_PHONE,CONTACT_BUSINESS_FAX,ADD_USER_ID,ADD_USER_DATE) " +
"Values(59,QAFranchise.GET_CONTACT_LIST_ID(59),'" + firstname + "','" + middlename + "','" + lastname + "','" + mail + "','" + homeaddress + "','" + homecity + "','" + homestate + "','" + homezipcode + "','" + homecountry + "','" + homephone + "','" + homefax + "','" + homemobile + "','" + businesscompany + "','" + businessaddress + "','" + businesscity + "','" + businesstate + "','" + businesszip + "','" + businesscountry + "','" + businessjob + "','" + businessdepartment + "','" + businessoffice + "','" + businessphone + "','" + businessfax + "',1,getdate())";
SqlCommand cmd = new SqlCommand(contactlist, cn);
cmd.ExecuteNonQuery();
}
cant take update button so want to make two operation on single button so plz help me.....
string contactlist = "update QAFranchise.HDR_CONTACT_LIST where CONTACT_FIRST_NAME='" + TxtATFistName.Text + "',CONTACT_MIDDLE_NAME='" + TxtATMiddleName.Text + "',CONTACT_LAST_NAME='" + TxtATLastName.Text + "',CONTACT_EMAIL='" + TxtATEmail.Text + "',CONTACT_HOME_STREET_ADDRESS='" + TxtATHomeAddress.Text + "',CONTACT_HOME_MOBILE='" + TxtATHomeMobile.Text + "'";
SqlCommand cmd1 = new SqlCommand(contactlist, cn);
cmd1.ExecuteNonQuery();
edit button is also here but first i select edit button then select row of grid then that row data comes into textboxes and then i save(update ) data so i was writeen update query into save button but there also insert query so double data insert into table so how can i check condition????
we cannot take hiddenfeild and set value=0 bcoz i my table multiple value so i can select any one so we cant use...
so plz give me another solution.....
plz plz help me.