How to insert Null value to Data Base using C# in ASP.Net

Question

HiI have a table in Sql server 2008 named called table1 and data come in this table through the windows application now problem is that I donrsquot know the value how many data value for a particular row sometime it might be one and sometime it might be fiveIDNameData 1Data 2Data 3Data 4Data 51A10203040502B1020NullNullNull3C102030Nullnull

AnandM · Accepted Answer

Hi appguruz16I have created a sample which fullfill your requirementHTMLltdivgt    lttablegt        lttrgt            lttdgt                ltaspLabel Text34ID34 runat34server34 gt            lttdgt            lttdgt                ltaspTextBox ID34txtID34 runat34server34 gt            lttdgt        lttrgt        lttrgt            lttdgt                ltaspLabel Text34NAME34 runat34server34 gt            lttdgt            lttdgt                ltaspTextBox ID34txtName34 runat34server34 gt            lttdgt        lttrgt        lttrgt            lttdgt                ltaspLabel Text34DATA134 runat34server34 gt            lttdgt            lttdgt                ltaspTextBox ID34txtData134 runat34server34 gt            lttdgt        lttrgt        lttrgt            lttdgt

ID	NAME	DATA1	DATA2	DATA3	DATA4	DATA5
1	A	10	20	30	Null	Null
2	B	40	50	60	70	80

How to insert Null value to Data Base using C# in ASP.Net

Company

Explore

Follow us

Contact Us

ID	Name	Data 1	Data 2	Data 3	Data 4	Data 5
1	A	10	20	30	40	50
2	B	10	20	Null	Null	Null
3	C	10	20	30	Null	null