SqlConnection sqlConnection=null;
SqlCommand sqlCommand=null;
string connectStr="server=172.31.112.200;Database=GZPSS;user id='sa';password='1234Qwer'";
sqlConnection=new SqlConnection(connectStr);
sqlCommand=new SqlCommand();
sqlCommand.Connection=sqlConnection;
if(sqlConnection.State.ToString()!="Open")
{
sqlConnection.Open();
}
string queryString="selet * from table1";
SqlDataReader sqlDataReader=null;
sqlCommand.CommandText=queryString;
sqlDataReader=sqlCommand.ExecuteReader();//sqlCommand.ExecuteNonQuery();
while(sqlDataReader.Read())
{
//do something with sqlDataReader.
}
if(sqlConnection.State.ToString()=="Open")
sqlConnection.Close();