Adding information to a DataTable using textfields

Question

Hey guys I am working on a project where I need to create my own employee management system. I created a datatable and connected it to my datagridview. I need to allow the user to add information to the system. For this I added multiple text boxes (ID Name Contact_Number...etc) How do I get to add the information entered by the user to enter the datatable/datagridview (or both). Thanks in advance :)

Gaurav Kumar · Answer

this may help you. http://www.c-sharpcorner.com/UploadFile/9f0ae2/gridview-edit-delete-and-update-in-Asp-Net/

Gaurav Kumar · Answer

Dear Nikita I suggest you to go through some tutorials to insert data into database through textboxes. It'd be good for you for the road ahead you'll get in future. There is no one in this forum or any where else can teach you until you wish to learn. This sentence may hurt you but I can't keep away you from the truth. So better if you'd go through some tutorials by google them. there are lots of tutorials. We all are here to ask learn and share the information and our experience but sorry no one can do your work. One more link you can get for binding the grid in windows form as below http://www.aspdotnet-suresh.com/2014/12/bind-data-to-datagridview-in-windows-application-in-csharp-vbnet.html

Nikita Sudhir · Answer

Nope. I've used the code you've given. Populating the table works adding doesn't. I'm getting this: An unhandled exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll Additional information: There is no row at position 0.

Manas Mohapatra · Answer

Comment out that line because you are using Windows application. Secondly for adding new records to Data table follow below code: public partial class Form1 : Form { DataTable dtCurrentTable = new DataTable(); public Form1() { //Load data to dtCurrentTable datatable and Bind data to grid // Write up your logic InitializeComponent(); } private void button1_Click_1(object sender EventArgs e) { DataRow drCurrentRow = null; drCurrentRow = dtCurrentTable.NewRow(); dtCurrentTable.Rows[dtCurrentTable.Rows.Count][ID] = ID.Text; dtCurrentTable.Rows[dtCurrentTable.Rows.Count][Name] = Name.Text; dtCurrentTable.Rows[dtCurrentTable.Rows.Count][Contact_Number] = Contact_Number.Text; dtCurrentTable.Rows.Add(drCurrentRow); // Bind datatable to grid dataGrid.DataSource = dtCurrentTable; } }

Nikita Sudhir · Answer

I have no issues with the table. The DataBind() doesn't work for me. It's always an error. I just want to know how to add information from the textfields to the datagrid and possibly append the datatable.

Gaurav Kumar · Answer

Replace this code in side the form_load and run. Do not use public BindingSource . Just try and let us know. DataTable dt = new DataTable(); dt.Columns.Add(Employee_ID typeof(int)); dt.Columns.Add(Employee_Name typeof(string)); dt.Columns.Add(Home_Address typeof(string)); dt.Columns.Add(Date_Of_Joining typeof(string)); dt.Columns.Add(Contact_Number typeof(string)); dt.Columns.Add(Location_InCharge typeof(string)); dt.Columns.Add(Total_Sales typeof(int)); dt.Rows.Add(100 Ashley Loughlin 8 Fergusson Street NSW 2470 24/07/2010 +610267021973 Australia 1000000); dt.Rows.Add(200 Drew D. McCaskill 2070 Hartland Avenue WI 53202 04/12/2007 +192028941061 USA 1073900); dt.Rows.Add(300 Jan Fuerst Boxhagener Str. 14 20535 Hamburg Borgfelde 05/01/2010 +149040813500 Germany 999999); dt.Rows.Add(400 Cristoforo Pisano Via Moiariello 12045-Tagliata CN 24/07/2014 +1393293332496 Italy 500000); dt.Rows.Add(500 Natalia Samuelsson Karlsängen 45 FOTÖ 09/11/2010 +460398658218 Sweden 1009900); dataGridView1.DataSource = dt; dataGridView1.DataBind(); I tried at my end it is working fine.

Nikita Sudhir · Answer

This is my entire code. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.IO; namespace PersonnelSystem { public partial class Form1 : Form { public DataTable dt = new DataTable(); public BindingSource bs = new BindingSource(); public Form1() { InitializeComponent(); } //Automatically loading datatable and datagridview private void Form1_Load(object sender EventArgs e) { dt.Columns.Add(Employee_ID typeof(int)); dt.Columns.Add(Employee_Name typeof(string)); dt.Columns.Add(Home_Address typeof(string)); dt.Columns.Add(Date_Of_Joining typeof(string)); dt.Columns.Add(Contact_Number typeof(string)); dt.Columns.Add(Location_InCharge typeof(string)); dt.Columns.Add(Total_Sales typeof(int)); dt.Rows.Add(100 Ashley Loughlin 8 Fergusson Street NSW 2470 24/07/2010 +610267021973 Australia 1000000); dt.Rows.Add(200 Drew D. McCaskill 2070 Hartland Avenue WI 53202 04/12/2007 +192028941061 USA 1073900); dt.Rows.Add(300 Jan Fuerst Boxhagener Str. 14 20535 Hamburg Borgfelde 05/01/2010 +149040813500 Germany 999999); dt.Rows.Add(400 Cristoforo Pisano Via Moiariello 12045-Tagliata CN 24/07/2014 +1393293332496 Italy 500000); dt.Rows.Add(500 Natalia Samuelsson Karlsängen 45 FOTÖ 09/11/2010 +460398658218 Sweden 1009900); bs.DataSource = dt; dataGridView1.DataSource = bs; } //Exiting the program private void exitToolStripMenuItem_Click(object sender EventArgs e) { Application.Exit(); } //Adding information to the datagridview private void Add_btn_Click(object sender EventArgs e) { } //Deleting the selected record(s) private void Delete_btn_Click(object sender EventArgs e) { foreach (DataGridViewCell oneCell in dataGridView1.SelectedCells) { if (oneCell.Selected) dataGridView1.Rows.RemoveAt(oneCell.RowIndex); } } //Only numbers can be entered in the total sales text field private void Total_Sales_txt_KeyPress(object sender KeyPressEventArgs e) { e.Handled = char.IsNumber(e.KeyChar) || e.KeyChar == 8 ? false : true; } //Clearing text fields private void Clear_btn_Click(object sender EventArgs e) { Employee_ID_txt.Clear(); Employee_Name_txt.Clear(); Home_Address_txt.Clear(); Date_Of_Joining_mtxt.Clear(); Contact_Number_mtxt.Clear(); Location_InCharge_txt.Clear(); Total_Sales_txt.Clear(); } //Saving datagrid view information to an excel file private void saveToolStripMenuItem_Click(object sender EventArgs e) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = Execl files (*.xls)|*.xls; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; saveFileDialog.CreatePrompt = true; saveFileDialog.Title = Export Excel File To; saveFileDialog.ShowDialog(); Stream myStream; myStream = saveFileDialog.OpenFile(); StreamWriter sw = new StreamWriter(myStream System.Text.Encoding.GetEncoding(-0)); string str = ; try { for (int i = 0; i { if (i > 0) { str += 	; } str += dataGridView1.Columns[i].HeaderText; } sw.WriteLine(str); for (int j = 0; j { string tempStr = ; for (int k = 0; k { if (k > 0) { tempStr += 	; } tempStr += dataGridView1.Rows[j].Cells[k].Value.ToString(); } sw.WriteLine(tempStr); } sw.Close(); myStream.Close(); } catch (Exception c) { MessageBox.Show(c.ToString()); } finally { sw.Close(); myStream.Close(); } } //Providing user with the print dialogue box private void printToolStripMenuItem_Click(object sender EventArgs e) { //Open the print dialog PrintDialog printDialog = new PrintDialog(); printDialog.Document = printDocument1; printDialog.UseEXDialog = true; //Get the document if (DialogResult.OK == printDialog.ShowDialog()) { printDocument1.DocumentName = Print; printDocument1.Print(); } } //Allows user to customize form colour. private void customizeToolStripMenuItem_Click(object sender EventArgs e) { colorDialog1.ShowDialog(); //this refers to the form this.BackColor = colorDialog1.Color; } //Opens form 2 private void aboutToolStripMenuItem_Click(object sender EventArgs e) { Form2 f2 = new Form2(); f2.Show(); } //Filtering the name private void Filter_Name_txt_TextChanged(object sender EventArgs e) { dt.DefaultView.RowFilter = string.Format(Employee_Name LIKE '%{0}%' Filter_Name_txt.Text); } //Filtering the location private void Filter_Location_txt_TextChanged(object sender EventArgs e) { dt.DefaultView.RowFilter = string.Format(Location_InCharge LIKE '%{0}%' Filter_Location_txt.Text); } //display selected information into text fields private void dataGridView1_CellContentClick(object sender DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; Employee_ID_txt.Text = row.Cells[Employee_ID].Value.ToString(); Employee_Name_txt.Text = row.Cells[Employee_Name].Value.ToString(); Date_Of_Joining_mtxt.Text = row.Cells[Date_Of_Joining].Value.ToString(); Home_Address_txt.Text = row.Cells[Home_Address].Value.ToString(); Location_InCharge_txt.Text = row.Cells[Location_InCharge].Value.ToString(); Total_Sales_txt.Text = row.Cells[Total_Sales].Value.ToString(); Contact_Number_mtxt.Text = row.Cells[Contact_Number].Value.ToString(); } } //Display employee details who have made past sales of more than one million dollars private void Filter_Sales_btn_Click(object sender EventArgs e) { } } }

Gaurav Kumar · Answer

post your latest code for binding.

Nikita Sudhir · Answer

An unhandled exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll Additional information: There is no row at position 5.

Rajeesh Menoth · Answer

Hi What error you have occured? Are you check that error in google ?

Nikita Sudhir · Answer

It doesn't seem to work... The line where I have to bind the data DataBind() is an error.

Nikita Sudhir · Answer

It doesn't seem to work... The line where I have to bind the data DataBind() is an error.

Rajeesh Menoth · Answer

Hi Nikita Sudhir  Try this one : https://khanrahim.wordpress.com/2010/04/10/insert-update-delete-with-datagridview-control-in-c-windows-application/

Manas Mohapatra · Answer

public partial class Form1 : Form { DataTable dtCurrentTable = new DataTable(); public Form1() { //Load data to dtCurrentTable datatable and Bind data to grid // Write up your logic InitializeComponent(); } private void button1_Click_1(object sender EventArgs e) { DataRow drCurrentRow = null; drCurrentRow = dtCurrentTable.NewRow(); dtCurrentTable.Rows[dtCurrentTable.Rows.Count][ID] = ID.Text; dtCurrentTable.Rows[dtCurrentTable.Rows.Count][Name] = Name.Text; dtCurrentTable.Rows[dtCurrentTable.Rows.Count][Contact_Number] = Contact_Number.Text; dtCurrentTable.Rows.Add(drCurrentRow); // Bind datatable to grid dataGrid.DataSource = dtCurrentTable; dataGrid.DataBind(); } }

Nikita Sudhir · Answer

Could you provide me with the modified code because I didn't understand what you just said. I'm sorry I'm new to this.

Manas Mohapatra · Answer

I assumed that you are using Web Application so I provided Viewstate concept. But Viewstate doesn't work with windows application so you are getting error. In order to resolve problem Declare datatable variable as a public inside class. And delete Veiwstate code and update datatable value in each record addition. This is just a replacement nothing else. Let me know if you face any prob.

Nikita Sudhir · Answer

How do I fix those error lines?

Nikita Sudhir · Answer

Manas Mohapatra · Answer

Below link may help you to understand better. http://www.aspsnippets.com/Articles/Add-new-Row-to-GridView-on-Button-Click-in-ASPNet.aspx

Nikita Sudhir · Answer

Could you please tell me how to set my datatable to viewable? I didn't quite understand that.

Manas Mohapatra · Answer

Hi Nikita As per your requirement you need to add textboxes for ID Name Contact_Number etc.. Step1: Assuming that you have already a datatable and bind that datatable to datagrid. Let's say your datatable(DataTable dt = new DataTable();) which is already used. When you bind datatable to grid please store datatable in Viewstate. //Store the DataTable in ViewState ViewState[CurrentTable] = dt; Step2 : Then you want to add new new record by entering value to testxboxes and click on Add button. When button click event is fired you need to fetch datatable from viewstate and add new record to viewstate. And also update viewstate information for future purpose(add new record). // Checking viewstate value is not NULL if (ViewState[CurrentTable] != null) { DataTable dtCurrentTable = (DataTable)ViewState[CurrentTable]; DataRow drCurrentRow = null; drCurrentRow = dtCurrentTable.NewRow(); dtCurrentTable.Rows[dtCurrentTable.Rows.Count][ID] = ID.Text; dtCurrentTable.Rows[dtCurrentTable.Rows.Count][Name] = Name.Text; dtCurrentTable.Rows[dtCurrentTable.Rows.Count][Contact_Number] = Contact_Number.Text; dtCurrentTable.Rows.Add(drCurrentRow); // Again update Current data table in viewstate for future purpose ViewState[CurrentTable] = dtCurrentTable; // Bind datatable to grid dataGrid.DataSource = dtCurrentTable; dataGrid.DataBind(); }

Nikita Sudhir · Answer

Thanks for the reply but that doesn't help me at all...