fidelio
دوشنبه 01 شهریور 1389, 19:43 عصر
من این کد رو debug می کنم:
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 ProgrammingDataAdapters
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection NorthwindConnection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\NORTHWND.MDF;"
+"Integrated Security=True;Connect Timeout=30;User Instance=True");
private DataSet NorthwindDataSet = new DataSet ("Northwind");
private DataTable CustomersTable = new DataTable("Customers");
private void Form1_Load(object sender, EventArgs e)
{
SqlDataAdapter SqlDataAdapter1 = new SqlDataAdapter("SELECT * FROM Customers", NorthwindConnection);
NorthwindDataSet.Tables.Add(CustomersTable);
SqlDataAdapter1.Fill(NorthwindDataSet.Tables["Customers"]);
dataGridView1.DataSource = NorthwindDataSet.Tables["Customers"];
SqlCommandBuilder commands = new SqlCommandBuilder(SqlDataAdapter1);
}
private void UpdateButton_Click(object sender, EventArgs e)
{
NorthwindDataSet.EndInit();
SqlDataAdapter1.Update(NorthwindDataSet.Tables["Customers"]);
}
}
}
این که توی رویداد Update آداپتر تعریف شده شناخته نمی شه برام سوال برانگیزه و راه حل برطرف کردن این خطا رو اگر کسی بگه ممنون می شم.
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 ProgrammingDataAdapters
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection NorthwindConnection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\NORTHWND.MDF;"
+"Integrated Security=True;Connect Timeout=30;User Instance=True");
private DataSet NorthwindDataSet = new DataSet ("Northwind");
private DataTable CustomersTable = new DataTable("Customers");
private void Form1_Load(object sender, EventArgs e)
{
SqlDataAdapter SqlDataAdapter1 = new SqlDataAdapter("SELECT * FROM Customers", NorthwindConnection);
NorthwindDataSet.Tables.Add(CustomersTable);
SqlDataAdapter1.Fill(NorthwindDataSet.Tables["Customers"]);
dataGridView1.DataSource = NorthwindDataSet.Tables["Customers"];
SqlCommandBuilder commands = new SqlCommandBuilder(SqlDataAdapter1);
}
private void UpdateButton_Click(object sender, EventArgs e)
{
NorthwindDataSet.EndInit();
SqlDataAdapter1.Update(NorthwindDataSet.Tables["Customers"]);
}
}
}
این که توی رویداد Update آداپتر تعریف شده شناخته نمی شه برام سوال برانگیزه و راه حل برطرف کردن این خطا رو اگر کسی بگه ممنون می شم.