error while retrieving data from database on windows form application

Question

trying to retrieve some data from the database and put in into my form. the code goes

notificationList.Add(new notificationForm(
            (String)dataset.Tables["alertdetails"].Rows[0]["memberName"],
            (String)dataset.Tables["alertdetails"].Rows[0]["locationName"],
            (String)dataset.Tables["alertdetails"].Rows[0]["photo"],
            "",
            (String)dataset.Tables["alertdetails"].Rows[0]["memberid"], 
            "",
            "", x, y, alertId));

the arguments for my notificationForm is

public notificationForm(String name, String location, String imageExtension,
                        String alertType,String memberid,String date,String time,
                        int x,int y,String alertid)

the error goes

Unable to cast object of type 'System.Int32' to type 'System.String'.

on the line whereby i retrieve memberid. anyone know how to fix that? it works fine for memberName, locationName and photo though.

eeerahul · Accepted Answer · 2011-12-08 10:38:02Z

1

dataset.Tables["alertdetails"].Rows[0]["memberid"]

gives you the integer value, if the datatype of memberid in the database is int. Then, either add ToString() at the end or cast it to an int.

Example:

dataset.Tables["alertdetails"].Rows[0]["memberid"].ToString()
                      OR
Convert.ToInt32(dataset.Tables["alertdetails"].Rows[0]["memberid"])

edited Dec 8, 2011 at 10:38

eeerahul

1,6254 gold badges27 silver badges41 bronze badges

answered Dec 8, 2011 at 10:11

Stone Cold

2162 gold badges6 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mitch Wheat · Accepted Answer · 2011-12-08 10:06:31Z

0

Cast it to an int (32bit integer), which is what the error message is telling you.

Check the type of 'memberid' column in the database table. Presumably it is an integer.

answered Dec 8, 2011 at 10:06

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Collectives™ on Stack Overflow

error while retrieving data from database on windows form application

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related