System.FormatEx ception: Input String was not in a correct format.

[sbox]

I've got an error "System.FormatE xception: Input string was not in a correct
format." while I'm implementing a datagrid and a textbox
What's wrong with it?

Sub Button1_Click(s ender As Object, e As EventArgs)
DataGrid1.DataS ource = MyQueryMethod(C Int(TextBox1.Te xt))
DataGrid1.DataB ind()
End Sub

Function MyQueryMethod(B yVal others As String) As System.Data.Dat aSet
Dim connectionStrin g As String = "server='localh ost'; user id='******';
password='***** *'; database='***** *'"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Sql Client.SqlConne ction(connectio nString)
Dim queryString As String = "SELECT [Software].* FROM [Software] WHERE
([Software].[Others] like @Others)"
Dim dbCommand As System.Data.IDb Command = New
System.Data.Sql Client.SqlComma nd
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dbParam_others As System.Data.IDa taParameter = New
System.Data.Sql Client.SqlParam eter
dbParam_others. ParameterName = "@Others" dbParam_others. Value = others
dbParam_others. DbType = System.Data.DbT ype.String
dbCommand.Param eters.Add(dbPar am_others)

Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Sql Client.SqlDataA dapter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet
dataAdapter.Fil l(dataSet)
Return dataSet

End Function

[Darrin J Olson]

I would guess it is something to do with converting the TextBox1.Text to an
int data type. The textbox could potentially contain a value other than a
numeric value. This would cause this error. Also, MyQueryMethod looks like
it is expecting a value of a string data type. Since you are converting
TextBox1.Text to an int type, this may also cause the error.

-Darrin
"sbox" <s@b.x> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

I've got an error "System.FormatE xception: Input string was not in a correct format." while I'm implementing a datagrid and a textbox
What's wrong with it?

Sub Button1_Click(s ender As Object, e As EventArgs)
DataGrid1.DataS ource = MyQueryMethod(C Int(TextBox1.Te xt))
DataGrid1.DataB ind()
End Sub

Function MyQueryMethod(B yVal others As String) As System.Data.Dat aSet
Dim connectionStrin g As String = "server='localh ost'; user id='******'; password='***** *'; database='***** *'"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Sql Client.SqlConne ction(connectio nString)
Dim queryString As String = "SELECT [Software].* FROM [Software] WHERE
([Software].[Others] like @Others)"
Dim dbCommand As System.Data.IDb Command = New
System.Data.Sql Client.SqlComma nd
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dbParam_others As System.Data.IDa taParameter = New
System.Data.Sql Client.SqlParam eter
dbParam_others. ParameterName = "@Others" dbParam_others. Value = others
dbParam_others. DbType = System.Data.DbT ype.String
dbCommand.Param eters.Add(dbPar am_others)

Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Sql Client.SqlDataA dapter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet
dataAdapter.Fil l(dataSet)
Return dataSet

End Function

[Ben Miller [MSFT]]

You should not have the ' ' in your connection string. Take a look at the
connection strings at

http://www.able-consulting.com/dotne...anagedProvider

Ben Miller

--
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

"sbox" <s@b.x> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

I've got an error "System.FormatE xception: Input string was not in a correct format." while I'm implementing a datagrid and a textbox
What's wrong with it?

Sub Button1_Click(s ender As Object, e As EventArgs)
DataGrid1.DataS ource = MyQueryMethod(C Int(TextBox1.Te xt))
DataGrid1.DataB ind()
End Sub

Function MyQueryMethod(B yVal others As String) As System.Data.Dat aSet
Dim connectionStrin g As String = "server='localh ost'; user id='******'; password='***** *'; database='***** *'"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Sql Client.SqlConne ction(connectio nString)
Dim queryString As String = "SELECT [Software].* FROM [Software] WHERE
([Software].[Others] like @Others)"
Dim dbCommand As System.Data.IDb Command = New
System.Data.Sql Client.SqlComma nd
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dbParam_others As System.Data.IDa taParameter = New
System.Data.Sql Client.SqlParam eter
dbParam_others. ParameterName = "@Others" dbParam_others. Value = others
dbParam_others. DbType = System.Data.DbT ype.String
dbCommand.Param eters.Add(dbPar am_others)

Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Sql Client.SqlDataA dapter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet
dataAdapter.Fil l(dataSet)
Return dataSet

End Function