Export (0) Print
Expand All

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); 
              command.Parameters.Add(year); 
              command.Parameters.Add(credits); 
              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

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft