Mohammadvb6
سه شنبه 18 تیر 1387, 14:05 عصر
اشکال کجاست ؟
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace WindowsApplication3
{
using System.Data;
using System.Data.SqlClient;
public partial class Form1 : Form
{
SqlConnection objsqlconnection = new SqlConnection("server=localhost; database=pubs; user id =admin ; password=");
SqlDataAdapter objdataadapter = new SqlDataAdapter();
DataSet objdataset = new DataSet();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
objdataadapter.SelectCommand = new SqlCommand();
objdataadapter.SelectCommand.Connection = objsqlconnection;
objdataadapter.SelectCommand.CommandText = " select au_lname,au_fname,title,price " +
" from authors " +
" join titleauthors on authors.au_id = " +
" titleauthors.au_id " +
" join titles on titleauthors.title_id= " +
" titles.title_id " +
"order by au_lname,au_fnme";
objdataadapter.SelectCommand.CommandType = CommandType.Text;
objsqlconnection.Open();
objdataadapter.Fill(objdataset, " authors ");
objsqlconnection.Close();
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objdataset;
dataGridView1.DataMember = "authors";
objdataadapter = null;
objsqlconnection = null;
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace WindowsApplication3
{
using System.Data;
using System.Data.SqlClient;
public partial class Form1 : Form
{
SqlConnection objsqlconnection = new SqlConnection("server=localhost; database=pubs; user id =admin ; password=");
SqlDataAdapter objdataadapter = new SqlDataAdapter();
DataSet objdataset = new DataSet();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
objdataadapter.SelectCommand = new SqlCommand();
objdataadapter.SelectCommand.Connection = objsqlconnection;
objdataadapter.SelectCommand.CommandText = " select au_lname,au_fname,title,price " +
" from authors " +
" join titleauthors on authors.au_id = " +
" titleauthors.au_id " +
" join titles on titleauthors.title_id= " +
" titles.title_id " +
"order by au_lname,au_fnme";
objdataadapter.SelectCommand.CommandType = CommandType.Text;
objsqlconnection.Open();
objdataadapter.Fill(objdataset, " authors ");
objsqlconnection.Close();
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objdataset;
dataGridView1.DataMember = "authors";
objdataadapter = null;
objsqlconnection = null;
}
}
}