Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C# Update method from Form to DataClass
Message
From
09/11/2004 19:41:27
 
General information
Forum:
ASP.NET
Category:
Web forms
Environment versions
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00959753
Message ID:
00959819
Views:
10
This message has been marked as the solution to the initial question of the thread.
Tom,

Your UpdateUser() method is expecting parameters of type User, but you're sending it a string. But, there's an easy solution ... overload your method. Try this:
public void UpdateUser(string UserID, string FirstName)
{
   User oUser = new User();
   oUser.UserID = UserID;
   oUser.FirstName = FirstName;

   this.UpdateUser(oUser);
}

public void UpdateUser(User UserID,User FirstName)
{
 // etc.etc. as you already have it coded.
}
~~Bonnie



>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
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform