Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C# Update method from Form to DataClass
Message
 
To
All
General information
Forum:
ASP.NET
Category:
Web forms
Title:
C# Update method from Form to DataClass
Environment versions
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00959753
Message ID:
00959753
Views:
43
I have a small application in VB.NET that works and now I am converting it to C#.

I am trying to create an Update Function using C#. The Form makes a call to my Data Class.

In the Form’s Update Function:
private string UserID;
private string FirstName;

UserID = txtUserID.Text;
FirstName = txtFirstName.Text;

ScrapDB.UpdateUser(UserID, FirstName); // I am not sure of this part!  It throws these errors: 
Errors:
1. c:\inetpub\wwwroot\eScrap_C\Users.aspx.cs(85): Argument '1': cannot convert from 'string' to 'eScrap_C.ScrapDB.User'

2. c:\inetpub\wwwroot\eScrap_C\Users.aspx.cs(85): Argument '2': cannot convert from 'string' to 'eScrap_C.ScrapDB.User'


ScrapDB.cs
public class User
		{
			public string UserID;
			public string FirstName;
			public string LastName;
			public string PhoneExt;
			public string DepartmentCode;
			public string PositionName;

		}

public void UpdateUser(User UserID,User FirstName)

SqlConnection UpdateUserConnection = GetConnection();
{
		
			string UpdateStatement	= "UPDATE UserInfo SET  "
				+ "UserID = @UserID, "
				+ "FirstName = @FirstName ";

SqlCommand UpdateCommand = new SqlCommand(UpdateStatement, UpdateUserConnection);
UpdateCommand.Parameters.Add("@UserID", UserID);
UpdateCommand.Parameters.Add("@FirstName", FirstName);
		
UpdateUserConnection.Open();

UpdateCommand.ExecuteNonQuery();
UpdateUserConnection.Close();
}
Any suggestion are most welcomed!

Tom
Next
Reply
Map
View

Click here to load this message in the networking platform