insert values via web service in asp.net using c#

Question

please help me to insert values to database through webservice in asp.net c#

Amit Choudhary · Answer

hi friend, Add a webservice file in your project. Create a webmethod in a your class file and add that class file name and namespace to your webservice .asmx file. public class Service1 : System.Web.Services.WebService { [System.Web.Services.WebMethod( TransactionOption=TransactionOption.RequiresNew)] public string DoSomethingTransactional() { MySQLCommand command = new MySQLCommand(); command.CommandText = "insert into race values (" + race_number + ",'" + race_date_time + "','" + start_time + "','" + end_time + "')"; Sql_Conn.ConnectionString = "Server=10.110.96.180;Port=3306;Data Source=bike_demo;User Id=root;Password=utdmashup;"; Sql_Conn.Open(); command.Connection=Sql_Conn; int res=command.ExecuteNoQuery(); // The transaction was successful... if(res!=0) ContextUtil.SetComplete(); return ContextUtil.TransactionId.ToString(); } } Checkout the link tutorial for full overview of webservices Mark as answer if it helps.

Vasanth · Answer

nelson , we can do insert as like same as which we used in our application with the help of DB helper class. Before that you need to look ADO.NET and implement in web services / Application

insert values via web service in asp.net using c#

Answers (2)