hi friends...
can anyone tell me how to do this task.
in a vb form i should input a sql query and should get the output. how to do this????
plz help me
madhanacdc 0 Newbie Poster
selvaganapathy 31 Posting Pro
Hi,
I am assuming that you know how to connect the database.
I am giving a prototype to do this (ADODB Connection)
> Create New Standard EXE Project
> In Form1 (Default), Place a TextBox (Text1) and Command Button (Command1)
> Insert a DataGrid Control (Ctrl + T, Microsoft DataGrid Control)
> During Form_Load () Make the Connection and Set the DataGrid DataSource
> In the Command1_Click () Event
Execute the Query using Connection.Execute (Text1.Text)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.