[Cat_FYP]

heya,

To anyone that can help, I would be eternally grateful!!
I need to extract information from a table in a database using ASP.Net and VB script. So far, I have tried

dim intNumber

int (intNumber)

objectConn.Open()

intNumber = (int) cmd.ExecuteScalar();
'number = cByte (cmd.ExecuteScalar())

objConn.Close()

but I keep getting an error saying that int can't handle that number of arguments. I've tried loads of things but keep ending back where I started.
I need to extract a specific column from a table in my database and then convert that to a string if possible.

Help please!!

[Shane]

Code:

'//Import namespaces
using System.Data;
using System.Data.SqlClient;
 
// main code
// create connection object. This is used to store your connection.
SqlConnection conn = new SqlConnection("CONNECTION STRING HERE");
 
// create command object. This object contains sql command info.
SqlCommand cmd = new SqlCommand("select number from table",conn);
 
int number;
 
// open the connection
conn.Open();
 
// execute scalar and return one value. If you're trying to return
// more than one record, then use the SqlDataReader, not the scalar.
number = Convert.ToInt32(cmd.ExecuteScalar());
 
// close
conn.Close();

Originally Posted by Cat_FYP

heya,

To anyone that can help, I would be eternally grateful!!
I need to extract information from a table in a database using ASP.Net and VB script. So far, I have tried

dim intNumber

int (intNumber)

objectConn.Open()

intNumber = (int) cmd.ExecuteScalar();
'number = cByte (cmd.ExecuteScalar())

objConn.Close()

but I keep getting an error saying that int can't handle that number of arguments. I've tried loads of things but keep ending back where I started.
I need to extract a specific column from a table in my database and then convert that to a string if possible.

Help please!!

[Cat_FYP]

Thanks for the help. Much appreciated!!

Originally Posted by Shane

Code:

'//Import namespaces
using System.Data;
using System.Data.SqlClient;
 
// main code
// create connection object. This is used to store your connection.
SqlConnection conn = new SqlConnection("CONNECTION STRING HERE");
 
// create command object. This object contains sql command info.
SqlCommand cmd = new SqlCommand("select number from table",conn);
 
int number;
 
// open the connection
conn.Open();
 
// execute scalar and return one value. If you're trying to return
// more than one record, then use the SqlDataReader, not the scalar.
number = Convert.ToInt32(cmd.ExecuteScalar());
 
// close
conn.Close();