Hussein39
دوشنبه 08 فروردین 1390, 23:11 عصر
سلام دوستان
به نظر شما مشکل این کد چی می تونه باشه که این پیغام رو می ده
DataTable must be set prior to using DataView.
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 School_Project
{
classData_Job
{
publicstaticstring connect(string DatabaseName)
{
return@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\" + DatabaseName + ";Integrated Security=True;User Instance=True; Connect Timeout=0";
}
publicstaticvoid SQL_Dataview_adoptor()
{
SqlConnection con = newSqlConnection(connect("School.mdf"));
SqlCommand cmd = newSqlCommand();
cmd.Connection = con;
cmd.CommandTimeout = 0;
cmd.CommandText = "INSERT INTO Student(SName,LastName) Values(@SName,@LastName)";
cmd.Parameters.AddWithValue("@SName", "Fradon"); cmd.Parameters.AddWithValue("@LastName", "Jafari");
con.Open();
cmd.ExecuteNonQuery();
con.Close();
SqlDataAdapter SDAdoptor = newSqlDataAdapter();
SDAdoptor.SelectCommand = cmd;
SDAdoptor.SelectCommand.Connection = con;
DataSet DSet = newDataSet();
SDAdoptor.Fill(DSet, "Student");
DataView DView = newDataView(DSet.Tables["Student"]);
DView.Sort = "SName";
MessageBox.Show( DView.Count.ToString());
con = null;
cmd = null;
SDAdoptor = null;
DSet = null;
DView = null;
}
}
}
با تشکر:قلب:
به نظر شما مشکل این کد چی می تونه باشه که این پیغام رو می ده
DataTable must be set prior to using DataView.
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 School_Project
{
classData_Job
{
publicstaticstring connect(string DatabaseName)
{
return@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\" + DatabaseName + ";Integrated Security=True;User Instance=True; Connect Timeout=0";
}
publicstaticvoid SQL_Dataview_adoptor()
{
SqlConnection con = newSqlConnection(connect("School.mdf"));
SqlCommand cmd = newSqlCommand();
cmd.Connection = con;
cmd.CommandTimeout = 0;
cmd.CommandText = "INSERT INTO Student(SName,LastName) Values(@SName,@LastName)";
cmd.Parameters.AddWithValue("@SName", "Fradon"); cmd.Parameters.AddWithValue("@LastName", "Jafari");
con.Open();
cmd.ExecuteNonQuery();
con.Close();
SqlDataAdapter SDAdoptor = newSqlDataAdapter();
SDAdoptor.SelectCommand = cmd;
SDAdoptor.SelectCommand.Connection = con;
DataSet DSet = newDataSet();
SDAdoptor.Fill(DSet, "Student");
DataView DView = newDataView(DSet.Tables["Student"]);
DView.Sort = "SName";
MessageBox.Show( DView.Count.ToString());
con = null;
cmd = null;
SDAdoptor = null;
DSet = null;
DView = null;
}
}
}
با تشکر:قلب: