my connection code is: String strConnection; strConnection = "server=localhost;User ID=sa;Password=sas;database=db"; SqlConnection conn = new SqlConnection(strConnection); conn.Open(); how will i write it in any application configuration file working in windows form,and call it on every page that needs to b connected?? can any body help me??

$h@ma!|@

thx but i dun understand how to create dataset from user entered values and update to db:(:doh:

$h@ma!|@

i m using dataadapter to handle dataset..the date is shown in the datagrid..now i want to update the records edited by the user i have used one button to show the records,(in which i hv declared dataadapters and dataset) and behind "edit record" button i want to write the code for updation if i use the command DataAdapter.Update(Dataset); what should i do as the dataadpter and dataset are declared behind the other button?? is there any other option ( i m not using stored procedures)

$h@ma!|@

wild card characters are used to match strings as select * from table where name LIKE '%brown%'; but doesnt supports matching of dates,number what will we do if we want approximate matching of dates and numbers??

$h@ma!|@

well tbl is the tablename in databases..actually these are not the actual tablenames but it was to simplify the query to post

$h@ma!|@

still no progress!!:(

$h@ma!|@

some exception is handled at runtime

$h@ma!|@

if(combobox2.text==" teachers name") str="t_name"; //giving field name //many if statements here strQuery = " SELECT * FROM tbl1,tbl2,tbl3 WHERE tbl1." + str + "=" + textBox1.Text+"AND tbl1.t_id=tbl2.tb_id AND tbl.t_id=tbl3.tb3_id "; it works but when i do //tablename=combobox1.text; //or tablename="tbl1"; strQuery = " SELECT * FROM tbl1,tbl2,tbl3 WHERE" + tablename + "." + str + "=" + textBox1.Text+"AND tbl1.t_id=tbl2.tb_id AND tbl.t_id=tbl3.tb3_id "; it gives error

$h@ma!|@

in my windows form,for search,two combo boxes are provided.the first one gives the table names and in second combo box the respective fields are provided ,by selecting any field the user enters the required value according to which te search is done i m storing both tablename and field name in string now in my select statement when i append the string with field name (with hard coded table name); it functions well but when i concatenate string having table name it gives errors..

$h@ma!|@

well leave it i did it....

$h@ma!|@

i want to fill dataadapter with more then one table what will be the syntax for it and binding more then one datamembers(tables) with grid

$h@ma!|@

thx alot it really worked :-D so nice of u...and m feeling sorry as i found ur reply too late

$h@ma!|@

waiting for ur answer:confused:

$h@ma!|@

hmmmm but as i told i m working in windows application and it doesnt support databind option is there any replacement or any directives/namespaces to include? and what if i want to update records using dataset?

$h@ma!|@

well! isnt there any need to use data reader?? well my code is //connection as conn strQuery = " SELECT * FROM table"; SqlCommand com1 = new SqlCommand(strQuery, conn); DataSet ds=new DataSet(); SqlDataAdapter da=new SqlDataAdapter(); SqlDataReader dr = com1.ExecuteReader(); if (dr.Read()) { da.Fill(ds,"table"); } its not working i mean data is not displaying in the grid..and the exception that is shown is "The SelectCommand property has not been initialized before calling 'Fill'."

$h@ma!|@

in windows apllication, i want to select table's data and show it in datagrid but i dont undertand how will i bind the data is there any way to use datagrd view manager or something like this???? m confused!!!:(

$h@ma!|@

and i have written in app file rescue15 is it ok???

$h@ma!|@

thx but it is giving error i.e; The name 'ConfigurationSettings' does not exist in the current context

$h@ma!|@

i m working on widows application..for connectivity to sql i want to give datasource in app config file..and in every page i wan to call that string but i dont understand how to do that can anyone help me??

$h@ma!|@

ok fine i'll try thx

$h@ma!|@