Hi All,

Please someone help to insert data into the database.

In my code I've written a function for data insertion.

Now this function  must return some value so I'm stating it as:

 int var=sqlcmd.ExecuteNonQuery();

and then closing the connection.

But the above statement throws the exception as it is unable to convert String variable to Guid even though I'm not using Guid anywhere all through my code.

Thanking you in anticipation. 

 you have written a db funcation to insert data or  c#??

hi,

 I think u shoude use sqlcmd.ExecuteNonQuery() rather than assigning it to a variable..Because  ExecuteNonQuery doesnot return anything..

cheers mate

Hi,
 ExecuteNonQuery returns number of rows affected.
if your store proc is like this and you are genataring pk automatically on an insert

e.g.

Insert Into XYZ(col1) values(@value1)

select @@Identity  

then you can execute scalar

int id = Convert.ToInt32(command.ExecuteScalar());

It gave me an InvalidCastException with the explaination: Failed to convert parameter value from a String to a Guid.

This is the same exception I was getting when I was using ExecuteNonQuery(). 

I have written a C# function which inserts the data from textboxes into the database table.

I'm getting InvalidCastException. Please someone help me..

Keep Coding.

Please post your  code  ,  so  as  to  help  you   out.........

public bool InsertUserDetails(String psUID, String psFirstName, String psLastName)

vsqlcmd.CommandType = CommandType.Text;

SqlParameter vpUserId = new SqlParameter();

vpUserId.SqlDbType = SqlDbType.UniqueIdentifier;

vpFirstName.ParameterName = "@FirstName";

vpLastName.ParameterName = "@LastName";

else

hi,

        Use try catch whenever you are transacting with the database....ExecuteNonQuery return value is a boolean so use that type .

cheers

elegantkvc:

ExecuteNonQuery return value is a boolean so use that type .

ExecuteNonQuery doesn't return a boolean, it returns an int value for the number of rows affected by the query.

The problem probably lies with the UserID parameter which is set to a type of SqlDbType.UniqueIdentifier. Check the value you're setting this parameter to.

Surely ExecuteNonQuery returns int value and I'm passing a String value to the UserID field.

Hi Namrata

Please change

vpUserId.SqlDbType = SqlDbType.UniqueIdentifier;

to

vpUserId.SqlDbType = SqlDbType.Varchar.

Should solve your problem. Hope this helps.

To be exact when you do the following:

vpUserId.ParameterName = "@UserId";

ParameterDirection.Output;

Thank you this change has made my code working.