M
MUHAMAMD SALIM SHAHZAD
dear respected sir,
i'm beginner in vb.net and ado.net enviornment...
i would like to work and learn business(database applicatiosn area),
please can any one help me solve this...
i wanted to make very simple windows forms,then by programming want to
create query, connection, datasets, dataadapter,databinding for using
oledb
but i am facing a lots problem in syntax i am stuck/dead
imports system.data
imports system.data.oledb
private sub form1_load(......some val,ref..etc)
dim cn as new oledb.oledbconnection("provider=microsoft.jet.oledb.4.0;date
source=c:\northwind.mdb")
cn.open
dim da as new dataadapter("select * from customers",cn)
dim ds as new datasets()
da.fill(ds,"cutomers")
textbox1.text = textbox1.databinding.add(ds,"companyname")
end sub
and i have some buttons add, edit, delete, update...
so i can not success above...can any one help me to tell in very
simple form and how to update actual datbase...in fact by using
dataset it is update modify data...using datagrids...but failure in
case of indvidual records on the forms...and plus only update at
datasets time...not actual when i close form and open again..then it
give me same no of old records...
please can any one give some guidence appreciated sir
urs obediently
shahzad
i'm beginner in vb.net and ado.net enviornment...
i would like to work and learn business(database applicatiosn area),
please can any one help me solve this...
i wanted to make very simple windows forms,then by programming want to
create query, connection, datasets, dataadapter,databinding for using
oledb
but i am facing a lots problem in syntax i am stuck/dead
imports system.data
imports system.data.oledb
private sub form1_load(......some val,ref..etc)
dim cn as new oledb.oledbconnection("provider=microsoft.jet.oledb.4.0;date
source=c:\northwind.mdb")
cn.open
dim da as new dataadapter("select * from customers",cn)
dim ds as new datasets()
da.fill(ds,"cutomers")
textbox1.text = textbox1.databinding.add(ds,"companyname")
end sub
and i have some buttons add, edit, delete, update...
so i can not success above...can any one help me to tell in very
simple form and how to update actual datbase...in fact by using
dataset it is update modify data...using datagrids...but failure in
case of indvidual records on the forms...and plus only update at
datasets time...not actual when i close form and open again..then it
give me same no of old records...
please can any one give some guidence appreciated sir
urs obediently
shahzad