[bunny20]

Can anyone tell me what's the equivalent of this vb codes in c#?

Private Sub cmdAddSave_Click()
Dim rs As New ADODB.Recordset
rs.Open "Select * From UserAccount", Conn, 3, 3
With rs rs.AddNew
	 rs!UserName = txtUserName.Text
	 rs!LastName = txtLastName.Text
	 rs!FirstName = txtFirstName.Text
	 rs!MiddleName = txtMiddleInitial.Text
	 rs!Age = txtAge.Text
	 rs!Gender = cboGender.Text
	 rs!Password = txtPassword.Text
	 rs.Update
	 MsgBox "New User Account Successfully Sav"
	ed", vbInformation + vbOKOnly, "User Name"
	 End With
  Set rs = Nothing
End Sub

it's a great help...

thank you...

[dklingman]

click here

sorry ignore that link! i looked at the code to quick and didn't realize that it was vb6 code and not vb.net

[bunny20]

please someone gave me an equivalent of the above codes in C#.....

That was my project last semester in VB6 and I want to convert it in C# but since I'm new in C# I don't know the equivalents of those codes....

It's really a great , great , great help if you can provide an equivalent...

[b.ihde]

Hi! I m not a C# pro but maybe i can help a little bit.. I m also not at work so i cannot
use C# right now.. All i can do is to try..

I m sure this have to be modified a little bit to get the right answer..

But let me try:

private void cmdAddSave_Click(object Sender, EventArgs e)
Recordset rs = new Recordset(); // don´t really know what´s: ADODB.
rs.Open(UserAccount, Conn, 3, 3); // don´t really know how to convert: "Select * From UserAccount", Conn, 3, 3
	 rs.Add(UserName, LastName, FirstName, MiddleName, Age, Gender, Password);
	 UserName = txtUserName.Text
	 LastName = txtLastName.Text
	 FirstName = txtFirstName.Text
	 MiddleName = txtMiddleInitial.Text
	 Age = txtAge.Text
	 Gender = cboGender.Text
	 Password = txtPassword.Text

	 rs.Update();

	 MessageBox.Show("New User Account Successfully Sav");
	 ed", vbInformation + vbOKOnly, "User Name" // what´s ed??? maybe the MessageBoxdetails?Then it would be:

		string message = "New User Account Successfully Sav\r\n" + txtUsername.Text;
		string caption = "User Account";
		MessageBoxButtons buttons = MessageBoxButtons.OK;
		MessageBoxIcon icon = MessageBoxIcon.Information;

	 MessageBox.Show(message, caption, buttons, icon);

  Set rs = Nothing // I don´t know again..

I hope this helps you a little bit, or just helps other to complete it...

regards

B.Ihde

[bunny20]

b.ihde, on 13 Jan, 2009 - 12:36 AM, said:

Hi! I m not a C# pro but maybe i can help a little bit.. I m also not at work so i cannot
use C# right now.. All i can do is to try..

I m sure this have to be modified a little bit to get the right answer..

But let me try:

private void cmdAddSave_Click(object Sender, EventArgs e)
Recordset rs = new Recordset(); // don´t really know what´s: ADODB.
rs.Open(UserAccount, Conn, 3, 3); // don´t really know how to convert: "Select * From UserAccount", Conn, 3, 3
	 rs.Add(UserName, LastName, FirstName, MiddleName, Age, Gender, Password);
	 UserName = txtUserName.Text
	 LastName = txtLastName.Text
	 FirstName = txtFirstName.Text
	 MiddleName = txtMiddleInitial.Text
	 Age = txtAge.Text
	 Gender = cboGender.Text
	 Password = txtPassword.Text

	 rs.Update();

	 MessageBox.Show("New User Account Successfully Sav");
	 ed", vbInformation + vbOKOnly, "User Name" // what´s ed??? maybe the MessageBoxdetails?Then it would be:

		string message = "New User Account Successfully Sav\r\n" + txtUsername.Text;
		string caption = "User Account";
		MessageBoxButtons buttons = MessageBoxButtons.OK;
		MessageBoxIcon icon = MessageBoxIcon.Information;

	 MessageBox.Show(message, caption, buttons, icon);

  Set rs = Nothing // I don´t know again..

I hope this helps you a little bit, or just helps other to complete it...

regards

B.Ihde

It's okay...anyway thank you for the effort of helping me...
I will try the code....

Thanks again...

[dklingman]

i don't know exactly what you're using as for you're connection string and/or the ado.net provider you're using but this should get you started.

			System.Data.OleDb.OleDbConnection cnn = new System.Data.OleDb.OleDbConnection("the connection string");

			cnn.Open();
			System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter("Select * From UserAccount",cnn);
			System.Data.OleDb.OleDbCommandBuilder builder = new System.Data.OleDb.OleDbCommandBuilder(da);
			
			DataTable dt = new DataTable("theTable");

			da.Fill(dt);
			
			DataRow dr = dt.NewRow();

			dr["UserName"] = txtUserName.Text;
			dr["LastName"] = txtLastName.Text;
			dr["FirstName"] = txtFirstName.Text;
			dr["MiddleName"] = txtMiddleInitial.Text;
			dr["Age"] = txtAge.Text;
			dr["Gender"] = cboGender.Text;
			dr["Password"] = txtPassword.Text;
			dt.Rows.Add(dr);

			da.InsertCommand = builder.GetInsertCommand();
			da.Update(dt);
			dt.Dispose();
			dt = null;
			da.Dispose();
			da = null;
			cnn.Close();
			cnn.Dispose();
			cnn = null;

[b.ihde]

Thank god, that we have some competent use here

[dklingman]

b.ihde, on 13 Jan, 2009 - 08:18 AM, said:

Thank god, that we have some competent use here

no one ever said i was competent, i mean look at me with that hat on

This post has been edited by dklingman: 13 January 2009 - 07:33 AM

[JackOfAllTrades]

bunny20, on 12 Jan, 2009 - 11:53 PM, said:

please someone gave me an equivalent of the above codes in C#.....

That was my project last semester in VB6 and I want to convert it in C# but since I'm new in C# I don't know the equivalents of those codes....

It's really a great , great , great help if you can provide an equivalent...

Perhaps, if you want to learn C#, you should actually make an attempt at doing so rather than just coming to DIC and asking someone to do it for you.

If you don't want to actually *learn* C#, then I would say you should hire someone if you're unwilling to even give it a try.

[b.ihde]

dklingman, on 13 Jan, 2009 - 06:33 AM, said:

no one ever said i was competent, i mean look at me with that hat on

I said so! haha but you re right, when i look at your hat... I really have to think about it again