Converting this Code to C#

I am trying to use this code from VB to C#..I tried to converting it but i get an Function error? can anyone please help me? Private Sub Datalist1_ItemCommand(ByVal source As Object, _ ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles Datalist1.ItemCommand If e.CommandName = "Show" Then Dim EmpIDlabel As Label = e.Item.FindControl("lblEID") Dim strEmpID As String = EmpIDlabel.Text CType(e.Item.FindControl("Datagrid1"), DataGrid).DataSource = GetEmpDetails(strEmpID) CType(e.Item.FindControl("Datagrid1"), DataGrid).DataBind() CType(e.Item.FindControl("Datagrid1"), DataGrid).Visible = True CType(e.Item.FindControl("btnDetails"), LinkButton).Text = "-" CType(e.Item.FindControl("btnDetails"), LinkButton).CommandName = "Hide" End If If e.CommandName = "Hide" Then CType(e.Item.FindControl("Datagrid1"), DataGrid).Visible = False CType(e.Item.FindControl("btnDetails"), LinkButton).Text = "+" CType(e.Item.FindControl("btnDetails"), LinkButton).CommandName = "Show" End If End Sub Function GetEmpDetails(ByVal Employeeid As String) As SqlDataReader Const strConnString As String = "server=localhost;uid=sa;pwd=;database=northwind" Dim objConn As New SqlConnection(strConnString) Dim strSQL As String strSQL = "SELECT FirstName , LastName ,Title, Address FROM Employees " & _ "WHERE Employeeid = @Employeeid" Dim objCmd As New SqlCommand(strSQL, objConn) Dim paramEmployeeid As SqlParameter paramEmployeeid = New SqlParameter("@Employeeid", SqlDbType.VarChar, 10) paramEmployeeid.Value = Employeeid objCmd.Parameters.Add(paramEmployeeid) objConn.Open() 'Open the connection Return objCmd.ExecuteReader(CommandBehavior.CloseConnection) End Function

Did you try running it through the VB.NET to C# converter, Instant C# ? (www.instantcsharp.com) I get: //TODO: INSTANT C# TODO TASK: Insert the following converted event handlers at the end of the 'InitializeComponent' method for forms or into a constructor for other classes: Datalist1.ItemCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(Datalist1_ItemCommand); //INSTANT C# NOTE: This method is an event handler //ORIGINAL LINE: Private Sub Datalist1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles Datalist1.ItemCommand private void Datalist1_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e) { if (e.CommandName == "Show") { Label EmpIDlabel = e.Item.FindControl("lblEID"); string strEmpID = EmpIDlabel.Text; ((DataGrid)(e.Item.FindControl("Datagrid1"))).DataSource = GetEmpDetails(strEmpID); ((DataGrid)(e.Item.FindControl("Datagrid1"))).DataBind(); ((DataGrid)(e.Item.FindControl("Datagrid1"))).Visible = true; ((LinkButton)(e.Item.FindControl("btnDetails"))).Text = "-"; ((LinkButton)(e.Item.FindControl("btnDetails"))).CommandName = "Hide"; } if (e.CommandName == "Hide") { ((DataGrid)(e.Item.FindControl("Datagrid1"))).Visible = false; ((LinkButton)(e.Item.FindControl("btnDetails"))).Text = "+"; ((LinkButton)(e.Item.FindControl("btnDetails"))).CommandName = "Show"; } } public SqlDataReader GetEmpDetails(string Employeeid) { const string strConnString = "server=localhost;uid=sa;pwd=;database=northwind"; SqlConnection objConn = new SqlConnection(strConnString); string strSQL = null; strSQL = "SELECT FirstName , LastName ,Title, Address FROM Employees " + "WHERE Employeeid = @Employeeid"; SqlCommand objCmd = new SqlCommand(strSQL, objConn); SqlParameter paramEmployeeid = null; paramEmployeeid = new SqlParameter("@Employeeid", SqlDbType.VarChar, 10); paramEmployeeid.Value = Employeeid; objCmd.Parameters.Add(paramEmployeeid); objConn.Open(); //Open the connection return objCmd.ExecuteReader(CommandBehavior.CloseConnection); }

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

vitenyi_i22y ago
Did you try running it through the VB.NET to C# converter, Instant C# ? (www.instantcsharp.com) I get: //TODO: INSTANT C# TODO TASK: Insert the following converted event handlers at the end of the 'InitializeComponent' method for forms or into a constructor for other classes: Datalist1.ItemCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(Datalist1_ItemCommand); //INSTANT C# NOTE: This method is an event handler //ORIGINAL LINE: Private Sub Datalist1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles Datalist1.ItemCommand private void Datalist1_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e) { if (e.CommandName == "Show") { Label EmpIDlabel = e.Item.FindControl("lblEID"); string strEmpID = EmpIDlabel.Text; ((DataGrid)(e.Item.FindControl("Datagrid1"))).DataSource = GetEmpDetails(strEmpID); ((DataGrid)(e.Item.FindControl("Datagrid1"))).DataBind(); ((DataGrid)(e.Item.FindControl("Datagrid1"))).Visible = true; ((LinkButton)(e.Item.FindControl("btnDetails"))).Text = "-"; ((LinkButton)(e.Item.FindControl("btnDetails"))).CommandName = "Hide"; } if (e.CommandName == "Hide") { ((DataGrid)(e.Item.FindControl("Datagrid1"))).Visible = false; ((LinkButton)(e.Item.FindControl("btnDetails"))).Text = "+"; ((LinkButton)(e.Item.FindControl("btnDetails"))).CommandName = "Show"; } } public SqlDataReader GetEmpDetails(string Employeeid) { const string strConnString = "server=localhost;uid=sa;pwd=;database=northwind"; SqlConnection objConn = new SqlConnection(strConnString); string strSQL = null; strSQL = "SELECT FirstName , LastName ,Title, Address FROM Employees " + "WHERE Employeeid = @Employeeid"; SqlCommand objCmd = new SqlCommand(strSQL, objConn); SqlParameter paramEmployeeid = null; paramEmployeeid = new SqlParameter("@Employeeid", SqlDbType.VarChar, 10); paramEmployeeid.Value = Employeeid; objCmd.Parameters.Add(paramEmployeeid); objConn.Open(); //Open the connection return objCmd.ExecuteReader(CommandBehavior.CloseConnection); }