Adding information to a DataTable using textfields

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

Comment out that line because you are using Windows application.

 

Secondly for  adding new records to Data table follow below code:

 

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.  

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.

 

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 < dataGridView1.ColumnCount; i++)

{

if (i > 0)

{

str += "\t";

}

str += dataGridView1.Columns[i].HeaderText;

}

sw.WriteLine(str);

for (int j = 0; j < dataGridView1.Rows.Count; j++)

{

string tempStr = "";

for (int k = 0; k < dataGridView1.Columns.Count; k++)

{

if (k > 0)

{

tempStr += "\t";

}

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)

{

}

}

}

Hi,

 

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

Hi Nikita Sudhir,

 

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

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();

}

}

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. 

Below link may help you to understand better. 

 

http://www.aspsnippets.com/Articles/Add-new-Row-to-GridView-on-Button-Click-in-ASPNet.aspx

Hi Nikita,

 

As per your requirement, you need to add textboxes for ID, Name, Contact_Number etc..

 

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.

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).

 

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;

 

    dataGrid.DataSource = dtCurrentTable;

    dataGrid.DataBind(); 

}