C# - Insert Selected Rows Value Of Gridview Into Database?
Apr 21, 2010
I am Developing Windows Form Application in .Net, I want to insert selected rows value of Gridview into database. First Column of my GridView is Checkbox, when user check one or more checkbox from gridview, i want to insert values of respective rows into Database. In Web application i done this using DataKeyNames property of GridView. Want to know how to do it in Windows Form Application. I am using Visual Studio 2005.
The page count is set to 10, when the user checks the checkbox(es), I will need to insert those records in a table. How will I know which row was selected? I found an example (untried) that is designed to loop through and insert the necessary records; but it does not address inserting records based on selecting rows via a checkbox. How do I put everything together.
I would like to create those checked/selected rows in gridview to SQL server database with a button click.For example, an user checks 2 rows in the gridview, and clicks on the create button. I would want the selected row/s to be created to the database. How would I go about doing this?
I have a GridView (BulkEditGridView), that has 10 rows from the datasource. I Add a TemplateField "Insert Row" button to insert 1 blank row at selected row using Rows.AddAt.First time i press "Insert Row", it works as expected, the row inserted at selected row. now i press another "Insert Row", the row is inserted, however the row (in first time inserted) now move to the last row. and so on.
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
I have an excel sheet that contains around 30,000 rows and 18 colmns. These no of rows and columns may increase in future. I need to read all these records from excel sheet and insert into a table in sql database. For reading the excel book I am using Oledbconnections. The possible solutions I have known as per my knowledge, to insert the data are
1. To insert one record at a time which makes 30,000 database hits. How will this affect the performance? 2. To use liked servers - bu this is not working for me.I do not have database permissions to use linked servers. So, the only option i have is the first one.
how do i get the selected item in the drop down list and insert it into database (togethi populated the drop down with the values from the tables in database. It is dynamic, not static.i have a button in the gridview called 'add'. so when user clicks on it the row (whatever columns in the row) would be inserted into database. i am doing insertion/create for this.
I work with Visual studio 2005 and Sql server data base. I extract 1 million rows from a database and I put the rows in a Sql table. With a simple direct extraction, in a few minutes I complete the operation:
Dim cmd As New SqlCommand(query, cnSql) cmd.ExecuteNonQuery() cmd.Dispose().
But, if I must select and modify some fields between extraction and introduction, it takes a lot of time! I work in this way. I extract rows from Dbase, Table1, and I put all into a Collection using dataReader:
Dim cmd As New SqlCommand(query, cnSql) Dim coll As New Collection coll.Clear() Dim dr As SqlDataReader = cmd.ExecuteReader() I replace some fields with the string "YES". Dim toRepl As String = "" If dr.HasRows Then Do While dr.Read toRepl = dr(5).ToString If Len(toRepl) <= 3 Then ToRepl = "YES" collPrel.Add(dr(0).ToString) collPrel.Add(dr(1).ToString) .................. .............. collPrel.Add(toRepl) collCount = collCount + 1 Loop End If dr.Close() cmd.Dispose() Now, I insert all into a SQL Table2: Dim a As String = "", b As String = "", c As String = "" etc. For i = 1 To collPrel.Count Step 6 a = collPrel.Item(i).ToString b = collPrel.Item(i + 1).ToString .............. ............... f = collPrel.Item(i + 5).ToString queryIns = "INSERT INTO Tab (name, adress, etc) VALUES ('" & a & "', '" & b & "', '" & c & "', etc. ) Dim cmdIns As New SqlCommand(queryIns, cnSql) cmdIns.CommandTimeout = 600 cmdIns.ExecuteNonQuery() cmdIns.Dispose() Next
This way to work goes right but it is necessary a lot of time for completing the operation.
I am trying to insert 8 different selected values from a CheckBoxList into 8 different columns of a database. As it now, I am only able to concatenate all 8 selections into a single string in one column. But this is not what I want to do. In my DB I have Column1, 2, 3, 4, 5, 6, 7, 8. Is there any way of getting this done?
[URL] .... In that tutorial temporary DataTable used to maintain the list selected rows or records and then use the DataTable to bind the secondary GridView. What I'd like to do is;
I'm using the IfUserIsInRole function and when I get the users Identity and name I'm prepopulating the gvSelected GridView with data (only people associated with that user) on page load. When I try to add none prepopulated people from the gvAll GridView to the gvSelected GridView all the origional prepopulated rows from the gvselected GridView are over written.