Gecko [ vsec.in ]

Name	Size	Permission
.mad-root	0 B	-rw-rw-rw-
BindCategories.cs	3.66 KB	-rw-rw-rw-
BindNews.cs	17.67 KB	-rw-rw-rw-
Class1.cs	2.74 KB	-rw-rw-rw-
DBManager_2.cs	5.21 KB	-rw-rw-rw-
DBmanager.cs	4.64 KB	-rw-rw-rw-
Dal_MediaType.cs	2.06 KB	-rw-rw-rw-
Dal_NewsSource.cs	3.04 KB	-rw-rw-rw-
Dal_PostNews.cs	17.14 KB	-rw-rw-rw-
Dal_Segment.cs	2.96 KB	-rw-rw-rw-
DataSetBill.xsd	15.47 KB	-rw-rw-rw-
DataSetBill.xss	859 B	-rw-rw-rw-
DataSetBill_Report.xsd	16.09 KB	-rw-rw-rw-
DataSetBill_Report.xss	859 B	-rw-rw-rw-
DataSetOnlyId.xsd	6.91 KB	-rw-rw-rw-
DataSetOnlyId.xss	854 B	-rw-rw-rw-
DataSetP_Pres.xsd	6.91 KB	-rw-rw-rw-
DataSetP_Pres.xss	3 B	-rw-rw-rw-
DataSetPatient.xsd	6.92 KB	-rw-rw-rw-
DataSetPatient.xss	3 B	-rw-rw-rw-
Emailsender.cs	1.15 KB	-rw-rw-rw-
GlobalClass.cs	495 B	-rw-rw-rw-
ManageSession.cs	1.24 KB	-rw-rw-rw-
PaymentData.cs	1.16 KB	-rw-rw-rw-
RishiMathod.cs	3.52 KB	-rw-rw-rw-
SMTPEmailSender.cs	1.56 KB	-rw-rw-rw-
ShowSlot.cs	413 B	-rw-rw-rw-
SmsSender.cs	1014 B	-rw-rw-rw-
Sql_Connection.cs	918 B	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
dbconnection.cs	1.19 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-

Code Editor : BindCategories.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Summary description for BindCategories
/// </summary>
public class BindCategories
{
    Sql_Connection con_obj = new Sql_Connection();

public DataTable MediaType()
    {
        SqlCommand cmd = new SqlCommand("Select * from CNF_MEDIA_TYPE", con_obj.DbConnect());        
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con_obj.DbClose();
        return dt;
    }
    public DataTable BindSegment()
    {
        SqlCommand cmd = new SqlCommand("Select * from CNF_SEGMENT_MASTER", con_obj.DbConnect());
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con_obj.DbClose();
        return dt;
    }
    public DataTable BindSubSegment()
    {
        SqlCommand cmd = new SqlCommand("Select *,(SELECT segment_name FROM CNF_SEGMENT_MASTER WHERE pk_cnf_segment_id=a.fk_cnf_segment_id) as segment from CNF_SUBSEGMENT_MASTER a order by fk_cnf_segment_id", con_obj.DbConnect());
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con_obj.DbClose();
        return dt;
    }
    public DataTable BindNewsSource()
    {
        SqlCommand cmd = new SqlCommand("Select * from CNF_NEWS_SOURCE", con_obj.DbConnect());
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con_obj.DbClose();
        return dt;
    }
    /// <summary>
    /// Active Binding
    /// </summary>
    /// <returns></returns>
    //public DataTable BindActiveMediaType()
    //{
    //    SqlCommand cmd = new SqlCommand("Select * from CNF_MEDIA_TYPE where type_status=1", con_obj.DbConnect());
    //    SqlDataAdapter da = new SqlDataAdapter(cmd);
    //    DataTable dt = new DataTable();
    //    da.Fill(dt);
    //    con_obj.DbClose();
    //    return dt;
    //}
    //public DataTable BindActiveSegment()
    //{
    //    //SqlCommand cmd = new SqlCommand("Select * from CNF_SEGMENT_MASTER where segment_status=1", con_obj.DbConnect());
    //    //SqlDataAdapter da = new SqlDataAdapter(cmd);
    //    //DataTable dt = new DataTable();
    //    //da.Fill(dt);
    //    //con_obj.DbClose();
    //    //return dt;
    //}
    //public DataTable BindActiveNewsSource()
    //{
    //    SqlCommand cmd = new SqlCommand("Select * from CNF_NEWS_SOURCE where source_status=1", con_obj.DbConnect());
    //    SqlDataAdapter da = new SqlDataAdapter(cmd);
    //    DataTable dt = new DataTable();
    //    da.Fill(dt);
    //    con_obj.DbClose();
    //    return dt;
    //}

public DataTable BindActivesubsegment()
    {
        SqlCommand cmd = new SqlCommand("Select * from CNF_SUBSEGMENT_MASTER where subsegment_status=1", con_obj.DbConnect());
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con_obj.DbClose();
        return dt;
    }

/// <summary>
    /// Active Binding With Pk-Id
    /// </summary>
    /// <returns></returns>
    /// 
    public DataTable Bind_ddl_SubSegment(string id)
    {
        SqlCommand cmd = new SqlCommand("Select * from CNF_SUBSEGMENT_MASTER where fk_cnf_segment_id='" + id + "' and subsegment_status=1", con_obj.DbConnect());
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con_obj.DbClose();
        return dt;
    }
}

${this.title}

Code Editor : BindCategories.cs