|
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!!!
|
|
|
|
|
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
|
|
|
|
|
Well, have you looked around at NHibernate's documentation?
puneet.bhatnagar123@gmail.com wrote: PLease replace < with '<' and > with '>'.
There is a checkbox at the bottom that says Ignore HTML tags in this message (good for code snippets)
"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
|
|
|
|
|
Finally got to a point where I need to use my own interface but got a bit stuck here.
I have a simple interface
public interface IStockItem : IComparable
{
string StockCode { get; set; }
}
and two structs that implement it fully: SparePart and ServiceTool
and collections of the two structs SparePartCollection<SparePart> and ServiceToolCollection<ServiceTool>
Now I need to get all the SparePart and ServiceTool objects together and sort them by the StockCode property.
What's the best way to collate the object collections to one collection based on the interface, and how do I implement CompareTo on that collection?
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
The solution depends on how you sort the SpareParts and ServiceTools.
One solution would be to add both collections to a single collection and then sort using a delegate, like this:
private static int CompareStockItems(IStockItem x, IStockItem y)
{
if (x.StockCode.Length < y.StockCode.Length)
return -1;
else if (x.StockCode.Length > y.StockCode.Length)
return 1;
else
return 0;
}
List<IStockItem> items = new List<IStockItem>();
items.AddRange(sparePartCollection);
items.AddRange(serviceToolCollection);
items.Sort(CompareStockItems);
You can also just do items.Sort() without specifying a sorting delegate, then the CompareTo methods of the two classes will be used.
This however depends on the implementation of the CompareTo method. If you want SpareParts only to be compared between themselves and ServiceTools also only between ServiceTools, then both CompareTo methods are likely to be different and you'd have to use a delegate to sort them in the list.
If the comparison is the same for both stock item types though, then you can duplicate the CompareTo method in both implementations and use something like:
public int CompareTo(object obj)
{
IStockItem item = obj as IStockItem;
if (item == null)
return -1;
else
{
if (this.StockCode.Length < item.StockCode.Length)
return -1;
else if (this.StockCode.Length > item.StockCode.Length)
return 1;
else
return 0;
}
}
for both stock item implementations. I don't recommend this design though, as a change in one implementation needs to be changed in the other accordingly.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
