|
You can do it with adding these controls to asp:TemplateField where do you stuck on this?
modified 20-Sep-20 21:01pm.
|
|
|
|
|
Hey Guys,
I have run into a small problem, we have sent a bulk email containing a link to a pdf file, a week after the bulk mail the pdf file had to be updated. My problem now is some of the recipients still viewing the cache version of the pdf, is there a way to force the browser to view the updated pdf file?
|
|
|
|
|
Probably like an image file, in which you attach a query string with the date after the file name.
name.pdf?ts=2017042601
If it ain't broke don't fix it
|
|
|
|
|
The problem is that the emails have already been sent so won't be able to add a query string.
|
|
|
|
|
Have the users clear their cache.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Maybe the web server is caching the pdf
If it ain't broke don't fix it
|
|
|
|
|
Hi,
Am using VS2008 Asp.net C#. I used Report.rdlc. I want to set A4size but 'SetPageSettings' function not enabled. It show error 'Does not contain a definition for SetPageSettings'
Below code i used
GlobalCS.sTraineeQry = sTrainQry1 + sTrainQry2 + sTrainQry3 + sTrainQry4 + sTrainQry5 + sTrainQry6 + sTrainQry7 + sTrainQry8 + sTrainQry9;
//set Processing Mode of Report as Local
ReportViewer1.ProcessingMode = ProcessingMode.Local;
//set path of the Local report
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Session_RDLC.rdlc");
dsSession dsSes = GetData(GlobalCS.sTraineeQry);//new dsSession();
//ReportDataSource reportDataSource = new ReportDataSource();
//reportDataSource.Name = "dsSession_DataTable1";
//reportDataSource.Value = dsSes.Tables[0];
ReportDataSource reportDataSource = new ReportDataSource("dsSession_DataTable1", dsSes.Tables[0]);
//ReportViewer1.LocalReport.DataSources.Clear();
System.Drawing.Printing.PageSettings ps = new System.Drawing.Printing.PageSettings();
ps.Landscape = true;
ps.PaperSize = new System.Drawing.Printing.PaperSize("A4", 827, 1170);
ps.PaperSize.RawKind = (int)System.Drawing.Printing.PaperKind.A4;
ReportViewer1.SetPageSettings(ps);
|
|
|
|
|
HI,
I am getting the following Errors,while inserting drop down list values in sql server database
ERROR:
Server Error in '/Online_Book_Shopping' Application.
Procedure or function 'spRegisteruser' expects parameter '@countryname', which was not supplied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Procedure or function 'spRegisteruser' expects parameter '@countryname', which was not supplied.
Source Error:
Line 60: cmd.Parameters.Add(password);
Line 61: con.Open();
Line 62: int i= cmd.ExecuteNonQuery();
Line 63: con.Close();
Line 64: }
Source File: e:\Vijaya\Online_Book_Shopping\SignUp.aspx.cs Line: 62
How to solve this???Please Help???
This is my code:
aspx.cs:-
protected void btnn_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["CS"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
SqlCommand cmd = new SqlCommand("spRegisteruser", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter name = new SqlParameter("@name", txtusername.Text);
SqlParameter mobile = new SqlParameter("@mobile", txtmobilenumber.Text);
SqlParameter password = new SqlParameter("@password", txtpassword.Text);
SqlParameter dropdown = new SqlParameter("@country",DropDownList1.SelectedItem.Value);
cmd.Parameters.Add(name);
cmd.Parameters.Add(dropdown);
cmd.Parameters.Add(mobile);
cmd.Parameters.Add(password);
con.Open();
int i= cmd.ExecuteNonQuery();
con.Close();
}
Sql table:-
Create Table dbo.RegisteredUsers
(
ID int identity Primary Key,
Name nvarchar(20),
Country_Name nvarchar(30),
Mobile_No bigint,
[Password] nvarchar(20)
)
Go
This is storedprocedure:-
Alter Proc spRegisteruser
@Name nvarchar(20),
@countryname nvarchar(30),
@mobile bigint,
@password nvarchar(20)
As
Begin
Insert dbo.RegisteredUsers Values(@Name,@countryname,@mobile,@password)
End
Web.config:-
<connectionstrings>
<add name="CS" connectionstring="Server=.;Initial Catalog=Sample;Integrated Security=True;">
|
|
|
|
|
The error:
Procedure or function 'spRegisteruser' expects parameter '@countryname', which was not supplied. Your code:
SqlParameter dropdown = new SqlParameter("@country",DropDownList1.SelectedItem.Value);
Did you see it now?
You have set a parameter named @country instead of @countryname .
|
|
|
|
|
Incredible when the error message tells you exactly what the problem is.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
It looks like you have misnamed a parameter. I guess that
Member 11161625 wrote: SqlParameter dropdown = new SqlParameter("@country",DropDownList1.SelectedItem.Value);
should be
Member 11161625 wrote: SqlParameter dropdown = new SqlParameter("@countryname",DropDownList1.SelectedItem.Value);
so that the parameter name in the Parameters collection matches the parameter name in the Stored Procedure.
|
|
|
|
|
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
|
|
|
|
|
Do not repost questions. You have the same question raised exactly below this.
modified 20-Sep-20 21:01pm.
|
|
|
|
|
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.
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 SUBFormat=@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
|
|
|
|
|
You have not given enough details of your problem.
But if I get it correctly you want to remove cascading dropdown behavior to display data in grid view, if yes then you can implement the drop down change event to display the data for each of them.
Whenever you have SelectedIndexChange event fired you can check the currently selected dropdown controls and prepare the data to bind to your grid control.
modified 20-Sep-20 21:01pm.
|
|
|
|
|
yes you are right...actually i dnt want to remove anything but its that i want to add on more feature which is that....on every dropdown selection it should show the data in gridview
|
|
|
|
|
So you may add a method to bind the data to grid view and make it visible.
Call this method on each SelectedIndexChange event and apply whatever business logic you have on selection change of current dropdown control and bind necessary data to your grid.
modified 20-Sep-20 21:01pm.
|
|
|
|
|
Hi I am using IE11, when my page runs it throws the error like below..please suggest..It runs fine in other broswers..
IE 11 giving XML5619: Incorrect document syntax
|
|
|
|
|
Set the content-type of you're request to text/xml and try.
modified 20-Sep-20 21:01pm.
|
|
|
|
|
Hi Friends,
I need your help.
Recently i got assignment to work on MVC based project.
Now i am well familiar with Traditional ASP.NET Web Forms & how it works..but not that much with MVC. So i need your general/overall guidance.
Consider a situation that i need to build internet based site wherein
a- Customer fills-in Registration page
b- Later when Admin logs-in the site, Admin can see List of Pending requests in the grid.
consider having columns like FirstName, LastName, Address, City, State in the Grid. First column in grid will have Image-with-Hyperlink
c If admin clicks on any record, again Registration page will open, admin can see details filled-in by user. Here admin can perform any of below 3 activities.
c1- Admin can modify any of these details & add few notes/comments, via Submit-Button.
c2- Admin can Approve request, via Submit-Button.
c3- Admin can Reject request, via Submit-Button.
After performing any of 3 above action, screen will go back to Pending-Request-Grid.
Approved/Rejected User will Not be shown in this grid.
d- Now Approved User will get shown into another grid call Manager Users.
Manage-User-Grid will have same info as Pending-Request-Grid, but here Image-Hyperlink will allow admin to disable a user Or will allow Edit user info.
Now considering above situation, i tried started developing MVC 5 based Web Application Project but i see that lot of features are coming into picture e.g. Partial-View, ViewModel, Entity Framework, Linq.
So it happens that, to complete Task-A, i implement one feature e.g. LINQ and after sometime, to complete Task-B, i got another article which show using Entity Framework. So again i need to create Few Classes, Delete Few Classes, Delete some code...
This kind of thigns takes more time & lot of times...working things get stopped.
I want to use below features in this project:
Entity Framekwork, Partial View, Strogly Typed View, Stored Procedure base Data Read/Modify
So what i want from you:
Q-1- Can you please tell me, which task to do 1st, so i can implement above fetures ?
Q-2 Also there are pages which has 2 List boxes. Means 2 Tables data need to be retrieved & displayed. So what is good method to display Multiple Tables data in the view, in current situation.
Note: This is small internet based site, but not having too much traffic. Also there is no Mobile-App reading this data.
So can you guys please help me...!!!
Any thoughts/article/video/link are welcome...!!!
Thanks
Devsql
|
|
|
|
|
I believe you are getting confused in MVC probably it's new for you so you are ending up rewriting a lot of code as you mentioned here. I will suggest to spend some time on MVC first so you will get a better idea and to code further. There is no special pattern for each of page you mention but you have to choose which is best suite you.
modified 20-Sep-20 21:01pm.
|
|
|
|
|
I thought I had this worked out in my main project, then I created a lite version of the project.
I can't figure out how to get my error handler page to work.
What works
Exception Pages when a page fails, I get the Exception message.
What doesn't work
when I have the URL up say Home, and I type in /Home/jllk;lk;lk;l junk, I expect to get the /Error/Page404 or /Error/Page500
What happens
I get a blank page with nothing.
What I have going
Web Config - This was suppose to handle page not found.
<customErrors mode="On">
<error statusCode="404" redirect="~/Error/Page404" />
<error statusCode="500" redirect="~/Error/Page500" />
</customErrors>
So this runs in Global.asax
void Application_Error(object sender, EventArgs e)
{
if (HttpContext.Current.IsDebuggingEnabled)
{
HttpException httpException = new HttpException();
RouteData routeData = new RouteData();
string controller = Request.RequestContext.RouteData.Values["controller"].ToString();
string action = Request.RequestContext.RouteData.Values["action"].ToString();
Response.Clear();
Server.ClearError();
if (controller != null)
routeData.Values.Add("controller", controller);
else
routeData.Values.Add("controller", "Error");
if (IsAjaxRequest())
{
Response.Write("Your JSON here");
}
else
{
if (httpException != null)
{
int httpCode = httpException.GetHttpCode();
switch (httpCode)
{
case 500:
Response.StatusCode = 404;
Response.ContentType = "text/html";
routeData.Values.Add("action", "Page500");
Server.ClearError();
break;
case 404:
Response.StatusCode = 404;
Response.ContentType = "text/html";
routeData.Values.Add("action", "Page404");
Server.ClearError();
break;
default:
Response.StatusCode = 404;
Response.ContentType = "text/html";
routeData.Values.Add("action", "Page404");
Server.ClearError();
break;
}
IController errorController = new coastEnviromental.Controllers.ErrorController();
try
{
Response.TrySkipIisCustomErrors = true;
errorController.Execute(new RequestContext(new HttpContextWrapper(Context), routeData));
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
Response.Redirect("Error");
}
}
}
}
}
Then the controller fires
public class ErrorController : Controller
{
public ActionResult Index()
{
return View();
return View("Page404", "Error");
}
public ActionResult Page404()
{
return View();
}
public ActionResult Page500()
{
return View();
}
}
And I get a blank page.
I tried setting a break point on the View, but It never hits.
If it ain't broke don't fix it
|
|
|
|
|
After Easter egg hunting for an hour, I added the string error to the ActionResult and now the View Renders
hmm.........
public class ErrorController : Controller
{
public ActionResult Index(string error)
{
return View();
}
public ActionResult Page404(string error)
{
return View("Page404");
}
public ActionResult Page500(string error)
{
return View("Page500");
}
}
If it ain't broke don't fix it
|
|
|
|
|
Hi Dear,
I'm Muhammad Bilal i want to develop Inventory module in Asp.NET. So please help me how i will start this module by using ASP.NET in MVC framework
|
|
|
|
|
So where do you stuck?
modified 20-Sep-20 21:01pm.
|
|
|
|
|