Hi Frinny,
Thanks for your reply, but sorry it didn't appear to be working.
I got error messages as no SqlDbType and Error 2 Non-invocable member System.Data.Sql Client.SqlComma nd.Parameters' cannot be used like a method.
User Profile
Collapse
-
Add two parameters in SqlParameter
Hi Code Masters,
I am an ASP beginner, I have a stored precodure which accepts two input parameters. In my ASP project, I have a button click event
Code:protected void OnAddClick(object sender, EventArgs e) { string concept = txtConcept.Text; string keyword = txtKeyword.Text; ....... int result = Helper.ConceptInsert(concept,keyword); }
Last edited by jhardman; Oct 14 '10, 05:48 AM. Reason: Accidentally posted in the classic asp forum. I'm moving you to the asp.net forum. -
Hi Oralloy,
I am sorry about the late reply.
I did have the html tag in my test.html.tt file. Anyway, I don't use this module any more. Now I use MIME::Lite instead, and problem solved itself. How strange it that!
I really appreciate your help, many thanks!Leave a comment:
-
Hi Oralloy,
I use
Code:my $raw_message = $msg->as_string; print "$raw_message";
P.S. What module you used to send normal email? I used to have mail:sendmail.Leave a comment:
-
Thanks Oralloy,
I added another text template called test.txt.tt,
Code:Dear [% sender_name %], This is to confirm your order of $ [% amount %] gift voucher from Evergreens Day Spa. Status: unpaid. Thank you! Yours Sincerely Evergreens Day Spa Team
I suppose...Leave a comment:
-
MIME::Lite::TT::HTML, send email twice
Hi Code Masters,
It seems there is not so much documentation around this "MIME::Lite::TT ::HTML" module.
I have a Perl script used to send confirmation emails to customers when they have ordered a gift voucher, part of the script is:
Code:my %params; $params{sender_name} = "$sender_first_name"."$sender_last_name"; $params{amount} = $gift_amount;
-
I really appreciate this, sorry for the laziness this time. I will try to do it myself the next time, thanks.Leave a comment:
-
Is there a way that I can get rid of the Thu to simply display as "28-Oct-2010"?Leave a comment:
-
-
Perl Date Function
Hi Code Masters,
I have a function to calculate current date as
Code:sub currentDate { my @timeParts=localtime; my ($day, $month, $year) = ($timeParts[3],$timeParts[4],$timeParts[5]); return ($month+1)."/".$day."/".($year+1900); }
Many thanks. -
Thanks.
I am using Adobe Acrobat Professional reader, it looks like I can locate the cornidates easily :).Leave a comment:
-
I don't, I am wondering how do I locate the position where to print on the pfd.
Is it using some kind of coordinates?Leave a comment:
-
-
Gift Voucher System
Hi code masters,
I am thinking of doing a gift voucher system where it can print a nice pdf vouchre dynamically.
I have a pdf template for gift voucher. The problem is that, what module can I use to print those scalar values (customer details) onto the pdf and generate a nice gift voucher? How do I locate the area to put the corresponding details?
Thanks in advanced
Eric -
I still don't quite understand.
There might be an easier way that use array to split the character string where it have "\t", then use loops or nested loops to get the value in the location column, and put back into an new string variable, put it into an array and sort the array.
I assume that all the codes are the same till myArray = bigString.Split ('\t');
But I am not sure how to get the value from the location column,...Leave a comment:
-
How
Thanks very much, I appreciate it. But how can I read file into DataTable and bind read file into ListBox?Leave a comment:
-
How to sort a list box?
Hello everyone. I am a C# learner. I am having troubles doing my first program.
Part of the function is to sort a list box contain client details.
For instance:
One typical line of the contactListBox is:
Surname Firstname Firstmeetingdat e Location Phone
I have work out the "sort by surname" button, it is simple to loop through the...Leave a comment:
-
Thanks very much!! It solves me a big question. But what if I need to sort by the location in each line? the location is a Combo box called locationComboBo x. Where should I put the syntax and what code should I put?
Many thanks...Leave a comment:
-
How to sort a listBox not by the first letter?
Hi, I am having trouble sorting a client contact lists by their surname. Every time when I press the "sort by surname button, it always appear alphabetical order
by clients' first name, because I put them before the surname, it is the first String of the every line in the listBox.
My code under the sortBySurname is
Code:private void sortBySButton_Click(object sender, EventArgs e) { contactListBox.Items.Clear();
-
Hi, I have try
private void dateTimePicker_ ValueChanged(ob ject sender, EventArgs e)
{
DateTime fistMeetingDate = dateTimePicker. Value;
DateTime currentDate = DateTime.Now;
TimeSpan duration= currentDate - fistMeetingDate ;
durationTextBox .Text = duration.ToStri ng();
}
But it appear a very strange String, for instance, today is "Tuesday,...Leave a comment:
No activity results to display
Show More
Leave a comment: