C# Sql INSERT statment - C# Discussion Boards

chilberto9-Jun-05 0:53

9-Jun-05 0:53

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

Re: Web Service shared class definition

NassosReyzidis14-Jun-05 1:27

NassosReyzidis

14-Jun-05 1:27

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

accessing HID + c#

g00fyman8-Jun-05 23:54

g00fyman

8-Jun-05 23:54

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

Re: accessing HID + c#

Dave Kreskowiak9-Jun-05 6:45

Dave Kreskowiak

9-Jun-05 6:45

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

Re: accessing HID + c#

g00fyman9-Jun-05 18:54

g00fyman

9-Jun-05 18:54

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

Re: accessing HID + c#

Dave Kreskowiak10-Jun-05 1:29

Dave Kreskowiak

10-Jun-05 1:29

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

Re: accessing HID + c#

g00fyman10-Jun-05 1:35

g00fyman

10-Jun-05 1:35

thank you for all your help

regards

g00fy

C# Sql INSERT statment

Rinventive8-Jun-05 23:33

Rinventive

8-Jun-05 23:33

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