|
Hi,
what about my second question?regarding requirement of com interoptiblity ?
which steps to be followed to make one .net dll to be com interoptiblity.?
|
|
|
|
|
|
Hello,
I have two webservices that send/receive the same UserInfo class. How do I tell consumers that the UserInfo class is the same in both web services.
In other words:
[WebService(Namespace="thesamenamespace")]
public class web1 : System.Web.Services.WebService {
...
[WebMethod(Description="Update a user.")]
public void UpdateUser(UserInfo user) { }
}
[WebService(Namespace="thesamenamespace")]
public class web2 : System.Web.Services.WebService {
...
[WebMethod(Description="Get user.")]
public UserInfo GetUser() { return new UserInfo(); }
}
When consumed in the client (via visual studio add web reference to build proxies), UserInfo is treated as two different class definitions. How can I "share" the definition.
Thanks in advance, Jeff
|
|
|
|
|
hi Chilberto,
What you have to do is make a DLL project that defines the UserInfo class and add reference to both webServicies, that will solve the problem.
Hope that helps.
GanDad
|
|
|
|
|
hello to everyone,
i need some idea of how to access a USB HID magnetic card reader in C#. i have googled quickly and search these articles but have not found anything revealing.
does anyone know if any quick tutorials to acheive this ?
kind regards,
g00fy
|
|
|
|
|
See if the manufacturer of the device has an SDK (Software development kit) for it. Without an SDK or reference for the device drivers for the device, you're out of luck. There is no such thing as "just accessing USB." Every device is different and requires its own driver. USB is NOT a generic access method for devices attached to it. It's an expansion bus, just like PCI, and just like PCI, each device must have it's own driver in order to communicate with it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
well i have the option to purchase RS232 interface rather than USB, would this be better for me ?
or is it much the same if i have SDK for USB ?
if i can get the driver, is it then a matter of listening to a certain port ?
or is it more low level requiring hardware instructions ?
or is it driver dependant?
sorry alot of question
kind regards
g00fy
|
|
|
|
|
g00fyman wrote:
well i have the option to purchase RS232 interface rather than USB, would this be better for me ?
Your still going to need to have the docs on the device so you know what commands the device accepts, how to format them, how to parse any data that comes back, ...
g00fyman wrote:
if i can get the driver, is it then a matter of listening to a certain port ?
If you don't have the driver, the device won't work!
g00fyman wrote:
is it more low level requiring hardware instructions ?
or is it driver dependant?
It's very hardware dependant. No matter what, you'll need some kind of documentation describing the command interface of the device. Without it, it'll be like your speaking Chinese in Oklahoma, if you even get to Oklahoma.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
thank you for all your help
regards
g00fy
|
|
|
|
|
I am trying to insert data into a Access db. I am able to connect to the db fine. I get an error in the catch telling me I have a problem with my sql statment.
This is my sql statment. (I have checked the spelling of all variables and field, table names etc...)
All information is comming from textboxes
--except newNum -- uses a method to find the next avalible number
(worked like this on a different db)
string sqlString = "INSERT INTO Cafe (CustomerNumber, FirstName, LastName, Address, City, Province, PostalCode, PhoneNumber, UserName, Password, TimePurchased ) VALUES ("
+ newNum.ToString()
+ ",'" + FirstNameTxt.Text
+ "','" + LastNameTxt.Text
+ "','" + AddressTxt.Text
+ "','" + CityTxt.Text
+ "','" + ProvinceTxt.Text
+ "','" + PostalCodeTxt.Text.ToUpper()
+ "','" + PhoneNumTxt.Text
+ "','" + UserNameTxt.Text
+ "','" + PasswordTxt.Text
+ "'," + TimePurchaseTxt.Text.ToString()
+ ")";
the Access db is called Assignment3
the table is called Cafe
CustomerNumber (autoNumber) PK
FirstName (Text)
LastName (Text)
Address (Text)
City (Text)
Province (Text)
PostalCode (Text)
PhoneNumber (Number)
UserName (Text)
Password (Text)
TimePurchased (Number)
I am new to sql and would really like some help
Thanks
|
|
|
|
|
Remove the autonumber, and it would be better controlled by Access itself instead of your function.
Include the error message in the email. Also, provide the value of sqlString at runtime which would be easy for us to look into.
|
|
|
|
|
The autonumber is controled by Access. each feild does have a value when I debug.
|
|
|
|
|
|
I still have a problem....this is what I did to remove the CustomerNum
string sqlString = "INSERT INTO Cafe ( FirstName, LastName, Address, City, Province, PostalCode, PhoneNumber, UserName, Password, TimePurchased ) VALUES ("
+ FirstNameTxt.Text
+ ",'" + LastNameTxt.Text
+ "','" + AddressTxt.Text
+ "','" + CityTxt.Text
+ "','" + ProvinceTxt.Text
+ "','" + PostalCodeTxt.Text.ToUpper()
+ "','" + PhoneNumTxt.Text
+ "','" + UserNameTxt.Text
+ "','" + PasswordTxt.Text
+ "'," + TimePurchaseTxt.Text
+ ")";
Error -- Syntax error in INSERT INTO statment
Thanks for your help!!
|
|
|
|
|
what does the sqlString look like if you dump it to the console?
Since you do not quote you parameters it is possible that they contain quotes or commas...
/cadi
24 hours is not enough
|
|
|
|
|
I'm not sure what you mean "dump it to the console" and none of the text input has anything other then letters and numbers.
I'm new to this...Thanks
|
|
|
|
|
Somthing like System.Console.Out.WriteLine(sqlString); .
Have yout tried to paste the result in any DB-Mamangent tool (if you use SQL Server try the Query Analyzer)?
You'll probably get a more detailed error description....
/cadi
24 hours is not enough
|
|
|
|
|
-> "... VALUES ('" not "... VALUES ("
some on "')" instead of ")"
good luck.
(PS: Debug the code, quickwatch the sqlString variable when fully loaded, copy the statement and execute it manually, then you'll know what went wrong or catch the execution and dump the error message.)
No hurries, no worries.
|
|
|
|
|
You don't put a apostrophes around the the first value like you have on the other values. By the way, this is extremely bad practice and leaves your code open to attack. You should read the article that I gave you a link to in order to find out how to prevent attacks on your code. To summaries the immediate situation, you should use a parameterised query rather than injecting the values directly into the SQL statement.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
I read the article, Thank you...after I get it working I will try to make it safer
|
|
|
|
|
The other point to that article is to make your code easier to debug and FAR less suseptible to your input ACCIDENTLY breaking your code. If the user happens to type an ' or " in those textboxes somewhere, it'll break your code when you try and insert that into the database. Parameterized queries remove that possiblity because the Parameter objects automatically escape these characters so they won't break your SQL code.
SQL attacks, or failure exploits, are not all deliberate, most happen by pure accident. Learn to avoid situations where your code can break by accident now, before bad habits become your normal practice.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I used the System.Console.Out.WriteLine(sqlString); so I could read what valuse are in the statment durning debug...I can't seem to see anything wrong. Just inexperienced and need practice.
|
|
|
|
|
|
Here is the INSERT statment I started with, this is from a previous project and it works fine.
string sqlString = "INSERT INTO Members (MemberNum, FirstName, LastName, Address, City, Province, PostalCode, Status, Balance ) VALUES ("
+ newNum.ToString()
+ ",'" + FirstName.Text
+ "','" + LastName.Text
+ "','" + Address.Text
+ "','" + City.Text
+ "','" + comboBox1.Text
+ "','" + PostalCode.Text.ToUpper()
+ "','" + GetMemberStatus()
+ "'," + BalanceOwing.Text
+ ")";
and the db information
MemberNum (autonumber)
LastName (text)
FirstName (text)
Address (text)
City (text)
Province (text)
PostalCode (text)
Status (text)
Balance (number)
Sorry to be so much trouble and thanks for your time
|
|
|
|
|
Here is my current statment
string sqlString = "INSERT INTO Cafe (CustomerNumber, FirstName, LastName, Address, City, Province, PostalCode, PhoneNumber, UserName, Password, TimePurchased ) VALUES ("
+ newNum.ToString()
+ ",'" + FirstNameTxt.Text
+ "','" + LastNameTxt.Text
+ "','" + AddressTxt.Text
+ "','" + CityTxt.Text
+ "','" + ProvinceTxt.Text
+ "','" + PostalCodeTxt.Text.ToUpper()
+ "','" + PhoneNumTxt.Text
+ "','" + UserNameTxt.Text
+ "','" + PasswordTxt.Text
+ "'," + TimePurchaseTxt.Text
+ ")";
and my current db
CustomerNumber (autonumber)
FirstName (Text) //Bill
LastName (Text) //Ray
Address (Text) //anystreet
City (Text) //Hometown
Province (Text) //Ont
PostalCode (Text) //N5BY4G
PhoneNumber (Number) //123456
UserName (Text) //Rbill
Password (Text) //whatever
TimePurchased (Number) //1
I how\pe this helps
|
|
|
|
|