To Update a cell in system.data.datatable you could try to use
system.DBNull.value.
Hope this helps.
_________________________________________________
www.premiumxl.com - German Developer / SEO Forum
groups.google.com/group/codingxl - Developer Discussions
On 16 Sep., 19:33, henry <[EMAIL PROTECTED]> wrote:
> can anyone please tell me what i'm doing wrong?
>
> cell2=0;
> if (Request["update"] == "Save Changes")
> {
> foreach (string var in Request.Form)
> {
> if (var == "pcgcomment" + cell2 + "")
> {
>
> if (Request.Form[var] == "")
> {
>
> }
> else
> {
>
> DSc.Tables[0].Rows[cell2]
> ["pcg_Comments"] = Request.Form[var].ToString();
> command2 = new OleDbCommand("update dbo.divAwards set
> divAwards.pcg_Comments =" + Request.Form[var] + " where divAwards.id
> =" + DSc.Tables[0].Rows[cell2]["ID"] + "", connc);
> DAc.UpdateCommand = command2;
> DAc.Update(DSc);
>
> }
> cell2++;
> }
>
> also, how can I update a cell value on a table to null value?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
