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 don't 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. I'm 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. :(