GetFillParameters Method
Collapse the table of content
Expand the table of content

IDataAdapter.GetFillParameters Method ()


Gets the parameters set by the user when executing an SQL SELECT statement.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

IDataParameter[] GetFillParameters()

Return Value

Type: System.Data.IDataParameter[]

An array of IDataParameter objects that contains the parameters set by the user.

private static void GetParameters(String connectiongString) {
           using (SqlConnection conn = new SqlConnection(connectiongString)) {
              String queryString = "Select [CourseID],[Title],[Credits] from [MySchool].[dbo].[Course] where [Year]=@Year and [Credits]>=@Credits"; 
              SqlParameter year = new SqlParameter("@Year", 2012); 
              SqlParameter credits = new SqlParameter("@Credits", SqlDbType.Int, 4, "Credits"); 
              credits.Value = 4; SqlCommand command = new SqlCommand(queryString, conn); 
              IDbDataAdapter mySchool = new SqlDataAdapter(command); 
              IDataParameter[] parameters = mySchool.GetFillParameters();
              Console.WriteLine("{0,-15}{1,-15}{2,-15}{3,-15}{4,-15}", "ParameterName", "SourceColumn", "Direction", "DbType", "Value"); 
              foreach (IDataParameter parameter in parameters) { 
                 Console.WriteLine("{0,-15}{1,-15}{2,-15}{3,-15}{4,-15}", parameter.ParameterName, parameter.SourceColumn, parameter.Direction, parameter.DbType, parameter.Value); 

.NET Framework
Available since 1.1
Return to top
© 2015 Microsoft