[WebMethod(EnableSession=true)]
public List<Emptab> delete(string ls_pkvalue)
{
List<Emptab> tDataList = new List<Emptab>();
Emptab tdata;
var a = new Array();
a[0] = empno.string;
a[1] = gender;
a[2] = eaddress;
a[3] = street;
try
{
tdata = new Emptab();
string ls_query = "";
ls_query = @"delete ('" + a[0] + "','" + a[1] + "','" + a[2] + "')from emptab ";
odcon = new OdbcConnection(con);
odcon.Open();
comm = new OdbcCommand(ls_query, odcon);
comm.ExecuteNonQuery();
tdata.dsexecstatus = "SUCCESS";
tdata.dsmsg = "Updated Succesfully";
tDataList.Add(tdata);
}
catch (Exception)
{
throw;
}
odcon.Close();
return tDataList;
}
}
}

Nilesh JadavPosted Jul 1, 2015, 8:46 AM
Try these links : http://www.aspsnippets.com/Articles/Select-Insert-Edit-Update-Delete-using-Web-Service-in-ASPNet.aspx
http://www.mindstick.com/Articles/99832454-6f3e-403d-87c5-6c1c5d0a1ebc/Insert%20Delete%20Update%20in%20SQL%20using%20web%20service%20in%20ASP%20NET#.VZPg3FJ1jDc
http://www.asp.net/web-forms/overview/data-access/accessing-the-database-directly-from-an-aspnet-page/inserting-updating-and-deleting-data-with-the-sqldatasource-cs
Vignesh ManiPosted Jul 1, 2015, 8:39 AM