|
hmm..
Since the agendaitem is populated at the time of datarowbound of Agenda, u can identify the row for inneragenda when the link button is clicked. U can then use the same relation as at the time of binding data to delete the data from the database and then rebind the two gridviews.
I know this can be resource extensive if u have several clicks per user as per ur application . Can't think of anything else. Let's see other suggestions.
|
|
|
|
|
I want to have some information regarding sending password to the mailId given in the textBox .
The code is made as follows:
I have made login form in which there is button "Forgot Password". After
clicking on it, there'll display a forgot password form in which u have to enter your email to get to know the password.
Asp.Net code:
SqlConnection conn;
btn_forgor_password_submit(sender object, EventArgs e)
{
SqlConnection conn;
string q = "select password from login where email='" + TextBox1.Text + "'";
conn = new SqlConnection("data source=.\\sqlexpress;integrated security=true;initial catalog=master");
cn.Open();
cmd = new SqlCommand(q, cn);
MailMessage mail = new MailMessage();
mail.To = TextBox1.Text;
mail.From = "hradmin@abc.com";
mail.Body = "ur pass is:" +cmd.ExecuteScalar().ToString();
SmtpMail.SmtpServer = "mail.abc.com";
SmtpMail.Send(mail);
Label1.Text = "mail has been sent";
cn.Close();
cmd.Dispose();
}
in the above code there is error "The server response was: 550 5.7.1 Unable to relay for emaiid@domain.com" . Also, there is warning while debugging the code "system.web.Mail.MailMessage is obsolete".
plz help me how we can get password and send automatically from the database to the emailId given in the textBox named "TextBox1.Text".
|
|
|
|
|
First, the obsolete message helps you to find the 'newer' version of MailMessage. The relaying message may be cause by the use of email addresses that don't exist, or the SMTP server refuses the 'relay' your mail. Find a SMTP server which helps you out.
Than a coding tip! Try avoiding the cmd.ExecuteScalar().ToString() !
Is the executescalar returns null, the tostring fill fail and cause an exception..
The following code should help you out
object oPassword = cmd.ExecuteScalar();
string sPassword = (oPassword == null) ? "Not found" : oPassword.ToString();
|
|
|
|
|
i'm asking how to get password using emailid given in the textbox..
other things are alright
|
|
|
|
|
Make sure the MailMessage.From is a valid email address that exists on the SmtpMail.SmtpServer.
Replace it with your own emailid to check if it works.
Allow relaying for your MailMessage.From address
Allow relaying for your IP Address
(I recommend that u see your specific mail server documentation for this or contact ur administrator).
FemDev
Don't forget to vote if you like answer
|
|
|
|
|
Hi all,
i find so many expert here so that is why i m posting my question here i would like abt LINQ.Is it going to come in demand in future i want suggestion from u guys.I know basics of it should i explore this and will this be help ful for my future.
Thanks and regards,
Amit Patel
|
|
|
|
|
Erhm, yes and yes....
LINQ will be quite helpfull if you use collections (no matter what collections) and will increase both performance of your software, and the time it takes to develop your software.
|
|
|
|
|
Why do you expect others to worry about your career? Please post only relevant technical questions here. For other things, use The Lounge.
|
|
|
|
|
Hello, Im tryin to build some search engin using asp.net/C# and can't find any article. i have table in SQL DB with customers and want to create search engine with 3 parameters (name, state, city) is anyone know good article or had a solution for that?
|
|
|
|
|
you're talking about basic SQL here. Do you own any books on SQL ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Yes, i have some books but none of them explain how to build search engine....if you talk about the select parameters, i think i know what to write
ALTER PROCEDURE dbo.advancedSearching
@indexKindword varchar(250) = NULL,
@indexKindword2 varchar(250) = NULL,
@indexKindword3 varchar(250) = NULL
AS
BEGIN
SELECT [companiesIndex].indexCatID, [companiesIndex].compantName, [companiesIndex].companyAddress, [companiesIndex].companyState, [companiesIndex].companyCity, [companiesIndex].companyPhone, [companiesIndex].companyFax, [companiesIndex].companyWebsite, [companiesIndex].keyWords
FROM companiesIndex
WHERE ([companiesIndex].cat LIKE '%' + @indexKindword + '%' OR [companiesIndex].cat IS NULL
AND [companiesIndex].companyState LIKE '%' + @indexKindword2 + '%' OR [companiesIndex].companyState IS NULL
AND [companiesIndex].companyCity LIKE '%' + @indexKindword3 + '%' OR [companiesIndex].companyCity IS NULL)
ORDER BY [compantName]
END
RETURN
but i dont know how to handle the results in the aspx.cs page (i know how to handle one parameter search)
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["searchString"] != null)
{
DisplaySearchResults(Request.QueryString["searchString"]);
Label50.Text = Repeater1.Items.Count.ToString();
}
}
public void DisplaySearchResults(string strSearch)
{
SqlConnection newconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ASPNETDBConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("spSearchByString", newconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SearchString", strSearch);
newconn.Open();
Repeater1.DataSource = cmd.ExecuteReader();
Repeater1.DataBind();
newconn.Close();
newconn.Dispose();
}
How you translate this page to get 3 parameters?
|
|
|
|
|
I have already written one this month. Just have a look..
See the signature below to find it.
|
|
|
|
|
Ohh... you might be asking for how to search using SQL ??
is this is so, read basic books on SQL.
Let me give you one instance on how the query look like:
Say you want to search name, state and city based on variables. If variables doesnt have value, your search doesnt need to hamper. Do like this :
SELECT * FROM TABLE
WHERE (CASE WHEN ISNULL(@P_NAME,'') = '' THEN '' ELSE NAME END)= ISNULL(@P_NAME,'')
AND (CASE WHEN ISNULL(@P_CITY,'') = '' THEN '' ELSE CITY END)= ISNULL(@P_CITY,'')
AND (CASE WHEN ISNULL(@P_STATE,'') = '' THEN '' ELSE STATE END)= ISNULL(@P_STATE,'')
Note : It could be optimized.
Thus if you ask
@P_Name = 'xxx'
@P_CITY = NULL
@P_STATE = 'yyyy'
It will not consider @P_CITY as search criteria..
Hopefully this gives you an idea.
|
|
|
|
|
Crystal Reports problem in .Net 2.0 showing blank pages after few hours
problem always resolve after restarting IIS
Please note that many users access application at a time.
please suggest any permanent solution
|
|
|
|
|
hammadahsan wrote: problem always resolve after restarting IIS
Why Would you do tht..!IIS should run at background..!If You restart the IIS..!i.e. you a re restarting the application..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Because this is the only way to fix this problem.
|
|
|
|
|
I think the problem might be with memory.
Try to see what you are placing into Session or application when you call the Crystal Report. I think the memory is not cleared properly when reports are opened.. and thus killing the solution..
You can also use Separate Application pool area rather than using the shared one to ensure have more memory.
But you should really look into the memory management for your solution.
|
|
|
|
|
Either your application is getting killed or your database (or both). Your solution does not scale up properly to accommodate more simultaneous users. To find out a "permanent" solution, you need to first find out where the problem is and what the problem is.
|
|
|
|
|
Good Day All
I have a ASP.NET app. There is a button one of the pages. I have placed a Break point in the Click event and when i click the Button it does not even go to the Break Point it shows this
http://www.tiyaneproperties.co.za/SSIS/Strange.jpg[^]
Thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Is the URL shown correct ? Are you connected to the web ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Good Day
The URL is Correct. When the Button is Clicked this will import the xml File. This works in other Browsers. yes am Connected to web.
Thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Import an XML file from where ? Have you put a breakpoint in page load to see if any of your code is run ? What if you refresh the page when it fails ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
When the Page load the the Break point works and when i click the Button, it gave that strange page. When i refresh the page, it goes back.
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
That is the First thing i did when i got this problem. I have resolved the Problems. The File that i wanted to import when that button is Clicked was too big. So i have resolved this by adding the Following entry in the web config in the System.web Section
< httpRuntime maxRequestLength="102400" />
Thanks once more time
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Are you submitting the page to a location using form action
or have you manually modified your form onsubmit event ?
|
|
|
|