|
benjamin yap wrote: How do i create an instance of the adapter
Something along the lines of staffTableAdapter myAdapter = new staffTableAdapter();
I suggest you read up on how to use table adapters and data sets
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
but i am not using coding base to create my dataset and connection string..i am using the server explorer thing
|
|
|
|
|
What does connection string have to do with it? You asked how to invoke your method, and at that point you have to do some coding. Again, read up on the subject.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Okay
i have created an instance of the staffTableAdapter this way
dsTablesTableAdapters.staffTableAdapter sa = new EBMS.dsTablesTableAdapters.staffTableAdapter();
so i want to call the ValidateLogin method, so i did this
sa.ValidateLogin()
But inside the arguement, it ask me for
dsTables.staffDataTables dataTable,string nric,string password
What do i have to put for the first arguement? they asked for dsTables.staffDataTables dataTable... for the other 2 arguement i out txtnric.text and txtpassword.text
|
|
|
|
|
When you created the ValidateLogin , didn't you make the query take in parameters?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Ok when i created a new Query, they asked me Type of SQL query to use.
SELECT which return rows
SELECT which return single value
UPDATE
DELETE
INSERT
At first, i selected "SELECT which return rows" and they asked for 3 arguement. dataTable, string nric and string password.
So i change to "SELECT which return single value"
string result = sa.ValidateLogin(txtUsername.Text, txtPassword.Text);
MessageBox.Show(result.ToString());
When i key the correct username and password, the messagebox shows the username. If i enter a wrong username and password, the whole program ended and point to my code and says, NullReferenceException was unhandled.
If the correct username was found, i want to store the results of other columm to my variable i declared. Because my staff table have
nric, name, [password], dob, address, tel_mobile, tel_home, catalogueAccess, inventoryAccess, orderAccess, adminAccess, staffAccess
if the username and password matches, i want to store all the values to the variable i create at the top of my LoginForm.cs
private bool catManager;
private bool inventManager;
private bool orderManager;
private bool administrator;
private bool user;
how do i do that?
|
|
|
|
|
benjamin yap wrote: If i enter a wrong username and password, the whole program ended and point to my code and says, NullReferenceException was unhandled.
You trap that exception and that is how you know if the login failed.
benjamin yap wrote: how do i do that?
You should be able to pick the pieces out of the dataset returned by the table adapter.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
may i know wats the code to pick out the pieces of the value? or you provide me with an article on that? cause i dont know wat search term to use
dsTablesTableAdapters.staffTableAdapter sa = new dsTablesTableAdapters.staffTableAdapter();
try
{
string result = sa.ValidateLogin(txtUsername.Text, txtPassword.Text);
MessageBox.Show(result[2].ToString());
this.DialogResult = DialogResult.OK;
i tried result[2] to return the 3 column value. But it return 'M' inside.. because the result gives me the username which is Admin and result[2] = 'm'. the 3rd character.
modified on Sunday, August 3, 2008 2:45 AM
|
|
|
|
|
benjamin yap wrote: sa.ValidateLogin(txtUsername.Text, txtPassword.Text);
Should be returning a dataset, not a string.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
it still wont work.
I change my Query Type to "Select which returns a row (return one or many rows or column)"
Then in my login.cs
DataTable staffdt = new DataTable();
dsTablesTableAdapters.staffTableAdapter sa = new dsTablesTableAdapters.staffTableAdapter();
try
{
staffdt = sa.GetDataByLogin(txtUsername.Text, txtPassword.Text);
//this.DialogResult = DialogResult.OK;
string uname = staffdt.Columns["name"].ToString();
MessageBox.Show(uname);
}
catch(NullReferenceException)
{
MessageBox.Show("Invalid Credentials");
}
take a look at my screen shot.
http://opencube.com.sg/c.GIF
how do i get the value of the returned datatable column by column
|
|
|
|
|
hi friend's
i have an application that work with threading.
in load_form event of the form i create an instance a thread object and run it,
now my problem is , i want to kill the thread on another event such as button_click event on this form and i cant do it.
i can not create my thread public, because the number of thread should be create is not certain in my allpication,
how can i do it, please sya me a solution to solve it...
thanks alot
nobody help you...
you have to help you yourself
and this is success way.
|
|
|
|
|
The only reliable way to kill a thread is to let the thread terminate normally.
This means you need a way to notify a thread that it needs to terminate, and
provide a way to wait for the thread to terminate if necessary.
There's synchronization objects you can use. For example, EventWaitHandle.
There's no need to "create my thread public", but you may need to keep contexts
to your created threads somewhere, like in a collection in your form class.
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
One way to gracefully terminate a thread is to set a volatile bool variable to some value and check this value inside the other thread, like this:
public void ButtonClickHandler(Object sender, EventArgs args)
{
requestStopThread = true;
}
Inside your thread you need to check if this variable will be set to true and then terminate the thread in a correct way:
while(!requestStopThread)
{
}
or
...
if(requestStopThread)
...
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Hello everyone,
I found when using proxy in IE, I can not access some web site and the error information is DNS resolution error. But when not using such proxy in IE, the page can be accessed.
My questions,
1. Proxy will do DNS lookup and proxy will not regard my local DNS settings (proxy has its own DNS settings)?
2. How to write some simple code, which can switch between resolving name by proxy and by my local DNS settings? So that I can do some automatic testing?
thanks in advance,
George
|
|
|
|
|
Hi,
I have a problem in downloading .css and script files associated with aspx page on downloading the page page. I have used java script to download the file.
code is :document.execCommand("SaveAs",true,document.title + '.html');
Thanks
modified on Saturday, August 2, 2008 7:18 AM
|
|
|
|
|
Hello everyone,
I am wrting an Http client to access some web page. My current network configuration is using proxy of local lab to access internet.
For the URLs which I can not access, I have also tried in IE, both of them are errors from DNS/Bad gateway. Here is the error message in IE.
My questions are,
1. is DNS fail to resolve the domain name to IP address the root cause?
2. If yes, which party is responsible to choose which DNS to use? Proxy will choose which DNS to use or proxy will resolve the name to IP directly?
IE error message,
Error Code 11001: Host not found
Background: This error indicates that the gateway could not find the IP address of the website you are trying to access. This is usually due to a DNS-related error.
Date: 8/2/2008 10:41:38 AM [GMT]
Server: NetworkLabProxy
Source: DNS error
thanks in advance,
George
|
|
|
|
|
HTTP, the protocol which web browsers use to retrieve and display web pages, is different from DNS. I don't think web proxies to DNS resolution - proxies get a resolved address to which they open a HTTP connection.
Here's a quick way to find out who's doing the resolution - Open cmd.exe and type nslookup. Play around with the options there (set d2) and you'll get a lot of information about who's doing the resolution.
|
|
|
|
|
|
Hello all,
m trying to apply sql transaction on many insert command,
the problem that m using multi-tear application and Typed Data Set and i want to do the commet and the rollback on the UI layer ,
so any suggestions are welcomed!
|
|
|
|
|
i fixed the problem
thx!!!
|
|
|
|
|
Yes: DON'T PUT DATABASE ACCESS IN THE UI!!!
|
|
|
|
|
I buid a UserControl , and how to forbid it to get focus?
And how to forbid a ToolStripControlHost to get focus ,when the ToolStripDropDown is opened?
|
|
|
|
|
Try setting .CanFocus to false?
I don't know whether or not it does what you want, I've always found trying to control focus rather frustrating so I don't bother anymore.
|
|
|
|
|
just put visible = false or enable = false.
Do you want to triggers a control from other usercontrol/form?
(place another post).
|
|
|
|
|
Hi
I am using nHibeernate version 1.0.4., which I took from SourceForge.Net with the configuration settings given in the site itself. I am getting the follwing error in Mapping a file.
Error Could not find a getter for property 'UN' in class 'Address.Info'
A first chance exception of type 'System.NullReferenceException' occurred in Address.exe
Please find below my code files: PLease replace &lt; with '<' and &gt; with '>'.
class Info
{
private int id;
private string UN;
private string PN;
}
My mapping File with name Info.hbm.xml:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name ="Address.Info, Address" table ="Info">
<id name ="Id" column="LoginID" type ="Int32" unsaved-value ="0">
<generator class="native" />
</id>
<property name="UN" column="UN" type="String(50)" />
<property name="PN" column="PN" type="String(50)" />
</class>
</hibernate-mapping>
Could you please tell me what I need to do to reslove this issue??
Thanks in Advance
With Regards,
Puneet
|
|
|
|