Update data into database using wcf service

Question

Hi I've gone through post by rohatash can you provide a post for update and delete data in database using wcf services http://www.c-sharpcorner.com/UploadFile/rohatash/inserting-data-into-database-using-wcf-service/

Ankit Sharma · Answer

Hi Mounika You can check this article by Rohatash http://www.c-sharpcorner.com/UploadFile/rohatash/insert-update-and-delete-data-in-gridview-using-wcf-service/ Hope this helps

Jemmy Jackson James · Answer

I like this answer.

Ankit Sharma · Answer

Hi Mounika I have attached the .aspx and .aspx.cs file. Please check.

mounika ymr · Answer

Hi Ankith Sharma The problem I'm facing is with .aspx and .aspx.cs will u pls send me

Ankit Sharma · Answer

Hi Mounika Please try below code public string InsertUserDetails(UserDetails userInfo) { string Message; SqlConnection con = new SqlConnection( Data Source=.;Initial Catalog=registration;User ID=sa;Password=wintellect ); con.Open(); SqlCommand cmd = new SqlCommand( insert into RegistrationTable(UserIDUserNamePasswordCountryEmail) values(@UserID@UserName@Password@Country@Email)  con); cmd.Parameters.AddWithValue( @UserID  userInfo.UserID); cmd.Parameters.AddWithValue( @UserName  userInfo.UserName); cmd.Parameters.AddWithValue( @Password  userInfo.Password); cmd.Parameters.AddWithValue( @Country  userInfo.Country); cmd.Parameters.AddWithValue( @Email  userInfo.Email); int result = cmd.ExecuteNonQuery(); if (result == 1) { Message = userInfo.UserName +  Details inserted successfully ; } else { Message = userInfo.UserName +  Details not inserted successfully ; } con.Close(); return Message; } Hope this helps

mounika ymr · Answer

Database has 5 Columns: SqlCommand cmd = new SqlCommand(insert into RegistrationTable(UserIDUserNamePasswordCountryEmail) values(@UserID@UserName@Password@Country@Email) con) in the given link inorder to insert values we need to pass 5 parameters but fields to insert excluded UserId. so I wanted an updated code to insert

Ankit Sharma · Answer

Hi Mounika if you are using this SQL command insert into RegistrationTable(UserNamePasswordCountryEmail) values(@UserName@Password@Country@Email) then you have to pass values for all the 4 arguments even if you are passing null also.

mounika ymr · Answer

Hi Ankit Sharma In the link below I'm getting error at this line :int result = cmd.ExecuteNonQuery(); UserId isnot included in insert command which is taking null values which not acceptable can u send me updated insert method

Rahul Kaushik · Answer

Below is Deleting in WCF public bool delete( int id) { var items= employeeList.First(x = > x.employeeID== id); employeeList.Remove(item); return true ; } In interface write this [OperationContract] bool delete( int id); in page.aspx.cs write this inside function bool chck = object.delete(userid); if(chck==true) { perform function; } else { Error message or ViewBag; }