AliRezaPro
یک شنبه 25 مرداد 1388, 18:31 عصر
سلام
من طبق کتاب آقای هاشمی الان صفحه ی 638 هستم
کدی که برای Sql server برای بانک Pubs برای مثال بود رو من کامل نوشتم ولی در آخر بهم Sqlexception داد
و متن :
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
مشکل از کجاست؟
اینهم از کد:
public partial class Form1 : Form
{
SqlConnection objSqlConnection = new SqlConnection("server=localhost;database=pubs;" +"user id=sa;password=");
SqlDataAdapter objsqlDataAdapter = new SqlDataAdapter();
DataSet objDataset = new DataSet();
////////////////////////////////////
private void Form1_Load(object sender, EventArgs e)
{
// Set the SelectCommand properties...
objsqlDataAdapter.SelectCommand = new SqlCommand();
objsqlDataAdapter.SelectCommand.Connection = objSqlConnection;
objsqlDataAdapter.SelectCommand.CommandText = "SELECT au_lname, au_fname, title, price " + "FROM authors " + "JOIN titleauthor ON authors.au_id = " + "titleauthor.au_id " + "JOIN titles ON titleauthor.title_id = " + "titles.title_id " + "ORDER BY au_lname, au_fname";
objsqlDataAdapter.SelectCommand.CommandType = CommandType.Text;
objSqlConnection.Open();
objsqlDataAdapter.Fill(objDataset, "authors");
objSqlConnection.Close();
DataGrid1.AutoGenerateColumns = true;
DataGrid1.DataSource = objDataset;
DataGrid1.DataMember = "authors";
objsqlDataAdapter = null;
objSqlConnection = null;
}به objSqlConnection.Open(); گیر میده
من طبق کتاب آقای هاشمی الان صفحه ی 638 هستم
کدی که برای Sql server برای بانک Pubs برای مثال بود رو من کامل نوشتم ولی در آخر بهم Sqlexception داد
و متن :
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
مشکل از کجاست؟
اینهم از کد:
public partial class Form1 : Form
{
SqlConnection objSqlConnection = new SqlConnection("server=localhost;database=pubs;" +"user id=sa;password=");
SqlDataAdapter objsqlDataAdapter = new SqlDataAdapter();
DataSet objDataset = new DataSet();
////////////////////////////////////
private void Form1_Load(object sender, EventArgs e)
{
// Set the SelectCommand properties...
objsqlDataAdapter.SelectCommand = new SqlCommand();
objsqlDataAdapter.SelectCommand.Connection = objSqlConnection;
objsqlDataAdapter.SelectCommand.CommandText = "SELECT au_lname, au_fname, title, price " + "FROM authors " + "JOIN titleauthor ON authors.au_id = " + "titleauthor.au_id " + "JOIN titles ON titleauthor.title_id = " + "titles.title_id " + "ORDER BY au_lname, au_fname";
objsqlDataAdapter.SelectCommand.CommandType = CommandType.Text;
objSqlConnection.Open();
objsqlDataAdapter.Fill(objDataset, "authors");
objSqlConnection.Close();
DataGrid1.AutoGenerateColumns = true;
DataGrid1.DataSource = objDataset;
DataGrid1.DataMember = "authors";
objsqlDataAdapter = null;
objSqlConnection = null;
}به objSqlConnection.Open(); گیر میده