如何使用查询字符串和文本框将数据插入到Sql表。 [英] How Do I Insert Data To Sql Table Using Query String And A Text Box.
本文介绍了如何使用查询字符串和文本框将数据插入到Sql表。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的所有人,
i有一个场景,比如我想使用查询字符串将名称和滚动号插入sql表。
在同一页面上我有一个文本框和一个按钮。在这个按钮上单击我想提交我的数据,即名称和卷号(在查询字符串中)和反馈在文本框中。
请帮帮我怎么做。
关心
sc.ConnectionString =Data Source = localhost; Initial Catalog = LoginScreen; Integrated Security = True;
sc.Open();
使用(SqlCommand myCommand = new SqlCommand(
INSERT INTO table(rollno,name,feedback)VALUES(@rollno,@ name,@ feedback)))
{
myCommand.Parameters.AddWithValue(@ rollno,'+ txtboxrollnumber.Text +');
myCommand.Parameters.AddWithValue(@ name,+ txtboxname.Text +');
myCommand.Parameters.AddWithValue(@ feedback,+ txtboxfeedback.Text +');
// ...
myCommand.ExecuteNonQuery();
// ...
}
sc.Close():
}
http://stackoverflow.com/questions/16215995/adding-textbox-values- to-an-sql-database-in-c-sharp [ ^ ]
: - )
而不是从asp.net你可以编写用于插入的存储过程,
CREATE PROCEDURE [dbo]。[ADD_Data]
/ *类型应该是他们的表格中的列类型* /
@Name varchar(MAX),
@RollNo varchar(MAX),
@Feedback varchar(MAX)
AS
BEGIN
INSERT INTO [dbo]。[FeedBackTable](姓名,RollNo,反馈)
VALUES(@ Name,@ RodNo,@反馈)
结束
现在下面的代码将进入你的按钮点击,
受保护 < span class =code-keyword> void Button1_Click( object sender,EventArgs e)
{
if (Request.QueryString [ 名称]!= < span class =code-keyword> null && Request.QueryString [ RollNumber]!= null )
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand com = new SqlCommand( ADD_Data ,con);
com.Parameters.AddWithValue( @ Name,Request.QueryString [ 名称]。ToString());
com.Parameters.AddWithValue( @ RollNo,Request.QueryString [ RollNumber]。ToString());
com.Parameters.AddWithValue( @ Feedback,txtboxFeedback.Text);
com.CommandType = CommandType.StoredProcedure;
尝试
{
con.Open();
com.ExecuteNonQuery();
}
catch (例外)
{
throw ;
}
最后
{
如果(con .State == ConnectionState.Open)
con.Close();
}
}
}
Dear ALL,
i have a scenario like i want to insert name and roll number into sql table using query string.
on the same page i have a text box and a button.on this button click i want to submit my data which is name and roll number(in query string) and feedback in text box.
please help me how can do that.
Regards
解决方案
using(SqlConnection sc = new SqlConnection()) { sc.ConnectionString = "Data Source=localhost;Initial Catalog=LoginScreen;Integrated Security=True"; sc.Open(); using (SqlCommand myCommand = new SqlCommand( "INSERT INTO table (rollno, name,feedback) VALUES (@rollno, @name,@feedback)")) { myCommand.Parameters.AddWithValue("@rollno", '"+ txtboxrollnumber.Text +"'); myCommand.Parameters.AddWithValue("@name", '"+ txtboxname.Text +"'); myCommand.Parameters.AddWithValue("@feedback", '"+ txtboxfeedback.Text +"'); //... myCommand.ExecuteNonQuery(); //... } sc.Close(): }
http://stackoverflow.com/questions/16215995/adding-textbox-values-to-an-sql-database-in-c-sharp[^]
:-)
Instead of calling query from asp.net you can write stored procedure for inserting,
CREATE PROCEDURE [dbo].[ADD_Data]
/*Type should be their column types from table*/
@Name varchar(MAX),
@RollNo varchar(MAX),
@Feedback varchar(MAX)
AS
BEGIN
INSERT INTO [dbo].[FeedBackTable] (Name , RollNo , Feedback )
VALUES (@Name , @RollNo , @Feedback )
END
Now below code will go in your Button click ,
protected void Button1_Click(object sender, EventArgs e) { if (Request.QueryString["Name"] != null && Request.QueryString["RollNumber"] != null) { SqlConnection con = new SqlConnection(connectionString); SqlCommand com = new SqlCommand("ADD_Data", con); com.Parameters.AddWithValue("@Name", Request.QueryString["Name"].ToString()); com.Parameters.AddWithValue("@RollNo", Request.QueryString["RollNumber"].ToString()); com.Parameters.AddWithValue("@Feedback", txtboxFeedback.Text); com.CommandType = CommandType.StoredProcedure; try { con.Open(); com.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (con.State == ConnectionState.Open) con.Close(); } } }
这篇关于如何使用查询字符串和文本框将数据插入到Sql表。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文