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.


Reply via email to