Hello sir.. I could make it work thank you. I have one more question
though.
I am writing some code in Page_Load event
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + "C:\Test\App_Data" + "\Northwind.mdb;Persist Security
Info=True"
Dim MySQL As String = "Select * from [Order Details] Where
OrderID =" & mOrderID
Dim MyConn As New System.Data.OleDb.OleDbConnection(strConn)
Dim objDR As System.Data.OleDb.OleDbDataReader
'Dim Cmd As New System.Data.OleDb.OleDbCommand(MySQL)
Dim Cmd As New System.Data.OleDb.OleDbCommand(MySQL, MyConn)
MyConn.Open()
Here how I could use connection string from web.config. So that I dont
have redclare it heere one more time?
csn I use
Dim MyConn As New
System.Data.OleDb.OleDbConnection(TestNorthwindCon nectionString)--where
"TestNorthwindConnectionString" is connection string specified in
web.config.?
Ray Booysen wrote:
Can you post your code and the line that fails?
BB wrote: Ok..this is diffcult to explain. Let me try again...Sorry about that.
I did mention what error I get before.
I get an error saying "Data type error in expression" . If you have
chance to watch that video example I mentioned before. You would see
example of filtering dataset on "State" field . I noticed field type of
state field is string. But when I try to do samething for OrderID field
in "Order Dteails" table OrderID datatype is Long Integer. Is that why
I get that error? How you pass parameters to dataset that have numeric
datatype?
know what I mean?
Juan T. Llibre wrote: It would help if, instead of a general "what's wrong?" post, you wouldpost
the exact text of the error returned and the source code segment to which
the error message points to.
Please snip out any non-essential code.
Only post the error text and the several lines of code that the error points to.
Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"BB" <sh******@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
Hi,
I am trying to create test web page using tutorial
http://download.microsoft.com/downlo...data_final.wmv
I am using northwind.mdb as data source. I am creating simple page
displaying orderid in combobox and displaying corrosponding
orderdetials in grid view. Now when I try to pass parameter to [Order
Details].orderid it gives me type mismatch error.I am just trying to do
same thing as in video example. Any idea what am I doing wrong?
Please Help!!