本文整理汇总了C#中System.Data.DataSet.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.Dispose方法的具体用法?C# DataSet.Dispose怎么用?C# DataSet.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.Dispose方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DataTableQuery
/// <summary>
/// 执行查询语句,返回DataTable
/// </summary>
/// <param name="dc">查询语句</param>
/// <param name="db">操作目标数据库</param>
/// <returns>DataTable</returns>
public static DataTable DataTableQuery(DbCommand dc, Database db)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
PrepareCommand(ref dc, db);
ds = db.ExecuteDataSet(dc);
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
ds.Dispose();
ds = null;
}
else
{
ds.Dispose();
ds = null;
return null;
}
}
catch (System.Exception e)
{
throw new Exception(e.Message);
}
return dt;
}
示例2: SaveVar_Click
protected void SaveVar_Click(Object sender, EventArgs e)
{
#region 保存变量修改
dsSrc = LoadDataTable();
int row = 0;
//bool error = false;
foreach (object o in DataGrid1.GetKeyIDArray())
{
int id = int.Parse(o.ToString());
string variablename = DataGrid1.GetControlValue(row, "variablename").Trim();
string variablevalue = DataGrid1.GetControlValue(row, "variablevalue").Trim();
if (variablename == "" || variablevalue == "")
{
//error = true;
continue;
}
foreach (DataRow dr in dsSrc.Tables["TemplateVariable"].Rows)
{
if (id.ToString() == dr["id"].ToString())
{
dr["variablename"] = variablename;
dr["variablevalue"] = variablevalue;
break;
}
}
try
{
if (dsSrc.Tables[0].Rows.Count == 0)
{
File.Delete(Utils.GetMapPath("../../templates/" + DNTRequest.GetString("path") + "/templatevariable.xml"));
dsSrc.Reset();
dsSrc.Dispose();
}
else
{
string filename = Server.MapPath("../../templates/" + DNTRequest.GetString("path") + "/templatevariable.xml");
dsSrc.WriteXml(filename);
dsSrc.Reset();
dsSrc.Dispose();
Discuz.Cache.DNTCache cache = Discuz.Cache.DNTCache.GetCacheService();
cache.RemoveObject("/Forum/" + DNTRequest.GetString("path") + "/TemplateVariable");
base.RegisterStartupScript("PAGE", "window.location.href='global_templatevariable.aspx?templateid=" + DNTRequest.GetString("templateid") + "&path=" + DNTRequest.GetString("path") + "&templatename=" + DNTRequest.GetString("templatename") + "';");
}
}
catch
{
base.RegisterStartupScript("", "<script>alert('无法更新数据库.');window.location.href='global_templatevariable.aspx?templateid=" + DNTRequest.GetString("templateid") + "&path=" + DNTRequest.GetString("path") + "&templatename=" + DNTRequest.GetString("templatename") + "';</script>");
return;
}
row++;
}
#endregion
}
示例3: ExecuteReader
public DataSet ExecuteReader(SqlCommand pCommand, String pTable)
//public DataSet executeReader(MySqlCommand pCommand, String tabla)
//public DataSet ExecuteReader(OleDbCommand pCommand, String pTable)
{
DataSet dsTable = new DataSet();
try
{
using (SqlDataAdapter adapter = new SqlDataAdapter(pCommand))
//using (MySqlDataAdapter adaptador = new MySqlDataAdapter(pCommand))
//using (OleDbDataAdapter adapter = new OleDbDataAdapter(pCommand))
{
pCommand.Connection = conn;
dsTable = new DataSet();
adapter.Fill(dsTable, pTable);
}
return dsTable;
}
catch (Exception ex)
{
ex.Source += " SQL: " + pCommand.CommandText.ToString();
Log.WriteException(MethodBase.GetCurrentMethod().Name, ex);
throw ex;
}
finally
{
if (dsTable != null)
{
dsTable.Dispose();
}
}
}
示例4: Start
public void Start()
{
do
{
DataSet dtsEquipments = new DataSet("Equipments");
EEP_Client_WS.EEP_Client_WS wsEEP_Client_WS = new EEP_Client_WS.EEP_Client_WS();
bool blFlag = false;
try
{
dtsEquipments.ReadXml(@gsEquipmentsFilePath);
DataTable dtDistinct = dtsEquipments.Tables[0].DefaultView.ToTable(true, new string[] { "CompanyID", "EquipmentID", "IP", "Port" });
foreach (DataRow dtwEquipment in dtDistinct.Rows)
{
//blFlag = PingIt(dtwEquipment["IP"].ToString());
blFlag = PingHost(dtwEquipment["IP"].ToString(), Int16.Parse(dtwEquipment["Port"].ToString()));
if (!blFlag)
wsEEP_Client_WS.Set_AlarmOccur(gsCompanyID
, dtwEquipment["EquipmentID"].ToString()
, dtwEquipment["EquipmentID"].ToString() + "(" + dtwEquipment["IP"].ToString() + ":"+ dtwEquipment["Port"].ToString() + ")" + ".State"
, dtwEquipment["EquipmentID"].ToString() + "(" + dtwEquipment["IP"].ToString() + ":"+ dtwEquipment["Port"].ToString() + ")" + ".State", DateTime.Now);
}
}
catch (Exception ex)
{
gLogger.ErrorException("EquipmentState.Start", ex);
}
finally
{
if (wsEEP_Client_WS != null) { wsEEP_Client_WS.Dispose(); wsEEP_Client_WS = null; }
if (dtsEquipments != null) { dtsEquipments.Dispose(); dtsEquipments = null; }
}
System.Threading.Thread.Sleep(1000 * giEquipmenStateCheck);
} while (true);
}
示例5: ExecuteDataset
public static DataSet ExecuteDataset(string commandText)
{
SqlConnection cn = null;
SqlCommand cmd = null;
SqlDataAdapter da = null;
DataSet ds = null;
try
{
cn = new SqlConnection(ConnectionString);
if (cn.State == ConnectionState.Closed) cn.Open();
cmd = new SqlCommand(commandText, cn);
cmd.CommandTimeout = CommandTimeout;
cmd.CommandType = CommandType.Text;
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open) cn.Close();
if (cn != null) cn.Dispose();
if (cmd != null) cmd.Dispose();
if (da != null) da.Dispose();
if (ds != null) ds.Dispose();
}
}
示例6: loadPermissions
public void loadPermissions()
{
DataSet ds = new DataSet();
try
{
cPermissions level = new cPermissions();
level.PermissionLevelID = 0;
ds = level.prmissionLvlGet();
dgvPrmssnT.DataSource = ds.Tables[0];
dgvPrmssnT.Columns[0].HeaderText = "Permission Level ID";
dgvPrmssnT.Columns[1].HeaderText = "Permission Level";
dgvPrmssnT.Columns[2].HeaderText = "Info";
dgvPrmssnT.Columns[3].HeaderText = "Date Added";
dgvPrmssnT.Columns[0].Visible = false;
dgvPrmssnT.Columns[1].Width = 100;
dgvPrmssnT.Columns[2].Width = 200;
dgvPrmssnT.Columns[2].Width = 200;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
ds.Dispose();
}
// pPerEdit.Enabled = false;
numP.Enabled = false;
txtQtyType.Enabled = false;
txtQtyType.Focus();
}
示例7: SelectUser
public void SelectUser(int x)
{
try
{
byte count = 0;
SqlCeCommand cmd = new SqlCeCommand("SELECT * FROM Users", cKoneksi.Con);
SqlCeDataReader dr;
if (cKoneksi.Con.State == ConnectionState.Closed) { cKoneksi.Con.Open(); }
dr = cmd.ExecuteReader();
if (dr.Read()) { count = 1; } else { count = 0; }
dr.Close(); cmd.Dispose(); if (cKoneksi.Con.State == ConnectionState.Open) { cKoneksi.Con.Close(); }
if (count != 0)
{
DataSet ds = new DataSet();
SqlCeDataAdapter da = new SqlCeDataAdapter("SELECT * FROM Users", cKoneksi.Con);
da.Fill(ds, "Users");
textBoxUser.Text = ds.Tables["Users"].Rows[x][0].ToString();
textBoxPass.Text = ds.Tables["Users"].Rows[x][1].ToString();
checkBoxTP.Checked = Convert.ToBoolean(ds.Tables["Users"].Rows[x][2]);
checkBoxTPK.Checked = Convert.ToBoolean(ds.Tables["Users"].Rows[x][3]);
ds.Dispose();
da.Dispose();
}
else
{
MessageBox.Show("Data User Kosong", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
buttonClose.Focus();
}
}
catch (SqlCeException ex)
{
MessageBox.Show(cError.ComposeSqlErrorMessage(ex), "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
}
示例8: Main
static void Main(string[] args)
{
Console.Title = "增加性别字段";
string connectionString = //数据库连接字串
"Data Source=.\\SQLExpress;Database=student;Trusted_Connection=true;";
SqlConnection connection = new SqlConnection(connectionString);//创建数据库连接实例
connection.Open(); //打开数据库连接
Console.WriteLine("数据库student连接成功!");
SqlCommand cmd = new SqlCommand(); //创建数据查询类实例
cmd.Connection = connection;
cmd.CommandText = "ALTER TABLE student_info ADD sex varchar(2)";
cmd.ExecuteNonQuery(); //执行添加sex字段SQL语句
cmd.Dispose();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM student_info",
"Data Source=.\\SQLExpress;Database=student;Trusted_Connection=true;");
DataSet dataSet = new DataSet(); //创建数据集
adapter.Fill(dataSet); //填充数据集
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
dataSet.Tables[0].Rows[i][5] = random.Next(2) == 0 ? "男" : "女";//修改性别值
}
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);//将数据集更新与数据库协调
adapter.Update(dataSet); //更新数据集到数据库
builder.Dispose();
dataSet.Dispose();
adapter.Dispose();
connection.Close(); //关闭数据库连接
Console.ReadLine();
}
示例9: SelectOldCodeList
private bool SelectOldCodeList()
{
string SQLCmd = "",condStr="";
string code = oldCodeEd.Text.Trim();
string desc = oldDescEd.Text.Trim();
code = code.Trim();
if (code != "") condStr += (condStr == "" ? "" : " AND ") + "(a.customerCode LIKE '" + code + Consts.SQL_CMD_ALL_MARKER + "')";
desc = desc.Trim();
if (desc != "") condStr += (condStr == "" ? "" : " AND ") + "(a.name LIKE N'" + desc + Consts.SQL_CMD_ALL_MARKER + desc + Consts.SQL_CMD_ALL_MARKER + "')";
SQLCmd += " SELECT * FROM customer";
if (condStr != "") SQLCmd += " WHERE " + condStr;
try
{
DataSet reportDataSet = new DataSet();
SqlDataAdapter dataAdapter = new SqlDataAdapter(SQLCmd, data.dataLibs.GetMasterConnectionString());
dataAdapter.Fill(reportDataSet);
common.myComboBoxItem item;
for (int idx = 0; idx < reportDataSet.Tables[0].Rows.Count; idx++)
{
item = new common.myComboBoxItem(reportDataSet.Tables[0].Rows[idx].ItemArray[0].ToString(),
reportDataSet.Tables[0].Rows[idx].ItemArray[1].ToString());
oldCodeLb.Items.Add(item);
}
reportDataSet.Dispose(); dataAdapter.Dispose();
}
catch (Exception er)
{
common.sysLibs.ShowErrorMessage(er.Message.ToString());
return false;
}
return true;
}
示例10: DataBindFuntion
/// <summary>
/// 窗体控件的数据绑定
/// </summary>
private void DataBindFuntion()
{
string drawingstr = string.Empty;
string sqlstr = string.Empty;
string responuser=string.Empty;
this.DRAWINGNOcomboBox.Items.Clear();
if (this.DRAWINGNOcomboBox.Text.Length != 0)
{
this.DRAWINGNOcomboBox.Text.Remove(0);
}
this.querybtn.Enabled = true;
this.DRAWINGNOcomboBox.Items.Clear();
if (this.drawingrbn.Checked == true)
{
sqlstr = "SELECT DRAWING_NO FROM PLM.PROJECT_DRAWING_TAB where drawing_type is null AND Project_Id = (select T.ID from PROJECT_TAB T where T.NAME='" + this.textBox1.Text.ToString() + "') AND DOCTYPE_ID IN (7) AND DOCTYPE_ID != 71 AND LASTFLAG = 'Y' AND NEW_FLAG = 'Y' AND DELETE_FLAG = 'N' ORDER BY DRAWING_ID DESC";
}
else if (this.modifyrbn.Checked == true)
{
sqlstr = "SELECT DRAWING_NO FROM PLM.PROJECT_DRAWING_TAB where drawing_type is null AND Project_Id = (select T.ID from PROJECT_TAB T where T.NAME='" + this.textBox1.Text.ToString() + "') AND DRAWING_NO IN (SELECT DISTINCT S.MODIFYDRAWINGNO FROM SP_SPOOL_TAB S WHERE S.FLAG = 'Y' AND S.MODIFYDRAWINGNO IS NOT NULL) AND DOCTYPE_ID = 71 AND LASTFLAG = 'Y' AND NEW_FLAG = 'Y' AND DELETE_FLAG = 'N' ORDER BY DRAWING_ID DESC";
}
FillComboBox.GetFlowStatus(this.DRAWINGNOcomboBox, sqlstr);
DataSet ds = new DataSet();
drawingstr = "SELECT distinct PLM.USER_API.CHINESENAME(RESPONSIBLE_USER) FROM PLM.PROJECT_DRAWING_TAB where Project_Id = (select T.ID from PROJECT_TAB T where T.NAME='" + this.textBox1.Text.ToString() + "') AND DOCTYPE_ID IN (7) AND DOCTYPE_ID != 71 AND LASTFLAG = 'Y' AND NEW_FLAG = 'Y' AND DELETE_FLAG = 'N'";
FillComboBox.GetFlowStatus(this.RESPONSIBLEcb, drawingstr);
responuser = "select PLM.PROJECT_API.Get_PROJECT_NAME(project_id) projectname, DRAWING_NO, DRAWING_TITLE, DRAWING_TITLE_CN,Revision, PLM.USER_API.CHINESENAME(RESPONSIBLE_USER) ChineseName FROM PLM.PROJECT_DRAWING_TAB t where Project_Id = (select T.ID from PROJECT_TAB T where T.NAME='" + this.textBox1.Text.ToString() + "') AND DOCTYPE_ID IN (7) AND DOCTYPE_ID != 71 AND LASTFLAG = 'Y' AND NEW_FLAG = 'Y' AND DELETE_FLAG = 'N' ORDER BY DRAWING_ID DESC";
User.DataBaseConnect(responuser, ds);
this.DrawingsDgv.DataSource = ds.Tables[0];
ds.Dispose();
SetStatus();
}
示例11: guardardatos
private void guardardatos()
{
DataSet ds;
SqlDataAdapter adapter;
try
{
System.Data.SqlClient.SqlConnection conn;
conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
ds = new DataSet();
conn.Open();
SqlCommand command = new SqlCommand("spContacto", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("NombreyApellido", txtNombreyApellido.Text);
command.Parameters.AddWithValue("Email", txtEmail.Text);
command.Parameters.AddWithValue("Mensaje", txtMensaje.Text);
command.ExecuteNonQuery();
adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
conn.Close();
ds.Dispose();
}
catch (Exception ex){
Response.Write(ex.Message);
}
finally { }
}
示例12: initList
//初始化用户表
public void initList()
{
listUser.Clear();
listUser.Columns.Add("用户名", 150, HorizontalAlignment.Center);
listUser.Columns.Add("真实姓名", 130, HorizontalAlignment.Center);
listUser.Columns.Add("密码", 150, HorizontalAlignment.Center);
try
{
if(sc.getConn().State!=ConnectionState.Open)
{
sc.Connect();
}
string cmdText = "select * from Users";
SqlDataAdapter adapter = new SqlDataAdapter(cmdText, sc.getConn());
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
ListViewItem item = listUser.Items.Add(dataSet.Tables[0].Rows[i][0].ToString());
for (int j = 1; j < dataSet.Tables[0].Columns.Count; j++)
{
item.SubItems.Add(dataSet.Tables[0].Rows[i][j].ToString());
}
}
dataSet.Dispose();
adapter.Dispose();
}
catch(Exception ex)
{
MessageBox.Show("初始化用户信息失败:"+ex.Message);
}
}
示例13: btnLogin_Click
protected void btnLogin_Click(object sender, DirectEventArgs e)
{
DataSet ds = new DataSet();
bool user = DIMERCO.SDK.Utilities.ReSM.CheckUserInfo(tfUserID.Text.Trim(), tfPW.Text.Trim(), ref ds);
if (ds.Tables[0].Rows.Count == 1)
{
DataTable dtuser = ds.Tables[0];
Session["UserID"] = dtuser.Rows[0]["UserID"].ToString();
DataSet ds1 = DIMERCO.SDK.Utilities.LSDK.getUserProfilebyUserList(dtuser.Rows[0]["UserID"].ToString());
if (ds1.Tables[0].Rows.Count == 1)
{
DataTable dt1 = ds1.Tables[0];
Session["UserName"] = dt1.Rows[0]["fullName"].ToString();
Session["Station"] = dt1.Rows[0]["stationCode"].ToString();
Session["Department"] = dt1.Rows[0]["DepartmentName"].ToString();
Session["CostCenter"] = dt1.Rows[0]["CostCenter"].ToString();
X.AddScript("window.location.reload();");
}
else
{
X.Msg.Alert("Message", "Data Error.").Show();
return;
}
}
else
{
X.Msg.Alert("Message", "Please confirm your UserID and Password.").Show();
return;
}
if (ds != null)
{
ds.Dispose();
}
}
示例14: InitialDataBind
private void InitialDataBind()
{
DataSet ds;
#region 绑定用户下拉列表
string[] str = new string[3] { "AA", "AG", "PG" };
User user = new User();
this.ddlUser.Items.Clear();
for (int i = 0; i < str.Length; i++)
{
ds = new DataSet();
ds = user.GetUsersByType(str[i].ToString(), "");
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
string userID = ds.Tables[0].Rows[j]["UserID"].ToString();
string userName = ds.Tables[0].Rows[j]["UserName"].ToString();
ListItem li = new ListItem(userName, userID);
this.ddlUser.Items.Add(li);
}
ds.Dispose();
}
#endregion
#region 绑定角色
int userid = Convert.ToInt32(this.ddlUser.SelectedValue);
FillSelectedRoleList(userid);
FillAllRoleList(userid);
#endregion
}
示例15: executeReader
public DataSet executeReader(MySqlCommand mySqlCommand, String tabla)
{
DataSet dsTabla = new DataSet();
try
{
using (MySqlDataAdapter adaptador = new MySqlDataAdapter(mySqlCommand))
{
mySqlCommand.Connection = conexion;
dsTabla = new DataSet();
adaptador.Fill(dsTabla, tabla);
}
return dsTabla;
}
catch (Exception ex)
{
ex.Source += " SQL: " + mySqlCommand.CommandText.ToString();
Log.Write(MethodBase.GetCurrentMethod().Name, ex);
throw ex;
}
finally
{
if (dsTabla != null)
dsTabla.Dispose();
}
}