string cString = "DataSource=192.168.12.84;Initial Catalog=zclReport;UserID=sa;Password=123;";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = cString;
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_Report_New_CorpCount";
SqlParameter[] parameters ={
new SqlParameter("@OrgCode",SqlDbType.VarChar,32),
new SqlParameter("@PlanCode",SqlDbType.VarChar,32)
};
parameters[0].Value = Org_Code;
parameters[1].Value = PlanCode;
cmd.Parameters.AddRange(parameters);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;