ASP.NET

sris 426 wrote:

What type of data i can keep in global.ajax file

bool LoadSubIndustries = true;
public int IndustryId { get; set; }

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        Populate_Industry();
    }

    LoadSubIndustries = false;
}

private void Populate_SubIndustry()
{
    DataSet dsSubIndustries = lookupManager.GetSubIndsutryByIndustryId(IndustryId);

    ddlSubIndustry.DataSource = dsSubIndustries.Tables["Lookup_SubIndustry"].DefaultView;
    ddlSubIndustry.DataValueField = "Id";
    ddlSubIndustry.DataTextField = "SubIndustry";

    ddlSubIndustry.DataBind();
}

private void Populate_Industry()
{
    DataSet dsIndustries = lookupManager.GetIndustries();

    ddlIndustry.DataSource = dsIndustries.Tables["Lookup_Industry"].DefaultView;
    ddlIndustry.DataValueField = "Id";
    ddlIndustry.DataTextField = "Industry";

    ddlIndustry.DataBind();
}

protected void ddlIndustry_SelectedIndexChanged(object sender, EventArgs e)
{
    if (LoadSubIndustries == false)
    {
        IndustryId = (int.Parse(ddlIndustry.SelectedValue.ToString()));
        Populate_SubIndustry();
    }
}

protected void ddlIndustry_SelectedIndexChanged(object sender, EventArgs e)
{
    if (LoadSubIndustries == false)
    {
        IndustryId = (int.Parse(ddlIndustry.SelectedValue.ToString()));
        Populate_SubIndustry();
    }
}

Mark Nischalke wrote:

First, read this[^]

Abhishek Sur wrote:

It will dispose cmd as it is ByRef.

Dim b As New SqlClient.SqlCommand()
x(b)
b.CommandText = "" ' this will allow Because of ByVal but will assign            ' value ddd to CommandText

Public Sub x(ByVal rr As SqlClient.SqlCommand)
        rr.CommandText = "dddd"
        rr.Dispose()
        rr = nothing
End Sub

 private void button1_Click(object sender, EventArgs e)
 {
      SqlCommand cmd = new SqlCommand();
      this.x(ref cmd);
      cmd.CommandText = ""; // This will throw Error... 
           
 }

private void x(ref SqlCommand com)
{
     com = null;
}