返回首页

您好
NBSP
我想插入源代码,创建,更新,删除数据库中的工作台,通过NET(C#),
例如表。阿巴斯ali95:乌玛・尚卡尔帕特尔

回答

评论会员:游客 时间:2012/02/05
_Zorro_:嗨,对此,你应该检查在Google上的一些文章,但这里有一个简单的例子:codeprelang="c#"SqlConnectionconnection=spanclass="code-keyword"new/spanSqlConnection(connectionString);SqlCommandcmd=spanclass="code-keyword"new/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"SELECTTable1.Field1FROM[dbo].[Table1]WHERETable1.Field2=@Field2"/span,connection);spanclass="code-comment"///spanspanclass="code-comment"@Field2isaparameter/spanspanclass="code-comment"///spanspanclass="code-comment"Thisiswhereyousetthe@Field2parametervalue./spancmd.Parameters.Add(spanclass="code-string""/spanspanclass="code-string"@Field2"/span,SqlDbType.NVarChar).Value=your_criteria; cmd.CommandType=CommandType.Text SqlDataReaderreader=cmd.ExecuteReader();spanclass="code-keyword"while/span(reader.Read()){.........} /pre/code这样,你是SQL注入攻击,你有一个'优雅'的解决方案。希望它可以帮助...|The_Leader:您好prerak,感谢其他soloutions,我认为,这将是有益的。首先,你应该这样做:{C}此代码为插入到表:codeprelang="c#"spanclass="code-keyword"private/spanspanclass="code-keyword"void/spanbutton1_Click(spanclass="code-keyword"object/spansender,EventArgse){SqlConnectionconection=spanclass="code-keyword"new/spanSqlConnection(spanclass="code-string""/spanspanclass="code-string"DataSource=.;InitialCatalog=uYOURDATABASENAME/u;IntegratedSecurity=True;"/span);spanclass="code-keyword"string/spanSql_Insert=(spanclass="code-string""/spanspanclass="code-string"INSERTINTOuYOURTABLENAME/uVALUES(@id,@fname,@lname)"/span);conection.Open();spanclass="code-keyword"try/span{SqlCommandcomand=spanclass="code-keyword"new/spanSqlCommand(Sql_Insert,conection);comand.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@id"/span,textBox1.Text);comand.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@fname"/span,textBox2.Text);comand.Parameters.AddWithValue(spanclass="code-string""/spanspanclass="code-string"@lname"/span,textBox3.Text);comand.ExecuteNonQuery();}spanclass="code-keyword"catch/span(System.Data.SqlClient.SqlExceptionex){MessageBox.Show(ex.ToString());}spanclass="code-keyword"finally/span{conection.Close();}}/pre/code此代码是从表中选择:{体C3}等我希望这是对您有用:archanakumari
<前LANG ="C#"GT; SqlCommand的CMD =新的SqlCommand('txttechid.Text",""txtname.Text""插入到technicalregistration值("。 ""txtloginName.Text","txtpwd.Text",""txtphoneno.Text","txtemail.Text","txteducation.Text","txtExperience.Text"','的"txtaddress.Text",""txtCountry.Text",""txtpincode.Text","律政司")",(SqlConnection的)Application.Get("CON"))
NBSP ; cmd.ExecuteNonQuery()
NBSP lblmessage.Text ="Submited的成功"; LT ;/ pregt;
NBSP

Remainning的更新,删除的üanalize这个代码和写OK
NBSP




Anilkumar" D
评论会员:。乌代・辛格 时间:2012/02/05
还有一些基础知识:
- {A2}
- {A3的}]