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=Micro soft.Jet.OLEDB. 4.0;Data
Source=" + "C:\Test\App_Da ta" + "\Northwind.mdb ;Persist Security
Info=True"
Dim MySQL As String = "Select * from [Order Details] Where
OrderID =" & mOrderID
Dim MyConn As New System.Data.Ole Db.OleDbConnect ion(strConn)
Dim objDR As System.Data.Ole Db.OleDbDataRea der
'Dim Cmd As New System.Data.Ole Db.OleDbCommand (MySQL)
Dim Cmd As New System.Data.Ole Db.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.Ole Db.OleDbConnect ion(TestNorthwi ndConnectionStr ing)--where
"TestNorthwindC onnectionString " 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.goo glegroups.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!!