|
|
try {
SqlConnection con = new SqlConnection("connectionstring");
string sqlQuery = "select user,pwd from Login where user= ' " + this.TextBox1.Text + " ' and pwd=' " + this.TextBox2.Text + " ' ";
con.Open();
SqlCommand com = new SqlCommand(sqlQuery, con);
int results = com.ExecuteScalar;
if (results == 1)
{
return true;
}
else
{
return false;
}
con.Close();
com.Dispose();
}
catch (SqlException ex) {
MessageBox.Show(ex.ToString);
}
|
|
|
|
|
Ever heard of SQL injection?
Cheers,
Vıkram.
After all is said and done, much is said and little is done.
|
|
|
|
|
Yes, I do.
But didn't wanted to confuse this guy with such fundas. Seems to be a Beginner.
|
|
|
|
|
If he's that much a beginner, it's all just as confusing, so you could have used parameters. Doing so now will confuse him, so we best leave it. 
|
|
|
|
|
I appreciate your good intent on getting him started with minimum pain and confusion. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
At the same time, if we can make him understand secure programming concepts even at the inception it would be good. Isn't it? 
|
|
|
|
|
thanks for your reply
But this shows the error to conver into string
|
|
|
|
|
I've been reading a lot of posts on how to use delegates to communicated between two forms. However, in every example I have the problem with the strucutre of the examples. In every case I've seen there is a main form, that delegates a function to another form. However the main form first creates the second form and then sends the data that way:
For example:
<br />
private void btnSend_Click(object sender, System.EventArgs e)<br />
{<br />
Form2 frm= new Form2();<br />
delPassData del=new delPassData(frm.funData);<br />
del(this.textBox1);<br />
frm.Show();<br />
}<br />
This is great except I have the issue where once another completely seperate form is created, some information is inputted by the user and then it closes. When this window closes I want to alert the first (main form) that this has happened so it can do some of its own calculations.
From what I've read delegates are the way to go but I have been unable to find a method to make this work. Thanks for your time and any help you give!
David
|
|
|
|
|
DavidNelson wrote: This is great except I have the issue where once another completely seperate form is created, some information is inputted by the user and then it closes. When this window closes I want to alert the first (main form) that this has happened so it can do some of its own calculations.
You can register a delegate with the Form.Closed[^] event. When the second form closes, it will raise this event. Alternatively, you can add an event to the second form. The event can be accompanied by a custom EventArgs derived class you create. This custom event class will carry additional information necessary for the first main form to make its calculations. In the second form, override the OnClosed method. Raise your custom event there. Register a delegate with the event in order to respond to it.
You can skip using events all together if the main form has access to the second form. In the second form, add properties representing the user entered information. The main form can access those properties after the second form is closed.
|
|
|
|
|
You can simply assign an event handler to the FormClosing event of the second form.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
What is the C# equivalent to java's .readInt()?
The following code returns different values when the same file is read.
C#
FileStream fs = new FileStream("file", FileMode.Open);<br />
BinaryReader br = new BinaryReader(fs);<br />
Console.out.WriteLine(br.ReadInt32();
Java
DataInputStream datainputstream = (new DataInputStream(new FileInputStream("file")));<br />
System.out.println(datainputstream.readInt());
|
|
|
|
|
|
i think so.
readInt()
Reads four input bytes and returns an int value.
http://java.sun.com/j2se/1.4.2/docs/api/java/io/DataInput.html
Reads four input bytes and returns an int value. Let a be the first byte read, b be the second byte, c be the third byte, and d be the fourth byte. The value returned is:
(((a & 0xff) << 24) | ((b & 0xff) << 16) |
((c & 0xff) << 8) | (d & 0xff))
|
|
|
|
|
The Java readInt method reads in big-endian (Motorola) format, while .NET ReadInt32 reads in little-endian (Intel) format.
---
single minded; short sighted; long gone;
|
|
|
|
|
Guffa wrote: The Java readInt method reads in big-endian (Motorola) format, while .NET ReadInt32 reads in little-endian (Intel) format.
How could I forget? Guess I haven't worked with Java in a long time 
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Ok so i figured it out.
Now when i write the integer to the file, i would have to write it using Big Endian coding so Java can read it, correct?
Anyone want to point me in the right direction?
|
|
|
|
|
Ok I'm still pretty new to C# and could use some advise. I'm trying to work with the SJPhone API and all the examples that come with it are in VB6. To start the program up you need to initialize the API and it is done like this...
Private Sub StartConnecting()
TextState.Text = "Initializing: stage 1"
Set ApiConnection = New SJxmlApiConnection
If (ApiConnection.Initialize("SJphoneXmlApiDemo.dll")) Then
ToConnectingState
Else
ToConnectfailedState
End If
End Sub
Now if I try to call the dll like that C# has a fit, but I just don't know why yet? What is the C# way of doing this? The Init function requests the dll passed as a string so what can I do different? Thank you for any help here.
|
|
|
|
|
Converting from VB6 to C# might be in the same league as a root canal. Here is my thought on how to do the code you specified...
(1) make a reference to SJPhoneXMLApiDemo.dll in the Solution
(2) the c# code may be something like:
void StartConnecting()
{
TextState.Text = "Initializing: stage 1";
SJxmlApiConnection ApiConnection;
if (ApiConnection.Initialize("SJPhoneXmlApiDemo.dll")))
{
ToConnectingState();
}
else
{
ToConnectfailedState();
}
}
Not sure if this code will compile, but it would be my first stab at the problem...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Well at least I can say that I was thinking the same thing when I made my attempt. My first try at making this work looked exactly like your code If I try to reference the DLL I get an error that it's not a valid COM object and when I try to run the above code I get a COM exception error. I did try to let VS convert the VB6 version of this app to C# and that was just a nightmare. Are there things you just can't do in C#, like this?
|
|
|
|
|
Hi,
I had been trying to set up my C# program to be a .dll for my C++ project. I had followed the guide from this site (http://www.csharphelp.com/archives/archive281.html) to package it as a Com Object. It worked in all regards, except that when I try to make a pointer to the exported class (public class DBCOM_Class : DBCOM_Interface in example), the named class is not seen by the C++ project. I can see/make pointer to the interface and the event handler, however the class itself doesn't show up in the list of members of the exported namespace (Database_COMObject) in the example.
What do I do wrong?
wbr,
Victor
|
|
|
|
|
I have a ToolStripContainer with four ToolStripPanels. I need to remove this container from the project without loosing the menus and toolbars I have contained within it.
I have been searching for two days trying to find any info on how to save the docked toolbars by serialization. I then decided to remove the container. I found lots of info on creating the container but nothing on serializing the controls or removing the ToolStripContainer from the project!
Any help is appreciated.
Mark
|
|
|
|
|
If you remove the container, you'll lose it's contents. Where were you hoping they would go ? You'd need to replace them with conventional menus and toolbars, and I don't think there's an automated way to do that.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thought so. I dropped the MenuStrip, ToolStrips (2) and a StatusStrip on a form. Later I added a ToolStripContainer (with four panels). Didn't like it so now I want to remove it.
Mark
|
|
|
|
|
need to know hw 2d dwt wrks for images hv a class in 1d form.
|
|
|
|
|
u shd wte cplet stcs or we dnt undsnd u
modified 12-Sep-18 21:01pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
