ASP.NET Discussion Boards

how to send mail using sql triggers

Shaik Haneef12-Mar-08 6:18

Shaik Haneef

12-Mar-08 6:18

how to send mail using sql triggers

This is haneef.............................................................

Re: how to send mail using sql triggers

Parwej Ahamad12-Mar-08 6:35

Parwej Ahamad

12-Mar-08 6:35

Go throught xp_sendmail extended stored procedure.

You can do it another way, create CLR stored procedure and you can use it in Triggers.

Haneef, I did not do more R & D with above said idea, so before going to implementation go through google for more infomation.

If you find any issues then let me know.

Parwej Ahamad
g.parwez@gmail.com

Re: how to send mail using sql triggers

Not Active12-Mar-08 6:53

Not Active

12-Mar-08 6:53

First step is to pick the correct forum. Mad | :mad:

This is a SQL question, use the SQL forum

only two letters away from being an asset

This Validation Expression will work in firefox but not ie. How do I get it to work in IE? [modified]

Ali Chaudhry12-Mar-08 5:35

Ali Chaudhry

12-Mar-08 5:35

I have a RequiredFieldValidator on a fileupload control that tests for a filename ending in 'daily.txt' or 'Daily.txt' or 'DAILY.TXT' or any other similar mixed upper/lowercase format of the filename 'daily.txt'. The validation expression I created is as follows:

ValidationExpression="[Dd][Aa][Ii][Ll][Yy]\.[Tt][Xx][Tt]$"

This tests out perfect in the many online regex validators. It even works in Firefox, but for some reason, IE won't validate a match. Is there something wrong with the validation expression with respect to how IE handles it?

The full markup for the fileupload is as below:

<asp:fileupload id="FileUploadImport" runat="server" />
<asp:button id="btnUpload" runat="server" text="Upload" validationgroup="ImportUpload" />
<asp:requiredfieldvalidator
  ID="rfvFileUploadImport" 
  Display="Dynamic" 
  ControlToValidate="FileUploadImport" 
  SetFocusOnError="true" 
  Text="Please select Import File." 
  ValidationGroup="ImportUpload" 
  runat="server" />
<asp:regularexpressionvalidator
  id="revFileUploadImport" 
  ControlToValidate="FileUploadImport" 
  SetFocusOnError="true" 
  ErrorMessage="Please select the location for the 'daily.txt' file" 
  ValidationExpression="[Dd][Aa][Ii][Ll][Yy]\.[Tt][Xx][Tt]$"
  ValidationGroup="ImportUploadr" runat="server" />

Please Help. I am using both IE 7 and IE 6

-Ali

modified on Wednesday, March 12, 2008 12:19 PM

Re: This Validation Expression will work in firefox but not ie. How do I get it to work in IE?

Muhammad Gouda12-Mar-08 5:42

Muhammad Gouda

12-Mar-08 5:42

Which version of IE do you use?

M. Gouda
foreach(Minute m in MyLife)
{
myExperience++;
}

Re: This Validation Expression will work in firefox but not ie. How do I get it to work in IE?

Ali Chaudhry12-Mar-08 5:45

Ali Chaudhry

12-Mar-08 5:45

IE 7

I also tested in IE 6 for kicks

Re: Use your own code to validate

Muhammad Gouda12-Mar-08 6:15

Muhammad Gouda

12-Mar-08 6:15

Really, I am not so familiar with Regular Expressions
If I faced such a problem, I would write my own validator

You can use

String.Compare(firstString,secondString,true);

where firstString will carry the last 9 characters of the file name
And secondString will carry the word "daily.txt"
And true means to ignore the case

M. Gouda
foreach(Minute m in MyLife)
{
myExperience++;
}

email error

solarthur0112-Mar-08 4:55

solarthur01

12-Mar-08 4:55

does anyone know how to enable STARTTLS in the mailsetting of the web.config file in asp.net. I keep getting the following error: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first e33sm3474460ugd.80.

Been stuck on this for days can anyone help??
cheers!!

picking subject from mail

Azi Qaiser12-Mar-08 4:38

Azi Qaiser

12-Mar-08 4:38

Hi All,

I have an ASP application which is sending out mails (an html page) with mailto link in it. But the subject line fo this mail is dynamically created.

I want that when someone clicks on mailto link in mail sent by the application to them, it should open a reply window with same subject and body defaulting the address, exactly like when you reply to mails in outlook with the same subject line prefixing Re: and containing the body of the recevied mail.

I hope i am clear enough.

Appreciate your help.

Its a bit urgent too guys.

Thanks.

Re: picking subject from mail

Justin Perez12-Mar-08 5:28

Justin Perez

12-Mar-08 5:28

Azi Qaiser wrote:
Its a bit urgent too guys.

Well let me drop everything I'm doing, and give you the shirt off my back. Would you like me to grill you a steak as well?

I'm going to become rich when I create a device that allows me to punch people in the face over the internet.

"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer

Re: picking subject from mail

eyeseetee12-Mar-08 5:33

eyeseetee

12-Mar-08 5:33

i'm sure there is some sort of irony with him wanting it urgent and the subject being an e-mail

Re: picking subject from mail

James J. Foster12-Mar-08 5:41

James J. Foster

12-Mar-08 5:41

So, if I understand it correctly, you want to programmatically trigger a "reply" action in the user's email client. Is this for an intranet scenario, where you can limit the number of email clients supported, or are you looking for this functionality regardless of what email client a user has?

Re: picking subject from mail

Christian Graus12-Mar-08 17:35

Christian Graus

12-Mar-08 17:35

Apparently it's not urgent enough to answer you. Or he didn't understand you. Or he copied and pasted your reply and it would not compile

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

RadioButtonList won't show

thomasa12-Mar-08 3:40

thomasa

12-Mar-08 3:40

Hey.

I have a anthem:PlaceHolder inside a asp:Repeater that contains an asp:RadioButtonList
something like

<br />
<asp:repeater id="rp" runat="server" gt;<br="" mode="hold" />HeaderTemplate&gt table&gt;&lt;/HeaderTemplate<br />
ItemTemplate&gt;<br />
td><anthem:ImageButton id="ibPt" runat="server"></anthem:ImageButton><br />
<anthem:PlaceHolder id="phPt" runat="server"><br />
<asp:Literal ID="liPt" Runat="server"></asp:Literal><br />
<asp:RadioButtonList ID="rblPt" Runat="server" Visible="False"></asp:RadioButtonList><br />
</anthem:PlaceHolder></td

And I have added a click event on my anthem:ImageButton that shall fill the RadioButtonList with items and make it Visible="true"
something like

private void OnPt(object sender, ImageClickEventArgs e)<br />
        {<br />
            MiBlo.Product bloProduct = null;<br />
            Anthem.ImageButton aibtnPartType = (Anthem.ImageButton)sender;<br />
            try <br />
            {   <br />
System.Web.UI.WebControls.RepeaterItem riSL = (System.Web.UI.WebControls.RepeaterItem)aibtnPartType.Parent;<br />
<br />
                int lngProductID = int.Parse(aibtnPartType.CommandName);<br />
                int lngCatalogID = int.Parse(aibtnPartType.CommandArgument);<br />
<br />
                bloProduct = new MiBlo.Product();<br />
<br />
                DataView dvProductPartTypes = bloProduct.GetProductPartTypes(lngProductID, lngCatalogID);<br />
<br />
                aibtnPartType.UpdateAfterCallBack = true;<br />
                aibtnPartType.Visible = false;<br />
<br />
                Anthem.PlaceHolder phPt = (Anthem.PlaceHolder)riSL.FindControl("phPt"); <br />
                Literal liPt = (Literal)phPt.FindControl("liPt");<br />
                liPt.Text = "";<br />
                liPt.Visible = false;<br />
<br />
                RadioButtonList rblPt = (RadioButtonList)phPt.FindControl("rblPt");<br />
                rblPt.Visible = true;<br />
                rblPt.RepeatColumns = 1;<br />
                <br />
                <br />
                for(int i = 0; i &lt; dvProductPartTypes.Count; i++)<br />
                {<br />
                    RadioButton rb = new RadioButton();<br />
                    rb.Text = dvProductPartTypes[i]["dblNumberInUnit"].ToString();<br />
                    rb.GroupName = "rblPt";                   <br />
                                        <br />
                    rblPt.Controls.Add(rb);<br />
                }<br />
<br />
                phPt.UpdateAfterCallBack = true;<br />
            }<br />
            catch (Exception err) <br />
            {<br />
                lblMessage.Text += err.Message;<br />
            }<br />
        }

It enters the code and everything seems OK, but it won't show. I tryed just to set the Literal liPt.Text = "Test" and not setting it
to liPt.Visible = false and that is shown correctly.

But I have no idea why the RadioButtonList won't show.
I have allso tried an anthem:RadioButtonList insted of an asp:RadioButtonList inside an anthem:PlaceHolder but it gave the same
result.

Anyone know the RadioButtonList won't show?
Thanks
Thomas

Re: RadioButtonList won't show solution

thomasa12-Mar-08 4:09

thomasa

12-Mar-08 4:09

It's not RadioButton one should add, but ListItems
as in:

for(int i = 0; i < dvProductPartTypes.Count; i++)<br />
                {<br />
                    ListItem li = new ListItem();<br />
                    li.Text = dvProductPartTypes[i]["dblNumberInUnit"].ToString();<br />
rblPt.Items.Add(li);<br />
                }

Connection to database

John.L.Ponratnam12-Mar-08 3:23

John.L.Ponratnam

12-Mar-08 3:23

How do we connect to a database from .aspx page?

Regards,
LEE

Re: Connection to database

J a a n s12-Mar-08 3:26

J a a n s

12-Mar-08 3:26

There are thousands of articles in the web including codeproject.
Use Goole[^] to find it.

*jaans

Re: Connection to database

eyeseetee12-Mar-08 3:33

eyeseetee

12-Mar-08 3:33

http://aspnet.4guysfromrolla.com/articles/032702-1.aspx

http://msdn2.microsoft.com/en-us/library/ms178371.aspx

check these out

loop for textboxes

eyeseetee12-Mar-08 1:45

eyeseetee

12-Mar-08 1:45

Hi
I have 20 different textboxes on a page
I need to make them all disabled.
IS there a way I can do this e.g. in a loop rather then writing out each textbox in the c# code?

thanks inadvance! Smile | :)

Re: loop for textboxes

N a v a n e e t h12-Mar-08 1:47

N a v a n e e t h

12-Mar-08 1:47

Iterate through the Page.Controls collection, check whether the control is a textbox, if yes set Enabled=false.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: loop for textboxes

eyeseetee12-Mar-08 1:58

eyeseetee

12-Mar-08 1:58

thanks for the reply

I have this so far

for (int x = 0; x < Page.Controls.Count; x++)
{
if (Page.Controls
}

How would I check if the control is a button and then set enable to false

would it be something like

Page.controls.Button.Enabled = false?

thanks!!

Re: loop for textboxes

N a v a n e e t h12-Mar-08 2:07

N a v a n e e t h

12-Mar-08 2:07

foreach (Control c in Page.Controls)
{
   if(c is TextBox)
     c.Enabled = false;
}

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: loop for textboxes

eyeseetee12-Mar-08 2:16

eyeseetee

12-Mar-08 2:16

Hi
it says attrivute enabled is not recognised, I can make it invisible but not disabled
what would be the reason for this?

thanks so far! Smile | :)

Re: loop for textboxes

N a v a n e e t h12-Mar-08 2:34

N a v a n e e t h

12-Mar-08 2:34

Try this

foreach (Control c in form1.Controls)
{
    if (c is TextBox)
        (c as TextBox).Enabled = false;
}

where form1 is your form name.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: loop for textboxes

eyeseetee12-Mar-08 3:11

eyeseetee

12-Mar-08 3:11

Hi
The syntax built this time but none of the textboxes are disabled.
Am I missing something?

thanks

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