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,006

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
ASP.NET āļāļąāļš JSON āđāļĨāļ°āļāļēāļĢāļĢāļąāļš-āļŠāđˆāļ‡āļ‚āđ‰āļ­āļĄāļđāļĨ JSON āļœāđˆāļēāļ™ Web Service (VB.NET , C#)
ASP.NET āļāļąāļš JSON āđāļĨāļ°āļāļēāļĢāļĢāļąāļš-āļŠāđˆāļ‡āļ‚āđ‰āļ­āļĄāļđāļĨ JSON āļœāđˆāļēāļ™ Web Service (VB.NET , C#)
āļāļēāļĢāļ™āļģ json āļĄāļēāđƒāļŠāđ‰āļ‡āļēāļ™āļĢāđˆāļ§āļĄāļāļąāļš asp.net āđƒāļ™āļāļēāļĢāļĢāļąāļšāļŠāđˆāļ‡āļ‚āđ‰āļ­āļĄāļđāļĨ json āļœāđˆāļēāļ™ web service āļāļēāļĢāđ€āļ‚āđ‰āļēāļĢāļŦāļąāļŠāđāļĨāļ°āļ–āļ­āļ”āļĢāļŦāļąāļŠ json āļšāļ™āļ āļēāļĐāļē vb.net āđāļĨāļ° c#
Rating :
Update :
2017-03-24 21:33:02 View : 57,775
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,504
Install .NET Framework 2.0 & Visual Studio 2005
Install .NET Framework 2.0 & Visual Studio 2005
Install .NET Framework 2.0 & Visual Studio 2005 āļ•āļīāļ”āļ•āļąāđ‰āļ‡āđāļĨāļ°āđƒāļŠāđ‰āļ‡āļēāļ™ .NET Framework 2.0 āđāļĨāļ° VS 2005
Rating :
Update :
2009-01-11 09:44:53 View : 8,602
ASP.NET GridView and Checkbox Select All Row Using jQuery
ASP.NET GridView and Checkbox Select All Row Using jQuery
āļšāļ—āļ„āļ§āļēāļĄ ASP.NET āļāļēāļĢāđƒāļŠāđ‰āļ‡āļēāļ™ jQuery āđ€āļžāļ·āđˆāļ­āđ€āļĨāļ·āļ­āļāđāļ–āļ§ Checkbox āđƒāļ™ GridView āđ€āļĨāļ·āļ­āļāđāļ–āļ§āļ—āļąāđ‰āļ‡āļŦāļĄāļ” āļŦāļĢāļ·āļ­āđ„āļĄāđˆāđ€āļĨāļ·āļ­āļāļ—āļąāđ‰āļ‡āļŦāļĄāļ”
Rating :
Update :
2017-03-17 22:11:54 View : 16,324
āļŠāļĢāđ‰āļēāļ‡ Crystal Report āļšāļ™ Visual Studio (VB.NET , C#) Step by Step
āļŠāļĢāđ‰āļēāļ‡ Crystal Report āļšāļ™ Visual Studio (VB.NET , C#) Step by Step
āļšāļ—āļ„āļ§āļēāļĄāļāļēāļĢāļŠāļĢāđ‰āļēāļ‡āļĢāļēāļĒāļ‡āļēāļ™āđāļšāļšāļ‡āđˆāļēāļĒ āđ† āļšāļ™ Crystal Report āļ‹āļķāđˆāļ‡āđ€āļ›āđ‡āļ™ Report Tools āļ—āļĩāđˆāđ„āļ”āđ‰āļĢāļąāļšāļ„āļ§āļēāļĄāļ™āļīāļĒāļĄāļĄāļēāļāļ—āļĩāđˆāļŠāļļāļ” āļ—āļģāļ‡āļēāļ™āļĢāđˆāļ§āļĄāļāļąāļš VB.NET āđāļĨāļ° C#
Rating :
Update :
2017-03-24 21:25:06 View : 111,230
.NET Console Application āđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄāļšāļ™ Console Application āļ”āđ‰āļ§āļĒ .NET Framework
.NET Console Application āđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄāļšāļ™ Console Application āļ”āđ‰āļ§āļĒ .NET Framework
.NET Console Application āđ€āļ‚āļĩāļĒāļ™āđ‚āļ›āļĢāđāļāļĢāļĄāļšāļ™ Console Application āļ”āđ‰āļ§āļĒ .NET Framework
Rating :
Update :
2017-03-24 21:19:30 View : 40,508
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
āļ›āļĢāļąāļšāđāļ•āđˆāļ‡āđ€āļ§āđ‡āļšāđƒāļŦāđ‰āđ‚āļŦāļĨāļ”āđ€āļĢāđ‡āļ§


āļŠāļļāļ”āļĒāļ­āļ” Source Code V2.0
 

āđāļˆāđ‰āļ‡āļŠāļģāļĢāļ°āđ€āļ‡āļīāļ™/āđ‚āļ­āļ™āđ€āļ‡āļīāļ™
 

Hit Link
   







Load balance : Server 03
Inline