Tutorial Video

[BB]

Hi,
I am trying to create test web page using tutorial

http://download.microsoft.com/downl...92-499f-8219-0d326f13bf18/hilo_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!!

 

[Juan T. Llibre]

It would help if, instead of a general "what's wrong?" post, you would post
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]

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?

It would help if, instead of a general "what's wrong?" post, you would post
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/
===================================

Hi,
I am trying to create test web page using tutorial

http://download.microsoft.com/downl...92-499f-8219-0d326f13bf18/hilo_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!!

 

[Ray Booysen]

Can you post your code and the line that fails?

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?

It would help if, instead of a general "what's wrong?" post, you would post
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/
===================================

Hi,
I am trying to create test web page using tutorial

http://download.microsoft.com/downl...92-499f-8219-0d326f13bf18/hilo_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!!

 

[BB]

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(TestNorthwindConnectionString)--where
"TestNorthwindConnectionString" is connection string specified in
web.config.?

Can you post your code and the line that fails?

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?

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/
===================================
Hi,
I am trying to create test web page using tutorial

http://download.microsoft.com/downl...92-499f-8219-0d326f13bf18/hilo_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!!