Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

DataInteraction.cs

using System;
using System.Data;
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;
using System.Data.SqlClient;

/// <summary>
/// Summary description for DataInteraction is created by...
/// </summary>
public class DataInteraction
{
    SqlConnection con = new SqlConnection();
    SqlCommand cmd = new SqlCommand();

SqlDataAdapter adpt = new SqlDataAdapter();

SqlDataReader dr;

public DataInteraction()
    {
        //con.ConnectionString = "server=DAV-23FB915E1EF\\SQLEXPRESS;Initial Catalog=MLMSwastik;Integrated Security=True; Trusted_connection=yes;";
        con.ConnectionString = ConfigurationManager.ConnectionStrings["Constr"].ToString();

//con.ConnectionString = "Datasource=208.43.0.115;Initial Catalog=schoolat;Integrated Security=false;user=school; Password=ruchin;  Trusted_connection=yes;";
        //con.ConnectionString = "Data source=208.43.0.115;Initial Catalog=schoolat;user ID=school; password=ruchin;  ";

}
    public DataSet FillDs(String query)
    {

DataSet ds = new DataSet();
        ds.Clear();
        con.Open();
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;   
        cmd.CommandText = query;
        cmd.ExecuteNonQuery();
        adpt.SelectCommand = cmd;
        adpt.Fill(ds);
        con.Close();
        return ds;
    }
    public void IDU(String query)
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;   
        cmd.CommandText = query;

cmd.ExecuteNonQuery();
        con.Close();
    }

public String SelectSclar(String query)
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;   
        cmd.CommandText = query;
        string result = Convert.ToString(cmd.ExecuteScalar());
        con.Close();
        return result;

}
    public SqlDataReader FillDr(String query)
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;   
        cmd.CommandText = query;
        dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        return dr;
    }

public void fillddl(string qry, DropDownList ddl,string txt,string val)
    {
        ddl.Items.Clear();   
        ddl.Items.Add("--Select--");  
        ddl.DataSource = FillDs(qry);
        ddl.DataTextField = txt;
        ddl.DataValueField = val;
        ddl.DataBind();  
    }

public void fillgrd( GridView gv,string qry)
    {
        gv.DataSource = FillDs(qry);
        gv.DataBind();

}

public void Ex_Sp(string sp,SqlParameter prm)
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(prm);  
        cmd.CommandText = sp;

cmd.ExecuteNonQuery();
        con.Close();
    }

public void Ex_Sp_arr(string sp, SqlParameter [] prm)
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddRange(prm);  
        cmd.CommandText = sp;

cmd.ExecuteNonQuery();
        con.Close();
    }

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2018-05-19 07:41:30
..	dir	-	0/0	0777	2025-07-24 01:07:07
ClsArrearMaster.cs	text/plain	2.76 KB	0/0	0666	2018-06-10 06:00:25
DataAccess.cs	text/plain	24.16 KB	0/0	0666	2018-06-10 06:00:25
DataInteraction.cs	text/plain	3.35 KB	0/0	0666	2018-06-10 06:00:25
DataIntraction.cs	text/plain	445 B	0/0	0666	2018-06-10 06:00:25
WebService.cs	text/plain	1.59 KB	0/0	0666	2018-06-10 06:00:26
clsDBOperations.cs	text/plain	23.79 KB	0/0	0666	2018-06-10 06:00:25
clsGenral.cs	text/plain	23.19 KB	0/0	0666	2018-06-10 06:00:25

Team Anon Force

https://t.me/Professor6T9x