GridView and Calender Example

Preeti Agrawalla

In the attached code i got problem that, when textbox1.text will be changed, monthCalender will be showed, n what date i select it is written to that textbox. But i am getting problem in entering today's date. and second problem is that after entering two dates in two textboxs, if i click on "GO" button gridview will be showed, which is working correctly. But in gridview my requirement is, when i enter "Quantity" cloumn as 5 and "Rate" column as 10, then automatically it will show "Amount" Column as multiplication of "quantity" And "Rate". Please go through my code and correct it.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
Hi,
I am able to enter today's date. You need to select it from calendar.
and for second issue

in your form1.designer.cs

this.gvPopulate.CellEndEdit += new System.Windows.Forms.DataGridViewCellEventHandler(this.GridViewCellEndEdit);

in your form1.cs

private void GridViewCellEndEdit(object sender, DataGridViewCellEventArgs e)
{
int total = 0;
string stringquantity = gvPopulate.Rows[e.RowIndex].Cells[2].Value.ToString();
string stringrate = gvPopulate.Rows[e.RowIndex].Cells[3].Value.ToString();
int quantity;
int rate;
if (stringquantity != string.Empty && stringrate != string.Empty)
{
quantity = Convert.ToInt32(stringquantity);
rate = Convert.ToInt32(stringrate);
total = quantity * rate;
gvPopulate.Rows[e.RowIndex].Cells[4].Value = total;
}
}

Regards,
Iftikar
Preeti Agrawalla13y ago
Hey thanks Iftikar...its working..
Preeti Agrawalla13y ago
didn't u get any error message when u run my attached code..Please Check it once again.. There is something ";" and ")" error is coming and also error "foreach (GridViewRow gridRow in gvPopulate.Rows)" in this line is coming.
Iftikar Hussain13y ago
try like this

private void button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=USER-PC;Initial Catalog=NetSoft;Integrated Security=True");
con.Open();
foreach (DataGridViewRow gridRow in gvPopulate.Rows)
{
string sql="insert into Bill values ('" +Convert.ToInt32(gridRow.Cells[0].Value) + "','" + gridRow.Cells[1].Value + "','" + gridRow.Cells[2].Value + "','" + gridRow.Cells[3].Value + "','" + gridRow.Cells[4].Value +"')";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
}
MessageBox.Show("Insertion successfully done");
con.Close();
}

Regards,
Iftikar
Iftikar Hussain13y ago
what error message you are getting?

Regards,
Iftikar
Sanjeeb Lenka13y ago
check this link:

http://www.c-sharpcorner.com/UploadFile/ANURAGSARKAR19/saving-data-using-datagridview-and-doing-calculations/

http://stackoverflow.com/questions/12776618/read-data-from-datagridview-and-save-to-database
Preeti Agrawalla13y ago
now i am inserting Gridview values in to Database. and i am getting errors..Please check below attached code and correct it. Thank You.
Preeti Agrawalla13y ago
Thanks Suresh....It is also working..:)
Suresh Babu13y ago
see this posted file. it will be help to u
u have another doubts please send to my [email protected]
9030218021
Iftikar Hussain13y ago
you welcome :)

Regards,
Iftikar
Preeti Agrawalla13y ago
Thanks a lot, thank u so much..................its working...:)