|
Hello Amit,
That is the point. I don't get any error.
Well, at least I am not seing it.
I also tried with "While..." and I get no returned value.
I tested the query, in Microsoft Access, with the parameters values which I show here and I get one result. However, my function doesn't return anything with those values.
The code I have now is as follows:
Public Function Load()
' Set Connection
Dim connectionString As String = ConfigurationManager.ConnectionStrings(_ConnectionString).ConnectionString
Dim connection As New System.Data.OleDb.OleDbConnection(connectionString)
' Set Command
Dim command As New System.Data.OleDb.OleDbCommand
With command
.CommandText = "EXECUTE content_SELECT"
.Connection = connection
.CommandType = CommandType.Text
End With
' Add Parameters
With command.Parameters
.Add(New OleDb.OleDbParameter("[@Culture]", "pt-PT"))
.Add(New OleDb.OleDbParameter("[@Page]", "Default.aspx"))
.Add(New OleDb.OleDbParameter("[@Name]", "Newsletter"))
End With
' Execute the Command
connection.Open()
Dim contentHtml As OleDb.OleDbDataReader = command.ExecuteReader
If contentHtml.Read Then
Return contentHtml.Item("content_html").ToString()
Else
Return "Not Found"
End If
contentHtml.Close()
connection.Close()
End Function
Any idea of might be going on or a way to try to figure this out?
Thanks,
Miguel
|
|
|
|
|
I am needing to create WebParts for SharePoint Services using VS 2005 Pro. I currently do not have Microsoft.SharePoint.dll on my PC as I am running XP and not server 2003.
My first question is: Is it possible to create webparts for sharepoint services using VS 2005 Pro because all the articles i could find were mentioning using Microsoft.SharePoint.dll with VS 2003.
Secondly, can I create user control (.ascx) and use it in SharePoint Servics?
Any help will be appreciated. Thanks.
|
|
|
|
|
hello
someone can help me
someone know article that help me to make a good data access layer use data access application block
i know how encapsulation this part is very important i wish to learn how encapsulation
encapsulating common functionality so i will reduce the number of lines of code in me DAL
thanks for the time
|
|
|
|
|
|
thank i will be check the article
|
|
|
|
|
I know dynamic HTML is when we create html on fly. Can I say I know DHTML if I am doing some operation in code behind file where I am building some string as below
In Code Behind page
Dim a as string
a= DataSet.Table(0).row + “<Br>” + DataSet.Table(1).row + “<a href=amit.aspx>”
return a
In Html Page
<%=a%>
Please ignore syntax. As I am just trying to understand what terminology is used for above type of operation i.e where i am mixing html and server code?
Amit
Amit
|
|
|
|
|
Amit Kumar G wrote: I know dynamic HTML is when we create html on fly.
No, it's not. DHTML is basically using client scripts (e.g. Javascript) with HTML.
What you are doing is creating HTML code dynamically. That doesn't make the HTML code dynamic.
---
b { font-weight: normal; }
|
|
|
|
|
can you give me some real time example of DHTML.....it would be gr8 help to understand.
Amit
|
|
|
|
|
Typically DHTML is used to make things happen when the user interacts with the web page. Example:
<span onmouseover="this.style.color='#999';" onmouseout="this.style.color='';">Point here</span>
---
b { font-weight: normal; }
|
|
|
|
|
hi
i have 3 textbox in my webform (email,subject,description) and i use sqldatasource and asp.net 2.0 and c# .
how to insert textboxs.text values into my table (comments) with sqldatasource ?
and how to (update,delete) also ??
Please give me a full description with example because i am beginner .
thanks.
|
|
|
|
|
Hi,
Hope this article will help you.
[^]
Happy Coding
With Regards
Satips
|
|
|
|
|
Hello,
I downloaded the 3rd party program called Scriptx. It is a program that allows control over printing out of a browser. I need this in order to remove the header and footer on IE. My only issue is that the help documents dont really show me how i am suppose to use this program.
Has anyone had experience using this and can you show me how you used it in C#?
Thanks
Steve-o H.
There are 10 kinds of people in this world... Those who understand binary and those who dont.
|
|
|
|
|
Sir,
What are Secured Socket Layers .I want to implement it in the project.(an online project).
Please help.
Thanks
|
|
|
|
|
|
Can i get a code project linkin vb.net with asp.net that uses the Secure Sockets Layer (SSL)?
|
|
|
|
|
Hi All,
Iam facing problem with passing query string to page from javascript ,
for some times it was returning null value eventhough assigning the query string form javascript.
Any Help is appreciated.
Many Thanks,
Vijaya
vijaya
|
|
|
|
|
Can i see the input string .I mean ur query string.
|
|
|
|
|
Then you are most likely doing it wrong.
If you show some code it might be possible to say something of what you might be doing wrong.
---
b { font-weight: normal; }
|
|
|
|
|
Hi there,
I Am writing the security for my site based around Active Directory using ASP .NET 2.0 and the membership class. I have it all working and the configuration too to link to AD and add users etc... the only problem is that I have to validate using the URI and not cookies... no matter what I do a cookie is not created and creates a constant loop of the login page. If I change the cookieless property to 'URI' as opposed to 'UseCookies' in the membership - providers - add section of the web.config then it works fine but the authorisation key is in the URI of the browser I am using.
Could anyone throw any light on why this is causing me a problem? If I use the Page.Request.Browser.Cookies method to see if the browser supports cookies it returns true.
Thanks,
Adam Smith
|
|
|
|
|
How to Validate a login form using asp.net?
|
|
|
|
|
Hi,
Using the Required Field Validator,and the Regular Expression Validator we can validate the login form .
Otherwise go with the inbuilt Login Control in Asp.Net2.0
Happy Coding
With Regards
Satips
|
|
|
|
|
I just bought a new computer and I install visual studio express last night. Is there an easy way to take the site I developed locally on my previous computer and transport it to my new computer. The site before was developed in VS 2003. I have no problem getting the site from one computer to another but I am curious what all I need to transfer. Anyone have any clue?
|
|
|
|
|
Not shure for Express but regular VS has a conversion wizard which fiers automaticlly when you open a ASP.NET 1.1 application in it.
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
So when I should put my previous website in the webroot folder and put the solution in the 2005 Visual Studio folder? Then when I try to use my project it should convert automatically?
|
|
|
|
|
HI
Guys i posted the same question few days ago but i couldn't get the satisfactory answer , my question is , if i am using the data base to autheniticate the user name and password in ASP.NET, then what are the purpose of authentication modes in ASP.Net e.g. which are Windows,form,passport and none, can any one let me know the purpose of these authentication modes,by default which is windows in ASP.NET 1.1. plz reply ASAP with example,thankx in advance.
|
|
|
|