C Sharp :: Saving Multiple Rows Of Gridview Into Database
Jun 1, 2013
Ihave a gridview which populated via selected item on my drop down list which I don't have any problem with that. My problem is I am trying to save multiple rows on my gridview into my database, for example I have added 3 items on my gridview which looks like this:
Id | Name
111 | Jack
222 | Nicole
333 | John
Now, I want all that under column Id which is 111, 222 and 333 will be save on my database once I click Save button I am trying the code below but it gives me an error saying "system.data.sqlclient.sqlparameter does not contain a definition for 'Values' and no extension method 'Values' accepting a first argument of type..." :
SqlConnection con = new SqlConnection("Data Source=GATE-PCSQLEXPRESS;Initial Catalog=dbProfile;Integrated Security=True");
SqlCommand cmdd = new SqlCommand("Insert into profile (Id, profile_id)VALUES(@id, @profile_id", con);
foreach (GridViewRow row in GridView1.Rows) {
[Code] .....
My table should be look like this once I am able to save multiple rows from my gridview into my database:
auto_id | Id | profile_id
1 |111 | 101
2 |222 | 101
3 |333 | 101
I am using asp.net with c#.
View 1 Replies
ADVERTISEMENT
Jun 3, 2013
I am having a problem with deleting gridview rows. I am populating my gridview by selecting value in a dropdownlist then by clicking the add button, value will be added in my gridview, here is my code:
In my aspx:
<asp:GridView ID="GridView1" runat="server"
CssClass="mGrid" EmptyDataText = "There are no records to display">
<Columns>
<asp:TemplateField ItemStyle-Width="10">
<HeaderTemplate>
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server"/>
[Code] ....
With the btnRemove codes above, If I clicked it, it'll remove all values in my gridview even the unchecked rows, what I want is that just the checked rows not all. And are there any other simple way of removing rows in a gridview than using checkbox? I am using c# with asp.net.
View 1 Replies
View Related
Feb 12, 2014
using System;
using System.Collections.Generic;
using System.ComponentModel;
[Code]....
find the attachment.
Data is displaying in grid view but when i enter the particulars it's not inserting in to DB & grid view.
View 1 Replies
View Related
Mar 29, 2013
I'm trying to add a function now that lets the user open 1 or more files and import them to the database and dataGridView. Now the way it is now (should) work. But when it has finished with FILE1, it won't add FILE2 as it then gives me an error that the Column Date Already exists.
My code is below
private void btnOpenLog_Click(object sender, EventArgs e) {
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "Log Files (*.log)|*.log";
openFileDialog1.Multiselect = true;
[Code] .....
View 12 Replies
View Related
Oct 5, 2014
My program add something in a data base, but after program is closed all data is removed.
conturiSQLDataSet.LoginsRow newUserRow = conturiSQLDataSet.Logins.NewLoginsRow();
...
conturiSQLDataSet.Logins.Rows.Add(newUserRow);
There is a method that program can save all data?
View 2 Replies
View Related
Feb 17, 2014
I wanted to retrieve all rows from database and display in listview using list<string>
con.Open();
MySqlCommand view = new MySqlCommand("Select Cust_ID,Fname,Mname from Customer;", con);
MySqlDataReader v1 = view.ExecuteReader();
while (v1.Read()) {
for (int i = 0; i < v1.FieldCount; i++){
result.Add(v1["Cust_ID"].ToString());
[Code] .....
View 4 Replies
View Related
Aug 1, 2012
I have a Dropdownlist with in a gridview, in my grid I have 10 records, my dropdown values are 1,2,3...10. In first record drop down value is 1, second record dropdown value is 2....
1.now I changed the 5 drop down value to 2, then second drop value is changed to 3 and 3 dropdown has been changed to 4, 4th dropdown has been changed to 5
2.I changed the 5th drop down value to 8, then 8th dropdown value is changed to 7, 7th dropdown has been changed to 6, 6th dropdown has been changed to 5
Attached Files PAM.zip (7.0 KB, 87 views)
View 1 Replies
View Related
Mar 17, 2014
I want to connect an access database (.mdb) to my Windows Forms application - this I can do and I have no problems viewing my table in server explorer.
Some code example or template that I can use as a base to learn from - I have literally trawled Google and Youtube and cannot find what I am after.
What I want to do is have a basic form, 2 text boxes and a button to save the data to my database.
FirstName and LastName are the 2 boxes.
View 6 Replies
View Related
Apr 4, 2013
I have a gridview in which I show report data, I wanted to print this data, so I added print functionality. This print functionality does not print entire gridview data, it only prints data which is visible on the screen and skip the data which is under vertical scroll bar.
Below is the print grid view code in c# for WINDOWS APPLICATION.
private void btnPrint_Click(object sender, EventArgs e)
{
if (printDialog1.ShowDialog() == DialogResult.OK)
{
[Code]....
View 3 Replies
View Related
May 17, 2013
passing selected row in gridview to my dropdown. I have 1 gridview, 1 textbox and 1 dropdown list box. My dropdown is populated by SqlDataSource from my table Country. On my gridview, I have 3 columns, which are SELECT, NAME and COUNTRY. Under SELECT column, I have my hyperlinked Select, every time I clicked on a certain row NAME will pass in textbox (no problem with that), but in my dropdown it does not populates the COUNTRY that I choose. For example, I have Jack for name and USA for country. Beside Jack and USA, I have a hyperlink Select, when I click Select, Jack will display on my textbox and supposed to be USA will display on my dropdown but not displaying instead it says an error "'cboCountry' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value".
I have tried the codes below:
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
txtname.Text = GridView2.SelectedRow.Cells[1].Text;
cboCountry.Text = GridView2.SelectedRow.Cells[2].Text;
}
Only the textbox os working, no luck at all in dropdown...I'm using c# and asp.net.
View 1 Replies
View Related
Dec 31, 2013
I'm trying to find a way to remove an item that has been dynamically added when I change my drop down list selected user. The way this works is I add an edit and delete button dynamically when I select a user. I need to have the existing one be removed when I change users. Here is the code I'm using to build the two buttons. How do I remove them? Do I wipe out the columns and then add the columns again?
try {
dgvBG.DataSource = this.bgDataTableAdapter.GetData(cbPatientID.SelectedItem.ToString());
try {
Image editBGImg = Properties.Resources.editor;
Image delBGImg = Properties.Resources.del;
DataGridViewImageColumn btnBGEdit = new DataGridViewImageColumn();
[Code] ....
View 4 Replies
View Related
Mar 26, 2013
I am developing windows application using visual studio 2008 and c#.
I have a GRIDVIEW, but I am not sure how to make a specific column of gridview as hyperlink.
For Example: First column of my grid view is Item ID and if user clicks any of the value in this column a new form should open.
Below is the code of my GIRDVIEW
DataSet ds;
DataSet ds3;
public void FillGridView(int LotID) {
clsPurchase obj = new clsPurchase();
[Code] ....
View 2 Replies
View Related
Aug 6, 2012
I have a Gridview ,in that one of the Column is DropDownList .I have 10 Records in my Grid and my DropDown Values are like this 1,2,3....10.This is the format to store my DropDown values ,if i delete 4th Row ,then my DropDown Values are Changed like 1,2,3,4....9.This is my task ,but i'm getting this format 1,2,3,--,5...10.
View 1 Replies
View Related
Sep 12, 2014
I retrieve all the row values from database into text box.But I could not Update it.It shows error message is : The variable name '@value' has already been declared. Variable names must be unique within a query batch or stored procedure. Must declare the scalar variable "@keyValue".
my code is here:
public partial class ECB_ECBConfiguration : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
DataTable dt = ECBDal.GetECBConfiguration();
foreach(DataColumn col in dt.Columns)
[Code] ....
View 1 Replies
View Related
Feb 15, 2013
I'm getting an error when I want t add a file to my dataGridView that I can't add any data because it is databound. I've been working around this but still gives me the same error. heres the snippet of the code:
private void btnOpenLog_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
if (openFileDialog1.ShowDialog() != DialogResult.Cancel)
{
String sLine = "";
[Code] ....
View 18 Replies
View Related
Sep 14, 2014
I delete rows in datagridview using chcekbox column. I write the following code:
private void btndelpay_Click(object sender, EventArgs e) {
DialogResult dr = MessageBox.Show("delete row", "do you want to delete",
MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (dr == DialogResult.Yes)
[Code] ......
my problem is /how to umcheck from rows in datagridview in chechboxes column when the user select dialogResult.NO
View 1 Replies
View Related
Sep 14, 2014
I fetch maxid row to view in datagridview using the following code :
public static DataTable GetMaximpID() {
string strconn = AlShehabi.Properties.Settings.Default.NewSalariesDBConnectionString;
SqlConnection conn = new SqlConnection(strconn);
if (conn.State == ConnectionState.Closed)
[Code] ....
But I want to fetch all rows inserted and view in datagridview.... For example if user insert 4 rows I want to view them in datagridview after insert them using insertbutton_click....
View 2 Replies
View Related
Aug 23, 2013
What i'm trying to do is load an image from my database create some graphics to it. probably just some lines and marks and save it back to my database. here's so far what I got.
for creating graphics:
} private void pictureBox3_MouseDown(object sender, MouseEventArgs e) {
draw = true;
} private void pictureBox3_MouseMove(object sender, MouseEventArgs e) {
if (draw) {
Graphics g = Graphics.FromImage(pictureBox3.Image);
[Code] ....
but the saving part doesnt work :( I think it only saves the image loaded to the picturebox but not the graphics created to it. how to merge it? i've tried to google it and found some sort of same cases but fails to make it work, something like converting it to bitmap.
View 2 Replies
View Related
May 29, 2014
I want to select three columns from my text file i.e. Empl No, Start Date and Created Date. After selecting this, I want to insert the data into a database.
I have attached a copy of the text file.
I have the following code so far:
if (File.Exists(filename))
{
string[] lines = File.ReadAllLines(filename);
for (int y = 0; y < lines.Length; y++) {
Console.WriteLine(lines[y].ToString());
}
How do i select specific details for each employee
View 1 Replies
View Related
Jun 1, 2013
I have an application with general customer detail.
It has TextBox and radio button.
First I have used if statement then code but on first step is working fine then error is showing.
try
{
if (textBox1.Text == "")
{
[Code].....
View 5 Replies
View Related
Jul 27, 2013
I have created 2 form which is login form, which username textbox already connected to the database and it is successfully. When user login, it direct to the second form, and in the second form, there are multiple textbox that i have created using Array List, and it has shown.
Here is my problem: I want to connect the textboxes in second form to the database, but it shown nothing when i run the program, i already trace the code which is the error, and the error is on when OleDBDataReader is reading, i dunno what's wrong with my code, in login form it run perfectly, but in the second form, there is an error.
Here is the image for Login Form:
Here is the image for Second Form:
Here is the code for Second Form: [CODE]
private List<List<TextBox>> textBoxCodeContainer = new List<List<TextBox>>();
string connectionString = (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=ArchivesProjectsProgramSell SystemSell SystemApp_Datadb1.accdb;Persist Security Info=False;");
//****TextBox for Code****
for (int y = 0; y <= 16; y++)
[code]....
For the Second Form, in the column of code, it supposed to shown the autocomplete like at the Login Form.
View 2 Replies
View Related
Feb 8, 2014
The main question how to fully traverse/circumvent through all TreeView, for transforming Tree structure into a Table structure.
I want to note that the TreeView may contain a different number of branches, with different depths and different names.
I found a lot of information how to populate TreeView e.g. from DataTable, but I didn't found information how to recursively traverse/circumvent a TreeView and populate/fill data e.g. to DataTable.
As sample I have following TreeView:
Aaron
-Baldwin
--Caleb
---Dale
--Earl
-Fabian
Gabriel
-Harold
-Ian
Necessary to convert the TreeView into e.g. DataTable:
id | Name | ParentId
--------------------------------
1 | Aaron | null
2 | Baldwin | 1
3 | Caleb | 2
4 | Dale | 3
5 | Earl | 2
6 | Fabian | 1
7 | Gabriel | null
8 | Harold | 7
9 | Ian | 7
View 1 Replies
View Related
Dec 21, 2012
How to set execute statement in the end of sql, Attach is my code:
private void InsertintoDB() {
string strSQL = "";
string strDBType = System.Configuration.ConfigurationManager.AppSettings["DBType"];
string strConn = System.Configuration.ConfigurationManager.AppSettings["DB_CONNECTION_STRING1"].ToString();
string strInsertTableName_Sql = "CIMMGR.[dbo].ANSDATA";
[Code] ....
View 2 Replies
View Related
Jul 12, 2013
I just wanna update my database with one click only.
I do for update my database from datagridview1 but it shows a error like this :
Unhandled exception has occurred in your application . If you click Continue, the application will ignore this error and attempt to continue. If you click Quit,the application will close immediately.
Update requires a valid UpdateCommand when passed DataRow collection with modified rows
Attached Files : WindowsFormsApplication4.zip (127.2 KB)
View 2 Replies
View Related
Aug 3, 2013
I am developing a win form application with sq l server2005, in client system after install the application I created the folder for storing the database of running application, like that I have every year database separately, My doubt is how to connect the particular year database while loading the app?
View 1 Replies
View Related
Apr 3, 2013
How can i browse database name and server to connect?
View 3 Replies
View Related