我正在尝试将此 VB.NET 代码转换为 C#:
Protected Sub BT_KEM_CARIAN_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BT_KEM_CARIAN.Click
Dim cmd As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand("Select * from pengguna where idpengguna = @idpengguna", myconn)
cmd.CommandType = Data.CommandType.Text
cmd.Connection = myconn
Try
myconn.Open()
Dim rdr2 As SqlDataReader
cmd.Parameters.AddWithValue("idpengguna", KEMASKINI_MASUK.Text)
rdr2 = cmd.ExecuteReader(CommandBehavior.CloseConnection)
rdr2.Read()
KEMASKINI_ID.Text = rdr2("IDPENGGUNA").ToString
KEMASKINI_IC.Text = rdr2("NoIC").ToString()
KEMASKINI_NAMA.Text = rdr2("nama").ToString()
KEMASKINI_MASUK.Text = rdr2("idpengguna").ToString()
KEMASKINI_CAPAIAN.Text = rdr2("kodaccesslevel").ToString()
Catch
MsgBox("Succesfully Updated")
End Try
myconn.Close()
MultiView1.SetActiveView(View4)
End Sub
Result:
protected void BT_KEM_CARIAN_Click(object sender, System.EventArgs e)
{
System.Data.SqlClient.SqlConnection myconn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.AppSettings["DB"]);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("Select * from pengguna where idpengguna = @idpengguna", myconn);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = myconn;
try {
myconn.Open();
SqlDataReader rdr2 = default(SqlDataReader);
cmd.Parameters.AddWithValue("idpengguna", KEMASKINI_MASUK.Text);
rdr2 = cmd.ExecuteReader(CommandBehavior.CloseConnection);
rdr2.Read();
KEMASKINI_ID.Text = rdr2("IDPENGGUNA").ToString;
KEMASKINI_IC.Text = rdr2("NoIC").ToString();
KEMASKINI_NAMA.Text = rdr2("nama").ToString();
KEMASKINI_MASUK.Text = rdr2("idpengguna").ToString();
KEMASKINI_CAPAIAN.Text = rdr2("kodaccesslevel").ToString();
} catch {
Interaction.MsgBox("Succesfully Updated");
}
myconn.Close();
MultiView1.SetActiveView(View4);
}
下面的代码给出了错误
rdr2 是一个“变量”,但像“方法”一样使用
KEMASKINI_ID.Text = rdr2("IDPENGGUNA").ToString;
KEMASKINI_IC.Text = rdr2("NoIC").ToString();
KEMASKINI_NAMA.Text = rdr2("nama").ToString();
KEMASKINI_MASUK.Text = rdr2("idpengguna").ToString();
KEMASKINI_CAPAIAN.Text = rdr2("kodaccesslevel").ToString();
在 C# 中,数组项是用方括号引用的,而 VB 中所有内容都用括号引用。改成这样:
KEMASKINI_ID.Text = rdr2["IDPENGGUNA"].ToString();
KEMASKINI_IC.Text = rdr2["NoIC"].ToString();
KEMASKINI_NAMA.Text = rdr2["nama"].ToString();
KEMASKINI_MASUK.Text = rdr2["idpengguna"].ToString();
KEMASKINI_CAPAIAN.Text = rdr2["kodaccesslevel"].ToString();
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)