|
|
You're in the
dotnet windows forms databinding
group:Default value of a GUID field?!
dotnet windows forms databinding:
I have a column named "ID" and its type is "uniqueidentifier" in SQL Server
2005 Express. this column is the primary key and its default value is "newid()" in SQL Server. I have generated a DataSet in C# that has this column but its default value is DBNull what can I do to make the default value be the return value of this function ( or I want the Id be generated by default in the DataSet)? System.Guid.NewGuid()
Hi,
[quoted text, click to view] "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message news:Ol1XaNM%23GHA.3352@TK2MSFTNGP03.phx.gbl... >I have a column named "ID" and its type is "uniqueidentifier" in SQL Server >2005 Express. > this column is the primary key and its default value is "newid()" in SQL > Server. > > I have generated a DataSet in C# that has this column but its default > value is DBNull what can I do to make the default value be the return > value of this function ( or I want the Id be generated by default in the > DataSet)? If you are using VB/VC#2005 then attach an eventhandler to DataTable.TableNewRow to set a Guid.NewGuid. HTH, Greetings [quoted text, click to view] > > System.Guid.NewGuid() >
I have attached this handler but when the user goes to the last (empty) row
of the grid and then leaves this fake data row an error is reported and DataGrid does detect that the user hasnt entered any value and the row should be dissmissed!? how to correct this problem? [quoted text, click to view] "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message news:R790h.150224$Lj6.2582627@phobos.telenet-ops.be... > Hi, > > "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message > news:Ol1XaNM%23GHA.3352@TK2MSFTNGP03.phx.gbl... >>I have a column named "ID" and its type is "uniqueidentifier" in SQL >>Server 2005 Express. >> this column is the primary key and its default value is "newid()" in SQL >> Server. >> >> I have generated a DataSet in C# that has this column but its default >> value is DBNull what can I do to make the default value be the return >> value of this function ( or I want the Id be generated by default in the >> DataSet)? > > If you are using VB/VC#2005 then attach an eventhandler to > DataTable.TableNewRow to set a Guid.NewGuid. > > HTH, > Greetings > >> >> System.Guid.NewGuid() >> > >
Hi,
[quoted text, click to view] "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message news:eE6FVEz%23GHA.3952@TK2MSFTNGP03.phx.gbl... >I have attached this handler How did you implement the handler ? [quoted text, click to view] > but when the user goes to the last (empty) row of the grid and then leaves > this fake data row an error is reported and DataGrid does detect that the > user hasnt entered any value and the row should be dissmissed!? > If the user enters the empty row and then leaves without entering any data then the row should be dismissed and attaching an eventhandler to TableNewRow for setting a new guid doesn't seem to prevent this. And are you using a DataGrid or DataGridView ? HTH, greetings [quoted text, click to view] > how to correct this problem? > > "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message > news:R790h.150224$Lj6.2582627@phobos.telenet-ops.be... >> Hi, >> >> "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message >> news:Ol1XaNM%23GHA.3352@TK2MSFTNGP03.phx.gbl... >>>I have a column named "ID" and its type is "uniqueidentifier" in SQL >>>Server 2005 Express. >>> this column is the primary key and its default value is "newid()" in SQL >>> Server. >>> >>> I have generated a DataSet in C# that has this column but its default >>> value is DBNull what can I do to make the default value be the return >>> value of this function ( or I want the Id be generated by default in the >>> DataSet)? >> >> If you are using VB/VC#2005 then attach an eventhandler to >> DataTable.TableNewRow to set a Guid.NewGuid. >> >> HTH, >> Greetings >> >>> >>> System.Guid.NewGuid() >>> >> >> > >
Hi,
[quoted text, click to view] "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message news:%23G5%23dsC$GHA.3312@TK2MSFTNGP02.phx.gbl... > the function implementation is this: > > void TableGroups_TableNewRow(object sender, DataTableNewRowEventArgs e) > > { > > (e.Row as DataSetGroups.TableGroupsRow).ID = Guid.NewGuid(); > > } Looks ok to me, you're saying that this code is causing the problems with the DGV ? Greetings [quoted text, click to view] > > "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message > news:UX%0h.154783$aZ2.2552974@phobos.telenet-ops.be... >> Hi, >> >> "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message >> news:eE6FVEz%23GHA.3952@TK2MSFTNGP03.phx.gbl... >>>I have attached this handler >> >> How did you implement the handler ? >> >>> but when the user goes to the last (empty) row of the grid and then >>> leaves this fake data row an error is reported and DataGrid does detect >>> that the user hasnt entered any value and the row should be dissmissed!? >>> >> >> If the user enters the empty row and then leaves without entering any >> data then the row should be dismissed and attaching an eventhandler to >> TableNewRow for setting a new guid doesn't seem to prevent this. >> >> And are you using a DataGrid or DataGridView ? >> >> HTH, >> greetings >> >>> how to correct this problem? >>> >>> "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message >>> news:R790h.150224$Lj6.2582627@phobos.telenet-ops.be... >>>> Hi, >>>> >>>> "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message >>>> news:Ol1XaNM%23GHA.3352@TK2MSFTNGP03.phx.gbl... >>>>>I have a column named "ID" and its type is "uniqueidentifier" in SQL >>>>>Server 2005 Express. >>>>> this column is the primary key and its default value is "newid()" in >>>>> SQL Server. >>>>> >>>>> I have generated a DataSet in C# that has this column but its default >>>>> value is DBNull what can I do to make the default value be the return >>>>> value of this function ( or I want the Id be generated by default in >>>>> the DataSet)? >>>> >>>> If you are using VB/VC#2005 then attach an eventhandler to >>>> DataTable.TableNewRow to set a Guid.NewGuid. >>>> >>>> HTH, >>>> Greetings >>>> >>>>> >>>>> System.Guid.NewGuid() >>>>> >>>> >>>> >>> >>> >> >> > >
the function implementation is this:
void TableGroups_TableNewRow(object sender, DataTableNewRowEventArgs e) { (e.Row as DataSetGroups.TableGroupsRow).ID = Guid.NewGuid(); } [quoted text, click to view] "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message news:UX%0h.154783$aZ2.2552974@phobos.telenet-ops.be... > Hi, > > "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message > news:eE6FVEz%23GHA.3952@TK2MSFTNGP03.phx.gbl... >>I have attached this handler > > How did you implement the handler ? > >> but when the user goes to the last (empty) row of the grid and then >> leaves this fake data row an error is reported and DataGrid does detect >> that the user hasnt entered any value and the row should be dissmissed!? >> > > If the user enters the empty row and then leaves without entering any data > then the row should be dismissed and attaching an eventhandler to > TableNewRow for setting a new guid doesn't seem to prevent this. > > And are you using a DataGrid or DataGridView ? > > HTH, > greetings > >> how to correct this problem? >> >> "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message >> news:R790h.150224$Lj6.2582627@phobos.telenet-ops.be... >>> Hi, >>> >>> "Leon_Amirreza" <amirreza_rahmaty@yahoo.com> wrote in message >>> news:Ol1XaNM%23GHA.3352@TK2MSFTNGP03.phx.gbl... >>>>I have a column named "ID" and its type is "uniqueidentifier" in SQL >>>>Server 2005 Express. >>>> this column is the primary key and its default value is "newid()" in >>>> SQL Server. >>>> >>>> I have generated a DataSet in C# that has this column but its default >>>> value is DBNull what can I do to make the default value be the return >>>> value of this function ( or I want the Id be generated by default in >>>> the DataSet)? >>> >>> If you are using VB/VC#2005 then attach an eventhandler to >>> DataTable.TableNewRow to set a Guid.NewGuid. >>> >>> HTH, >>> Greetings >>> >>>> >>>> System.Guid.NewGuid() >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |