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

Abhishek Sur wrote:

I thought everything that is not derived from ValueTypes are called ByRef.
But it isnt actually.

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

       'prueba 1
       Dim b As New SqlClient.SqlCommand()
       Prueba1(b)
       ''here  the variable     b have       commandtext="ddddddd",    commandtimeout=45,
       ''CommandType = CommandType.StoredProcedure
       b.CommandText = ""


       'prueba 2
   End Sub
   Public Sub Prueba1(ByVal rr As SqlClient.SqlCommand)
       rr.CommandText = "dddd"
       rr.CommandTimeout = 45
       rr.CommandType = CommandType.StoredProcedure

       rr.Dispose()
       rr = Nothing
   End Sub