?using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// DataOperate 的摘要說明
/// </summary>
public class DataOperate
{
	public DataOperate()
	{
	}
    DataCon dataCon = new DataCon();
    public bool DataCom(string sqlstr)
    {
        SqlConnection sqlconn = dataCon.getCon();
        sqlconn.Open();
        SqlCommand sqlcomm = new SqlCommand(sqlstr, sqlconn);
        try
        {
            sqlcomm.ExecuteNonQuery();
            return true;
        }
        catch
        {
            return false;
        }
        finally
        {
            sqlconn.Close();
        }
    }
    public bool gvBind(GridView gv, string sqlstr)
    {
        SqlConnection sqlconn = dataCon.getCon();
        sqlconn.Open();
        SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstr, sqlconn);
        DataSet mydataset = new DataSet();
        sqldataadapter.Fill(mydataset);
        gv.DataSource = mydataset;
        try
        {
            gv.DataBind();
            return true;
        }
        catch
        {
            return false;
        }
        finally
        {
            sqlconn.Close();
        }
    }
    public bool dataBind(DataList dl,string sqlstr)
    {
        SqlConnection sqlconn = dataCon.getCon();
        sqlconn.Open();
        SqlDataAdapter myadapter = new SqlDataAdapter(sqlstr, sqlconn);
        DataSet mydataset = new DataSet();
        myadapter.Fill(mydataset);
        dl.DataSource = mydataset;
        try
        {
            dl.DataBind();
            return true;
        }
        catch
        {
            return false;
        }
        finally
        {
            sqlconn.Close();
        }
    }
}