Database

yogesh_kumar_agarwal wrote:

i want to know did you are using msaccess as backend???

yogesh_kumar_agarwal wrote:

i think you didn't read the connection string properly he tries to connect with a mdb database file means Access

Jacquers wrote:

I could do it in code, but it seems inefficient as it would be a two step process.

laziale wrote:

I am beginner

<br />
<br />
1. Import the SqlClient namespace<br />
<br />
2. Create the object of SQL Connect to bind with SQLServer<br />
<br />
SQLConnection con=new SQLConnection("Initial Catelog=test;Data Source=.;user id=sa;password=pwd");<br />
<br />
here <br />
<br />
Data Source is the computer name on which the database in created<br />
Initial Catelog is the database name available on the server<br />
user id is the user id for database as on password<br />
<br />
<br />
3. Now create the command object to give the sql command to the sever<br />
<br />
SQLCommand cmd=new SQLCommand(sqlstr,con);<br />
<br />
here con is the object for connection and sqlstr is the query to execute like in our case it is<br />
<br />
"insert into tbltest values ('" + txtname.text + "')"<br />
<br />
4. Now Execute the command using cmd object<br />
<br />
cmd.ExecuteNonQuery();<br />
<br />
<br />
Remember to open the connection using <br />
con.Open()<br />
before xecution of Query.<br />
<br />
<br />

Deques wrote:

the european computers have comma set in the regional settings. so this could be problematic unless i change the decimal to a dot.