Click here to Skip to main content
15,895,011 members
Home / Discussions / C#
   

C#

 
GeneralRe: Genericize access to variables Pin
Eddy Vluggen2-Sep-10 8:45
professionalEddy Vluggen2-Sep-10 8:45 
GeneralRe: Genericize access to variables Pin
Shani Natav2-Sep-10 9:14
Shani Natav2-Sep-10 9:14 
GeneralRe: Genericize access to variables Pin
Eddy Vluggen2-Sep-10 9:22
professionalEddy Vluggen2-Sep-10 9:22 
AnswerRe: Genericize access to variables PinPopular
Daniel Grunwald1-Sep-10 8:20
Daniel Grunwald1-Sep-10 8:20 
GeneralRe: Genericize access to variables Pin
PIEBALDconsult1-Sep-10 9:04
mvePIEBALDconsult1-Sep-10 9:04 
AnswerRe: Genericize access to variables [modified] Pin
Paul Michalik1-Sep-10 11:47
Paul Michalik1-Sep-10 11:47 
GeneralRe: Genericize access to variables Pin
AspDotNetDev1-Sep-10 11:51
protectorAspDotNetDev1-Sep-10 11:51 
AnswerRe: Genericize access to variables Pin
Łukasz Nowakowski1-Sep-10 20:14
Łukasz Nowakowski1-Sep-10 20:14 
AnswerRe: Genericize access to variables Pin
Alexander Voronin2-Sep-10 1:52
Alexander Voronin2-Sep-10 1:52 
AnswerRe: Genericize access to variables Pin
ExportedNorwegian2-Sep-10 2:01
ExportedNorwegian2-Sep-10 2:01 
AnswerRe: Genericize access to variables Pin
Dave Buhl2-Sep-10 3:11
Dave Buhl2-Sep-10 3:11 
AnswerRe: Genericize access to variables Pin
JaceTheAce2-Sep-10 4:12
JaceTheAce2-Sep-10 4:12 
AnswerRe: Genericize access to variables Pin
RMcEachern2-Sep-10 10:37
RMcEachern2-Sep-10 10:37 
AnswerRe: Genericize access to variables Pin
coolguy19882-Sep-10 15:09
coolguy19882-Sep-10 15:09 
QuestionDo you know which office outlook 2003 component can be sign into Microsoft Exchange Server via outlook? Pin
milestanley1-Sep-10 1:44
milestanley1-Sep-10 1:44 
Questionquestion Pin
bitayekta1-Sep-10 0:51
bitayekta1-Sep-10 0:51 
AnswerRe: question Pin
Pete O'Hanlon1-Sep-10 1:05
mvePete O'Hanlon1-Sep-10 1:05 
AnswerRe: question Pin
Smithers-Jones1-Sep-10 5:12
Smithers-Jones1-Sep-10 5:12 
GeneralRe: question Pin
Pete O'Hanlon1-Sep-10 7:45
mvePete O'Hanlon1-Sep-10 7:45 
GeneralRe: question Pin
AspDotNetDev1-Sep-10 9:16
protectorAspDotNetDev1-Sep-10 9:16 
AnswerRe: question Pin
Eddy Vluggen1-Sep-10 8:38
professionalEddy Vluggen1-Sep-10 8:38 
AnswerRe: question Pin
Dave Kreskowiak1-Sep-10 8:58
mveDave Kreskowiak1-Sep-10 8:58 
QuestionTrying to update sql table from datagrid Pin
mpanger1-Sep-10 0:31
mpanger1-Sep-10 0:31 
(i posted this incorrectly to quick answers. I am reposting this here)

I am working on my first C# SQL project. A simple checkbook register.

I referred to the CodeProject article:

Using the DataGrid Control Using the DataGrid Control[^]

I added a datagridview control to my form and set the data source as my checkbook register in SQL Express.

I am able to see all the checkbook entries when I run the form.

My first attempt at updating the sql table is generating a compile error.

The error is:
cannot convert from 'System.Data.DataSet' to 'FirstCheckBookInSQL.CheckBookManagementDataSet.CheckbookUSBPersonalDataTable'

I've been researching this for 3 days, but I'm just not making sense of what I am seeing.

Can someone help please!
Thank you.
Mark


My code in Form1.cs:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace FirstCheckBookInSQL
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

        }

        
        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'checkBookManagementDataSet.CheckbookUSBPersonal' table. You can move, or remove it, as needed.
            this.checkbookUSBPersonalTableAdapter.Fill(this.checkBookManagementDataSet.CheckbookUSBPersonal);
        }

        private void TBDbutton_Click(object sender, EventArgs e)
        {

            DataSet myChangedDataSet = this.checkBookManagementDataSet.GetChanges();
            if (myChangedDataSet != null)
            {
                // get how many rows changed

// this is the line I am having trouble with:
                int modifiedRows = this.checkbookUSBPersonalTableAdapter.Update(myChangedDataSet);

                //MessageBox.Show("Database has been updated successfully: " +
                //modifiedRows + " Modified row(s) ", "Success");
                this.checkBookManagementDataSet.AcceptChanges();
                myChangedDataSet.AcceptChanges();

            }

            MessageBox.Show("no data changed");
        }
    }
}
</pre>

AnswerRe: Trying to update sql table from datagrid Pin
OriginalGriff1-Sep-10 6:16
mveOriginalGriff1-Sep-10 6:16 
GeneralRe: Trying to update sql table from datagrid Pin
mpanger1-Sep-10 7:20
mpanger1-Sep-10 7:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.