|
Thank U For Reply Me bt
How I perform Ur Coding In My Coding????
This is my All Coding In Button_click()
---------------------------------------------------------------------------
using system;
using Microsoft.data.odbc;
private void login_Click(object sender, EventArgs e)
{
OdbcConnection cn;
OdbcCommand cmd;
OdbcDataReader odr;
string MyString;
MyString = "Select * from users";
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl8i;UID=itehad;PWD=creative;");
cmd = new OdbcCommand(MyString, cn);
cn.Open();
MessageBox.Show("Connected");
cmd.CommandText = "Select * from users";
odr = cmd.ExecuteReader();
while (odr.Read())
{
if (usr.Text == odr["userid"].ToString())
{
MessageBox.Show("User Login", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DialogResult drsave = MessageBox.Show("Login Fail", "Erorr", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
if (drsave == DialogResult.OK)
{
usr.Text = "";
pass.Text = "";
usr.Focus();
}
else
this.Close();
}
}
}
---------------------------------------------------------------------------
Thanks In Advace
Jawad Khatri
|
|
|
|
|
Okay, normally you should write it by yourself, but today is friday, so here it comes:
private bool DoesUserExists(string sUserID) {
OdbcConnection cn;
OdbcCommand cmd;
OdbcParameter dbParameter;
OdbcDataReader odr;
string MyString = "Select * from users WHERE userid = @userid";
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl8i;UID=itehad;PWD=creative;");
cn.Open();
cmd = new OdbcCommand(MyString, cn);
dbParameter = new OdbcParameter("userid", sUserID");
cmd.Parameters.Add(dbParameter);
odr = cmd.ExecuteReader();
bool bResult = (odr.HasRows && odr.Read());
odr.Close();
cn.Close();
return bResult;
}
private void login_Click(object sender, EventArgs e)
{
if(this.DoesUserExists(usr.Text)) {
MessageBox.Show("User Login", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
} else {
DialogResult drsave = MessageBox.Show("Login Fail", "Erorr", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
if (drsave == DialogResult.OK)
{
usr.Text = "";
pass.Text = "";
usr.Focus();
} else {
this.Close();
}
}
}
You should add fail-safe to your app by using try-catch blocks, especially while interacting with the database. Next step would be to seperate the dataccess into an own assembly.
Regards
Sebastian
|
|
|
|
|
Thanks Alot Sir for Help me
Sir When I Run this program give error
Error Is
Error 1
'Microsoft.Data.Odbc.OdbcDataReader' does not contain a definition for 'HasRows'
|
|
|
|
|
Why don't you use the System.Data.Odbc.OdbcDataReader?
|
|
|
|
|
ok.
i use this and trying to solve my problem
sorry for distrb u Sir
|
|
|
|
|
No problem. And please don't call me sir... 
Just give a feedback if your problem is solved.
Regards
Sebastian
|
|
|
|
|
|
SeMartens wrote: odr.Read(); --> true if you have one record
ExecuteScalar will be more appropriate in this case than reader.
|
|
|
|
|
Yep, you are right... but we want to confuse beginners, or?
|
|
|
|
|
sir Actually i am use dotnet after 1 year thats why i am facing lot of problem
sir i kindly request to u please give me solution
|
|
|
|
|
Try the below sample code
query = "select username from tablename where username = '" + usr.text + "'";
sqlcommand cmd = new sqlcommand(query,con);
sqldatareader dr;
dr=cmd.executereader();
while(dr.read())
{
if(dr["username"].tostring() == usr.text)
{
true user
}
else
{
false user
}
}
dr.close();
Regards,
Karthik K...
|
|
|
|
|
Be careful about how you test for equality, in all but the rarest case you shoud use the Equals method.
a == b
This compares two objects and returns true if they are they same object, that is the same instance. This does not compare the content.
a.Equals(b)
Compares the two instances and is defined by each classes implimentation. In the trivial case of the string, it returns true if they have the same content. Any class you write should override this method if you need to compare instances' values.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
My WCF properly working when SecurityMode.None. If I switch to SecurityMode.Message so it is not work in client side. My main problem is how can I encrypt to message in WCF?
Following code OK, its work;
Host Side Code
---------------------------------------------------------------------
NetTcpBinding tcpBinding = new NetTcpBinding(SecurityMode.None);
Uri tcpUri = new Uri("net.tcp://10.0.105.240:7070/HesaplamaServisi");
ServiceHost host = new ServiceHost(typeof(Hesaplayici), tcpUri);
host.Description.Behaviors.Add(new ServiceMetadataBehavior());
host.AddServiceEndpoint(typeof(IHesaplamalar), tcpBinding, "net.tcp://10.0.105.240:7070/HesaplamaServisi");
host.AddServiceEndpoint(typeof(IMetadataExchange), System.ServiceModel.Description.MetadataExchangeBindings.CreateMexTcpBinding(), "mex");
host.Open();
Client Side Code
---------------------------------------------------------------------
NetTcpBinding tcpBinding = new NetTcpBinding(SecurityMode.None);
IHesaplamalar proxy = ChannelFactory<IHesaplamalar>.CreateChannel(tcpBinding, new EndpointAddress("net.tcp://10.0.105.240:7070/HesaplamaServisi/"));
FOLLOWING NOT WORK
---------------------------------------------------------------------
I want encrypt to message, so I add following code both side;
NetTcpBinding tcpBinding = new NetTcpBinding(SecurityMode.Message);
tcpBinding.Security.Message.AlgorithmSuite = System.ServiceModel.Security.SecurityAlgorithmSuite.TripleDesSha256Rsa15;
This code properly work when Host and Client same PC, If client.exe run another PC in same network this code not work. What can I do? Thanks...
|
|
|
|
|
Hi,
it is just a guess but which operating systems are you using for client and server? As far as I know is SHA256 only supported on Vista or higher. Maybe thats a problem.
Regards
Sebastian
|
|
|
|
|
By the way, did you try to debug your code? Maybe you get an exception for this.
|
|
|
|
|
I made the following class:
public class MyTextBox : TextBox
{
private int _IntVariable = int.MaxValue;
private myEnum _EnumVariable;
public MyTextBox()
{
}
public int IntVariable
{
get {return _IntVariable;}
set {_IntVariable = value;}
}
public myEnum EnumVariable
{
get {return _EnumVariable;}
set {_EnumVariable = value;}
}
}
When I create a user control and place a "MyTextBox" control on the user control, I name it txtName and set the IntVariable to 7 and the designer shows 7. Then, when I build the solution again, the value shown in the designer resets to the maximum value of an integer while the code in the InitializeComponent() method still shows : this.txtName.IntVariable = 7;.
However, the enumeration property can be set and it persists when the solution is re-built, the UserControl is closed and re-opened in the designer, or Visual Studio is closed and re-opened and the solution re-opened.
Can anyone explain why the integer property is not persisting and the enumeration property is and if there is anything I can do to make the integer property persist in the designer?
|
|
|
|
|
Sorry, I can't replicate the problem. It behaves as expected here 
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Hi,
I'm trying to build an over laying image like in the following link if you do mouse over Stars after Rate this Content you will see the overlaying form.
http://msdn.microsoft.com/hi-in/library/a72418yk(en-us).aspx[^]
I want to build same kind of control in C# Windows application? Is it possible ? Please help out.
|
|
|
|
|
IMO PictureBox which displays a Panel with needed controls on MouseHover might be a good start.
|
|
|
|
|
How to open a new File on a Button click such as an Application file.
|
|
|
|
|
Have you tried to Google[^]for it??
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Use an OpenFileDialog, then open the file. How you do this depends on which file format it is. If you just want to open it, use Process.Start(fileName)
Between the idea
And the reality
Between the motion
And the act
Falls the Shadow
|
|
|
|
|
Rupaa wrote: How to open a new File on a Button click such as an Application file.
To do anything on a button click you will require event processing.
If you want to open a file specified by the user, so you need only a file path in string format, you could use OpenFileDialog.
If you want to open a file, so actually access it, which would mean you want its information. You can use
some .Net's classes inside of the System.IO namespace. They are ending with 'reader'. So what type of file access do you need?
If you want just only to execute a certain assembly executable, then I guess Process.Start(fileName) should be fine.
... I hope this helps! 
|
|
|
|
|
can you help me to build an application use scanner to scan document
|
|
|
|
|
Yes I can.
My rates are $120 (US) per hour.
Let me know
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
