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.