|
Couple of ways.
1) Create the param first
SqlParameter pressJobOrderParam = new SqlParameter("@Param2", SqlDbType.NVarChar, 18, "Press_job_order");<br />
pressJobOrderParam.Value = 123;<br />
this.sqlSelectCommand1.Parameters.Add(pressJobOrderParam);
2) Add the param, as you did, then refer to it by name.
this.sqlSelectCommand1.Parameters.Add(new SqlParameter("@Param2", SqlDbType.NVarChar, 18, "Press_job_order"));<br />
this.sqlSelectCommand1.Parameters["@Param2"].Value = 123;
|
|
|
|
|
Thanks for Help?
Do you have any idea about crystal report field hide and show. And date format in crystal i select date field from sql database i need to store date in dd/MMMM/yyyy format and also show in crystal report in this format. Any Idea?
....Thank again.
|
|
|
|
|
if "myDate" is of type DateTime i think to format it you use
myDate.ToString("dd/MMMM/yyyy");
|
|
|
|
|
The Add method returns a reference to the parameter, so you can set it's value.
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.NVarChar, 18, "Press_job_order")).Value = "42";
---
b { font-weight: normal; }
|
|
|
|
|
this.sqlSelectCommand1.Parameters.Add("@Param2", System.Data.SqlDbType.NVarChar, 18).Value = "Press_job_order";
or (if you're using .NET 2.0) :
this.sqlSelectCommand1.Parameters.AddWithValue("@Param2", "Press_job_order");
|
|
|
|
|
Hi,
Is it possible to use C# as a scripting language in an MFC App?
Any ideas are welcome?
thanks
Ning
|
|
|
|
|
There's an option to make it possible:
Make a COM-enabled .NET assembly with a ScriptingEngine class in it.
This class should have a method that reads a script from a .cs file and compile it dynamicly into an assembly (that is not written to disk, but kept in memory). After the method has loaded and compiled the script it should run the script.
I don't have much knowledge about passing COM objects into .NET methods, but just give it a shot and you will have something that is pretty amazing if it works.
WM.
What about weapons of mass-construction?
|
|
|
|
|
My codeis as follows For LinkButton created from the event handler lnk_Click(), I was not able to fire the event.Pls do suggest some ways to get out of it
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
LinkButton lnk3;
LinkButton lnk1;
LinkButton lnk;
protected void Page_Load(object sender, EventArgs e)
{
for (int i = 1; i < 11; i++)
{
lnk1 = new LinkButton();
lnk = new LinkButton();
lnk.Text =Convert.ToString(i);
lnk1.Text = " ";
this.Form.Controls.Add(lnk);
lnk1.Enabled = false;
this.Form.Controls.Add(lnk1);
lnk.Click +=new EventHandler(lnk_Click);
if (i > 9)
{
lnk3 = new LinkButton();
lnk3.Text = "More";
this.Form.Controls.Add(lnk3);
lnk3.Click+=new EventHandler(lnk_Click);
}
}
}
public void lnk_Click(object sender, EventArgs e)
{
string str = ((LinkButton)sender).Text;
Response.Write("Hi Just Testing" + " "+ str);
if (((LinkButton)(sender)).Text == "More")
{
for (int i = 0; i < 11; i++)
{
lnk1 = new LinkButton();
lnk = new LinkButton();
lnk.Text = Convert.ToString(i);
lnk1.Text = " ";
this.Form.Controls.Add(lnk);
lnk1.Enabled = false;
this.Form.Controls.Add(lnk1);
lnk.Click += new EventHandler(lnk_Click);
if (i > 9)
{
lnk3 = new LinkButton();
lnk3.Text = "More";
this.Form.Controls.Add(lnk3);
lnk3.Click += new EventHandler(lnk_Click);
}
}
}
}
}
|
|
|
|
|
i've to set some conditions to my program. user has to enter a string of 2 letters + 7 numbers in this order eg. x1234567y
how do i set the conditions to make sure the order is correct?
thanks
|
|
|
|
|
use regular expression
MCAD
|
|
|
|
|
what do u mean by regular expression? i was told to do onkeypress event on textbox.. how do i start doing that, do u know?
|
|
|
|
|
nidhelp wrote:
what do u mean by regular expression?
A regular expression is a language that's used to define the format of an input string. Google will tell you more.
nidhelp wrote:
i was told to do onkeypress event on textbox.. how do i start doing that, do u know?
In the designer, click on the text box, in the properties, tick the lightning flash. I'd suggest that textchanged is perhaps a better event to go for. What's your level of experience here ? Are you just starting ? Why do you have this requirement ? Is it homework ( I'm still happy to help you if it is ) ?
Once you have an event that tells you the text has changed, a regular expression is still the way to know the format of the string. Look up Expresso on this site, it's an app that helps you build regex, and a great learning tool.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
What's your level of experience here ? Are you just starting ? Why do you have this requirement ? Is it homework?
i am v new to c#. for more details, i've replied u in my other post regarding tab page that day. =)
ok i've looked through some codes on regular expression.. do i have to simply copy paste the codes i need in my program and it'll know what format i want, or do i've to go somewhere to click/select/fill in something to specify my format of an input string?
also how's a textchanged better than onkeypress?
thanks!
|
|
|
|
|
nidhelp wrote:
i am v new to c#. for more details, i've replied u in my other post regarding tab page that day. =)
Ah... welcome back 
BTW, you can highlight my replies and hit the 'Quote selected text' button to get the format you see when I quote you.
nidhelp wrote:
do i have to simply copy paste the codes i need in my program and it'll know what format i want, or do i've to go somewhere to click/select/fill in something to specify my format of an input string?
\d is a number, \w is a character in a word ( alpha ), and {} allow you to show number of items
If this regex matches anything
\d\w{6}\d
and the number of characters is 8, then you have a number, six letters and a number. Was that the format you wanted ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
o thanks for teaching me about quote selected text =)
my format is a letter, 7 numbers, a letter
>> \w\d{7}\w correct?
hmmmm.. i need to ensure that the user only types s/S or f/F for the first letter.. how is that possible?
i clicked on the lightning button n looked through the onkeypress already but it still gives me no clue as to how to even use the onkeypress to do my app..
|
|
|
|
|
nidhelp wrote:
hmmmm.. i need to ensure that the user only types s/S or f/F for the first letter.. how is that possible?
A regex can contain more specific info, [] is used for character groups.
[sSfF]\d{7}[sSfF]
will do it. OnKeyPress will give you a function that runs when a key is pressed. In that function, you need to get the text from the textbox and check it. Something like this:
TextBox tb = sender as TextBox;
string input = tb.Text;
if (input.Length == 9 && System.Text.RegularExpressions.Regex.Match(input, @"[sSfF]\d{7}[sSfF]").Success)
{
// The string is correct
}
else
{
// Don't forget that unless the length is 9, they could still be entering, so don't put a warning box here. A better place for that would be the lose focus event.
}
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Christian Graus wrote:
// Don't forget that unless the length is 9, they could still be entering, so don't put a warning box here. A better place for that would be the lose focus event.
I recommend the Validating event. That's what it's for, and if you set e.Cancel = true, focus won't leave the control.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
in >> TextBox tb = sender as TextBox
what is sender? i have to replace sender with some other things right?
can i write the conditions which u typed under private bool.
do i need to type something in OnKeyPress property?
thanks i've learnt quite a lot from u =)
|
|
|
|
|
nidhelp wrote:
what is sender? i have to replace sender with some other things right?
No, the event has an object called sender. Did you not create the event yet ? I did it this way instead of using a variable directly precisely so that you didn't need to change the code I gave you.
nidhelp wrote:
can i write the conditions which u typed under private bool.
You can set up a property if you'd like. Then you need to change the variable name though.
nidhelp wrote:
do i need to type something in OnKeyPress property?
OnKeyPress lets you check every time the user types. If they are pressing a button to do something and you need THEN to check if the code is valid, forget the events ( although the Validating event may be worth a look, I know nothing about that ), and then it would make sense to make it a private property, to encapsulate this piece of functionality.
nidhelp wrote:
thanks i've learnt quite a lot from u =)
No worries, always glad to help.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
sorry but i dont get u... do i create KeyPressEvent n put those codes inside it?
|
|
|
|
|
If you want to validate whenever a key is pressed, yes. If you always need a valid code, then I'd go with the code that accepts nothing else ( unless it's some sort of licence key ). If you don't always need it, then I'd not bother with the event, because people can type what they like, you can proceed with and without a valid value ( although it would be better for the UI to tell people the value was not valid ). Then you can instead do this check when the button is pressed that causes the value to be used.
I'm about to leave for 2 days, so that's the end of my help for now. Good luck...
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
If you are using a textbox, you can handle the key press event and process the necessary logic to allow/disallow certain characters from being entered. Here's some code below. I have not tested it but the logic is there i believe:
private void tbEditor_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
{
if(e.KeyChar == (char)8)
e.Handled = false;
else if(Char.IsLetter(e.KeyChar) == true && (tbEditor.Text.Length == 0 || tbEditor.Text.Length == 8))
e.Handled = false;
else if(Char.IsDigit(e.KeyChar) == true && (tbEditor.Text.Length > 0 || tbEditor.Text.Length < 8))
e.Handled = false;
else
e.Handled = true;
}
<font=arial>Weiye Chen
Life is hard, yet we are made of flesh...
|
|
|
|
|
hi
im not supposed to disable any keys from being entered into the textbox.. the user is free to type n my app shd only open up a form when he types in a correct format..
correct format is a letter, 7 numbers, a letter..
i also have to make sure the first letter is S or s or F or f.. as long as the first letter is not correct, the form will not open..
|
|
|
|
|
I got this to work with a combination of both ways. Using the Validating method, and a RegularExpression.
Just to confirm - the pattern you wanted was:
s,S,f or F at the start
7 numbers
and upper or lowercase letter at the end
which I represented as the reg ex: [sSfF]\d{7}[a-zA-Z]
In the form designer, highlight your textbox and look at the Properties grid. Swap it to events using the little lightning symbol. Scroll until you see an event named Validating. Double-Click inside the textbox to the right of the event name - this should do 2 things
1) Jump to the code-behind view
2) Enter the stub of an event...mine started life looking liek this:
private void textBox1_Validating(object sender, System.ComponentModel.CancelEventArgs e)
{
}
The two arguments passed to this method are very useful.
sender - is the thing that sent this event (the textbox in this case)
e - is the event arguments, in this case of type CancelEventArgs. This type of event arguments has a Cancel property which can be set to true for this event to indicate that the contexts of the text box are NOT valid (hence the event name validating.
So back to the problem. In pseudo-code:
if textbox is not valid<br />
set Cancel to true
this can be done in the following two lines
TextBox tb = sender as TextBox;<br />
e.Cancel = !Regex.Match(tb.Text,@"[sSfF]\d{7}[a-zA-Z]").Success;
However, to explain this
1) Cast the sender to type TextBox
TextBox tb = sender as TextBox
2)Determine if its text is valid:
bool isValid = Regex.Match(tb.Text,@"[sSfF]\d{7}[a-zA-Z]").Success;
3)if not valid, set Cancel to false
e.Cancel = !isValid;
end result: until you enter the correct sequence of characters into the textbox you are unable to tab out or close the form.
|
|
|
|
|
i just finished reading n doing the top half of what u typed only but i want to thank u already.. u r v detailed n i cld follow through n understand your instructions easily.. hey thanks! =)
i'll be reading n doing the bottom half after i type this.. hopefully it works..
=)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
