executing SQL query in C#

Question

hi, suppose we have some text boxes already binded with BindingNavigator how to execute an SQL query using the code so the binded data can be specified with this SQL statement using C#.

Answer 1

Just say a textbox (txtMyID) is bind to a database filed called "MyID". So you can write UPDATE SQL like this

string SQL = "UPDATE MyTable SET SomeField = 'Something' WHERE MyID = '"+ txtMyID.Text + "'"

I don’t know is this the thing you are asking. But hope this will help you

Answer 2

thanx for your reply but this  is not what i want

when you bind a textbox with the binding navigator control the data will apear on the text box and when you press the move next button, the binding navigator control will point to then next record, now the data that are being selected by the binding navigator is the whole database how can i execute an SQL query using the code to change the selection of the data and to make some filtration using the binding navigator control by code.

regards,

Answer 3

Hi  Sculptor  I often use code as follow to add databinding to a bindingNavigator
if I think we can cheng Datasource for the BindingSource to get any table you want to bind to the Navigator

DBAccess DB = new DBAccess();
DataTable TB= DB.getData().Tables[0];
BindingSource bs = new BindingSource();
bs.DataSource = TB.DefaultView;
this.dataGridView1.DataSource = bs;
this.bindingNavigator1.BindingSource = bs;

I am not sure if it meet your question

best Regards!

Answer 4

thanx i think this piece of code would help but
Lets suppose that we have this query "SELECT * FROM emp WHERE sal > 6000" and i want to execute this query using the code.

regards

Answer 5

Try this

string ConnectionString = "My Connection String";
SqlConnection Conn = new SqlConnection(ConnectionString);
Conn.Open();

SqlDataAdapter DA = new SqlDataAdapter("SELECT * FROM emp WHERE sal > 6000", Conn);
DataTable dt = new DataTable();
DA.Fill(dt);

if (Conn.State == ConnectionState.Open)
{
    Conn.Close();
}

BindingSource BS = new BindingSource();
BS.DataSource = dt;
dataGridView1.DataSource = BS;
bindingNavigator1.BindingSource = BS;

Answer 6

Thank you very much

this is the exact answer that meets my desire;

Answer 7

Hi again

Now what if I wanted to bind text boxes instead of data grid using the same piece of code. Lets suppose that we have textBox1 to be binded with (id) column at emp table and textBox2 to be binded with (name) at the same table, what would be the code for this purpose.

Thanks

regards,

Answer 8

here is the code

textBox1.DataBindings.Add("Text", BS, "id");
textBox2.DataBindings.Add("Text", BS, "name");

Answer 9

Thanks, this is exactly what i need to know

regards,

Answer 10

Thanks, this is exactly what i need to know

regards,