Public Class Data
    Public Function ProjMain() As DataSet
        Dim objData As ConnectSql
        Dim objcom As SqlCommand
        Try
            objData = New ConnectSql
            objData.CreateCommand(objcom, CommandType.StoredProcedure, "ProjMain")
            ProjMain = objData.CreateDataset("Data", objcom)
            objcom.ExecuteReader()
        Catch ex As Exception
        End Try
    End Function
end class

venkat

If you remove your Try Catch block this code is almost certainly throwing an error. You never call your connection string from your webconfig file nor do you return anything. The code your provided executes as a method, not a function.

DataTable getDataTable()
{
 DataTable tempDT = new DataTable();
 daSql = new SqlDataAdapter();
 sqlCmd = new SqlCommand();
 sqlConn = new SqlConnection();
 daSql.SelectCommand = sqlCmd;
 sqlCmd.Connection = sqlConn;
 sqlConn.ConnectionString = ConfigurationSettings.AppSettings("ConnectionStrin g");
 sqlCmd.CommandText = [SQL Statement];
 daSql.Fill(tempDT);
 return tempDT;
}

That code returns a datatable.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

i'm beginner in ASP.net pl. explain ur code

i enter ur code

but error : declaration expected

Just try the code below, it should work for you:

Dim sConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("C onnectionString"))
            Dim sQuery As String = "spTest"

            sConn.Open()
            Dim sqlCmd As SqlCommand = New SqlCommand(sQuery,sConn)
            sqlCmd.CommandType = CommandType.StoredProcedure
            Dim da As SqlDataAdapter = New SqlDataAdapter(sqlCmd)
            Dim ds As DataSet = New DataSet()
            da.Fill(ds)

            DataGrid1.DataSource = ds
            DataGrid1.DataBind()
            sConn.Close()

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

mike, where is put ur code

Friend,

Don't mind, I guess first you need to study some programming basics, and then move to .net.

Anyways, the code I gave you can be put wherever you wish to bind the datagrid, say on page_load.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

The declartaion error that my code throws is because, in my code that I supplied, I do not declare my Sql objects in that function; I thought it was obvious that one would need to delare the objects to use that function.

I understand that you are a beginner to .NET and I applaud you for wanting to learn, however, I agree with Mike here. It seems that you need to study some programming basics before you start in on hard core .NET programming. I suggest picking up a book or reading any of the various resources that come up on google to get you started.


-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thanks Mike & Dparson ur guidance

Please send us code dat u have wrote for binding data

ragards

Pravin Patil

Dim sConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("C onnectionString"))
            Dim sQuery As String = "spTest"

            sConn.Open()
            Dim sqlCmd As SqlCommand = New SqlCommand(sQuery,sConn)
            sqlCmd.CommandType = CommandType.StoredProcedure
            Dim da As SqlDataAdapter = New SqlDataAdapter(sqlCmd)
            Dim ds As DataSet = New DataSet()
            da.Fill(ds)

            DataGrid1.DataSource = ds
            DataGrid1.DataBind()
            sConn.Close()

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.