What is the difference between Server.Transfer and
Response.Redirect? Why would you choose one over the other?
Answer Posted / x
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;
public partial class _Default : System.Web.UI.Page
{
public string qry = string.Empty;
public SqlDataAdapter dap = null;
public DataSet dst = null;
public string proj;
public string mod;
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString =
ConfigurationManager.ConnectionStrings
["Connection"].ToString();
con.Open();
string sql = string.Empty;
string projCode = string.Empty;
string moduleID = string.Empty;
if (!IsPostBack)
{
qry = "Select Projcode from Etmtech.dbo.Project
where edgesupported = 1 and libraryname = 'recon' order by
projcode";
dap = new SqlDataAdapter(qry, con);
dst = new DataSet();
dap.Fill(dst);
selProject.DataSource = dst;
selProject.DataTextField = dst.Tables[0].Columns
["Projcode"].ToString().ToUpper();
selProject.DataBind();
dap.Dispose();
dst.Dispose();
qry = "Select clientname,clientid from
etmtech.dbo.client (nolock) order by clientid";
dap = new SqlDataAdapter(qry, con);
dst = new DataSet();
dap.Fill(dst);
selClient.DataSource = dst;
selClient.DataTextField = dst.Tables[0].Columns
["clientname"].ToString();
selClient.DataValueField = dst.Tables[0].Columns
["clientid"].ToString();
selClient.DataBind();
dap.Dispose();
dst.Dispose();
}
projCode = selProject.SelectedValue.ToString();
if(Session["projCode"] == null || !projCode.Equals
(Session["projCode"].ToString()))
{
qry = string.Empty;
qry = "Select descr,moduleid from
Recon.dbo.Recon_Menu (Nolock) where projcode = '" +
selProject.SelectedItem.Text + "'";
dap = new SqlDataAdapter(qry, con);
dst = new DataSet();
dap.Fill(dst);
selModule.DataSource = dst;
selModule.DataValueField = dst.Tables[0].Columns
["moduleid"].ToString();
selModule.DataTextField = dst.Tables[0].Columns
["descr"].ToString();
selModule.DataBind();
dap.Dispose();
dst.Dispose();
Session["projCode"] = projCode;
}
moduleID = selModule.SelectedValue;
if (!moduleID.Equals(string.Empty))
{
qry = string.Empty;
qry = "select
o.objectorder,o.descr,pt.name,p.parmvalue from
recon.dbo.recon_object o (nolock)";
qry = qry + " ,recon.dbo.recon_parameter p
(nolock),recon.dbo.recon_lu_parametertype pt (nolock)";
qry = qry + " where o.moduleid =" +
Convert.ToInt32(moduleID) + " and o.objectid = p.objectid
and p.parmtypeid = pt.parmtypeid order by o.objectorder";
dap = new SqlDataAdapter(qry, con);
dst = new DataSet();
dap.Fill(dst);
GVobj.DataSource = dst;
GVobj.DataBind();
if (dst.Tables[0].Rows.Count > 0)
{
btSave.Enabled = true;
btCancel.Enabled = true;
}
dap.Dispose();
dst.Dispose();
}
string client = selClient.SelectedValue.ToString();
}
protected void GVobj_RowDataBound(object sender,
GridViewRowEventArgs e)
{
if (e.Row.RowIndex == 0)
{
proj = e.Row.Cells[1].Text;
}
if (e.Row.RowIndex > 0)
{
if (proj.Equals(e.Row.Cells[1].Text))
{
e.Row.Cells[1].Text = "";
}
}
}
}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is base class of .net?
Explain the asp.net session state modes.
Is asp.net and .net are same or different?
What are the file extensions for razor views?
Explain asp.net application life cycle?
Mention few asp.net validators.
What is viewstate? What does the “enableviewstate” property do?
Distinguish between Server-side and Client-side code with its functionality?
Where is http session stored?
What are the difference between function and stored procedure in .net programming language?
What is autopostback in dropdownlist in asp net?
benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks
Explain how do you deploy your asp.net application?
What is asp.net web application?
What is the use of data set in asp.net?