Click here to Skip to main content
15,890,512 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Force Browser to use updated pdf file instead of cache version Pin
ZurdoDev26-Apr-17 10:21
professionalZurdoDev26-Apr-17 10:21 
AnswerRe: Force Browser to use updated pdf file instead of cache version Pin
jkirkerx26-Apr-17 12:49
professionaljkirkerx26-Apr-17 12:49 
QuestionRDLC SetPageSettings Pin
D.Manivelan26-Apr-17 4:16
D.Manivelan26-Apr-17 4:16 
QuestionRE-Drop Down List Error Pin
Member 1116162526-Apr-17 2:32
Member 1116162526-Apr-17 2:32 
AnswerRe: RE-Drop Down List Error PinPopular
Jochen Arndt26-Apr-17 2:41
professionalJochen Arndt26-Apr-17 2:41 
GeneralRe: RE-Drop Down List Error Pin
ZurdoDev26-Apr-17 3:22
professionalZurdoDev26-Apr-17 3:22 
AnswerRe: RE-Drop Down List Error Pin
jsc4226-Apr-17 2:52
professionaljsc4226-Apr-17 2:52 
QuestionI want to show data in gridview even if only one dropdown is selected Pin
Member 1314815825-Apr-17 20:05
Member 1314815825-Apr-17 20:05 
My form is working properly but the only problem is the i want to make that the gridview should also visible when i select only one dropdown. The below dropdown is just a one sample of my code.

I have a 4 dropdownlist which are connected with gridview. It is like a if i trigger 1st dropdown i have to select 2,3,4 then only the grid will show related data. I want that if i select only 1 or 1&2 or 1&2&3 then also it should show related data


protected void ddlFormat_SelectedIndexChanged(object sender, EventArgs e)

if (ddlFormat.SelectedIndex != 0)

{

SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet dsDisp = new DataSet();
string lformat = "";
String strConnString = ConfigurationManager.ConnectionStrings["CallcenterConnectionString"].ConnectionString;
if (ddlFormat.SelectedValue.ToString().Trim().ToUpper().Contains("LOYALTY"))
{
lformat = "LOYALTY";
}
else
{
lformat = ddlFormat.SelectedValue.ToString();
}

using (var con = new SqlConnection(strConnString))
{
con.Open();
using (cmd = new SqlCommand("UserManagement", con))
{
cmd.Parameters.Add("@flag", SqlDbType.VarChar).Value = "2";
cmd.Parameters.Add("@CallType", SqlDbType.VarChar).Value = ddlCalltype.SelectedValue.ToString();
cmd.Parameters.Add("@Format", SqlDbType.VarChar).Value = ddlFormat.SelectedItem.Text;
cmd.Parameters.Add("@disposition", SqlDbType.VarChar).Value = ddlDisp.SelectedValue.ToString();
cmd.Parameters.Add("@SubDisposition", SqlDbType.VarChar).Value = ddlSubdisp.SelectedValue.ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
da.SelectCommand = cmd;
da.Fill(dsDisp);
}
con.Close();
}
ddlDisp.DataTextField = "Disposition";
ddlDisp.DataValueField = "Disposition";
ddlDisp.DataSource = dsDisp.Tables[0];
ddlDisp.DataBind();
ddlDisp.Items.Insert(0, "<----Select---->");
ddlDisp.Focus();
}
}
protected void ddlFormat_SelectedIndexChanged(object sender, EventArgs e)
{ if (ddlFormat.SelectedIndex != 0)

{

SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet dsDisp = new DataSet();
string lformat = "";
String strConnString = ConfigurationManager.ConnectionStrings["CallcenterConnectionString"].ConnectionString;
if(ddlFormat.SelectedValue.ToString().Trim().ToUpper().Contains("LOYALTY"))
{
lformat = "LOYALTY";
}
else
{
lformat = ddlFormat.SelectedValue.ToString();
}
using (var con = new SqlConnection(strConnString))
{
con.Open();
using (cmd = new SqlCommand("UserManagement", con))
{
cmd.Parameters.Add("@flag", SqlDbType.VarChar).Value = "2";
cmd.Parameters.Add("@CallType", SqlDbType.VarChar).Value = ddlCalltype.SelectedValue.ToString();
cmd.Parameters.Add("@Format", SqlDbType.VarChar).Value = ddlFormat.SelectedItem.Text;
cmd.Parameters.Add("@disposition", SqlDbType.VarChar).Value = ddlDisp.SelectedValue.ToString();
cmd.Parameters.Add("@SubDisposition", SqlDbType.VarChar).Value = ddlSubdisp.SelectedValue.ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
da.SelectCommand = cmd;
da.Fill(dsDisp);
}
con.Close();
}
ddlDisp.DataTextField = "Disposition";
ddlDisp.DataValueField = "Disposition";

ddlDisp.DataSource = dsDisp.Tables[0];
ddlDisp.DataBind();

ddlDisp.Items.Insert(0, "<----Select---->");
ddlDisp.Focus();
}
} protected void ddlDisp_SelectedIndexChanged(object sender, EventArgs e)

{ try { if (ddlDisp.SelectedIndex != 0)

{

SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet dsSubDisp = new DataSet();

String strConnString = ConfigurationManager.ConnectionStrings["CallcenterConnectionString"].ConnectionString;

using (var con = new SqlConnection(strConnString))
{
con.Open();
using (cmd = new SqlCommand("UserManagement", con))
{
cmd.Parameters.Add("@flag", SqlDbType.VarChar).Value = "3";
cmd.Parameters.Add("@CallType", SqlDbType.VarChar).Value = ddlCalltype.SelectedValue.ToString();
cmd.Parameters.Add("@Format", SqlDbType.VarChar).Value = ddlFormat.SelectedItem.Text;
cmd.Parameters.Add("@disposition", SqlDbType.VarChar).Value = ddlDisp.SelectedValue.ToString();
cmd.Parameters.Add("@SubDisposition", SqlDbType.VarChar).Value = "";

cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
da.SelectCommand = cmd;
da.Fill(dsSubDisp);

}
con.Close();
}

{

ddlSubdisp.DataTextField = "SubDisposition";
ddlSubdisp.DataValueField = "SubDisposition";
ddlSubdisp.DataSource = dsSubDisp.Tables[0];
ddlSubdisp.DataBind();

ddlSubdisp.Items.Insert(0, "<----Select---->");
ddlSubdisp.SelectedIndex = 0;
ddlSubdisp.Focus();

}
}
}
catch (Exception ex)
{ }
} protected void Button2_Click1(object sender, EventArgs e) {

SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();

String strConnString = ConfigurationManager.ConnectionStrings["CallcenterConnectionString"].ConnectionString;

using (var con = new SqlConnection(strConnString))
{
con.Open();
using (cmd = new SqlCommand("UserManagement", con))
{
cmd.Parameters.Add("@flag", SqlDbType.VarChar).Value = "0";
cmd.Parameters.Add("@CallType", SqlDbType.VarChar).Value = ddlCalltype.SelectedValue.ToString();
cmd.Parameters.Add("@Format", SqlDbType.VarChar).Value = ddlFormat.SelectedItem.Text;
cmd.Parameters.Add("@disposition", SqlDbType.VarChar).Value = ddlDisp.SelectedValue.ToString();
cmd.Parameters.Add("@SubDisposition", SqlDbType.VarChar).Value = ddlSubdisp.SelectedValue.ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
da.SelectCommand = cmd;
da.Fill(dt);

}
con.Close();
}
gvDetails.DataSource = dt;
gvDetails.DataBind();
gvDetails.Visible = true;

}

Store procedure

ALTER PROCEDURE [dbo].[UserManagement]
@flag varchar(10),
@CallType varchar(50),
@Format varchar(50),
@disposition varchar(50),
@SubDisposition varchar(50)
AS
begin
if @flag = '0'
begin
Select DISTINCT Disp_id,CallType, Format, Disposition, SUbDisposition from CallCenter..Loy_DispMstr
where isactive='1' and CallType=@CallType and Format=@Format and Disposition = @disposition and SubDisposition =@SubDisposition
end

if @flag = '1'
begin
Select Formatid,Formatdetail,dispformat From loy_Formatdetail with (nolock)
Where isactive='1' and memberstatus = 'Member' order by FormatDetail
end

if @flag = '2'
begin
Select DISTINCT Disposition from CallCenter..Loy_DispMstr
where isactive='1' and CallType=@CallType and SUBFormat=@Format
end

if @flag = '3'
begin
Select distinct CallType,Format,Disposition,SubDisposition from Loy_DispMstr
where isactive='1' and CallType=@CallType and SUBFormat=@Format and Disposition = @disposition
end

if @flag = '4'
begin
select PID,Memberstatus,calltype,format,disposition,subdisposition, man_data,
creation_date,createdby,updation_date,updatedby from Loy_SubPlaceholder
end

end
AnswerRe: I want to show data in gridview even if only one dropdown is selected Pin
User 418025426-Apr-17 4:15
User 418025426-Apr-17 4:15 
QuestionI want to show data in gridview even if only one dropdown is selected..what will be the store procedure Pin
Member 1314815825-Apr-17 2:35
Member 1314815825-Apr-17 2:35 
AnswerRe: I want to show data in gridview even if only one dropdown is selected..what will be the store procedure Pin
User 418025425-Apr-17 2:43
User 418025425-Apr-17 2:43 
GeneralRe: I want to show data in gridview even if only one dropdown is selected..what will be the store procedure Pin
Member 1314815825-Apr-17 19:48
Member 1314815825-Apr-17 19:48 
GeneralRe: I want to show data in gridview even if only one dropdown is selected..what will be the store procedure Pin
User 418025426-Apr-17 4:18
User 418025426-Apr-17 4:18 
QuestionIE 11 giving XML5619: Incorrect document syntax Pin
dpkcp24-Apr-17 0:03
dpkcp24-Apr-17 0:03 
AnswerRe: IE 11 giving XML5619: Incorrect document syntax Pin
User 418025424-Apr-17 3:08
User 418025424-Apr-17 3:08 
QuestionDecide flow/featurs of ASP.NET MVC Project Pin
Member 1266445222-Apr-17 0:57
Member 1266445222-Apr-17 0:57 
AnswerRe: Decide flow/featurs of ASP.NET MVC Project Pin
User 418025422-Apr-17 4:18
User 418025422-Apr-17 4:18 
QuestionError Page , 404, 500 Pin
jkirkerx20-Apr-17 11:00
professionaljkirkerx20-Apr-17 11:00 
AnswerRe: Error Page , 404, 500 [got it to work, not sure if its solved] Pin
jkirkerx20-Apr-17 11:40
professionaljkirkerx20-Apr-17 11:40 
QuestionDevelop a Module in ASP.NET Pin
Muhammad Bilal20-Apr-17 4:08
Muhammad Bilal20-Apr-17 4:08 
AnswerRe: Develop a Module in ASP.NET Pin
User 418025420-Apr-17 14:29
User 418025420-Apr-17 14:29 
AnswerRe: Develop a Module in ASP.NET Pin
John C Rayan21-Apr-17 4:57
professionalJohn C Rayan21-Apr-17 4:57 
QuestionYou have to be inside an Angular CLI project in order to use the serve command Pin
indian14319-Apr-17 14:15
indian14319-Apr-17 14:15 
QuestionC# Data access layer and business logic Pin
sellol19-Apr-17 2:08
sellol19-Apr-17 2:08 
AnswerRe: C# Data access layer and business logic Pin
Richard MacCutchan19-Apr-17 5:43
mveRichard MacCutchan19-Apr-17 5:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.