or
myconn =
New
SqlConnection(constr)
myconn.Open()
mycomm =
New
SqlCommand(
"Select * from tab1 "
, myconn)
reader = mycomm.ExecuteReader
reader.Read()
DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(0).Value = reader(0).ToString.ToUpper
DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(1).Value = reader(1).ToString.ToUpper
DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(2).Value = reader(2).ToString.ToUpper
DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(3).Value = reader(3).ToString.ToUpper
DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(4).Value = reader(4).ToString.ToUpper
reader.Close()
myconn.Close()
radAutoCompleteBox1.AutoCompleteItems.Add(
"@office"
);
radAutoCompleteBox1.AutoCompleteItems.Add(
"@errands"
);
radAutoCompleteBox1.AutoCompleteItems.Add(
"@home"
);
radAutoCompleteBox1.AutoCompleteItems.Add(
"@furnitureshop"
);
radAutoCompleteBox1.AutoCompleteItems.Add(
"@computer"
);
radAutoCompleteBox1.AutoCompleteItems.Add(
"#garagecleanup"
);
radAutoCompleteBox1.AutoCompleteItems.Add(
"#interior"
);
radAutoCompleteBox1.AutoCompleteItems.Add(
"#projectx"
);