Click here to Skip to main content
15,915,513 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionHow to Pop up window base on Already Pop up Dialog? Pin
pubududilena13-Sep-06 17:27
pubududilena13-Sep-06 17:27 
AnswerRe: How to Pop up window base on Already Pop up Dialog? Pin
mbbisht13-Sep-06 18:26
mbbisht13-Sep-06 18:26 
QuestionCreating new Web on SharePoint server Pin
serious-sam13-Sep-06 16:04
serious-sam13-Sep-06 16:04 
Questionasp.net dropdownlist errors Pin
bdc60413-Sep-06 14:33
bdc60413-Sep-06 14:33 
AnswerRe: asp.net dropdownlist errors Pin
kiran kumar[Intelligroup]13-Sep-06 18:38
kiran kumar[Intelligroup]13-Sep-06 18:38 
QuestionXML Parsing Error: no element found Pin
FinnGrimw13-Sep-06 13:13
FinnGrimw13-Sep-06 13:13 
AnswerRe: XML Parsing Error: no element found Pin
kiran kumar[Intelligroup]13-Sep-06 18:46
kiran kumar[Intelligroup]13-Sep-06 18:46 
QuestionSelect Record Pin
shapper13-Sep-06 9:37
shapper13-Sep-06 9:37 
Hello,

I have two tables in an Access database: content and content_localized which are related.

I created a query:

SELECT content_localized.content_html
FROM content INNER JOIN content_localized ON content.content_id = content_localized.content_id
WHERE (((content.content_page)=[@Page]) AND ((content.content_name)=[@Name]) AND ((content_localized.content_culture)=[@Culture]));

I tested it in Microsoft Access and it is working fine.

Then I tried to retrieve its value from my web site but nothing shows up.

I am using the following code:

' Set Connection
Dim connectionString As String = ConfigurationManager.ConnectionStrings(_ConnectionString).ConnectionString
Dim connection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)

' Set Command
Dim command As New System.Data.OleDb.OleDbCommand
command.CommandText = "content_SELECT"
command.Connection = connection
command.CommandType = CommandType.StoredProcedure

' Add Parameters
command.Parameters.Add(New OleDb.OleDbParameter("@Culture", _Culture))
command.Parameters.Add(New OleDb.OleDbParameter("@Page", _Page))
command.Parameters.Add(New OleDb.OleDbParameter("@Name", _Name))

' Execute the Command
connection.Open()
Dim contentHtml As OleDb.OleDbDataReader = command.ExecuteReader
If contentHtml.Read Then
Return contentHtml.Item("content_html").ToString()
Else
Return "Error" ***
End If
contentHtml.Close()
connection.Close()

My function returns "Error" from line ***

Does anyone has an idea what might be wrong?

Thank You,

Miguel
AnswerRe: Select Record Pin
Amit Kumar G13-Sep-06 16:36
Amit Kumar G13-Sep-06 16:36 
GeneralRe: Select Record Pin
shapper14-Sep-06 1:36
shapper14-Sep-06 1:36 
QuestionVS 2005 and SharePoint webpart development Pin
student_rhr13-Sep-06 9:31
student_rhr13-Sep-06 9:31 
Questionapplication web Pin
raquidd2213-Sep-06 9:10
raquidd2213-Sep-06 9:10 
AnswerRe: application web Pin
_AK_13-Sep-06 22:16
_AK_13-Sep-06 22:16 
GeneralRe: application web Pin
raquidd2215-Sep-06 11:54
raquidd2215-Sep-06 11:54 
QuestionIs this Dynamic HTML Pin
Amit Kumar G13-Sep-06 8:34
Amit Kumar G13-Sep-06 8:34 
AnswerRe: Is this Dynamic HTML Pin
Guffa13-Sep-06 9:32
Guffa13-Sep-06 9:32 
GeneralRe: Is this Dynamic HTML Pin
Amit Kumar G13-Sep-06 10:12
Amit Kumar G13-Sep-06 10:12 
AnswerRe: Is this Dynamic HTML Pin
Guffa13-Sep-06 10:42
Guffa13-Sep-06 10:42 
QuestionHow to insert data into Table ? Pin
hdv21213-Sep-06 7:50
hdv21213-Sep-06 7:50 
AnswerRe: How to insert data into Table ? Pin
Sathesh Sakthivel13-Sep-06 17:41
Sathesh Sakthivel13-Sep-06 17:41 
Questionscriptx example in c# Pin
Steve-o H.13-Sep-06 7:46
Steve-o H.13-Sep-06 7:46 
QuestionSecured Socket Layers Pin
amaneet13-Sep-06 6:41
amaneet13-Sep-06 6:41 
AnswerRe: Secured Socket Layers Pin
_AK_13-Sep-06 6:55
_AK_13-Sep-06 6:55 
GeneralRe: Secured Socket Layers Pin
amaneet13-Sep-06 7:48
amaneet13-Sep-06 7:48 
QuestionQueryString problem Pin
vijayaBTS13-Sep-06 6:36
vijayaBTS13-Sep-06 6:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.