Visual studio 2005 express vs Visual studio 2005 standard or pro

Hi all
Im not sure if you will be able to answer my question. Im using express version of visual basic, which has a particular pain in the you no where limitation. I cannot through the database explorer connect to a remote sql express 2005. I no this is a limitation. I have looked at the option of buying Visual studio however I only need the VB module. From what I see you have to buy the whole version, which contains C#, JSP and more. I do not need them. I do not see the point of paying for all the modules but I only use VB.
 Questions
Can you buy them seperately.
Is there another workaround to communicate with a remote sql 2005 express without using database explorer.
 
Thanks
 
 

You can use remote server in code behind. I use it all the time. Just that I don't get the explorer.
Thanks,
Max
Let Me Google That For You!

Hi 
Thanks for the quick reply. Do you have some example code for me to view
Regards
 Warren 
 

This is one of the functions I use in one my websites.
 
 private DataSet GetSalesDataFull()
  {
     DataSet ds = new DataSet();
     string sqlSalesData = @"SELECT * FROM Customers";
     SqlConnection connection = new SqlConnection("Data Source=<SERVER_NAME>;Initial Catalog=<DATABASE_NAME>;Integrated Security=True");
     SqlCommand command = new SqlCommand(sqlSalesData, connection);
     SqlDataAdapter salesOrderAdapter = new SqlDataAdapter(command);
     salesOrderAdapter.Fill(ds, "TABLE_NAME");
     salesOrderAdapter.Dispose();
     command.Dispose();
     return ds;
  }
 
Thanks,
Max
Let Me Google That For You!

Thanks for the help I appreciate it. I will play with the code and see what I get. I see its in C#. Thats ok its not difficult to convert to vb.
 
Thanks