Re: DropDownList - ListItem - ASP.NET Discussion Boards

Dayekh30-Oct-06 23:34

30-Oct-06 23:34

Thanks for the reply 3alaa2,

The thing is, I'm trying to make sense of how the list item will work. Let's say I names the value of the list item All just like the text for the list item.

Currently the query to populate the dropdown is simply:

"SELECT tblProject.inProjectID, tblProject.vchProjectName

FROM tblProject ORDER BY tblProject.vchProjectName"

If I am to include the list item, All, how would the query look?

Re: DropDownList - ListItem

just3ala231-Oct-06 0:31

just3ala2

31-Oct-06 0:31

No problem Big Grin | :-D

U can simply use the If/Else condition and use the sql statememnt
"SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject ORDER BY tblProject.vchProjectName" if the user select listitem(0) and use your other sql statement that has the Where clause

If u r using stored procedures there is another better solution.
Tell me if u do...

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 0:48

Dayekh

31-Oct-06 0:48

I am using stored procedures for saving/delete/updating records. This Query is a one off query populating a dropdownlist..

Would the solution look something like :

If Me.ddlProject.SelectedValue = ListItem(0) Then

"SELECT tblProject.inProjectID, tblProject.vchProjectName
FROM tblProject
WHERE tblProject.vchProjectName = [Any value(lol no idea what to write here!)]
ORDER BY tblProject.vchProjectName "

Else

"SELECT tblProject.inProjectID, tblProject.vchProjectName
FROM tblProject
ORDER BY tblProject.vchProjectName"

Thanks again for the replyin..

Re: DropDownList - ListItem

just3ala231-Oct-06 1:05

just3ala2

31-Oct-06 1:05

it's more like ...

<br />
If ddlProject.Items(0).Selected Then<br />
'The (All) statement<br />
<br />
"SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject ORDER BY tblProject.vchProjectName"<br />
<br />
Else<br />
'The specific project statement<br />
"SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject WHERE tblProject.vchProjectName = '"& ddlProjects.selectedValue &"' ORDER BY tblProject.vchProjectName"<br />
<br />
End If<br />

Hope this solves the problem

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 1:19

Dayekh

31-Oct-06 1:19

Thanks man,

One issue though... It is throwing an 'Out of range' error exception..

This is how I am populating the dropdownlist:

<br />
Dim sQueryDDL As String<br />
Dim sTableDDL As String<br />
Dim dsDDL As DataSet = New DataSet<br />
<br />
If ddlProject.Items(0).Selected Then<br />
                sTableDDL = "SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject ORDER BY tblProject.vchProjectName"<br />
            Else<br />
                sTableDDL = "SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject WHERE tblProject.vchProjectName = '" & ddlProject.SelectedValue & "' ORDER BY tblProject.vchProjectName"<br />
            End If<br />
            sTableDDL = "tblProject"<br />
            dsDDL = clsCommon.getData(sQueryDDL, sTableDDL)<br />
            dsDDL.Tables(0).DefaultView.Sort = "vchProjectName"<br />
            Me.ddlProject.DataSource = dsDDL.Tables(0).DefaultView<br />
            Me.ddlProject.DataTextField = "vchProjectName"<br />
            Me.ddlProject.DataValueField = "inProjectID"<br />
            Me.ddlProject.DataBind()<br />
            Me.ddlProject.Items.Insert(0, New ListItem("<< All >>", ""))

I have a creeping suspricion that the last line is the problem. Let me know if you can. Thanks..

Re: DropDownList - ListItem

just3ala231-Oct-06 1:33

just3ala2

31-Oct-06 1:33

u don't need the last line of code because the drop down list is already binded and the fields are inserted after the Me.ddlProject.DataBind() statement

let me know if u r still havin a problem ...

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 2:30

Dayekh

31-Oct-06 2:30

hi again,

This statement is thrown at me:

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

This is the line it highlighted as the erroneous one:

If ddlProjectRequestSearch.Items(0).Selected Then

Question: Shall I implement a <asp:listitem> tag in the front end code for the "All" option? I'm gonna try that now and see what happens.

Re: DropDownList - ListItem

just3ala231-Oct-06 3:02

just3ala2

31-Oct-06 3:02

u can do that as a solution

If u wanna keep it as before:

<br />
If ddlProjectRequestSearch.SelectedValue = "All" Then<br />
            'The code for all ...<br />
        Else<br />
            'The code for the rest ...<br />
        End If<br />
<br />
<br />
End If<br />

Put this code in the ddlProjectRequestSearch_SelectedIndexChanged and make the postback property "True"

or put it in a button and leave the postback property for the ddlProjectRequestSearch in the default state (False)

This should work fine, i tried it now Big Grin | :-D

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 3:42

Dayekh

31-Oct-06 3:42

I am populating the DropDownList in the PageLoad event. When will the list populate if the code is in the ddlProjectRequestSearch_SelectedIndexChanged method ?

Also, exactly where are we defining the ListItem "All". Since I erased it from the .aspx.vb file shall I make a <listitem> tag for it ?

Sorry bout taking up your time and Thanks.

Re: DropDownList - ListItem

just3ala231-Oct-06 5:36

just3ala2

31-Oct-06 5:36

The code i wrote doesn't populate the drop down list
this is for the event of selecting an item from the list
and yes, try adding a static item (tag) for it Name "All" and Value "All" so that code would work fine with u.
if it doesn't work try adding it in the code behind

<br />
ddlProjectRequestSearch.Items.Add("All")<br />

No problem man

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 5:46

Dayekh

31-Oct-06 5:46

I'm gonna try this again tomorrow.. I've had enough for today.. I will continue the long thread tomorrow lol...

Thanks again ya akhy.. Smile | :)

Error BC30002: Type ‘XXX’ is not defined…

greekius30-Oct-06 21:28

greekius

30-Oct-06 21:28

http://www.google.com.tr/search?hl=tr&q=BC30002&meta=[^]

there is no solution about the problem in google, any suggestion?

Problem is there is a class in web project, it works in local machine but not works at my web server :S it returns that error message

Logon Failure : Unknown username or bad password

Raju Sharma30-Oct-06 20:56

Raju Sharma

30-Oct-06 20:56

Actually what i am doing is from IE i am accessing my web site running on asp.net platform. In the datagrid i have given the link. Whwn i click the link
i logon the FTP server and make the socket connection from where i have to start downloading the file.

When i try to acces the IP of the client machine like \\192.168.1.82\c$\abc.iso for downloading the abc.iso file to the client machine, then
i get the error "Logon Failure : Unknown username or bad password"

SAMPLE CODE
***************************************************************
Public Sub DownloadFile(ByVal sFileName As String, _
ByVal sLocalFileName As String, _
ByVal bResume As Boolean)
Dim st As Stream
Dim output As FileStream
Dim cSocket As Socket
Dim offset, npos As Long
'sLocalFileName = "C:\Inetpub\wwwroot\WebDelivery\Downloadfiles\" & sLocalFileName & ".iso"
If (Not (m_bLoggedIn)) Then
Login()
End If

SetBinaryMode(True)

If (sLocalFileName.Equals("")) Then
sLocalFileName = sFileName
End If

If (Not (File.Exists(sLocalFileName))) Then
st = File.Create(sLocalFileName)
st.Close()
End If

output = New FileStream(sLocalFileName, FileMode.Open)
cSocket = CreateDataSocket()
offset = 0

If (bResume) Then
offset = output.Length

If (offset > 0) Then
SendCommand("REST " & offset)
If (m_iRetValue <> 350) Then
'throw new IOException(reply.Substring(4));
'Some servers may not support resuming.
offset = 0
End If
End If

If (offset > 0) Then
npos = output.Seek(offset, SeekOrigin.Begin)
End If
End If

SendCommand("RETR " & sFileName)

If (Not (m_iRetValue = 150 Or m_iRetValue = 125)) Then
MessageString = m_sReply
Throw New IOException(m_sReply.Substring(4))
End If

Do While (True)
m_aBuffer.Clear(m_aBuffer, 0, m_aBuffer.Length)
m_iBytes = cSocket.Receive(m_aBuffer, m_aBuffer.Length, 0)
output.Write(m_aBuffer, 0, m_iBytes)

If (m_iBytes <= 0) Then
Exit Do
End If
Loop

output.Close()
If (cSocket.Connected) Then
cSocket.Close()
End If

ReadReply()
If (Not (m_iRetValue = 226 Or m_iRetValue = 250)) Then
MessageString = m_sReply
Throw New IOException(m_sReply.Substring(4))
End If

End Sub
***************************************************************

Please help as i am struck on this from last 10 days
please help !!!!!!

thanks

Raju sharma

Printing the contents of a web grid

petro_00730-Oct-06 20:23

petro_007

30-Oct-06 20:23

Greetings people,

First off, you guys will have to excuse me in case my problem is a simple one. Im not a programmer after all.

Anyway, my problem is very simple: Im trying to display the results of my query in a grid on a webpage and I need to be able to do two things:
1.I want to render the first column fixed such that it remains visible whenever the user scrolls from left to right.
2.I want to be able to print the grid such that each page has the column headers and the corresponding row headers( the fixed column that I talked about in my first point above).
I have searched the internet for a web control that can allow me to do this but so far nothing.

Any ideas on how I can achieve this? Any help will be greatly appreciated.

Kind regards,
Pete.

(Exam 70-528): Microsoft® .NET Framework 2.0 Web-Based Client Development

Girish Pendse30-Oct-06 19:59

Girish Pendse

30-Oct-06 19:59

Hi,
I want to give Exam 70-528: Microsoft® .NET Framework 2.0 Web-Based Client Development so I need help from you, please tell me how to prepare for this exam.
also please let me know if any one has study material/books for this exam.
Thanks in advance

Thanks & Regards
Girish Pendse

Re: (Exam 70-528): Microsoft® .NET Framework 2.0 Web-Based Client Development

minhpc_bk31-Oct-06 0:28

minhpc_bk

31-Oct-06 0:28

http://www.microsoft.com/learning/exams/70-528.asp[^]

what the event that is fired when closing the browser window

abdelhameed8130-Oct-06 19:39

abdelhameed81

30-Oct-06 19:39

hi all

i want to knw how to log off the user of my site if the browser window is closed or the Pc connection was terminated.

thank u all

abdelhameed81

Re: what the event that is fired when closing the browser window

just3ala231-Oct-06 1:39

just3ala2

31-Oct-06 1:39

Guess u need javascript here!

Best Regards
3ala2 Smile | :)

.NET Best Architecture!!!?

cloudking1196630-Oct-06 18:42

cloudking11966

30-Oct-06 18:42

Hi All,
Recently I heard that some companies create a class of each tables present in the database, I will illustrate the same

If there is a table called Employee with EmployeeId, EmployeeName and Salary, then they create a class clsEmployee with EmployeeId, EmployeeName and Salary as their private fields and accessor methods.

And rather than passing the Dataset or XML through the wire, they pass the collection of this objects.

Can anyone tell me what is the advantage of this architecture?, where can I find some articles or guide to implement this architecturte?

Grateful to you all Smile | :)

Sony sebastian

Re: .NET Best Architecture!!!?

just3ala231-Oct-06 1:36

just3ala2

31-Oct-06 1:36

Guess u should look for the same reasons why to use object oriented programming because what u r talkin about is a simple implementation for object oriented programming

If u want a running ASP.net application (VB Script) send post here

Best Regards
3ala2 Smile | :)

Re: .NET Best Architecture!!!?

minhpc_bk31-Oct-06 13:41

minhpc_bk

31-Oct-06 13:41

Hi there,
Actually, I agree with someone said that they both have their own places, you can find some of interesting discussions from the links:

http://weblogs.asp.net/despos/archive/2005/08/04/421549.aspx[^]
http://msdn.microsoft.com/msdnmag/issues/05/08/CuttingEdge/[^]
http://aspnet.4guysfromrolla.com/articles/050405-1.aspx[^]

and here's the tutorial: http://www.asp.net/learn/dataaccess/default.aspx?tabid=63[^]

Re: .NET Best Architecture!!!?

cloudking119661-Nov-06 19:08

cloudking11966

1-Nov-06 19:08

Thanks Dude!!!

I will go through all the links you gave.

How to download text file on client system

asprajesh30-Oct-06 18:15

asprajesh

30-Oct-06 18:15

Hi all ..I m working on Asp ..i have made a asp application ..which crate text file on Server..After that i want to give facility how to download that txt file on user system..
just like we download attached file from our mail.. to local disk..
Plzzz give me solutions ..
thanx in advance..

Life is not easy ,let's make it.

Accessing Global Objects in User Controls

GregStevensCA30-Oct-06 13:34

GregStevensCA

30-Oct-06 13:34

I have a question. I have created a class (DBClass) to act as a handler for interactions with a database. Creating an instance of that class opens a connection to the database, and the object then has a number of methods for handing transactions with the database.

Initially, my thought was to include the class definition file (which also creates a single instance of the object, called DB) at the beginning of each document. Then, I thought, I'd be able to reference the DB object anywhere in the page to interact with the database.

So, this is (a simplified version of) what my main page looks like:

<!-- #include virtual="dbclass.aspx" -->
<%@ Register TagPrefix="inc" TagName="title" Src="title.ascx" %>
<html>
 <head>
  <title>Side Bar Template</title>
 </head>
 <body>
  <inc:title runat="Server" />
 </body>
</html>

The dbclass.aspx file contains the code that defines the DBClass class and creates a single instance of that class called DB.

Now, the title.ascx file defines a User Control that prints the title of the page, by looking up the URL of the page in a database and retrieving the corresponding title. That look-up in the database is handled by the DB object:

<%@ Control Language="VB" ClassName="TitleControl" %>
   <h1>
<% 
    Response.Write( DB.GetNameFromUrl( Request.ServerVariables("URL") ) )
%>
   </h1>

But when I run the main page, it gives a compilation error then trying to compile the
Title Control, because I reference the DB object without declaring it inside that file (title.ascx).

Any idea how I can get the user control to be "aware" of the main DB object I've defined in the calling page?

Thanks for any help or insight..

----G

Re: Accessing Global Objects in User Controls

minhpc_bk30-Oct-06 13:50

minhpc_bk

30-Oct-06 13:50

Hi there,
Basically, if you want to access the properties/methods of the calling page, you'll need to get reference to the page instance first, then you can use its members, and from the user control, you can easily access the containing web page using the Page property. Also, if you want to create the DB object in every page, you may think of creating a base class for all web pages and expose this object via a public property in the base class, you later can cast in the Page property in the user control to the base class before calling its members.

In addition, the way you send the output to the web page in the user control is really old, instead you can place a label control in tne control and simply set the Text property. I guess you might be interested in some examples from here[^].

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