You will need to put explict in the code or you can change and put this in the constructor of the class.
On Fri, Mar 8, 2013 at 9:10 AM, Suraj <suraj....@gmail.com> wrote: > Hi frens, > I have created a table in SQL server with 10 columns with char > datatype with default value ' ' (empty). > > For the table, i insert values into 6 columns using the below code in > c# using linq > > tblRecordType1 objtblRecordType1 = new tblRecordType1(); > objtblRecordType1.AccountNumber = 1233; > objtblRecordType1.AccountNumber2 = 1233; > objtblRecordType1.AccountNumber3 = 1233; > objtblRecordType1.AccountNumber4 = 1233; > > objReadTextFileDataContext.tblRecordType1s.InsertOnSubmit(objtblRecordType1); > objReadTextFileDataContext.SubmitChanges(); > > The above code will insert records into 4 columns only. > > since, I had set default value to ' ' for all columns, I expected the > remaining 6 columns to have ' '. But, here they have null. > > Can you please have a look and advice. > > Regards, > Suraj > > -- > -- > 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 dotnetdevelopment@googlegroups.com > To unsubscribe from this group, send email to > dotnetdevelopment+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > > --- > 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 unsubscribe from this group and stop receiving emails from it, send an > email to dotnetdevelopment+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Rene Felix Correa Analista Desenvolvedor http://renefc3.wordpress.com -- -- 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 dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net --- 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 unsubscribe from this group and stop receiving emails from it, send an email to dotnetdevelopment+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.