farshad1_1390
چهارشنبه 23 آذر 1390, 21:05 عصر
با سلام،من كد زير رو براي اتصال به sql 2000 استفاده ميكردم و جواب ميده،ولي براي اتصال به sql 2005 خطا ميگيره،ميخواستم بپرسم كه كجاي اين كد رو بايد تغيير بدم تا درست بشه.ممنون ميشم اگه كمكم كنيد
{
publicpartialclassForm2 : Form
{
SqlConnection objconnection = newSqlConnection("Server=localhost;" +
"database=school;Integrated Security=true;");
SqlDataAdapter objDataAdapter = newSqlDataAdapter();
DataSet objDataSet = newDataSet();
public Form2()
{
InitializeComponent();
}
privatevoid يToolStripMenuItem_Click(object sender, EventArgs e)
{
GrdDisplayInformationMajor.Visible = true;
objDataAdapter.SelectCommand = newSqlCommand();
objDataAdapter.SelectCommand.Connection = objconnection;
objDataAdapter.SelectCommand.CommandText =
"select count(StudentCode)as t from Tbl_student;";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objconnection.Open();
objDataAdapter.Fill(objDataSet, "TblMajor");
objconnection.Close();
GrdDisplayInformationMajor.AutoGenerateColumns = true;
GrdDisplayInformationMajor.DataSource = objDataSet;
GrdDisplayInformationMajor.DataMember = "TblMajor";
DataGridViewCellStyle objAlignRightCellStyle = new
DataGridViewCellStyle();
objAlignRightCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight;
DataGridViewCellStyle objAlternalternatingCellStyle = new
DataGridViewCellStyle();
objAlternalternatingCellStyle.BackColor = Color.WhiteSmoke;
GrdDisplayInformationMajor.AlternatingRowsDefaultC ellStyle =
objAlternalternatingCellStyle;
GrdDisplayInformationMajor.Columns[0].HeaderText = "كل";
objDataAdapter = null;
objconnection = null;
objAlternalternatingCellStyle = null;
objAlignRightCellStyle = null;
}
}
}
{
publicpartialclassForm2 : Form
{
SqlConnection objconnection = newSqlConnection("Server=localhost;" +
"database=school;Integrated Security=true;");
SqlDataAdapter objDataAdapter = newSqlDataAdapter();
DataSet objDataSet = newDataSet();
public Form2()
{
InitializeComponent();
}
privatevoid يToolStripMenuItem_Click(object sender, EventArgs e)
{
GrdDisplayInformationMajor.Visible = true;
objDataAdapter.SelectCommand = newSqlCommand();
objDataAdapter.SelectCommand.Connection = objconnection;
objDataAdapter.SelectCommand.CommandText =
"select count(StudentCode)as t from Tbl_student;";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objconnection.Open();
objDataAdapter.Fill(objDataSet, "TblMajor");
objconnection.Close();
GrdDisplayInformationMajor.AutoGenerateColumns = true;
GrdDisplayInformationMajor.DataSource = objDataSet;
GrdDisplayInformationMajor.DataMember = "TblMajor";
DataGridViewCellStyle objAlignRightCellStyle = new
DataGridViewCellStyle();
objAlignRightCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight;
DataGridViewCellStyle objAlternalternatingCellStyle = new
DataGridViewCellStyle();
objAlternalternatingCellStyle.BackColor = Color.WhiteSmoke;
GrdDisplayInformationMajor.AlternatingRowsDefaultC ellStyle =
objAlternalternatingCellStyle;
GrdDisplayInformationMajor.Columns[0].HeaderText = "كل";
objDataAdapter = null;
objconnection = null;
objAlternalternatingCellStyle = null;
objAlignRightCellStyle = null;
}
}
}