|
There are a few things that you need to look at here.
1. You are using a query (as others have pointed out) that is wide open to SQL Injection.
2. You don't dispose of your SqlCommand (try wrapping them it the using statement).
3. You are using the wrong method to read data (and I'm surprised nobody pointed this out to you). Basically you have opened up a DataReader to read a single value out of the database. This is overkill. Try replacing this with ExecuteScalar instead, which is designed to return single values.
4. In your finally block, you call conn.Close ; what happens if you didn't manage to open the connection in the first place?
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
i wanted to create a software for a server that can handle many client.. it is possible to handle the server all the client without a software for the client just like a log-in system that they can connect to the server?...... and it is possible to manage the server all the transaction with in the network?.... Someone can give me an idea or an open source code to solve my problem... PLSSS HELP ME... tnx...
|
|
|
|
|
nEar_mO wrote: i wanted to create a software for a server
What exactly do you want the software to do?
|
|
|
|
|
that can manage the transaction....
|
|
|
|
|
What you are trying to achieve is not possible at all.
C# is providing transaction management, but not in the
sense you are understanding.
What I understand from your question is, you want to develop
"SQl Server Management Studio" kind of functionality.
Although find following link useful for transaction management.
Microsoft .NET Framework 2.0 Transaction Management[^]
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
Howdy,
Thanks for looking into this.
I have a single form application.
The Main Form has a TableLayoutPanel.
When a user clicks a button on the main form, a UserControl is added to the controls in the TableLayoutPanel.
The UserControl has a button on it.
What I'd like to happen:
When the button on the UserControl is clicked, I want the Main Form to perform a method.
How do I get the Main Form to listen to an event on a Button on the UserControl?
Note: I need to see some code in the answer. I've read about delegates and such, but I'm not getting something. If I see it in code, I think I would understand.
Thanks in advance
Jess
|
|
|
|
|
There are a number of ways to do this. The easiest way is to create a custom UserControl with a custom event.
public partial class MyUserControl : UserControl
{
public event EventHandler TheButtonWasClick;
public MyUserControl()
{
InitializeComponent();
button1.Click += new EventHandler(button1_Click);
}
private void button1_Click(object sender, EventArgs e)
{
if (TheButtonWasClick != null)
TheButtonWasClick(this, EventArgs.Empty);
}
}
Now in your main form you wire up your custom UserControl...
public partial class MainForm : Form
{
private void mainFormButton_Click(object sender, EventArgs e)
{
MyUserControl myUserControl = new MyUserControl();
myUserControl.TheButtonWasClick += new EventHandler(myUserControl_TheButtonWasClick);
}
void myUserControl_TheButtonWasClick(object sender, EventArgs e)
{
}
}
Does this help you?
The mind is like a parachute. It doesn’t work unless it’s open.
|
|
|
|
|
This helps a lot, but I think I forgot to explain something.
The controls in the TableLayoutPanel are added at run time. How do I link the MainForm to each of the button click events for UserControls I'm adding at run time?
Also, I'm adding the UserControls to TableLayoutPanel.Controls, not the MainForm directly. Do I need to do something different in that case?
Just to make sure I've described it well:
0. The MainForm has a TableLayoutPanel with UserControls added to the TableLayoutPanel.Controls collection at run time.
1. I have a 'Save' button on any of the UserControls in the TableLayoutPanel.
2. I want the MainForm to run a method when 1. occurs.
Note: I don't mean to doubt your example. I'm just at a learning stage where I want to make sure I understand exactly what's going on.
|
|
|
|
|
JessStuart wrote: I'm just at a learning stage where I want to make sure I understand exactly what's going on.
Every programmer ought to stay in this stage! Don't be nervous. It's a pleasure to answer someone's question that has a genuine desire to learn.
I think I can explain the concept better if you'll post the code where your adding the user control to the TableLayoutPanel.
I'll modify it and show you how it works.
Cheers!
Richard
The mind is like a parachute. It doesn’t work unless it’s open.
|
|
|
|
|
Thanks for the encouragement.
Here's how I solved it, based on your example:
Relavant Main Form Code:
private void btnAddQuery_Click(object sender, EventArgs e)
{
SQLXmlInterface newSxi = new SQLXmlInterface();
newSxi.SaveButtonClicked += new System.EventHandler(SQLXmlInteface_SaveButtonHandler);
sqlInterfaces.Add(newSxi);
tlpQueries.Controls.Clear();
foreach (SQLXmlInterface sxi in sqlInterfaces)
{
sxi.Refresh();
tlpQueries.Controls.Add(sxi);
}
RefreshControls();
}
private void SQLXmlInteface_SaveButtonHandler(object sender, EventArgs e)
{
RefreshControls();
}
Here's the relevant Dynamically Added Child Control Code:
public partial class SQLXmlInterface : UserControl
{
SQLXmlObject sqlObject;
bool saved = false;
bool validated = true;
public event EventHandler SaveButtonClicked;
private void btnSave_Click(object sender, EventArgs e)
{
saved = true;
sqlObject = new SQLXmlObject(txtTitle.Text, txtQuery.Text);
RefreshControls();
if (SaveButtonClicked != null)
SaveButtonClicked(this, EventArgs.Empty);
}
}
Synopsis (please correct if I've got it wrong):
The Main Form "listens" to the child control by the EventHandler assigned to the newSxi.SaveButtonClicked event.
The child object btnSave_Click event triggers (just calls, really) the SaveButtonClicked event.
Since the Main Form has the EventHandler defined for the SaveButtonClicked event, when the SaveButtonClicked event occurs, the EventHandler for the Main Form runs the SQLXmlInteface_SaveButtonHandler method, which was assigned to it in this code from the Main Form:
newSxi.SaveButtonClicked += new System.EventHandler(SQLXmlInteface_SaveButtonHandler);
|
|
|
|
|
A+ my friend! Events are not the easiest thing to wrap your brain around.
BTW, I might add that it's really not proper to include the text "Interface" in an object. (There is an actual .Net object called an interface)
The subject of an interface is entirely for another time but it is a very helpful tool.
I would suggest: "SQLXmlEditor" or "SQLXmlViewer" depending on it's functionality.
The mind is like a parachute. It doesn’t work unless it’s open.
|
|
|
|
|
Hi,
Does anyone know of a convenient way to play mp3 files without using windows media player component??
Many thanks
|
|
|
|
|
|
Thanks mate! Looks good..
|
|
|
|
|
And thanks for linking me to the site.. Unfortunately, it doesn't help me as I'm playing the file from an embedded object as a stream.. Thanks anyways pal!
|
|
|
|
|
You could copy it to a temp file though
|
|
|
|
|
harold aptroot wrote: You could copy it to a temp file though
I thought so.. I think I'll have to do it this way, thanks Harold!
|
|
|
|
|
|
I want send for exampel message from one Client to server and server send that message to another Client how I must do it?!
my server project just can send that message to client that send message!!!
|
|
|
|
|
Socket implementation - see here[^].
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
|
|
|
|
|
I have a class which reads mails from an OWA(OutlookWebAccess)mail box. I am using the following code as follows, but not sure how will I get the attachment and read those attachemnt.
"SELECT" & _
" ""DAV:href""" & _
",""urn:schemas:httpmail:sendername""" & _
",""urn:schemas:httpmail:subject""" & _
",""urn:schemas:httpmail:datereceived""" & _
",""urn:schemas:httpmail:read""" & _
",""urn:schemas:httpmail:htmldescription""" & _
",""urn:schemas:httpmail:hasattachment""" & _
",""urn:schemas:httpmail:attachmentfilename""" & _
" FROM scope
Even saving the attachment and reading the file thereafter from local folder is also fine. But I don't know how to do the same. Can anybody provide any help for that?
I read something that relates to this in this link. But not able to understand anything. Is this is the way to achieve this?
Please help.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
|
Every .NET (and indeed windows) application can have arguments - see the "args" parameter to your "main" method.
When your external app starts your console app. it can provide the parameters as part of the command line.
Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.
|
|
|
|
|
|
You are joking, aren't you?
He said, having a horrible feeling you aren't
Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.
|
|
|
|