|
Hey
I want to execute a code when the dataset position change ,,
thanks,
jooooo
|
|
|
|
|
Have you ever heard of event handlers? You might want to see if there is one that gets triggered when the dataset position changes. 
"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
|
|
|
|
|
Hi, i got a access database which i want to use it for my C# application.
I created a new database connection using the Server Explorer -> Data Connections -> Add Connection, then browse for my database file and test connection. Connection Succeded.
I then right click my project -> Add -> New Item -> Dataset. Then i draw all my tables thru the server explorer into the Dataset.
I have 1 table called Staff. I right click the staffTableAdapter -> Add new Query.
SELECT nric, name, [password], dob, address, tel_mobile, tel_home, catalogueAccess, inventoryAccess, orderAccess, adminAccess, staffAccess FROM staff where nric = ? and password = ?
then I name my method name as "ValidateUser".
problem : inside my LoginForm.cs. For the method
private void btnLogin_Click(object sender, EventArgs e)
{
}
What do i code inside here to call my TableAdaptable method "Validate User"
modified on Saturday, August 2, 2008 1:16 PM
|
|
|
|
|
benjamin yap wrote: What do i code inside here to call my TableAdaptable method "Validate User"
Depends. first, you instantiate an instance of the staffTableAdapter, then pass the appropriate parameters to your method. Hard to tell without seeing everything as a whole.
"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
|
|
|
|
|
my dataset is called dsTable. How do i create an instance of the adapter
|
|
|
|
|
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++
![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif)
|
|
|
|
|
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!!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
