|
Hi Richard,
As always, thank you so much.
You are right about the EnableSSL. It should have been set to True.
About adding those values to config file, I have two questions.
1, you said I wouldn't need ton configure smtpclient instance,
What should it look like completely?
2, Our goal is to present user with three options, to send email using gmail, or outlook or yahoo.
I am not sure why they are doing this but if I add the smtpClient instance in config file, how do I handle the other two?
Hope I am making some sense.
|
|
|
|
|
samflex wrote: What should it look like completely?
Exactly as I posted in my previous message. The default constructor for the SmtpClient picks up the settings from the config file, so you don't need to set anything in your code.
samflex wrote: Our goal is to present user with three options, to send email using gmail, or outlook or yahoo.
In that case, the <mailSettings> element won't work. There isn't an option to load different sets of settings in different scenarios.
I'd still recommend putting the settings in the config file, so that you don't have to recompile your code if they change. But you'll need to store them differently, possibly using a custom configuration section.
How to: Create Custom Configuration Sections Using ConfigurationSection[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I made a slight change which seems to work.
I changed <system.web>...
to
<system.net>...
and then moved
<compilation debug="true" targetFramework="4.0"/>
to <system.web>...
<pre>
<system.web>
<compilation debug="true" targetframework="4.0">
Thanks for all your help as usual.
|
|
|
|
|
Sorry sir, I got pulled away from this for a moment.
Happens all the time!
Anyway, I keep getting this error:
recognized configuration section system.web/mailSettings
after adding this to the config file - exactly as you have it.
|
|
|
|
|
samflex wrote: system.web/mailSettings
samflex wrote: exactly as you have it.
Are you sure about that? Read my message again - it's <system.net>, not <system.web>. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I have a div which is misbehaving badly. It seems that some very long text entered into this "tableItem" is causing the icon within the div to be pushed down to the next line. How do I stop this maddening behavior?
<pre>
<div style="max-height: 175px; overflow-y: auto; width: auto;">
<table id="tblSelectedItem" runat="server">
<tbody>
<tr>
<td>
<div class='itemStyle'>
<div style='float: left; border: 0; min-width: 245px;'> </div>
<div style='display: inline-block; float: left; border: 0;'>
<img src="~/Images/search.png" id="imgSearch" alt="Select Items" runat="server" class="SearchIconStyle" />
</div>
</div>
</td>
</tr>
<tr>
</tr>
</tbody>
</table>
</div>
.itemStyle {
border: 1px solid #cccccc;
border-radius: 6px;
display: inline-block;
padding: 3px 3px 3px 3px;
white-space: nowrap;
margin: 0;
height: 20px;
}
.SearchIconStyle {
cursor: pointer;
margin-top: 2px;
margin-right: 2px;
}
modified 3-May-17 18:20pm.
|
|
|
|
|
Which table item are you referring to ? I can't see any text in your table item.
|
|
|
|
|
I attempted to add an image, but I do not believe I was able to do that. The text gets put into the div via the code-behind, and could be anything, since it is data that comes from a database.
At any rate, I believe we have solved this issue, or come very close to solving it. For one, I believe we put in a break "
", which appears to have helped. Also, I think a good bit of the supporting JavaScript had to be modified.
Thanks all for your assistance. Have a great weekend!!
|
|
|
|
|
|
Hello,
I am looking for the suggestion to create a datagrid in ASP.NET with column value as CHECKBOX and Radio button as shown below.
Please suggest me how to implement it.
|
|
|
|
|
You have not shown anything.
Secondly, what prevents you from implementing it? Also, please set the data binding to the current data source, and DataGrid will automatically map the types of the columns to possible types. RadioButton, or CheckBox are two different types and have a different purpose. Show your data, sample input means and the table you have.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
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
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
