Register Register Member Login Member Login Member Login Forgot Password ??
PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone
 

Registered : 109,025

HOME > .NET Framework > .NET Parameterized Queries




Clound SSD Virtual Server

.NET Parameterized Queries

 
  .NET Parameterized Queries (Parameter Query) āļĢāļđāļ›āđāļšāļšāļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ€āļžāļ·āđˆāļ­āđ‚āļĒāļ™āļ„āđˆāļē Parameter āđƒāļŦāđ‰āļāļąāļš SQL Statement āđ€āļŦāļ•āļļāļœāļĨāļ—āļĩāđˆāđƒāļŠāđ‰āļžāļēāļĢāļēāļĄāļīāđ€āļ•āļ­āļĢāđŒ āļ—āļąāđ‰āļ‡āļ™āļĩāđ‰āļāđ‡āđ€āļžāļ·āđˆāļ­āļ•āđ‰āļ­āļ‡āļāļēāļĢāļ—āļĩāđˆāļˆāļ°āļ—āļģāļāļēāļĢāļāļģāļŦāļ™āļ”āļ„āļļāļ“āļŠāļĄāļšāļąāļ•āļīāđƒāļŦāđ‰āļāļąāļšāļ„āđˆāļēāļ•āļąāļ§āđāļ›āļĢ āļāđˆāļ­āļ™āļ—āļĩāđˆāļˆāļ°āļĄāļĩāļāļēāļĢ Input āļĨāļ‡āđƒāļ™ Statement āđāļĨāļ°āļ—āļąāđ‰āļ‡āļĒāļąāļ‡āļŠāļēāļĄāļēāļĢāļ–āļĨāļ”āļ›āļąāļāļŦāļēāļāļēāļĢāđāļšāđˆāļ‡āđāļĒāļāļĢāļ°āļŦāļ§āđˆāļēāļ‡āļ„āđˆāļē Argument āļ‚āļ­āļ‡āđāļ•āđˆāļĨāđˆāļ° Statement āđ€āļŠāđˆāļ™ Values ('1','I don't no')

Parameter Syntax
Dim QueryString As String = "SELECT * FROM Table1 WHERE Field1 LIKE @p1"
Dim Cmd As OleDbCommand = New OleDbCommand(QueryString, Connection)
Cmd.Parameters.Add("@p1", OleDbType.Char, 3).Value = "a"


āļŠāļģāļŦāļĢāļąāļšāđƒāļ™āļ•āļąāļ§āļ­āļĒāđˆāļēāļ‡āļœāļĄāđ„āļ”āđ‰āļ­āļ­āļāđāļšāļšāđ„āļ§āđ‰āļŠāļģāļŦāļĢāļąāļš NameSpace 5 āļ•āļąāļ§āļ„āļĢāļąāļš


1.System.Data.OleDb - Parameter Query(OleDbParameter)
strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
"VALUES (@sCustomerID,@sName,@sEmail,@sCountryCode,@sBudget,@sUsed)"

objCmd = New System.Data.OleDb.OleDbCommand(strSQL,objConn)

With objCmd
.Parameters.Add(New OleDbParameter("@sCustomerID","C005"))
.Parameters.Add(New OleDbParameter("@sName","Weerachai Nukitram"))
.Parameters.Add(New OleDbParameter("@sEmail","[email protected]"))
.Parameters.Add(New OleDbParameter("@sCountryCode","TH"))
.Parameters.Add(New OleDbParameter("@sBudget","2000000"))
.Parameters.Add(New OleDbParameter("@sUsed","1000000"))
End With



2.MySql.Data.MySQLClient - Parameter Query (MySQLParameter)
strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
"VALUES (?sCustomerID,?sName,?sEmail,?sCountryCode,?sBudget,?sUsed)"

objCmd = New MySql.Data.MySQLClient.MySQLCommand(strSQL,objConn)

With objCmd
.Parameters.Add(new MySQLParameter("?sCustomerID", "C005"))
.Parameters.Add(new MySQLParameter("?sName", "Weerachai Nukitram"))
.Parameters.Add(new MySQLParameter("?sEmail", "[email protected]"))
.Parameters.Add(new MySQLParameter("?sCountryCode", "TH"))
.Parameters.Add(new MySQLParameter("?sBudget", "2000000"))
.Parameters.Add(new MySQLParameter("?sUsed", "100000"))
End With


3.System.Data.SqlClient - Parameter Query (SqlParameter)
strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
"VALUES (@sCustomerID,@sName,@sEmail,@sCountryCode,@sBudget,@sUsed)"

objCmd = New System.Data.SqlClient.SqlCommand(strSQL,objConn)

With objCmd
.Parameters.Add(New SqlParameter("@sCustomerID","C005"))
.Parameters.Add(New SqlParameter("@sName","Weerachai Nukitram"))
.Parameters.Add(New SqlParameter("@sEmail","[email protected]"))
.Parameters.Add(New SqlParameter("@sCountryCode","TH"))
.Parameters.Add(New SqlParameter("@sBudget","2000000"))
.Parameters.Add(New SqlParameter("@sUsed","1000000"))
End With



4.System.Data.OracleClient - Parameter Query (OracleParameter)
strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
"VALUES (:sCustomerID,:sName,:sEmail,:sCountryCode,:sBudget,:sUsed)"

objCmd = New System.Data.OracleClient.OracleCommand(strSQL,objConn)
With objCmd
.Parameters.Add(new OracleParameter(":sCustomerID", "C005"))
.Parameters.Add(new OracleParameter(":sName", "Weerachai Nukitram"))
.Parameters.Add(new OracleParameter(":sEmail", "[email protected]"))
.Parameters.Add(new OracleParameter(":sCountryCode", "TH"))
.Parameters.Add(new OracleParameter(":sBudget", "2000000"))
.Parameters.Add(new OracleParameter(":sUsed", "100000"))
End With



5.System.Data.Odbc - Parameter Query (OdbcParameter)
strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
"VALUES (?,?,?,?,?,?)"

objCmd = New System.Data.Odbc.OdbcCommand(strSQL,objConn)
With objCmd
.Parameters.Add(New OdbcParameter("@sCustomerID","C005"))
.Parameters.Add(New OdbcParameter("@sName","Weerachai Nukitram"))
.Parameters.Add(New OdbcParameter("@sEmail","[email protected]"))
.Parameters.Add(New OdbcParameter("@sCountryCode","TH"))
.Parameters.Add(New OdbcParameter("@sBudget","2000000"))
.Parameters.Add(New OdbcParameter("@sUsed","1000000"))
End With



Transaction()









āļšāļ—āļ„āļ§āļēāļĄāļ­āļ·āđˆāļ™ āđ† āđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāļāļēāļĢ āļāļēāļĢāđƒāļŠāđ‰ Parameter Query
Go to : ASP.NET Access BLOB Binary Data and Parameterized Query
Go to : ASP.NET MySQL BLOB Binary Data and Parameterized Query
Go to : ASP.NET SQL Server BLOB Binary Data and Parameterized Query
Go to : ASP.NET Oracle BLOB Binary Data and Parameterized Query


       
Bookmark.   
       

 

  By : TC Admin
  Score Rating : -
  Create Date : 2009-01-15 00:05:27
  Download : No files
     

Clound SSD Virtual Server
-->
Related Links
āļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Crystal Report āļāļąāļšāļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Class āđāļĨāļ° DataSource (.NET)
āļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Crystal Report āļāļąāļšāļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Class āđāļĨāļ° DataSource (.NET)
āļ•āļąāļ§āļ­āļĒāđˆāļēāļ‡āļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ class āļšāļ™ .net framework āđ€āļžāļ·āđˆāļ­āļŠāļĢāđ‰āļēāļ‡ dataset āđāļĨāļ° datatable āļāļģāļŦāļ™āļ”āļ„āđˆāļē datasource āđƒāļŦāđ‰āļāļąāļš crystal report
Rating :
Update :
2017-03-24 21:32:24 View : 21,783
Smart Device Mobile Application Read and Write Text File
Smart Device Mobile Application Read and Write Text File
āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™ Device Application āđāļšāļšāļ‡āđˆāļēāļĒ āđ† āļŠāļģāļŦāļĢāļąāļšāļāļēāļĢ āļˆāļąāļ”āļāļēāļĢ Text File āļˆāļąāļ”āđ€āļāđ‡āļšāļ‚āđ‰āļ­āļĄāļđāļĨ āđāļĨāļ° āļ­āđˆāļēāļ™āļ‚āđ‰āļ­āļĄāļđāļĨāđƒāļ™āļĢāļđāļ›āđāļšāļšāļ‚āļ­āļ‡ Text File āļšāļ™ Smart Device
Rating :
Update :
2017-03-24 21:22:55 View : 13,908
āļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Report āļ”āđ‰āļ§āļĒ Report Viewer āđāļĨāļ°āļāļēāļĢāļŠāđˆāļ‡āļ„āđˆāļē Parameters (ReportViewer , MicrosoftReportViewer)
āļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Report āļ”āđ‰āļ§āļĒ Report Viewer āđāļĨāļ°āļāļēāļĢāļŠāđˆāļ‡āļ„āđˆāļē Parameters (ReportViewer , MicrosoftReportViewer)
āļ­āļ­āļāļĢāļēāļĒāļ‡āļēāļ™āļ”āđ‰āļ§āļĒ report viewer āļ‹āļķāđˆāļ‡āđ€āļ›āđ‡āļ™ report āļ‚āļ­āļ‡āļ„āđˆāļēāļĒ microsoft āļ—āļĩāđˆāļŠāļēāļĄāļēāļĢāļ–āđƒāļŠāđ‰āļ‡āļēāļ™āđ„āļ”āđ‰āļŸāļĢāļĩ āļĄāļĩāļĄāļēāļžāļĢāđ‰āļ­āļĄāļāļąāļš visual studio 2005 (.net 2.0) āļ‚āļķāđ‰āļ™āđ„āļ›
Rating :
Update :
2017-03-24 21:33:46 View : 90,012
.NET Windows Form Application  āđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄāļšāļ™ Windows Form Application āļ”āđ‰āļ§āļĒ .NET Framework
.NET Windows Form Application āđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄāļšāļ™ Windows Form Application āļ”āđ‰āļ§āļĒ .NET Framework
.NET Windows Form Application , Windows App by (VB.NET,C#) āđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄāļšāļ™ Windows Form Application āļ”āđ‰āļ§āļĒ .NET Framework
Rating :
Update :
2017-03-17 22:21:14 View : 74,489
Crystal Report āļāļąāļšāļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Report āļĢāļēāļĒāļ‡āļēāļ™āđāļšāļš JOIN āļ‚āđ‰āļ­āļĄāļđāļĨāļŦāļĨāļēāļĒāļ•āļēāļĢāļēāļ‡ Table (.NET)
Crystal Report āļāļąāļšāļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Report āļĢāļēāļĒāļ‡āļēāļ™āđāļšāļš JOIN āļ‚āđ‰āļ­āļĄāļđāļĨāļŦāļĨāļēāļĒāļ•āļēāļĢāļēāļ‡ Table (.NET)
āļ•āļąāļ§āļ­āļĒāđˆāļēāļ‡āļāļēāļĢāļ­āļ­āļ report āļ‚āļ­āļ‡ crystal report āļ—āļĩāđˆāļĄāļĩāļ„āļ§āļēāļĄāļ‹āļąāļšāļ‹āđ‰āļ­āļ™āļĒāļīāđˆāļ‡āļ‚āļķāđ‰āļ™ āđāļĨāļ°āļāļēāļĢāļ™āļģāļ‚āđ‰āļ­āļĄāļđāļĨāļŦāļĨāļēāļĒ āđ† āļ•āļēāļĢāļēāļ‡āļĄāļēāđāļŠāļ”āļ‡ āđƒāļ™ report āđ€āļ”āļĩāļĒāļ§āļāļąāļ™
Rating :
Update :
2017-03-17 21:20:01 View : 65,330
Shared Folder or Map Drive in Emulator Smart Device Mobile Application
Shared Folder or Map Drive in Emulator Smart Device Mobile Application
āļāļēāļĢāļŠāļĢāđ‰āļēāļ‡ Shared Folder āļĢāļ°āļŦāļ§āđˆāļēāļ‡ Emulator āļāļąāļš PC Desktop āđƒāļ™āļāļēāļĢāļĒāđ‰āļēāļĒāļ‚āđ‰āļ­āļĄāļđāļĨāļĢāļ°āļŦāļ§āđˆāļēāļ‡ Emulator āļāļąāļš Notebook āļŦāļĢāļ·āļ­ PC Desktop
Rating :
Update :
2017-03-24 21:17:19 View : 8,513
ThaiCreate.Com Forum


Comunity Forum Free Web Script
Jobs Freelance Free Uploads
Free Web Hosting Free Tools

āļŠāļ­āļ™ PHP āļœāđˆāļēāļ™ Youtube āļŸāļĢāļĩ
āļŠāļ­āļ™ Android āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄ Android
āļŠāļ­āļ™ Windows Phone āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄ Windows Phone 7 āđāļĨāļ° 8
āļŠāļ­āļ™ iOS āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄ iPhone, iPad
āļŠāļ­āļ™ Java āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄ āļ āļēāļĐāļē Java
āļŠāļ­āļ™ Java GUI āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄ āļ āļēāļĐāļē Java GUI
āļŠāļ­āļ™ JSP āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄ āļ āļēāļĐāļē Java
āļŠāļ­āļ™ jQuery āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄ āļ āļēāļĐāļē jQuery
āļŠāļ­āļ™ .Net āļāļēāļĢāđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄ āļ āļēāļĐāļē .Net
Free Tutorial
āļŠāļ­āļ™ Google Maps Api
āļŠāļ­āļ™ Windows Service
āļŠāļ­āļ™ Entity Framework
āļŠāļ­āļ™ Android
āļŠāļ­āļ™ Java āđ€āļ‚āļĩāļĒāļ™ Java
Java GUI Swing
āļŠāļ­āļ™ JSP (Web App)
iOS (iPhone,iPad)
Windows Phone
Windows Azure
Windows Store
Laravel Framework
Yii PHP Framework
āļŠāļ­āļ™ jQuery
āļŠāļ­āļ™ jQuery āļāļąāļš Ajax
āļŠāļ­āļ™ PHP OOP (Vdo)
Ajax Tutorials
SQL Tutorials
āļŠāļ­āļ™ SQL (Part 2)
JavaScript Tutorial
Javascript Tips
VBScript Tutorial
VBScript Validation
Microsoft Access
MySQL Tutorials
-- Stored Procedure
MariaDB Database
SQL Server Tutorial
SQL Server 2005
SQL Server 2008
SQL Server 2012
-- Stored Procedure
Oracle Database
-- Stored Procedure
SVN (Subversion)
āđāļ™āļ§āļ—āļēāļ‡āļāļēāļĢāļ—āļģ SEO
āļ›āļĢāļąāļšāđāļ•āđˆāļ‡āđ€āļ§āđ‡āļšāđƒāļŦāđ‰āđ‚āļŦāļĨāļ”āđ€āļĢāđ‡āļ§


Hit Link
   







Load balance : Server 05
Inline