如何建立与数据库的连接 [英] how to give connection to database

问题描述

先生iam较新
iam使用C#创建wfaplication
名称

地址

个人信息


当我单击提交按钮时，iam创建的表也如何给出连接

sir iam newer
iam create a wfaplication using C#
name

address

personal information


iam created table also how to give conection when i click on submit button

推荐答案

通过下面的数据库连接链接

http://connectionstrings.com/ [

Go through the below link for Database Connections

http://connectionstrings.com/[^]

SqlConnection cnn = new SqlConnection(@" Server = servername; Database = databasename; Trusted_Connection = True);
SqlCommand cmd =新的SqlCommand(插入表名(名称，地址，个人信息)值(@ col1，@ col2，@ col3，@ col4)"，con);

cmd.Parameters.AddWithValue("@ col1"，controlname);
cmd.Parameters.AddWithValue("@ col2"，控件名);
cmd.Parameters.AddWithValue("@ col3"，控件名);
cmd.Parameters.AddWithValue("@ col4"，控件名);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

SqlConnection cnn = new SqlConnection(@"Server=servername;Database=databasename;Trusted_Connection= True");
SqlCommand cmd = new SqlCommand("insert into tablename(name,address ,personal_information)values(@col1,@col2,@col3,@col4 )", con);

cmd.Parameters.AddWithValue("@col1",controlname);
cmd.Parameters.AddWithValue("@col2", controlname);
cmd.Parameters.AddWithValue("@col3", controlname);
cmd.Parameters.AddWithValue("@col4 ", controlname);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

这篇关于如何建立与数据库的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！