ASP.NET

body
{
}
.WorkSpace
{
   width:800px;
   height: 600px;
}

Murugavel Sadagopan wrote:

Hi,

i have three dropdown boxes, in first drop down boxes i have a items of databases name.
i want 2nd drop down box contains list of tables dependent on dropdown box1 of databasename.

please guide me,

Murugavel Sadagopan wrote:

in dropdownlist3 -- list the columns contains in the table depend on dropdownlist2

SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@databaseID", dropDownList1.SelectedValue);

ddlDropDownlist2 = MyClass.FillMyDropDownList(ddlDropDownlist2, parms, "ddlText", "ddlID", "ConnectionString", "SqlCommandOrStoredProcedure");



public DropDownList FillMyDropDown(DropDownList ddlName, SqlParameter[] parms, String TextValue, String IDValue, String ConnectionName, String StoredProcedure)
{
SqlCommand cmd = null;
cmd = BaseDatabaseData(StoredProcedure, parms, ConnectionName);
ddlName.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
ddlName.DataTextField = TextValue;
ddlName.DataValueField = IDValue;
ddlName.DataBind()
cmd.Connection.Close();

return ddlName;
}

private SqlCommand BaseDatabaseData(String StoredProc, SqlParameter[] arrParameters, String ConnectionName)
		{
			try
			{
                String connection = System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionName].ConnectionString;
				SqlConnection con = new SqlConnection(connection);

				SqlCommand cmd = new SqlCommand(StoredProc, con);
				cmd.CommandType = CommandType.StoredProcedure;
				cmd.Parameters.AddRange(arrParameters);
				cmd.CommandTimeout = 3600;
				cmd.UpdatedRowSource = UpdateRowSource.None;

				if (cmd.Connection.State.Equals(ConnectionState.Open))
					cmd.Connection.Close();
				
				cmd.Connection.Open();
				return cmd;
			}
			catch (Exception err)
			{
				throw new Exception(err.Message, err.InnerException);
			}
		}