| Author: balamurugan 04 Jul 2008 | Member Level: Gold | Rating:  Points: 1 |
dim da as new sqldataadapter("query",connection)
dim ds as new dataset
da.fill(ds)
|
| Author: UltimateRengan 04 Jul 2008 | Member Level: Diamond | Rating: Points: 1 |
Dim strConn As String
strConn = "USER=NewSCM;PASSWORD=asd;SERVER=asd;DATABASE=Emp"
Dim MySQL As String = "Select empno, empname from Emptbl"
Dim MyConn As New SqlClient.SqlConnection(strConn)
Dim ds As DataSet = New DataSet()
Dim Cmd As New SqlClient.SqlDataAdapter(MySQL, MyConn)
Cmd.Fill(ds, "Emptbl")
MyDataGrid.DataSource = ds.Tables("Emptbl").DefaultView
MyDataGrid.DataBind()
Advance Happy Diwali
SAP B1
|
| Author: VinothKumar 04 Jul 2008 | Member Level: Gold | Rating: Points: 6 |
Hi try this..
DataSet ds = CreateDataRow();
private DataSet CreateDataRow()
{
DataTable myTable = CreateDataTable();
DataRow dRow;
dRow = myTable.NewRow();
dRow["CompanyID"] = 1;
dRow["Name"] = "Vinoth";
dRow["Address"] = "Udumalpet";
dRow["City"] = "Coimbatore";
dRow["State"] = "TamilNadu";
dRow["Country"] = "India";
dRow["OfficePhone"] = 123;
myTable.Rows.Add(dRow);
DataSet dsIncomeAnalysis = new DataSet();
dsIncomeAnalysis.Tables.Add(myTable);
return dsIncomeAnalysis;
}
private DataTable CreateDataTable()
{
DataTable myDataTable = new DataTable();
DataColumn myDataColumn;
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetTyp("System.String");
myDataColumn.ColumnName = "CompanyID";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetTyp("System.String");
myDataColumn.ColumnName = "Name";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetTyp("System.String");
myDataColumn.ColumnName = "Address";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetTyp("System.String");
myDataColumn.ColumnName = "City";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetTyp("System.String");
myDataColumn.ColumnName = "State";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetTyp("System.String");
myDataColumn.ColumnName = "Country";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetTyp("System.String");
myDataColumn.ColumnName = "OfficePhone";
myDataTable.Columns.Add(myDataColumn);
return myDataTable;
}
Hope this helps..
vino...
Note:
If this has answered your query, kindly rate it.
|
| Author: mohamed jamal 04 Jul 2008 | Member Level: Gold | Rating: Points: 6 |
Dim strConn As String
strConn = "USER=NewSCM;PASSWORD=asd;SERVER=asd;DATABASE=Emp"
Dim MySQL As String = "Select empno, empname from Emptbl"
Dim MyConn As New SqlClient.SqlConnection(strConn)
Dim ds As DataSet = New DataSet()
Dim Cmd As New SqlClient.SqlDataAdapter(MySQL, MyConn)
Cmd.Fill(ds, "Emptbl")
MyDataGrid.DataSource = ds.Tables("Emptbl").DefaultView
MyDataGrid.DataBind()
|