locked
Display data from Access in different controls RRS feed

  • Question

  • User-1998474842 posted

    dear all

    please can some one tell us below cod in c#

    <%@ Page Language=VB Debug=true %>
    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.OLEDB" %>
    <script runat=server>
    Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)
        If Not IsPostBack Then
            Dim DBConn as OleDbConnection
            Dim DBCommand As OleDbDataAdapter
            Dim DSPageData as New DataSet
            DBConn = New OleDbConnection_
                "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
                "DATA SOURCE=" _
                & Server.MapPath("EmployeeDatabase.mdb;"))
            DBCommand = New OleDbDataAdapter _
                ("Select LastName & ', ' & FirstName " _
                "as EmpName, ID " _
                "From Employee " _
                "Order By LastName, FirstName", DBConn)
            DBCommand.Fill(DSPageData, _
                "EmployeeNames")
            DBCommand = New OleDbDataAdapter _
                ("Select * from Employee", DBConn)
            DBCommand.Fill(DSPageData, _
                "EmployeesAll")
            DBCommand = New OleDbDataAdapter _
                ("Select LastName from Employee", DBConn)
            DBCommand.Fill(DSPageData, _
                "Emp3")
            ddlEmps.DataSource = _
                DSPageData.Tables("EmployeeNames").DefaultView
            ddlEmps.DataBind()
            dgEmps2.DataSource = _
                DSPageData.Tables("EmployeesAll").DefaultView
            dgEmps2.DataBind()
            dgEmps3.DataSource = _
                DSPageData.Tables("Emp3").DefaultView
            dgEmps3.DataBind()
        End If
    End Sub
    </SCRIPT>
    <HTML>
    <HEAD>
    <TITLE>Retrieving Access Data</TITLE>
    </HEAD>
    <Body LEFTMARGIN="40">
    <form runat="server">
    <BR><BR>
    <asp:dropdownlist
        id="ddlEmps"
        datatextfield="EmpName" 
        datavaluefield="ID"
        runat="server"
    />
    <BR><BR>
    <asp:datagrid
        id="dgEmps2" 
        runat="server" 
        autogeneratecolumns="True"
    >
    </asp:datagrid>
    <BR><BR>
    <asp:datagrid
        id="dgEmps3" 
        runat="server" 
        autogeneratecolumns="True"
    >
    </asp:datagrid>
    </form>
    </BODY>
    </HTML>

    Sunday, April 1, 2012 6:56 AM

Answers

  • User-1618234021 posted

    Use the following to conver:

    http://www.developerfusion.com/tools/convert/vb-to-csharp/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, April 1, 2012 7:00 AM
  • User3866881 posted

    Hello peshagm:)

    Yes,you can just do a converting from VB.net to C# using the tool given to you by the 2nd man!Here's the result:

    public void Page_Load(object Sender, EventArgs E)
    {
    	if (!IsPostBack) {
    		OleDbConnection DBConn = default(OleDbConnection);
    		OleDbDataAdapter DBCommand = default(OleDbDataAdapter);
    		DataSet DSPageData = new DataSet();
    		DBConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" + "DATA SOURCE=" + Server.MapPath("EmployeeDatabase.mdb;"));
    		DBCommand = new OleDbDataAdapter("Select LastName & ', ' & FirstName " + "as EmpName, ID " + "From Employee " + "Order By LastName, FirstName", DBConn);
    		DBCommand.Fill(DSPageData, "EmployeeNames");
    		DBCommand = new OleDbDataAdapter("Select * from Employee", DBConn);
    		DBCommand.Fill(DSPageData, "EmployeesAll");
    		DBCommand = new OleDbDataAdapter("Select LastName from Employee", DBConn);
    		DBCommand.Fill(DSPageData, "Emp3");
    		ddlEmps.DataSource = DSPageData.Tables["EmployeeNames"].DefaultView;
    		ddlEmps.DataBind();
    		dgEmps2.DataSource = DSPageData.Tables["EmployeesAll"].DefaultView;
    		dgEmps2.DataBind();
    		dgEmps3.DataSource = DSPageData.Tables["Emp3"].DefaultView;
    		dgEmps3.DataBind();
    	}
    }



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 2, 2012 8:49 PM

All replies

  • User-1618234021 posted

    Use the following to conver:

    http://www.developerfusion.com/tools/convert/vb-to-csharp/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, April 1, 2012 7:00 AM
  • User3866881 posted

    Hello peshagm:)

    Yes,you can just do a converting from VB.net to C# using the tool given to you by the 2nd man!Here's the result:

    public void Page_Load(object Sender, EventArgs E)
    {
    	if (!IsPostBack) {
    		OleDbConnection DBConn = default(OleDbConnection);
    		OleDbDataAdapter DBCommand = default(OleDbDataAdapter);
    		DataSet DSPageData = new DataSet();
    		DBConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" + "DATA SOURCE=" + Server.MapPath("EmployeeDatabase.mdb;"));
    		DBCommand = new OleDbDataAdapter("Select LastName & ', ' & FirstName " + "as EmpName, ID " + "From Employee " + "Order By LastName, FirstName", DBConn);
    		DBCommand.Fill(DSPageData, "EmployeeNames");
    		DBCommand = new OleDbDataAdapter("Select * from Employee", DBConn);
    		DBCommand.Fill(DSPageData, "EmployeesAll");
    		DBCommand = new OleDbDataAdapter("Select LastName from Employee", DBConn);
    		DBCommand.Fill(DSPageData, "Emp3");
    		ddlEmps.DataSource = DSPageData.Tables["EmployeeNames"].DefaultView;
    		ddlEmps.DataBind();
    		dgEmps2.DataSource = DSPageData.Tables["EmployeesAll"].DefaultView;
    		dgEmps2.DataBind();
    		dgEmps3.DataSource = DSPageData.Tables["Emp3"].DefaultView;
    		dgEmps3.DataBind();
    	}
    }



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 2, 2012 8:49 PM