i wrote this in vb so it is just like a C#
from your question i assume this so please write your code if this is not what you want???
'for VB
FOR CONNECTION
Public cn As New SqlClient.SqlConnection
Public Sub cnopen(){
Dim ConnectionString As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=G:\blabla.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=true;"
cn = New SqlClient.SqlConnection(ConnectionString)
cn.Open()
End Sub
}
sub selectDataFromDatabase(){ 'subroutine to trigger
Dim dataFile As New DataSet 'creating new dataset
qry = "select * from `tablename`" 'query string
Dim cmd As New SqlClient.SqlCommand(qry, cn) 'qry="query string" cn= connection
Dim da As New SqlClient.SqlDataAdapter(cmd)
dataFile.Clear()
da.Fill(dataFile)
dataLists.DataSource = dataFile.Tables(0) 'here datalist is a datagridview
}
'to clear the datagridview
sub clearGrid(){
dataLists.columns.clear() 'you don't have to clear the row only columns clear will clear the datagridview
}
'how to use it
'to select the data
selectDataFromDatabase()
'to clear grid
clearGrid()
For C#
void selectDataFromDatabase(){ 'subroutine to trigger
Dim dataFile As New DataSet; 'creating new dataset
qry = "select * from `tablename`;" 'query string
Dim cmd As New SqlClient.SqlCommand(qry, cn); 'qry="query string" cn= connection
Dim da As New SqlClient.SqlDataAdapter(cmd);
dataFile.Clear();
da.Fill(dataFile);
dataLists.DataSource = dataFile.Tables(0) 'here datalist is a datagridview;
}
'to clear the datagridview
void clearGrid(){
dataLists.columns.clear(); 'you don't have to clear the row only columns clear will clear the datagridview
}
if this is not what you want that please send your code i will look at it
Submit an article or tip