SQL_CONNECTION.ConnectionString = "Data Source =192.168.1.200; Database=DBName; User ID=sa; Password=password; Connect Timeout=0"
SQL_CONNECTION.Open() MyQuery = "SELECT * From TableName" MyCommand = New SqlCommand(MyQuery, SQL_CONNECTION) MyDataReader = MyCommand.ExecuteReader RowNo = 0 GridName.RowCount = 0 While MyDataReader.Read GridName.Rows.Add(1) GridName.Rows(RowNo).Cells(1).Value = MyDataReader!FieldName RowNo=RowNo+1 End While SQL_CONNECTION.Close()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)