hi everbody.........

this code i pick from grauva khanna...
it working..but for one coulmn only..
my question is ..how to manipulate every column with dbnull.value

      'If TextBox1.Text.Trim = "" And TextBox2.Text.Trim = "" And TextBox3.Text.Trim = "" And TextBox4.Text.Trim = "" Then
        'DT.Rows.Add(DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value)

        'ElseIf Not TextBox1.Text.Trim = "" And Not TextBox2.Text.Trim = "" And Not TextBox3.Text.Trim = "" And Not TextBox4.Text.Trim = "" Then
        'DT.Rows.Add(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text)

        'ElseIf TextBox1.Text.Trim = "" And Not TextBox1.Text.Trim = "" And TextBox2.Text.Trim = "" And Not TextBox2.Text.Trim = "" Then
        'DT.Rows.Add(DBNull.Value, TextBox1.Text, DBNull.Value, TextBox4.Text)

        '' ElseIf Not TextBox3.Text.Trim = "" And TextBox3.Text.Trim = "" And Not TextBox4.Text.Trim = "" And TextBox4.Text.Trim = "" Then
        'DT.Rows.Add(TextBox1.Text, DBNull.Value, TextBox3.Text, DBNull.Value)

        ' End If

thank.............

Whichever the column gives error just change it as "DBNull.Value.Tostring"

---

U.PARANTHAMAN

Simply you can add a row and no need to mention with column names...

dim My_Row as datarow

For F11 As Integer = 0 To 40

My_Row = Dt.NewRow

Dt.Rows.Add(My_Row)

Next

---

U.PARANTHAMAN

thank Paramu....for your feedback


i have 13 column in dtgridview and 13 textbox for key in data.

BUT sometimes i need the certain cell(column) is NULL or EMPTY

ERROR is coming whenthe textbox is NULL ..error message"could'not store

let said the textbox7 is NULL for row1 and NOT null at row2 ..(how to assign the my textbox.text to My_Row)

give idea..

Whichever the column gives error just change it as "DBNull.Value.Tostring"

---

U.PARANTHAMAN

hai paramu........
give example..please.