Missing Data Source Options, MS Visual Basic 2008 Express

OxonDev
OxonDev used Ask the Experts™
on
When I try to create a Data Connection in VB 2008 Express I don't have the same Data Source options as I do in Visual Web Developer 2008 Express.

The "Microsoft SQL Server" Data Source option in VWDE isn't there in VBE.  Both are loaded on the same machine as SQL Server Express 2008.  
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
No IDE support for databases other than SQL Server Express and Microsoft Access

http://en.wikipedia.org/wiki/Microsoft_Visual_Studio_Express

Commented:
if you want to use coding ..follow the link..it helps

http://www.experts-exchange.com/Microsoft/Development/Visual_Studio_Express/Q_23018352.html

if you want step by step let me know..

here is the c# code ..just 3 steps

         

 SqlCommand myCommand = new SqlCommand("select * from tblImg1 where img_id=@img_id", conn);

            // Mark the Command as a Text
            myCommand.CommandType = CommandType.Text;

            // Add Parameters to Command (optional)
            SqlParameter img_id = new SqlParameter("@img_id", SqlDbType.Int);
            img_id.Value = ID;
            myCommand.Parameters.Add(img_id);

            conn.Open();

            SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);
            DataSet myDataSet = new DataSet();           
            myAdapter.Fill(myDataSet);

Open in new window

Author

Commented:
It take your point, but the name of the server I connect to using a  "Microsoft SQL Server (SqlClient)" data source in VWDE is [PC NAME]\SQLEXPRESS .  It seems odd I can't connect using "Microsoft SQL Server (SqlClient)" data source in VBE on the same machine.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial