'Declaration Public Shadows Function CreateParameter() As SqlParameter
public new SqlParameter CreateParameter()
Return Value
A SqlParameter object.
'Declaration Public Shadows Function CreateParameter() As SqlParameter
public new SqlParameter CreateParameter()
Public void CreateParam(SqlConnection myConnection) { SqlCommand myCommand = new SqlCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno",myConnection); SqlParameter myParam = myCommand.CreateParameter(); myParam.SqlType = Devart.Data.SqlServer.SqlType.Int; myParam.Value = 10; myParam.ParameterName = "Deptno"; myCommand.Parameters.Add(myParam); myConnection.Open(); SqlDataReader myReader = null; try { myReader = myCommand.ExecuteReader(); while (myReader.Read()) { Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1) + ", " + myReader.GetString(2)); } } finally { myReader.Close(); myConnection.Close(); } }
Public Sub CreateParam(ByVal myConnection As SqlConnection) Dim myCommand As New SqlCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno", myConnection) Dim myParam As SqlParameter = myCommand.CreateParameter() myParam.SqlType = Devart.Data.SqlServer.SqlType.Int myParam.Value = 10 myParam.ParameterName = "Deptno" myCommand.Parameters.Add(myParam) myConnection.Open() Dim myReader As SqlDataReader = Nothing Try myReader = myCommand.ExecuteReader() While myReader.Read() Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _ + myReader.GetString(1) + ", " _ + myReader.GetString(2)) End While Finally myReader.Close() myConnection.Close() End Try End Sub