ASP.NET

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);
			}
		}

bbc_sh wrote:

else
string filepath=Server.MapPath("~/pic/" + UploadeTest.FileName);
UploadeTest.SaveAs(filepath);

<br />
else<br />
{<br />
string filepath=Server.MapPath("~/pic/" + UploadeTest.FileName);<br />
UploadeTest.SaveAs(filepath);<br />
}<br />

<br />
protected void uploade_Click(object sender, EventArgs e)<br />
{<br />
string filepath;<br />
if (UploadeTest.HasFile == false)<br />
{<br />
uploadedetail.Text = "plese select youre file";<br />
}<br />
else<br />
filepath=Server.MapPath("~/pic/" + UploadeTest.FileName);<br />
UploadeTest.SaveAs(filepath);<br />
}<br />