C # Query SQL returns multiple parameters

1. Query the MySQL statement as needed, return three required parameters, not a dataset

2. Write the function as follows:

public static void Getparas (string condition 1, out string return value 1, out string return value 2, out string return value 3)
{
The return value is 1= string. Empty;
The return value is 2= string. Empty;
The return value is 3= string. Empty;



String strSQL = String. Format ("SELECT * from table where field 1= ' {0} ' limit 1", condition 1);

Execute SQL statement

DataTable dt = ds. Tables[0];
if (dt! = null && dt. Rows.Count = = 1)
{
Object obj = dt. rows[0][return value 1 "];
if (obj! = null &&!) ( obj is DBNull))
{
The return value 1= convert.tostring (obj). Replace ("", "");
}
obj = dt. rows[0]["return value 2"];
if (obj! = null &&!) ( obj is DBNull))
{
The return value 2= convert.tostring (obj);
}
obj = dt. rows[0]["return value 3"];
if (obj! = null &&!) ( obj is DBNull))
{
The return value 3= convert.tostring (obj);
}
}
}

3. With the above SQL execution, the corresponding three return values are queried.

4. Call the function as follows

String returns a value of 1= string. Empty;
String returns a value of 2= string. Empty;
String returns a value of 3= string. Empty;

Getparas (query condition 1, out return value 1, out return value 2, out return value 3);

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

C # Query SQL returns multiple parameters