新增一个类:DoDataBase.CS
using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
namespace StockMarket_AnalysisViewNew
{
public class DoDataBase
{
public DoDataBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static DataSet GetDataSet(string sql)
{
SqlConnection conn = new SqlConnection();
DataSet ds = new DataSet();
try
{
conn = new SqlConnection("Server=192.168.2.8;User id=sa;Pwd=gaogao;Database=DBData");
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
sda.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
conn.Close();
}
}
public static int ExecuteSQL(string sql)
{
SqlConnection conn = new SqlConnection();
try
{
conn = new SqlConnection("Server=192.168.2.8;User id=sa;Pwd=gaogao;Database=DBData");
SqlCommand sqlCmd = new SqlCommand(sql, conn);
conn.Open();
return sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
}
}
调用:
private void button1_Click(object sender, EventArgs e)
{
int inti;
string strSql = "SELECT * FROM CS_Code";
DataSet MyDataset = new DataSet();
MyDataset = DoDataBase.GetDataSet(strSql);
for(inti=0;inti<MyDataset.Tables[0].Rows.Count ;inti++)
{
string test = MyDataset.Tables[0].Rows[inti]["sID"].ToString();
MessageBox.Show(test);
}
string strSql = "Delete From Stock_UPRateList";
inti = DoDataBase.ExecuteSQL(strSql);
}