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

C Sharp :: Delete Rows In Gridview

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

C Sharp :: Inserting Data Into Database And Display In Gridview

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

C Sharp :: Opening And Importing Multiple Files Into DataGridView / Database

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

C# :: SQL Database Not Saving?

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

C# :: How To Retrieve All Rows In Database Using List

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

C Sharp :: DropDownList Inside A GridView?

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

C# :: Access Database Connection And Saving Data

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

C Sharp :: How To Print Entire Gridview Data

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

C Sharp :: Passing Selected Row From Gridview To Dropdown

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

C Sharp :: How To Remove Dynamically Created Buttons In Gridview

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

C Sharp :: Add Hyperlink In Gridview Column In Windows Application Developed In C#?

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

C Sharp :: DropDown Values Are Changed When Delete A Record In GridView

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

C Sharp :: How To Update All Rows Using Text Box

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

C Sharp :: Rows Cannot Be Programmatically Added

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

C Sharp :: How To Delete Multi Rows In Datagridview

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

C Sharp :: How To Fetch All Rows Inserted In Datagridview

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

C Sharp :: Saving Picturebox Image With Graphics In It

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

C Sharp :: How To Select Specific Rows And Columns From A Text File

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

C Sharp :: Saving Data In SQL Server Parameter Error Showing

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

C# :: Connect Multiple Textbox To Database In WinApp

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

C Sharp :: TreeView To Database Or At Least DataTable

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

C Sharp :: How To Set Database Execute Statement

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

C Sharp :: Updating Database From Datagridview

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

C Sharp :: How To Connect With Particular Database File (MDB) While Loading App

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

C Sharp :: Browse Database Name And Server To Connect?

Apr 3, 2013

How can i browse database name and server to connect?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved