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

 

 

0
wstevens
6/1/2007 4:55:12 PM
📁 asp.net.visual-studio-2005
📃 7760 articles.
⭐ 0 followers.

💬 4 Replies
👁️‍🗨️ 1231 Views

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!
0
bullpit
6/1/2007 5:10:07 PM

Hi

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

Regards

 Warren 

 

0
wstevens
6/1/2007 5:53:50 PM

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!
0
bullpit
6/1/2007 5:58:39 PM

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

 

 

0
wstevens
6/2/2007 5:47:11 AM
Reply: