Click here to Skip to main content
15,861,168 members
Home / Discussions / C#
   

C#

 
GeneralC# - Multidimensionnal array of pointers Pin
Orahn18-Jan-04 7:05
Orahn18-Jan-04 7:05 
GeneralRe: C# - Multidimensionnal array of pointers Pin
leppie18-Jan-04 10:04
leppie18-Jan-04 10:04 
GeneralRe: C# - Multidimensionnal array of pointers Pin
Orahn18-Jan-04 10:09
Orahn18-Jan-04 10:09 
GeneralRe: C# - Multidimensionnal array of pointers Pin
leppie18-Jan-04 10:13
leppie18-Jan-04 10:13 
GeneralRe: C# - Multidimensionnal array of pointers Pin
Heath Stewart18-Jan-04 11:49
protectorHeath Stewart18-Jan-04 11:49 
GeneralRe: C# - Multidimensionnal array of pointers Pin
Orahn18-Jan-04 18:58
Orahn18-Jan-04 18:58 
GeneralRe: C# - Multidimensionnal array of pointers Pin
pat2918-Jan-04 18:58
pat2918-Jan-04 18:58 
GeneralExecuteNonQuery() problem in C# Pin
Qamarwis18-Jan-04 5:10
Qamarwis18-Jan-04 5:10 
Hi!
I am developing a web application in asp.net using C# code with sql server 2000 as a db server. I take input from user an populate it in db.now i have problem when i try to insert data in db.
my code is as follows:
SqlConnection myConnection;
private void Page_Load(object sender, System.EventArgs e)
{
myConnection = new SqlConnection("Server=AKRAM;uid=sa;pwd=mypwd;database=HRIS");

Label1.Text="";

}
private void btnSubmit_Click(object sender, System.EventArgs e)
{

String strInsert = "insert into User(UserID,Password,UserType,"+
" FirstName,LastName,Age,Gender,Phone,Fax,Email,URL,"+
" Address,City,State,Country) values (@UserID," +
" @Password, @UserType, @FirstName, @LastName, @Age, " +
" @Gender, @Phone, @Fax, @Email, @URL, @Address, @City, @State," +
" @Country)";

SqlCommand insCommand = new SqlCommand(strInsert, myConnection);
// Create new parameters for the SqlCommand object and
// initialize them to the input-form field values.
insCommand.Parameters.Add(new SqlParameter("@UserID", SqlDbType.VarChar, 20));
insCommand.Parameters["@UserID"].Value = txtID.Text;

insCommand.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar, 20));
insCommand.Parameters["@Password"].Value = txtPassword.Text;
and so on i provide values to the parameters.
insCommand.Connection.Open()
but following stament comes, error is generated:
insCommand.ExecuteNonQuery();
..
..
..
I m unable to figure out the problem. Can any body help me...

Waiting 4 reply..
GeneralRe: ExecuteNonQuery() problem in C# Pin
Nick Parker18-Jan-04 5:39
protectorNick Parker18-Jan-04 5:39 
GeneralRe: ExecuteNonQuery() problem in C# Pin
Guillermo Rivero18-Jan-04 6:58
Guillermo Rivero18-Jan-04 6:58 
GeneralRe: ExecuteNonQuery() problem in C# Pin
india_nagpur118-Jan-04 20:04
india_nagpur118-Jan-04 20:04 
GeneralCustomCollection + Auto code generation in designer Pin
James Simpson18-Jan-04 3:05
James Simpson18-Jan-04 3:05 
GeneralRe: CustomCollection + Auto code generation in designer Pin
Heath Stewart18-Jan-04 11:45
protectorHeath Stewart18-Jan-04 11:45 
GeneralRe: CustomCollection + Auto code generation in designer Pin
James Simpson18-Jan-04 11:50
James Simpson18-Jan-04 11:50 
Generalado.net Pin
Roger Alsing18-Jan-04 1:30
Roger Alsing18-Jan-04 1:30 
GeneralRe: ado.net Pin
Arjan Einbu18-Jan-04 4:10
Arjan Einbu18-Jan-04 4:10 
GeneralRe: ado.net Pin
Heath Stewart18-Jan-04 11:31
protectorHeath Stewart18-Jan-04 11:31 
Generalcreating a dll with win32 functions, and calling it from C# Pin
misterbear17-Jan-04 23:52
misterbear17-Jan-04 23:52 
GeneralRe: creating a dll with win32 functions, and calling it from C# Pin
Nick Parker18-Jan-04 5:47
protectorNick Parker18-Jan-04 5:47 
GeneralRe: creating a dll with win32 functions, and calling it from C# Pin
leppie18-Jan-04 6:15
leppie18-Jan-04 6:15 
GeneralRe: creating a dll with win32 functions, and calling it from C# Pin
Heath Stewart18-Jan-04 11:24
protectorHeath Stewart18-Jan-04 11:24 
GeneralRe: creating a dll with win32 functions, and calling it from C# Pin
misterbear20-Jan-04 6:51
misterbear20-Jan-04 6:51 
GeneralRe: creating a dll with win32 functions, and calling it from C# Pin
Heath Stewart20-Jan-04 8:24
protectorHeath Stewart20-Jan-04 8:24 
GeneralWeb Service Question Pin
Mazdak17-Jan-04 20:25
Mazdak17-Jan-04 20:25 
GeneralRe: Web Service Question Pin
Heath Stewart18-Jan-04 11:19
protectorHeath Stewart18-Jan-04 11:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.