PLZ HELP NEEDED ON DATAGRIDVIEW

Question

Hi all,

Please help me in solving following query:

I want to update table at backend in database throughmakeing changes in datagridview.

What I want is, when User makes changes in datagridview and clicks save or update button, the changes which are made in datagridview should get reflect in table in databse.

For ex:

I am having "Datagridview", "Edit" and "Save" button on WinForm and table "EmpDetails" at backend in databse. I am filling "Datagridview" with table "EmpDetails". When user clicked "Edit" button he should allowed to make changes in "Datagridview". After making changes in "Datagridview" when user clicked "Save" button, whichever changes made in datagridview should get reflect at backend in table "EmpDetails".

HELP ME ITS URGENT

Sam Hobbs · Answer

First read my Database Table Update in a DataGridView without Writing Code . After you read that I think you will understand better what can be done.

Sam Hobbs · Answer

I suggest that you not use the other code. You do not need it; the code that gets generated when you do as described in my article will do everything that the other code does, plus more. I suggest that you just create a new project as described in my article except using your table and then proceed from there. What is the select button supposed to do?

Sam Hobbs · Answer

I don't know about the deployment issue. Create a new thread with a relevant subject and then someone else can help.

Aaditya Ganesan · Answer

it works thanks man... I av another question regarding deployment. I deployed it using click once and there is a default clickonce page that comes and not my form directly is there a way to directly get my form wen I enter the deployed address.

Sam Hobbs · Answer

If the DataGridView is bound to the prodspec table then there should not be a problem updating the table so if there is a problem I don't know what that problem is. If the DataGridView is bound to the prodspec table then you can use the BindingSource.Filter Property of the DataGridView's BindingSource to filter the data shown in the DataGridView so that only the selected product is shown.

Aaditya Ganesan · Answer

fine i ll make it clear for you, there is a table prodspec not empdetail.... i have a combo box that list out all the prodcode and it is connected to the database. I use this combo box to generate a gridview, So when i choose a prodcode I get a gridview of that particular prodcode with all the properties of the prodcode(just one row of data). This is done with a help of select statement and it works perfectly and then if the user modifies the properties or the row generated in the gridview and then on pressing the update button, I want it to update, but it ain't happenin.. I hope I am clear now Thank you

Sam Hobbs · Answer

The original question in this thread says that you have a DataGridView for the EmpDetails table. I don't see any mention of any other data except for the EmpDetails table and I don't see any mention of what else is in the form. So what I am saying is that it is not clear what the data is that you need to show and update and how the form works. You say you have a ComboBox with prodcode but I don't know how it is related to the EmpDetails table. I think we need more information about the data and what you are using to view and update it.

Aaditya Ganesan · Answer

this is my code try { string connStr = @"Data Source=MPMSQLDEV;Initial Catalog=prodcn;Integrated Security=True"; SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlDataAdapter dAd = null; DataSet dSet = new DataSet(); string strSql = "Select * FROM prodspec where prodcode='" + prodcode.Text + "'"; dAd = new SqlDataAdapter(strSql, conn); dAd.Fill(dSet, "prodspec"); prodspecDataGridView.DataSource = dSet.Tables[0]; prodspecDataGridView.DataSource = dSet.Tables["prodspec"].DefaultView; prodspecDataGridView.Visible = true; button4.Visible = true; } catch (Exception ee) { MessageBox.Show("no entry"); } } private void closegrid_Click(object sender, EventArgs e) { prodspecDataGridView.Visible = false; button4.Visible = false; } private void modify_Click_1(object sender, EventArgs e) { DataSet dSet = new DataSet(); SqlDataAdapter dAd = new SqlDataAdapter(); dAd.Update(dSet, "prodspec"); dSet.Tables["prodspec"].AcceptChanges(); // DataGridViewRow item = new DataGridViewRow(); // prodspecDataGridView.AllowUserToAddRows = true; //item.CreateCells(prodspecDataGridView); (I tried with these comment lines also but it is not working) My prob is with your method I am able to update the database but wen I chose a single prodcode from the combo box in the form, the gridview populates with a single row of that of the prodcode. but when I try updating by either the save button in toolbar or the modify button that i have coded it does not updates the database and shows an exception in the latter case Update unable to find TableMapping['prodspec'] or DataTable 'prodspec'. plz help me on how to select a single row from a combo box in the form or from the datagridview so that i get the corresponding values of the product and I can update the gridview and the database... hope I am clear, vry urgent Adi

Aaditya Ganesan · Answer

! more request.. I put a combo box for selection.. I need the other rows to pop up automatically on selecting the value... I dono hw to code this without SQL statement... and tehn save the changes... is it possible??

Aaditya Ganesan · Answer

glorious.. my select statement selects only one prod detail according to the combo box in the form... hw to do that in the datagridview .. the update is absolutely awesome... thank you so much

Aaditya Ganesan · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} namespace UpdateDataWindowsFormDataGridView { public partial class Form1 : Form { private SqlDataAdapter da; private DataTable dt; public Form1() { InitializeComponent(); // Configure display characteristics of the data grid view dataGridView.Anchor = AnchorStyles.Left | AnchorStyles.Right | AnchorStyles.Top | AnchorStyles.Bottom; this.Width = 500; this.Load += new EventHandler(Form1_Load); } void Form1_Load(object sender, EventArgs e) { // Set the data source of the data grid view dataGridView.DataSource = LoadData(); } private DataTable LoadData() { string sqlConnectString = @"my connetion"; string sqlSelect = "SELECT Id, IntField, StringField FROM DataGridView"; // Create a data adapter and command builder da = new SqlDataAdapter(sqlSelect, sqlConnectString); SqlCommandBuilder cb = new SqlCommandBuilder(da); // Load a DataTable with schema and data from table DataGridView dt = new DataTable(); da.FillSchema(dt, SchemaType.Source); da.Fill(dt); return dt; } private void saveButton_Click(object sender, EventArgs e) { da.Update(dt); MessageBox.Show("Changes saved.", "DataGridView", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } This is not my code but I just did exactly like this but on a extra note I have added a button which selects the value in the gridview…nw I want a button for just updating the gridview… wen I use this code the database remains unchanged(nothing happens)…. For the second button I have added the SQL dataadaptor and datatable publically hw t is in the prog but with a different object instance(name).. This code is workin if I create a dummy form with just one gridview and a button, but not wen 2 buttons (one for select and 1 for update ).. is there any other way to do this..

PLZ HELP NEEDED ON DATAGRIDVIEW

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (11)