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 |
![]() |
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 |
![]() |
Hi
Thanks for the quick reply. Do you have some example code for me to view
Regards
Warren
![]() |
0 |
![]() |
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 |
![]() |
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 |
![]() |