Update data into database using wcf service

mounika ymr

9y1k

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/

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Sharma9y ago
Accepted 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
Ankit Sharma9y ago
Hi Mounika,

I have attached the .aspx and .aspx.cs file.

Please check.
mounika ymr9y ago
Hi Ankith Sharma,

The problem I'm facing is with .aspx and .aspx.cs will u pls send me
Ankit Sharma9y ago
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(UserID,UserName,Password,Country,Email) 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 ymr9y ago
Database has 5 Columns:
SqlCommand cmd = new SqlCommand("insert into RegistrationTable(UserID,UserName,Password,Country,Email) 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 Sharma9y ago
Hi Mounika,

if you are using this SQL command

insert into RegistrationTable(UserName,Password,Country,Email) values(@UserName,@Password,@Country,@Email)

then you have to pass values for all the 4 arguments, even if you are passing null also.
mounika ymr9y ago
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 Kaushik9y ago
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;
}

Update data into database using wcf service

Ankit Sharma,