ehsanocx
چهارشنبه 14 دی 1390, 13:45 عصر
سلام دوستان من می خوام اطلاعاتی که درون بانکم هست رو توی dataGRidView نمایش بدم و از این دستورات استفاده کردم.
پایگاه داده SQL 2000
اسم بانکم Library
نام جدولم : Book
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;
//**************************** baraye Etesal be bank be in class ha niaz darim
using System.Data.SqlClient;
namespace Library
{
public partial class Frm_Main : Form
{
SqlConnection objConnection = new SqlConnection("Server=local;Database=Library.mdf;Integrated Security=true;");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
public Frm_Main()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// Time / Date
DateTime dteDate;
dteDate = DateTime.Now;
lblTime.Text = dteDate.ToLongDateString();
lblDate.Text = dteDate.ToLongTimeString();
//*******************
//NameKetab
//Talif
//Nasher
//SaleEnteshar
//NobatChap
//Tedad
//Gheymat
//NoeKetab
// Set the SelectCommand properties...
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection =objConnection;
objDataAdapter.SelectCommand.CommandText ="SELECT NameKetab, Talif, Nasher, SaleEnteshar,NobatChap,Tedad,Gheymat,NoeKetab " +
"FROM Book ";
objDataAdapter.SelectCommand.CommandType =CommandType.Text;
// Open the database connection...
objConnection.Open();
// Fill the DataSet object with data...
objDataAdapter.Fill(objDataSet, "Book");
// Close the database connection...
objConnection.Close();
// Set the DataGridView properties
// to bind it to our data...
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objDataSet;
dataGridView1.DataMember = "Book";
// Clean up
objDataAdapter = null;
objConnection = null;
}
با این دستورات برنامه رو run می کنم فرمم بالا نمیاد و اما هیچ پیغامی هم نمیده . ایراد کارم کجاست؟
پایگاه داده SQL 2000
اسم بانکم Library
نام جدولم : Book
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;
//**************************** baraye Etesal be bank be in class ha niaz darim
using System.Data.SqlClient;
namespace Library
{
public partial class Frm_Main : Form
{
SqlConnection objConnection = new SqlConnection("Server=local;Database=Library.mdf;Integrated Security=true;");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
public Frm_Main()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// Time / Date
DateTime dteDate;
dteDate = DateTime.Now;
lblTime.Text = dteDate.ToLongDateString();
lblDate.Text = dteDate.ToLongTimeString();
//*******************
//NameKetab
//Talif
//Nasher
//SaleEnteshar
//NobatChap
//Tedad
//Gheymat
//NoeKetab
// Set the SelectCommand properties...
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection =objConnection;
objDataAdapter.SelectCommand.CommandText ="SELECT NameKetab, Talif, Nasher, SaleEnteshar,NobatChap,Tedad,Gheymat,NoeKetab " +
"FROM Book ";
objDataAdapter.SelectCommand.CommandType =CommandType.Text;
// Open the database connection...
objConnection.Open();
// Fill the DataSet object with data...
objDataAdapter.Fill(objDataSet, "Book");
// Close the database connection...
objConnection.Close();
// Set the DataGridView properties
// to bind it to our data...
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objDataSet;
dataGridView1.DataMember = "Book";
// Clean up
objDataAdapter = null;
objConnection = null;
}
با این دستورات برنامه رو run می کنم فرمم بالا نمیاد و اما هیچ پیغامی هم نمیده . ایراد کارم کجاست؟