.cs class for transaction sql by anil kumar aggarwal (soft. dov.)

using System;using System.Data;using System.Configuration;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;using System.IO;using System.Net.Mail;using System.Diagnostics;using System.Net;///
/// <summary> Summary description for clsConnection/// </summary>public class clsConnection{

{
public clsConnection()//// TODO: Add constructor logic here//}






{
SqlConnection con = new SqlConnection();SqlCommand com = new SqlCommand();SqlDataAdapter da = new SqlDataAdapter();string constr = "Data Source=150.236.12.34;Initial Catalog=PMS; User Id=pms;Password=smp;";MailMessage mail;public static string connectget{

}
}

{


{
con.ConnectionString = constr;
con.Open();
}
com.CommandText = str;
com.Connection = con;
da.SelectCommand = com;
da.Fill(ds);
con.Close();

}







{


{
con.ConnectionString = constr;
con.Open();
}
com.CommandText = str;
com.Connection = con;
da.SelectCommand = com;
s1 =
con.Close();

}

{

{
con.ConnectionString = constr;
con.Open();
}
com.CommandText = str;
com.Connection = con;
da.SelectCommand = com;
com.ExecuteNonQuery();
con.Close();
}

{
return "Data Source=150.236.12.34;Initial Catalog=PMS; User Id=pms;Password=smp;";public DataSet selectds(string str)DataSet ds = new DataSet();if (con.State == ConnectionState.Closed)return ds;public string SelectScalar(string str)string s1;if (con.State == ConnectionState.Closed)Convert.ToString(com.ExecuteScalar());return s1;public void ExecuteQuery(string str)if (con.State == ConnectionState.Closed)public void fillRadioButtonList(String query, RadioButtonList objDDL, String colfield, String valField)try{

{
con.ConnectionString = constr;
con.Open();
}

objDDL.Items.Clear();
da =
da.Fill(ds);

objDDL.DataSource = ds.Tables[0];
objDDL.DataTextField = colfield;
objDDL.DataValueField = valField;
objDDL.DataBind();
}

}

{
if (con.State == ConnectionState.Closed)DataSet ds = new DataSet();new SqlDataAdapter(query, con);catch { }public void FillDropdownListwithvalue(String query, DropDownList objDDL, String colfield, String valField)try{

{ con.ConnectionString = constr; con.Open(); }

objDDL.Items.Clear();
da =
da.Fill(ds);


NewRow[colfield] =
newtbl = ds.Tables[0];
newtbl.Rows.InsertAt(NewRow, 0);
newtbl.AcceptChanges();
newtbl = newtbl.Copy();
objDDL.DataSource = ds.Tables[0];
objDDL.DataTextField = colfield;
objDDL.DataValueField = valField;
objDDL.DataBind();
}

}

{

{
con.ConnectionString = constr;
con.Open();
}



}
}if (con.State == ConnectionState.Closed)DataSet ds = new DataSet();new SqlDataAdapter(query, con);DataTable newtbl = new DataTable();DataRow NewRow = ds.Tables[0].NewRow();"-Please Select-";catch { }public int getmaxid(string str)if (con.State == ConnectionState.Closed)SqlCommand commm = new SqlCommand(str, con);int maxid = Convert.ToInt32(commm.ExecuteScalar()) + 1;return maxid;