how to design the gridview in windows forms?

Question

Manas Mohapatra · Answer

Change your inline query: string Query = "UPDATE additem1 SET quantity = quantity - " + Convert.ToInt32(this.txtquantity.Text) + " where [Itemid] = " + Convert.ToInt32(this.txtitemid.Text) + ";"; Assuming that Itemid is integer datatype. If it is varchar then you need to add single quote in your query.

Krishna Rajput Singh · Answer

Hello Dileep aalla thanks for writing if you want to know about design of grid view you can design as per requirement simply create window form and drag and drop gridview then you create your database and connect to app to data if nee any help simply find or search in google lots of articles available if need ore follow Manas Mohapatra links i hope happy coding and programming if find helpful answer mark as correct

Manas Mohapatra · Answer

Please go through below links: http://www.aspsnippets.com/Articles/Bind-Fill-DataGridView-in-Windows-Forms-WinForms-Application-in-C-and-VBNet.aspx http://www.dotnetperls.com/datagridview-tutorial http://www.c-sharpcorner.com/UploadFile/1e050f/insert-update-and-delete-record-in-datagridview-C-Sharp/

dileep aalla · Answer

hai, anybody can help me.. i will make a project on billmanagement sysytem ..am stuck at query to update the quqntity.. my requirment is to sell the item (given the value from the textbox)when quantity is updated in database.. can u please modify this below query string str = "server = APPS-PC\SQLEXPRESS;Initial Catalog=amaron;Integrated Security=true;"; SqlConnection con = new SqlConnection(str); string Query = " UPDATE additem1 SET quantity = quantity- " + Convert.ToInt32(this.txtquantity.Text) + "' where [Itemid] = '" + Convert.ToInt32(this.txtitemid.Text) + "';"; SqlCommand cmd = new SqlCommand(Query, con); thanks in advance.

dileep aalla · Answer

it's working.. Thank u so much.. manas mohapatra..

ali tuncer · Answer

you should search for DataGridView..