Converting VB to C#

[tehon3299]

I am using the code below (VB) to insert things into an SQL database. I want to use this code on a C# page. How can I do this?

           	Dim MyCommand As New SqlCommand
			Dim MyConnection As New SqlConnection
			Dim MySQLDataAdapter as New SqlDataAdapter
			Dim SessionCmd As String

			SessionCmd = "INSERT INTO tmPicIndex (UserID, PicName, PicDesc) VALUES (" & user & ", " & savename.Value & ", 0)"
			
			MyConnection = New SqlConnection("server=(local);database=PictureShare;Trusted_Connection=yes")
							
			MyCommand = New SqlCommand(SessionCmd, MyConnection)

			MyCommand.Connection.Open()
				
				Try
					MyCommand.ExecuteNonQuery()
				Catch Exp As SQLException
					If Exp.Number = 2627
			            
					Else
			            
					End If
				End Try
				
			MyCommand.Connection.Close()

 

[Robby]

try this...

MyConnection = new SqlConnection("server=127.0.0.1;database=PictureShare;Trusted_Connection=yes");
MySQLDataAdapter = new SqlDataAdapter();
SessionCmd String = "INSERT INTO tmPicIndex (UserID, PicName, PicDesc) VALUES (" & user & ", " & savename.Value & ", 0)";
MyCommand = new SqlCommand(SessionCmd, MyConnection);

MyCommand.Connection.Open();
    
try
{
	MyCommand.ExecuteNonQuery();
}
catch(SQLException Exp)
{
	if (Exp.Number == 2627)
	{

	}
	else
	{
            
	}
}
MyCommand.Connection.Close();

 

[Bucky]

If you want to use VB code in a C# project without having to
convert it all, you could compile the VB code into a class library
project that you can reference from your C# project. Then
you can use all the methods and properties in it just like any class.

 

[Volte]

You dont even need to compile it; just create a new VB project in
your solution and insert the class.

 

[tehon3299]

I used that code and it tells me that MyConnection is not declared. Im importing the same things for SQL in VB and C#. Do I need to import something else?

 

[Bucky]

The declaration for these variables should be as follows:

SqlConnection MyConnection = new SqlConnection("server=127.0.0.1;database=PictureShare;Trusted_Connection=yes");
SqlDataAdapter MySQLDataAdapter = new SqlDataAdapter();
string SessionCmd = "INSERT INTO tmPicIndex (UserID, PicName, PicDesc) VALUES (" + user + ", " + savename.Value + ", 0)";
SqlCommand MyCommand = new SqlCommand(SessionCmd, MyConnection);

 

[Robby]

Oops, I made a mess of that one.