0817CLass

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Data.OleDb;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text.RegularExpressions;
namespace Erp
{
 /// <summary>
 /// Summary description for Erp.
 /// </summary>
 public class Erp
 {
      
  public string Connectionstring;  //Show Two value
  public SqlConnection conn;
     
       public void Open() //Open SqlConnection
       {
            string dataconnection =  System.Configuration.ConfigurationSettings.AppSettings["Sql"];
      conn=new SqlConnection(dataconnection);
            if (conn.State != ConnectionState.Open)
            conn.Open();
        } 
       
  public void Close() //Close SqlConnection
  {
   if(conn.State==ConnectionState.Open)
   conn.Close() ;
  }
  
  public DataSet Data_ds(string Sql_txt) //databind DataSet 
  {
   this.Open();   
   SqlDataAdapter sdr = new SqlDataAdapter(Sql_txt, conn);
   DataSet ds = new DataSet();
   sdr.Fill(ds);
   return ds;
  }
  
  public void databind_drg(DataGrid drg, string Sql_txt) //databind DataGrid
  {
   this.Open();
   drg.DataSource = this.Data_ds(Sql_txt);
   drg.DataBind();
   this.Close();
  }
  
  public void databind_dlst(DataList dlst, string Sql_txt) //databind DataList
  {
   dlst.DataSource = this.Data_ds(Sql_txt);
   dlst.DataBind();
   this.Close();
  }

  public void data_Chg(string Sql_txt) //chang database
  {
   this.Open();
   SqlCommand cmd = new SqlCommand(Sql_txt, conn);
   cmd.ExecuteNonQuery();
   cmd=null;
   this.Close();
  }
  
  public void databind_drop(DropDownList drop,string Sql_txt,string Id,string Name,string table) //databind DropDownList
  {

           this.Open();
           SqlDataAdapter sdr=new SqlDataAdapter(Sql_txt,conn);
     DataSet ds=new DataSet();
           sdr.Fill(ds,"table");
     drop.DataTextField="id";
     drop.DataValueField="Name";
     drop.DataSource=ds.Tables["table"].TableName;
        drop.DataBind();  

  }
  public void Alert(string massage,Page page) //Show massage
  {
           page.RegisterStartupScript("","<script> alert('"+massage+"');</script>");
  }
 }
}