ASP.NET Discussion Boards

musigati17-Apr-07 9:03

17-Apr-07 9:03

I am new to ASP.NET
I am working on something as example but get a connectionstring not initialize problem and can't solve it.
Any help?

Thanks

This is all the files i have web config file, default.aspx ,default.aspx.vb and class.vb

Web.Conf
*********

<configuration>
<connectionstrings>
<add name="ConnectionString" connectionstring="Dsn=Photobank;uid=adminphotobank;pwd=adminphotobank"
="" providername="System.Data.Odbc">

<appsettings>
<add key="photobankConnectionString" value="packet size=4096;user id=bank;data source=ODBC.SQL.photo;persist security info=False;initial catalog=bank;password=bank">

<system.web>

<compilation debug="true" strict="false" explicit="true">
<pages>
<namespaces>
<clear>
<add namespace="System">
<add namespace="System.Collections">
<add namespace="System.Collections.Specialized">
<add namespace="System.Configuration">
<add namespace="System.Text">
<add namespace="System.Text.RegularExpressions">
<add namespace="System.Web">
<add namespace="System.Web.Caching">
<add namespace="System.Web.SessionState">
<add namespace="System.Web.Security">
<add namespace="System.Web.Profile">
<add namespace="System.Web.UI">
<add namespace="System.Web.UI.WebControls">
<add namespace="System.Web.UI.WebControls.WebParts">
<add namespace="System.Web.UI.HtmlControls">

<authentication mode="Windows">

******************************************
default.aspx.vb

Imports System.IO
Imports System.IO.Path
Imports System.Web.UI.Page
Imports System.Data.DataSet
Imports System.Data.DataTable
Imports System.Data.SqlClient

Partial Class _Default
Inherits System.Web.UI.Page

#Region " Code généré par le Concepteur Web Form "

'Cet appel est requis par le Concepteur Web Form.
'<system.diagnostics.debuggerstepthrough()>
Private Sub InitializeComponent()
Me.oConn = New System.Data.SqlClient.SqlConnection

End Sub
Protected WithEvents cmdAdvancedSearch As System.Web.UI.WebControls.Button
Protected WithEvents oConn As SqlConnection
Protected WithEvents Button1 As System.Web.UI.WebControls.Button

'REMARQUE : la déclaration d'espace réservé suivante est requise par le Concepteur Web Form.
'Ne pas supprimer ou déplacer.

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN : cet appel de méthode est requis par le Concepteur Web Form
'Ne le modifiez pas en utilisant l'éditeur de code.

InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Placez ici le code utilisateur pour initialiser la page

If Not IsPostBack Then
ViewState("isQuickSearch") = True

FillddList("ddCategory")
End If

End Sub

Public Function FillddList(ByVal ddList As String)
Dim SQLQuery As String 'SQL to fetch Data
Dim FieldText, FieldValue As String 'Name of the columns to add as text and as values...
Dim HeaderItem As New ListItem
Dim SelectAllItem As New ListItem
SQLQuery = ""
FieldText = ""
FieldValue = ""

Select Case ddList
Case "ddCategory"

SQLQuery = "SELECT * FROM CATEGORY ORDER BY " & "DESC E"
FieldText = "DESC E"
FieldValue = "DESC E"

HeaderItem.Value = ""
HeaderItem.Text = "Select a category"

SelectAllItem.Value = ""
SelectAllItem.Text = "All categories"

End Select

Dim Data As SqlDataAdapter = New SqlDataAdapter(SQLQuery, oConn)
Dim Odata As New Data.DataSet()
Data.Fill(Odata) // MY ERROR IS ON THIS LINE: CONNECTION STRING NOT INITIALIZE

Dim xrd As DropDownList = CType(Me.FindControl(ddList), DropDownList)
xrd.DataSource = Odata

xrd.DataTextField = Odata.Tables.Item(0).Columns(FieldText).ToString
xrd.DataValueField = Odata.Tables.Item(0).Columns(FieldValue).ToString

xrd.DataBind()

If SelectAllItem.Text <> "" Then
xrd.Items.Insert(0, SelectAllItem)
End If

If HeaderItem.Text <> "" Then
xrd.Items.Insert(0, HeaderItem)
End If

End Function

End Class

************************************************

default.aspx

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<title>Untitled Page

This is a test

<asp:dropdownlist id="DropDownList1" runat="server" datasourceid="SqlDataSource1"
="" datatextfield="CTGY ID" datavaluefield="DESC E">
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:ConnectionString %>"
="" providername="<%$ ConnectionStrings:ConnectionString.ProviderName %>" selectcommand="SELECT * FROM [ CATEGORY]">

*****************************************

Thanks,

Musigati

Re: ConnectionString

Sandeep Akhare19-Apr-07 1:56

Sandeep Akhare

19-Apr-07 1:56

No Need to Post all your files only post what you want to do and Where is the error And post only code which is showing error
PLease put the code in the code foramt given while posting any code

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: ConnectionString

musigati19-Apr-07 3:01

musigati

19-Apr-07 3:01

Sorry for that.The problem is in the codefile and this stopping me to run the application.
The error is in the aspx.vb code and here is the code: When run the application i got this one:" DArd.Fill(DSrd)--->connectionstring not initialized--<" which means that Dsrd has to be initialized somewhere.The following is the code:

Imports System.IO
Imports System.IO.Path
Imports System.Web.UI.Page
Imports System.Data.DataSet
Imports System.Data.DataTable
Imports System.Data.SqlClient

Partial Class _Default
Inherits System.Web.UI.Page

Public Function FillddList(ByVal ddList As String)
Dim SQLQuery As String 'SQL to fetch Data
Dim FieldText, FieldValue As String 'Name of the columns to add as text and as values...
Dim HeaderItem As New ListItem
Dim SelectAllItem As New ListItem
SQLQuery = ""
FieldText = ""
FieldValue = ""

Select Case ddList
Case "ddCategory"

SQLQuery = "SELECT * FROM PHOTOBANK TBL CATEGORY(dbo) ORDER BY " & "DESC E"
FieldText = "DESC E"
FieldValue = "DESC E"

HeaderItem.Value = ""
HeaderItem.Text = "Select a category"

SelectAllItem.Value = ""
SelectAllItem.Text = "All categories"

End Select

Dim DArd As SqlDataAdapter = New SqlDataAdapter(SQLQuery, oConn)
Dim DSrd As New Data.DataSet()
DArd.Fill(DSrd)

Dim xrd As DropDownList = CType(Me.FindControl(ddList), DropDownList)
xrd.DataSource = DSrd

xrd.DataTextField = DSrd.Tables.Item(0).Columns(FieldText).ToString
xrd.DataValueField = DSrd.Tables.Item(0).Columns(FieldValue).ToString

xrd.DataBind()

If SelectAllItem.Text <> "" Then
xrd.Items.Insert(0, SelectAllItem)
End If

If HeaderItem.Text <> "" Then
xrd.Items.Insert(0, HeaderItem)
End If

End Function

End Class

Number of lines in a label control

happyheartcs17-Apr-07 8:47

happyheartcs

17-Apr-07 8:47

Hi everybody,
Does anyone know a way to force the number of lines in a label control.
For example I don't want the number of lines to exceed 4 lines & if the text is longer than that,it gets cut (cuz actually the label is inside a datagrid & I don't want the text to increase & scrolls to appear)

Thanks aloot

Re: Number of lines in a label control

kubben17-Apr-07 14:09

kubben

17-Apr-07 14:09

Sometimes I use a textbox that is set to multiline and change its appearance and make it read only. That way you also get a scroll bar if you go over the lines you want to show.

Hope that helps.
Ben

IIS6 App Mapping problem with .* file extension

TOMCAT8117-Apr-07 6:24

TOMCAT81

17-Apr-07 6:24

Hi,
For the past half an hour i was struggling with IIS6 trying to force all incoming requests to be handled by asp.net (aspnet_isapi.dll). In IIS5, you had to open IIS manager and from website properties select "Home directory/Configuration/Mapping" add a new extension * and point to : C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll

According to help topic it should be the same for IIS6, but when i tried to put * or .* it didn't accept it , and all what i was getting is an error "Wrong extension format".

After almost half an hour i finally figured out that it shoud be added in a bit different way:
from website properties select "Home directory/Configuration/Mapping" and choose Insert instead of Add, under "Executable" enter path to aspnet_isapi.dll
and uncheck "Verify that file exists", otherwise it wont work for folders. Unfortunately this also doesnt help.

In Microsoft's support site (http://support.microsoft.com/kb/326965/en-us) they say to update the existing list of MIME types. I did that also, but unfortunately this also does not solve the problem.

Please help me out if you have any solution.

You can reach me at vishvesh888@hotmail.com or vishveshraiter@gmail.com

Thanks
Vishvesh Raiter

Re: IIS6 App Mapping problem with .* file extension

N a v a n e e t h17-Apr-07 18:26

N a v a n e e t h

17-Apr-07 18:26

Which is your server version ? Under Windows Server 2003: .* is not allowed in the mapping , there is an extra ‘all extensions’ section where you can add the aspnet_isapi.dll. Check This[^] aricle

printf("Navaneeth!!")

www.w3hearts.com

Re: IIS6 App Mapping problem with .* file extension

TOMCAT8117-Apr-07 19:18

TOMCAT81

17-Apr-07 19:18

Thanks for your quick reply. But the link which you pointed tells all about the Mapping in IIS5.1. I am using Windows 2K3 IIS6.0.

Please do reply.
Thanx

Advice needed...

Software_Specialist17-Apr-07 5:41

Software_Specialist

17-Apr-07 5:41

Hi fellas..

I am creating an application. And for that i want to create a website. But i am lil confused as at the moment i dont know asp.net or dream weaver or anything. Basically i never created website. I am software developer student.
The site would be simple advertisment of ma application and also there gonna be a forum section.
Do you require database for forums. I guess you do. So i guess best option would be asp.net.
Please guide me the right path so that i could get started.

Thanks

Re: Advice needed...

Tarakeshwar Reddy17-Apr-07 5:52

Tarakeshwar Reddy

17-Apr-07 5:52

JumpyForum[^] and CodeProfect-Forum[^]. You can also do a search at http://www.codeproject.com/info/search.asp for the keyword forum

Re: Advice needed...

kinsella_john17-Apr-07 17:22

kinsella_john

17-Apr-07 17:22

hi there,

i am just learning asp.net myself and from what i have gatered so far, you do not need a database to create a basic blogging forum..

if you want people to sign up to your site, you will need database connectivity..

i would recommend that you use asp.net for this task, and the best way for somebody with little experience is to get hold of visual studio..

i believe visual studio 2005 express edition is available for free on the microsoft website
http://msdn.microsoft.com/
along with free versions of SQL Server Express 2005 if you should decide that you do want to use a database..

the other fantastic thing about the msdn website is that there are literally hours of tutorials on visual studio, asp.net and sql server..

its a fantastic resource.. just go to the site and search for any of the above mentioned items.

ps. they also provide several free asp.net templates for sites, which can again be useful if webdesign is not your strong point, as it should help you bang up a nice site..

good luck...

John Michael Kinsella
kinsellajohn@hotmail.com

Re: Advice needed...

Russell Jones17-Apr-07 23:33

Russell Jones

17-Apr-07 23:33

you could try something like dotnetnuke if you want a content driven website. or phpbb if you are just looking to setup a forum. You could produce a few simple pages in asp.net and include a phpbb forum in the pages.

Russ

How to get toolbar button's coordinates

aamn117-Apr-07 5:35

aamn1

17-Apr-07 5:35

Hi,
I have a small program which adds button on the IE toolbar,
i want to show an popup/window exactly below the button in every condition
(window resize).
any help, link is greatly appreciated.

thanks in advance.

amolk

amolk

Re: How to get toolbar button's coordinates

Sandeep Akhare19-Apr-07 2:01

Sandeep Akhare

19-Apr-07 2:01

aamn1 wrote:
I have a small program which adds button on the IE toolbar,

Did you add button to the toolbar ?

aamn1 wrote:
i want to show an popup/window exactly below the button in every condition
(window resize).
any help, link is greatly appreciated.

Actually what is your requirement ?

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

dynamic styles

kkadir17-Apr-07 5:33

kkadir

17-Apr-07 5:33

Hello everyone,

I am trying to change styles of some client-side objects dynamically.

For example whenever the user is at the mainPage.aspx, the text between <div id="activeMainPage">blablabla</div> should be bold.

My problem is : how can I get the current page, and how can I change the text's style dynamically ?

BTW, I am a really newbie in ASP.Net.

Thanks for your helps and best regards.

.:: Something is Wrong ::.

Re: dynamic styles

mghiassi17-Apr-07 7:28

mghiassi

17-Apr-07 7:28

Hello,
You can use CSSclass.

Re: dynamic styles

kinsella_john17-Apr-07 17:33

kinsella_john

17-Apr-07 17:33

unfortunately i am also a bit of a newbie in asp.net and cant offer a dynamic response,

however there is a simple way that you can get your text bold on certain pages that should work through asp.net.

presumably you are using external css style sheets.. in which case create a style for you div

ie #activeMainPage { font-size:60pt; }

in your external page and then if you only wish it to appear on mainpage.aspx / then only refer to it from that page.

so for each normal page you could for example name your div "homelink" and for your main page call it "activehomelink".

i know this doesnt directly answer your question, but i hope that it offers you a solution, all be it a non-dynamic one.

if you already knew this way, good luck in your search for the dynamic way

cheers

John Michael Kinsella
kinsellajohn@hotmail.com

Re: dynamic styles

kkadir17-Apr-07 22:03

kkadir

17-Apr-07 22:03

Thanks for your helps Kinsella,
That is the exact thing what I was doing. The problem is how to make my objects use the activeXX{...} style when they should. I think some javascript will help.

Anyway, search never ends Big Grin | :-D

.:: Something is Wrong ::.

Re: dynamic styles

RichardGrimmer18-Apr-07 5:28

RichardGrimmer

18-Apr-07 5:28

Basic js manipulation of DOM objects centres around the document.getElementById function - give it the id you want and a variable is returned representing the object.

From there, you can manipulate the .style.XXX attributes of the object to style them as you need.

Best resource for this? www.w3schools.com

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

DebuggingErrors

TheEagle17-Apr-07 5:30

TheEagle

17-Apr-07 5:30

Hi..
My project was running on my old computer whithout any problem.But I copied the project to my new laptop.now when I try to run this project I face 2 errors that I couldn't solve:

1-the error:
Error while trying to run the project:unable to start debugging on the webserver.you dont have permissions to debug the server.verify that you are a member of the 'Debugger Users' group on the server.

2-If I click ctrl+F5 to pass this error I got the error:
SQL Server does not exist or access denied.

Iam getting the connection string from an xml configuration file as the following:
<connectionstring>Server=MyLocalServerName;Integrated Security=SSPI;Initial Catalog=MyDatabaseName;
Iam running the project localy and Iam using asp.net.

I am too late but i will never give up

Multi lingual satallite assembly problem

biaali17-Apr-07 4:28

biaali

17-Apr-07 4:28

i have created a sattelite assembly for my resouce file and added to my website but gives the following error

Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "DefaultPage.resources" was correctly embedded or linked into assembly "App_Web_ipc-9kf9" at compile time, or that all the satellite assemblies required are loadable and fully signed.

Validation Application Block

Brendan Vogt17-Apr-07 3:30

Brendan Vogt

17-Apr-07 3:30

Hi,

Has any one used the Validation Application Block? I want to know is this server side only??

And, can one use this application block with the Membership provider when adding and rerieving values from the Membership tables?

Regards
ma se

i got this error

dtamils17-Apr-07 3:18

dtamils

17-Apr-07 3:18

access to the path \"c:windows\\system32\\wmsconfig.cnf \" is denied

can i create file like this?

Re: i got this error

N a v a n e e t h17-Apr-07 5:21

N a v a n e e t h

17-Apr-07 5:21

dtamils wrote:
can i create file like this?

If ASP.NET is not having write permission on the specified folder, then you can't

printf("Navaneeth!!")

www.w3hearts.com

How to make asp:button invisible in mozilla

Bhaskar Ravindranath17-Apr-07 2:50

Bhaskar Ravindranath

17-Apr-07 2:50

im using asp:button in my application and i want to make it invisible ,its working fine in internet explorer but it is visible in mozilla.i want to make it invisible in mozilla also, without using the property visible="false".How to do it.. please help me..

Dream it to achieve it

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