Add DataRow into DataTable in C#

Question

Sir I need your help in how can Add DataRow into DataTable in C#. Please Take a look to the comboBox Fill Function below. Please correct it. DataTable dtbl = new DataTable(); dtbl=SpEmployeeId.ViewEmployeeIdbyEmployeeNameReport(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString())); DataRow dRow = dtbl.NewRow(); dRow[employeeId] = All dtbl.Rows.InsertAt(dRow 0); cmbEmployee.DataSource = dtbl; cmbEmployee.DisplayMember = employeeNo; cmbEmployee.ValueMember = employeeId; My comboBox is to be look like:- All 2 1 4 8 5 3

kiran k · Answer

DataTable dataTable = new DataTable(); dataTable.Columns.Add(JOB_ID); dataTable.Columns.Add(JOB_TITLE); dataTable.Columns.Add(MIN_SALARY); dataTable.Columns.Add(MAX_SALARY); DataRow row = null; //Accessing DbContext object studyEntities1 sdContext = new studyEntities1(); // access DBContext object for your database //get the records of JOBS table var query = (from j in sdContext.JOBS.AsEnumerable() orderby j.MIN_SALARY ascending select j); foreach (var rowObj in query) { row = dataTable.NewRow(); dataTable.Rows.Add(rowObj.JOB_ID rowObj.JOB_TITLE rowObj.MIN_SALARY rowObj.MAX_SALARY); }

Vulpes · Answer

Try: DataTable dtbl = null; dtbl=SpEmployeeId.ViewEmployeeIdbyEmployeeNameReport(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString())); DataColumn col = new DataColumn(strEmployeeNo typeof(string)); dtbl.Columns.Add(col); for (int i = 0; i { dtbl.Rows[i][strEmployeeNo] = dtbl.Rows[i][employeeNo].ToString(); } DataRow dRow = dtbl.NewRow(); dRow[strEmployeeNo] = All; dtbl.Rows.InsertAt(dRow 0); cmbEmployee.DataSource = dtbl; cmbEmployee.DisplayMember = strEmployeeNo; cmbEmployee.ValueMember = employeeId;

Sunny Sharma · Answer

Hi Bineesh Here's a sample code for you: ------------------------------------------------------ DataTable dt = new DataTable (); dt.Columns.Add( RecordNo ); dt.Rows.Add(dt.NewRow()[ RecordNo ] = All ); for ( int i = 1; i { DataRow dr = dt.NewRow(); dr[ RecordNo ] = i.ToString(); dt.Rows.Add(dr); } comboBox1.DataSource = dt; comboBox1.DisplayMember = RecordNo ; ------------------------------------------------------ HTH :)

Hanook · Answer

Sample code for adding DataRow into a dataTable DataTable dataTable = new DataTable(); dataTable.Columns.Add(JOB_ID); dataTable.Columns.Add(JOB_TITLE); dataTable.Columns.Add(MIN_SALARY); dataTable.Columns.Add(MAX_SALARY); DataRow row = null; //Accessing DbContext object studyEntities1 sdContext = new studyEntities1(); // access DBContext object for your database //get the records of JOBS table var query = (from j in sdContext.JOBS.AsEnumerable() orderby j.MIN_SALARY ascending select j); foreach (var rowObj in query) { row = dataTable.NewRow(); dataTable.Rows.Add(rowObj.JOB_ID rowObj.JOB_TITLE rowObj.MIN_SALARY rowObj.MAX_SALARY); }