regarding datatable..

Question

hi friends.. how to insert a value in a datatable during runtime..(ex;hi) i want coding for that in vb.. i am doing this in windows application.. its urgent.. regards gopal

Rajendra Deopura · Answer

Dear The following code helps you to add new row in a datatable at run time : Dim ds As New DataSet Dim dt As New DataTable(Student) Dim dc1 As New DataColumn(FirstNameSystem.Type.GetType(String)) Dim dc2 As New DataColumn(LastName System.Type.GetType(String)) dt.Columns.Add(dc1) dt.Columns.Add(dc2) ds.Tables.Add(dt) Dim table As DataTable = ds.Tables(0) Dim row As DataRow = table.NewRow row(0) = Rajendra row(1) = Deopura dt.Rows.Add(row)

Manish Dwivedi · Answer

Hi By using this code u can add the text during runtime. DataSet tempDS = ds1; DataColumn dcQuestionStatus = new DataColumn ( QuestionStatus  typeof ( string )); DataColumn dcGivenAnswer = new DataColumn ( GivenAnswer  typeof ( string )); DataColumn dcAnswerStatus = new DataColumn ( AnswerStatus  typeof ( string )); tempDS.Tables[0].Columns.Add(dcQuestionStatus); tempDS.Tables[0].Columns.Add(dcGivenAnswer); tempDS.Tables[0].Columns.Add(dcAnswerStatus); foreach ( DataRow row in tempDS.Tables[0].Rows) { row[ QuestionStatus ] = NoStatus ; row[ GivenAnswer ] =  ; row[ AnswerStatus ] =  ; } Happy Coding!!