20-04-13, 02:09 AM
لو مثلا الجدول اسمه Table1
والحقول ID, Name, Address, Phone
اعمل الجملة كالتالي
والحقول ID, Name, Address, Phone
اعمل الجملة كالتالي
كود :
dim cs as new New SqlConnection = "ضع جملة الاتصال بقاعدة البينات هنا"
Dim ds As New DataSet
Dim sql As String = "Select * from table1"
Dim da As New SqlDataAdapter(sql, cs)
da.fill(ds, "Table1")
for i as integer = 0 to Me.BindingContext(ds, "Table1").Count - 1
datagridview1.rows.add(new string() {Me.BindingContext(ds, "Table1").Current("ID"), Me.BindingContext(ds, "Table1").Current("Name"), Me.BindingContext(ds, "Table1").Current("Address"), Me.BindingContext(ds, "Table1").Current("Phone")}
Me.BindingContext(ds, "Table1").Position +=1
next