ليست برنامه Load كردن اطلاعات
با كمي تصرف:
در #C:
using System.Data;
using System.Data.SqlClient;
.
.
.
SqlConnection cnn = new SqlConnection();
SqlDataAdapter sda = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
privatevoid Connect()
{
cnn.ConnectionString = "Data Source=Computer1;initial catalog=StorDB ;integrated security=true;";
}
private DataSet LoadAll()
{
Connect();
cmd.CommandText = "select * from Table";
cmd.Connection = cnn;
sda.SelectCommand = cmd;
cnn.Open();
sda.Fill(ds , "Barnamenevis");
cnn.Close();
return ds;
}
private void Form1_Load(object sender, EventArgs e)
{
LoadAll();
dataGridView1.DataSource = ds;
dataGridView1 .DataMember ="Barnamenevis";
}
}
}
در VB.NET:
Imports System.Data
Imports System.Data.SqlClient
PublicClass Form1
Dim cnn As New SqlConnection()
Dim cmd As New SqlCommand()
Dim sda As New SqlDataAdapter()
Dim ds As New DataSet()
Private Sub Connect()
cnn.ConnectionString = "Data Source=Computer1;initial catalog=StorDB ;integrated security=true;"
End Sub
Private Function LoadAll() As DataSet
Connect()
cmd.CommandText = "select * from Table"
cmd.Connection = cnn
sda.SelectCommand = cmd
sda.SelectCommand.Connection = cnn
cnn.Open()
sda.Fill(ds, "Barnamenevis")
cnn.Close()
Return ds
End Function
PrivateSub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesMyBase.Load
LoadAll()
DataGridView1.DataSource = ds
DataGridView1.DataMember = "Barnamenevis"
End Sub
End Class
