Editing Database Table From Windows App

OK, I have this code in a web service. Trying to update from a client Windows app. Specifically, I need to get the setContacts method working so that it actually updates the table. Right now it does nothing.
[WebMethod]
public DataTable getContacts()
{
using (SqlConnection con = new SqlConnection(connString))
{
DataTable dt = new DataTable("Contacts");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da = new SqlDataAdapter("SELECT * FROM Contacts", con);
da.Fill(dt);
return dt;
};
}
[WebMethod]
public void setContacts(DataTable table)
{
using (SqlConnection con = new SqlConnection(connString))
{
DataTable dt = new DataTable("Contacts");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da = new SqlDataAdapter("SELECT * FROM Contacts", con);
da.Fill(dt);
da.Update(table);
};
}

2 Replies

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

Algo Rhythm16y ago

OK, I have this code in a web service. Trying to update from a client Windows app. Specifically, I need to get the setContacts method working so that it actually updates the table. Right now it does nothing.
[WebMethod]
public DataTable getContacts()
{
using (SqlConnection con = new SqlConnection(connString))
{
DataTable dt = new DataTable("Contacts");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da = new SqlDataAdapter("SELECT * FROM Contacts", con);
da.Fill(dt);
return dt;
};
}
[WebMethod]
public void setContacts(DataTable table)
{
using (SqlConnection con = new SqlConnection(connString))
{
DataTable dt = new DataTable("Contacts");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da = new SqlDataAdapter("SELECT * FROM Contacts", con);
da.Fill(dt);
da.Update(table);
};
}
Lalit M16y ago
you will get some idea from this link to edit database

http://www.codeproject.com/KB/architecture/DataModifierFramework.aspx