Update table record

[Alan]

I want to update an employee's name, here's my code:
public void Save(int aEmployeeID, string aFirstame, string aLastname)

{

SqlDataAdapter DaEmployee;

DataSet DsEmployee;

// _Conn is instantiated in constructor
DaEmployee = new SqlDataAdapter("UPDATE employee " +

"SET
firstname = " + aFirstname + ", lastname = " + aLastname +

" WHERE
employeeID = " + aEmployeeID.ToString(), _Conn);

DsEmployee = new DataSet();

DaEmployee.Fill(DsEmployee, "employee");

.........................................

}

[Peter Bromberg [C# MVP]]

Alan,
This will never get you to "First base". The DataAdapter "Fill" method is
only for populating a DataSet with the results of a SELECT query. You want to
use the DataAdapter's "Update" method, and supply a valid Update Command,
along with any other SqlCommands that are necessary.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Alan" wrote:

I want to update an employee's name, here's my code:
public void Save(int aEmployeeID, string aFirstame, string aLastname)

{

SqlDataAdapter DaEmployee;

DataSet DsEmployee;

// _Conn is instantiated in constructor
DaEmployee = new SqlDataAdapter("UPDATE employee " +

"SET
firstname = " + aFirstname + ", lastname = " + aLastname +

" WHERE
employeeID = " + aEmployeeID.ToString(), _Conn);

DsEmployee = new DataSet();

DaEmployee.Fill(DsEmployee, "employee");

.........................................

}

[Alan T]

Could you give me few lines of code in my case what should I do please ?

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:3B**********************************@microsof t.com...

Alan,
This will never get you to "First base". The DataAdapter "Fill" method is
only for populating a DataSet with the results of a SELECT query. You want
to
use the DataAdapter's "Update" method, and supply a valid Update Command,
along with any other SqlCommands that are necessary.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Alan" wrote:

I want to update an employee's name, here's my code:
public void Save(int aEmployeeID, string aFirstame, string aLastname)

{

SqlDataAdapter DaEmployee;

DataSet DsEmployee;

// _Conn is instantiated in constructor
DaEmployee = new SqlDataAdapter("UPDATE employee " +

"SET
firstname = " + aFirstname + ", lastname = " + aLastname +

" WHERE
employeeID = " + aEmployeeID.ToString(), _Conn);

DsEmployee = new DataSet();

DaEmployee.Fill(DsEmployee, "employee");

.........................................

}