how to access string array from a class to the drop down list items

Question

1.00/5 (1 vote)

See more:

here i'm just creating an object to a class which provides the sql connection in the default constructor as AccessData class(AccessData.cs)
in the webform1.aspx.cs
declaring the event of ddlDistrict and based on the district value i have to list out the Mandal list in that district which is taken from the table Locationsdt(SQL server 2008)
please explain me how to solve this task.

Posted 26-Oct-11 19:35pm

sandhya.T 2011

Add a Solution

Comments

Mehdi Gholam 27-Oct-11 1:38am

Show your code.

sandhya.T 2011 27-Oct-11 2:01am

sorry to say that i can't provide the code
bcoz im doing this at home, presently i'm in office.
plz help me the logic

Sergey Alexandrovich Kryukov 27-Oct-11 2:12am

Aha, let's see... What's "object to a class"? "District value"? No punctuation... I understand next to nothing... And please, this is consider rude: "bcoz", "plz". This is textspeak, not English.
--SA

sandhya.T 2011 27-Oct-11 2:46am

ya k but whoz dis

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anil Honey 206 · Accepted Answer · 2011-10-30T23:07:00

Almost all methods i have given in this code.But u should concentrate on this do hardwork and analize the code correctly.Put Break Points and execute.Dont do Blindly.So you Cant lean Anything.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;

/// <summary>
/// Summary description for DataAcessHelper
/// </summary>
public class DataAcessHelper
{
    SqlConnection objcon;
    public bool ExecuteSucess = false;
	public DataAcessHelper()
	{
		//
		// TODO: Add constructor logic here
		//

	}
    private void GetConnection(SqlCommand objcmd)
    {
        string connecstring = ConfigurationManager.ConnectionStrings["ANIL"].ToString();
        //string connecstring = ConfigurationManager.AppSettings["ANIL"].ToString();
        objcon = new SqlConnection(connecstring);
        objcon.Open();
        objcmd.Connection = objcon;
    }

    public int ExecuteStoredProcedure(SqlCommand objcmd)
    {
     
        GetConnection(objcmd);
        int obj = objcmd.ExecuteNonQuery();
        Dbclose(objcmd.Connection);
        ExecuteSucess = true;
        return obj;


    }
    public int ExecuteSPReturnID(SqlCommand objcmd)
    {
      
        GetConnection(objcmd);
        int tempval = Convert.ToInt32(objcmd.ExecuteScalar());
        Dbclose(objcmd.Connection);
        ExecuteSucess = true;
        return tempval;
    }
    public SqlCommand CreateCommand(string strProcedureName)
    {

        System.Data.SqlClient.SqlCommand objcmd;
        objcmd = new System.Data.SqlClient.SqlCommand();
        objcmd.CommandText = strProcedureName;
        objcmd.CommandType = CommandType.StoredProcedure;

        return objcmd;

    }
    public SqlCommand CreateTextCommand(string strquery)
    {
        System.Data.SqlClient.SqlCommand objcmd;
        objcmd = new System.Data.SqlClient.SqlCommand();
        objcmd.CommandText = strquery;
        objcmd.CommandType = CommandType.Text;
        return objcmd;
    }
    public void AddParameter(SqlCommand objCmd, string strParaname, SqlDbType enmParaType, ParameterDirection enmParaDirection, int intParaSize, object objParaValue)
    {
        System.Data.SqlClient.SqlParameter objpara;
        objpara = new System.Data.SqlClient.SqlParameter();
        objpara.ParameterName = strParaname;
        objpara.SqlDbType = enmParaType;
        objpara.Direction = enmParaDirection;
        objpara.Size = intParaSize;
        objpara.Value = objParaValue;
        objCmd.Parameters.Add(objpara);
    }
    public DataSet GetDataSet(SqlCommand objCmd)
    {
     
        GetConnection(objCmd);
        System.Data.SqlClient.SqlDataAdapter objadp;
        objadp = new System.Data.SqlClient.SqlDataAdapter(objCmd);
        DataSet ds;
        ds = new DataSet();
        objadp.Fill(ds);
        Dbclose(objCmd.Connection);
        return ds;


    }
    public DataSet GetDataSet(SqlCommand objCmd, string Tablename)
    {
        GetConnection(objCmd);
        System.Data.SqlClient.SqlDataAdapter objadp;
        objadp = new System.Data.SqlClient.SqlDataAdapter(objCmd);
        DataSet ds;
        ds = new DataSet();
        objadp.Fill(ds, Tablename);
        Dbclose(objCmd.Connection);
        return ds;
    }
    public DataSet GetDataSet(SqlCommand objCmd, int startRecord, int MaxRecord, string srcTable)
    {
        GetConnection(objCmd);
        System.Data.SqlClient.SqlDataAdapter objadp;
        objadp = new System.Data.SqlClient.SqlDataAdapter(objCmd);
        DataSet ds;
        ds = new DataSet();
        objadp.Fill(ds);
        Dbclose(objCmd.Connection);
        return ds;

    }


    public DataTable GetDataTable(SqlCommand objCmd)
    {
        GetConnection(objCmd);
        System.Data.SqlClient.SqlDataAdapter objadp;
        objadp = new System.Data.SqlClient.SqlDataAdapter(objCmd);
        DataTable dt;
        dt = new DataTable();
        objadp.Fill(dt);
        Dbclose(objCmd.Connection);
        return dt;
    }
    public object GetValue(SqlCommand objCmd)
    {
    
        GetConnection(objCmd);
        object objvalue;
        objvalue = objCmd.ExecuteScalar();
        Dbclose(objCmd.Connection);
        return objvalue;
    }
    public bool DataExists(SqlCommand objcmd)
    {
        bool blnStatus;
        DataTable dtExist = GetDataTable(objcmd);
        if (dtExist.Rows.Count > 0)
        {
            blnStatus = true;
        }
        else
        {
            blnStatus = false;
        }
        return blnStatus;

    }
    private void Dbclose(SqlConnection sqlcon)
    {
        sqlcon.Close();
        sqlcon.Dispose();
    }
}

Anil Honey 206 · Accepted Answer · 2011-11-01T18:01:00

Dear Sandhya,

You can Use Dataset or DataTable.But iam Ising DataTable

public DataTable GetMantal()
   {
       DataTable dt = new DataTable();

       DataAcessHelper dashp = new DataAcessHelper();
       SqlCommand cmd = dashp.CreateCommand("sp_getMandal);
       dashp.AddParameter(cmd, "@districtname", SqlDbType.VarChar, ParameterDirection.Input, 50, FullName);
       dt = dashp.GetDataTable(cmd);

       return dt;
   }

But Infornt that is To Web Control You Should Retrive The values.Analize this One Try that One.I Hope You got an Idea.

Anil Honey 206 · Accepted Answer · 2011-10-26T20:13:00

Solution 1

Dear Sandhya,

C#

         protected void cmbDist_SelectedIndexChanged(object sender, EventArgs e)
{
    try
    {
        ds = new DataSet();
        ad = new SqlDataAdapter("select intmandalid,strMandalename from Mandal where intDiatrictid=" + cmbDist.SelectedItem.Value + "", (SqlConnection)Application.Get("JDCI"));
        ad.Fill(ds);
        drpmandal.Items.Clear();
        drpmandal.Items.Add("---Select---");
        drpmandal.Items[0].Value = "0";
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            drpmandal.Items.Add(ds.Tables[0].Rows[i][1].ToString());
            drpmandal.Items[i + 1].Value = ds.Tables[0].Rows[i][0].ToString();
        }
    }
    catch (Exception ex)
    {
    }
}

Its Works Please analize and do with what ever architecture u have taken.

Regards,

Anilkumar.D

Posted 26-Oct-11 20:13pm

Anil Honey 206

Updated 26-Oct-11 20:14pm

v2

Comments

sandhya.T 2011 27-Oct-11 2:30am

thanq for ur reply
but it is the webform page i just want to access the values from a seperate class
protected void cmbDist_SelectedIndexChanged(object sender, EventArgs e)
{

}

sandhya.T 2011 27-Oct-11 2:37am

protected void cmbDist_SelectedIndexChanged(object sender, EventArgs e)
{
AccessData c1= new AccessData();
string[] M=c1.Mandal(ddlDistrict.value);//how can i pass an argument
without using a parameter for the value of the ddl district
//by using the above stmt string[] can be retrieved or not
}
AccessData.cs
AccessData()
{
//connection stmts of sql server
}
public string[]Mandal(string dis)
{
//here i want to return the string array i.e list of mandals
}

please help me

Anil Honey 206 27-Oct-11 2:53am

What architecture ur using 3tier or 2tier Ur not setting any properties in your class file.

sandhya.T 2011 27-Oct-11 3:54am

hi archana,
im dng a simple project using a VS.net 2010 with the Sql server 2008,
now i have referred these terms then i got this info.
i.e im using the 2 tier application but i don't know the depth of it

Anil Honey 206 27-Oct-11 4:17am

Ur using Stored Procedures in your Class file.If your Using Class file then you should set properties for that means if for district you sholud give one propert for that and also for Mandal then u can pass the values and get the values.

sandhya.T 2011 27-Oct-11 4:56am

yes, im using the stored procedures to access the data from the sql
can u give me example code how to give the property for the district and mandal
please give me the code if possibles otherwise if u have any soft copy of it, just attach that soft copy

Anil Honey 206 · Accepted Answer · 2011-10-26T23:12:00

Here iam giving the Code You Should analize the code some sample iam giving.

C#

using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;

public class District
{
	public InboxCount()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    private Int32 _intDistrictid;
    private string strDistrictname;

    public Int32 IntDistrictId
    {
        get { return _intDistrictid; }
        set { _intDistrictid= value; }
    }

    public string DistrictName
    {
        get { return strDistrictname; }
        set { strDistrictname= value; }
    }

    //Example

    public DataTable InsertExample()
    {
        DataTable dt = new DataTable();

        DataAcessHelper acess = new DataAcessHelper();
        SqlCommand cmd = acess.CreateCommand("sp_stroreDistrict");
        acess.AddParameter(cmd, "@DistrictId", SqlDbType.Int, ParameterDirection.Input, 4, IntDistrictId);
        acess.AddParameter(cmd, "@Districtname", SqlDbType.VarChar, ParameterDirection.Input, 50, DistrictName);
        acess.ExecuteStoredProcedure(cmd);

        return dt;
    }

     public DataTable GetTotalMessage()
    {
        DataTable dt = new DataTable();

        DataAcessHelper dashp = new DataAcessHelper();
        SqlCommand cmd = dashp.CreateCommand("Sp_getdistrict");
        dashp.AddParameter(cmd, "@DistrictId", SqlDbType.Int, ParameterDirection.Input, 4, IntDistrictId);
        dt = dashp.GetDataTable(cmd);

        return dt;
    }
    public DataTable DeleteInbox()
    {
        DataTable dt = new DataTable();

        DataAcessHelper dashp = new DataAcessHelper();
        SqlCommand cmd = dashp.CreateCommand("sp_Deletedistrict");
        dashp.AddParameter(cmd, "@DistrictId", SqlDbType.Int, ParameterDirection.Input, 4, IntDistrictId);
        dashp.ExecuteStoredProcedure(cmd);


        return dt;
    }

}

You Should analize everything then only You can understand.

Anil Honey 206 · Accepted Answer · 2011-10-30T19:46:00

Dear Friend,

This is Simple Dataacess layer first Analize this and Implement in Your Project get and idea About This.Ok.

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 DataBaseClass
/// </summary>
public class DataBaseClass
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlCon"].ToString());

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

    public DataSet GetDataset(string strQuery)
    {
        try
        {
            SqlDataAdapter da = new SqlDataAdapter(strQuery, con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    public SqlDataReader ExecuteReader(string strQuery)
    {
        try
        {
            SqlDataReader dr = null;
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            else if (con.State == ConnectionState.Broken)
            {
                con.Close();
                con.Open();
            }
            SqlCommand cmd = new SqlCommand(strQuery, con);
            dr = cmd.ExecuteReader();
            return dr;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    public object ExecuteScalar(string strQuery)
    {
        try
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            else if (con.State == ConnectionState.Broken)
            {
                con.Close();
                con.Open();
            }
            SqlCommand cmd = new SqlCommand(strQuery, con);
            return cmd.ExecuteScalar();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    public void ExecuteNonQuery(string strQuery)
    {
        try
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            else if (con.State == ConnectionState.Broken)
            {
                con.Close();
                con.Open();
            }

            SqlCommand cmd = new SqlCommand(strQuery,con);
            cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    //internal DataSet GetDataSet(string strQuery)
    //{
    //    throw new NotImplementedException();
    //}
}

how to access string array from a class to the drop down list items

5 solutions

Solution 4

Solution 5

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0