ASP.NET

Re: multiselect listbox - set selections using delimeted string

9-Jul-09 13:02

I have a multiselect listbox that sends selections to the database field separated by commas - no problem there. No problem displaying the data.
I need to allow folks to edit the form data so I have a formview with all fields bound but when I try to bind the multiselect listbox, I get an error (because the data does not match the listbox items) -
So, I put the data into an array, intending to use the array values to set the selected items in the listbox. But I am a long time asp coder and cannot get my brain around how to do this with asp.net (VB)... I'm sure that I need to loop through the array values and compare them to the listbox values (loop within loop...)
I cannot believe I am the only one out there who has had to set the selections of a listbox this way...
Any help is MOST appreciated. This rediculous issue is holding up my entire project.....

Thanks

ublend

www.Developerof.NET9-Jul-09 20:52

www.Developerof.NET

9-Jul-09 20:52

Just to get you started i would give you the logic to be implemented.

You need a nested for loop, the outer loop spanning the length equal to the master data size while the inner loop spanning the length of the array obtained by splitting up the delimited values. Later you just need to check the value of the outer loop and the inner loop and if the match is found, mark the outer loop item as selected.

Hope this helps.

When you fail to plan, you are planning to fail.

Re: multiselect listbox - set selections using delimeted string

ublend10-Jul-09 8:41

10-Jul-09 8:41

thanks for the reply - I found that I was making it way too complicated... Laugh | :laugh:

Condango had the solution:
to highlight from database to multiselect
where SelectedDisplayValue is the value from database(eg SelectedDisplayValue= 3,4,10)
For i = 0 To (objListbox.Items.Count - 1)
If InStr(SelectedDisplayValue, objListbox.Items(i).Value) Then
objListbox.Items(i).Selected = True
End If
Next

ublend

Link protection

pforu19-Jul-09 11:26

pforu1

9-Jul-09 11:26

Dear All,

I want to know how to protect a file from downloading if the user is not logged in;just the way its done here on codeproject?
Suppose the file url is http://www.mydomain.com/photos.zip

Download file

Depending upon the login status it should either redirect to login page or proceed with download of the zip file, when download file link is clicked.I need the exact functionality of codeproject download feature.

Thanking you all in advance.

ublend9-Jul-09 13:19

9-Jul-09 13:19

Have you tried setting the navigateUrl property based on the status of their login?

If variable <> "your logged in value" Then
Me.HyperLink1.NavigateUrl = ""
End If

ublend

pforu19-Jul-09 14:47

pforu1

9-Jul-09 14:47

Hi,
Buddy i forgot to mention earlier that the page is in Classic ASP as opposed to Asp.Net..Sorry for that.

Please help..

Thanks

P

Gary Stafford9-Jul-09 16:08

Gary Stafford

9-Jul-09 16:08

I dug up an old (2002 old) classic ASP/VB site I created that required the user to enter a username and password, which is checked against the database. If they are successful, a session variable in the global.asa file is set to true. Each page checks the variable first and bounces the user if the variable returns false.

Top of each page:

'Check if user is logged in
Dim LoggedIn
LoggedIn = Session("LoggedIn")
If LoggedIn <> "True" Then
   Response.Redirect("login.asp")
End If

global.asa

Sub Session_OnStart	
   'Create a Session variable to track if the user has logged in
   Session("LoggedIn") = "False"
   ...
End Sub

Hope this helps.

Regards,

Gary

ublend10-Jul-09 8:39

10-Jul-09 8:39

how are you authenticating your users? - If you are using a database to store their userID and password, you could use a script like this to signify that they are authenticated:
----use your database connection then check the form data against the data in your admin table like:

Dim myPW, username,mystatus
username=request("username")
myPW=request("myPW")
Set RSlog = Server.CreateObject("ADODB.Recordset")
RSlog.Open "Select * from Admin where username='"&myLogin&"' and password='"&myPW& "'", Conn, 2, 2

If not RSLog.eof or not RSLOG.eof then
myStatus="IN"
end if

then lower in my page, where I want active links or not, I would code something like this:

Response.Write ("<a href="yourURLorFilepath/" & RS("filename")& """>Link</a>")
else
response.write("link not available")
end if

Hope that helps. Happy coding

ublend

Word Document Automation : Need Control after its opened

pforu110-Jul-09 16:36

pforu1

10-Jul-09 16:36

Hi ,

I am using a session variable to store my login info. Actually I am looking for a solution exactly similar to what we have on this site. I dont want to display link not available.
I have certain doc files,zip files for download where i would display the link something like http://www.mydomain.com/abc.doc but when the user clicks on this link i want then to be forced to login if not logged in.
So the problem is how to protect any link like this? If I would have been redirecting a user to any ASP page then its very easy to check the session value and then either permit or deny, but how to check on a link which directly points to a doc file or zip file ?
I hope i am not sounding like a fool Smile | :)

Thanks a lot for all the help so far.

Sandumone9-Jul-09 10:05

Sandumone

9-Jul-09 10:05

Hi all,

Thanks a lot for your help in advance.

I am doing a Mail Merging Application. I can get all data from the source (database, file or anything) and using mail Merge fields in Word Document from C# code, I open up the word which is merged with data from database.

MS Word Document Opens –

--- should this be open in IE

--- Or should this be open as ordinary MS Word on Desktop

The problem is if I open it anyway, I loose all control over the Word Document which is opened. I don’t want to do that. I want to keep control over it and allow the Users to update the document with some standard messages which we have in the project. What that means is, the messages will be selected and those messages selected will be put at some point where cursor is kept in the document.

So, when mail merging happens

MS Word Document is opened.
A pop up with standard messages is opened.
User selects the messages he/ she wants to insert into the MS Word Document which is opened.

For these things to happen, I should have control over the MS Word Document which is opened on the client side. Do selection of the messages and populate in Word document (this is my understanding, is there any way to do it easily).

The Issues are:

I need a way to open the MS Word Document in a controlled manner where I can still control the User editing or help user in editing when he / she clicks on my standard messages and wants them to populate on the MS Word Document.
How can I save the MS Word document and make sure that user is not saving it locally and has to upload it again to save it on server.

I Hope I am clear in explaining the situation, please find the attachments which show the MS Word Doc and the popup on side .

Re: Word Document Automation : Need Control after its opened

David Mujica9-Jul-09 10:23

David Mujica

9-Jul-09 10:23

Sounds like you are asking for a lot of client side javascript in order to handle it.

Maybe the approach should be more server-centric.

1) Perform the merge on the IIS server.
2) Prompt the user for messages that need to be incorporated
3) On the server, using Document automation, incorporate those messages
4) Confirm that the user wants to save the document. Save it on a server directory.

Basically, have everything under control on the server, don't try to open MS-Word on the client machine.

Just a thought. Rose | [Rose]

Browser compatability Issues

VivekUtsa9-Jul-09 8:00

Re: Browser compatability Issues

9-Jul-09 8:00

Hi Iam new to C#,Asp.Net.

Iam working on building a website http://www.missmegs.com/ this site is for a restaurant.

I have this site working fine in IE but when I go to Firefox the bottom image which I used as borders for this website is coming up which is making my client little upset.

How can I overcome this issue. Iam sure this can be done with CSS and divs but I dont know how. Please help me.

Any help is greatly appreciated.

Thank in advance.

Jeremy Likness9-Jul-09 8:24

Jeremy Likness

9-Jul-09 8:24

Here's a good overview of what to do and what you'll need to learn:

http://www.netmechanic.com/products/Browser-Tutorial.shtml[^]

The issue is more likely due to HTML than the fact you are using C#, etc.

Jeremy Likness
http://csharperimage.jeremylikness.com/

problem in getting the count of listitems in listbox javascript

nainakarri9-Jul-09 5:20

nainakarri

9-Jul-09 5:20

Hi

I have a listbox in aspx page and has some list in it.
Now i am trying to get the list count of the listbox from javascript.

I am trying to get that by using the following code.

function count()
{
var x = document.getElementById(<%=listbox1.ClientID %>);
var cnt = x.options.length;

}

I am using a master page here.
But the value cnt is not having any value.
I tried by using like this also
var cnt = x.length;
but still it gave me the result as undefined.

Please help me to get the count.

Thanks in advance

Naina

Re: problem in getting the count of listitems in listbox javascript

Blue_Boy9-Jul-09 6:14

Blue_Boy

9-Jul-09 6:14

This works properly.

alert(document.getElementById('<%=ListBox1.ClientID %>').options.length);

I Love T-SQL www.aktualiteti.com
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

DataBind having error with null values

dreamaway8209-Jul-09 5:15

dreamaway820

9-Jul-09 5:15

I am using a GridView and one of the fields is a DateTime. The values in this field can be null. When I call gvwDetails.DataBind() I get this error:

"String was not recognized as a valid DateTime."

I just want it to display an empty string if its a null value. It doesn't seem that hard but I have tried searching google and read a bunch of MS pages on GridViews and DataBind. The closest I have come is setting the ConvertEmptyStringToNull property in my field to true but its not doing anything. My code for the template field is:

<asp:TemplateField HeaderText="Date Due"> <br />
                <EditItemTemplate> <br />
                    <asp:TextBox ID="txtDateDue" runat="server" Text='<%# Bind("DATE_DUE") %>'></asp:TextBox> <br />
                </EditItemTemplate> <br />
                <FooterTemplate> <br />
                    <asp:TextBox ID="txtNewDateDue" runat="server" Width="100" ></asp:TextBox> <br />
                </FooterTemplate> <br />
                <ItemTemplate> <br />
                    <asp:Label ID="lblDateDue" runat="server" Text='<%# Eval("DATE_DUE") %>'></asp:Label> <br />
                </ItemTemplate> <br />
                <HeaderStyle HorizontalAlign="Left" /><br />
            </asp:TemplateField>

Is this really simple and I'm not seeing it? I'm sure there's some way of handling null values that I must not be seeing. Thank you for any help.

Re: DataBind having error with null values

Zafar A khan 9-Jul-09 19:14

Zafar A khan

9-Jul-09 19:14

Cast the date to varchar or char in Query then try.
if u r using MySql then cast the date like this.

select cast(Date_Format(Date_Due,'%d %M %Y') as char) as Date_Due from table_name

if u r using Ms SqlServer then do it like this

select CONVERT(varchar(20), Date_Due, 107) AS Date_Due from table_name

You can change the date format according to requirement.

Re: DataBind having error with null values [modified]

dreamaway82010-Jul-09 4:32

dreamaway820

10-Jul-09 4:32

~~That works, thank you very much.~~

Scratch that, I had made it a bound column and forgot to change it back. When I change it back to a template field it still doesn't work. Frown | :(

I have found some stuff that seems helpful (like this http://stackoverflow.com/questions/584570/why-does-my-repeater-keep-crashing-on-evalnull-values[^]) but still can't get this to work with my DateTime field.

One more edit: Okay I figured it out. I had some code in my RowDataBound event that was formatting the dates and I had to modify it in the case of an empty string. D'Oh! | :doh:

Thank you again for the help.

modified on Friday, July 10, 2009 1:02 PM

How to reset a counter on database table

VivekUtsa9-Jul-09 5:00

9-Jul-09 5:00

Hello all,

Iam new to C# and .NET but leanrt a lot while iam in here. I ran in to a situation, I have created a shopping cart application and made successfully all the way to the order confirmation. Now the client wants to reset the "Order Num" to zero on a daily basis.

i.e "Order Number" once order is placed has to start at 0 from 12 AM and has to be set to 0 at 12 PM so that they have a count on how many items they are selling per day.

How this can be achieved any help will be appreciated. Thanks in advance.

DoctorMick9-Jul-09 5:04

DoctorMick

9-Jul-09 5:04

There are 2 obvious ways I can think of....

1 - Store the order date in the database, that way the order numbers don't need to be reset, you can simply provide a screen to display the total number of orders for a given day.
2 - Store the order date and order number in the database against each order. Create a new table called something like currentordernumber, with 2 columns date and nextordernumber, each time you create a new order query this table to get the next order number and update the table to set the nextordernumber +1. If the current date is different to the date in the currentordernumber table update the date in the table and set the order number to 1.

Option 1 is by far the best option IMO.

VivekUtsa9-Jul-09 5:47

9-Jul-09 5:47

Thank you DoctorMick for a quick solution.

If I go with Option 1, there is a small issue. I also have to show the "Order Number" to the user so that they can take that to the store with them[Carry Out].

Like 7/9/09 -- orders 1 to 100. Purchaser can go a tell the restaurant for their order number that day.
7/10/09 -- order 1 to 150.

Manas Bhardwaj9-Jul-09 5:59

Manas Bhardwaj

9-Jul-09 5:59

Well, for that reason you can add another column to the table, lets say OrderNrOfDay.
Every time you insert the order in the table, check if the date today is same as that of the last order. If yes, the increment the OrderNrOfDay else set it to 1.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

VivekUtsa9-Jul-09 6:14

9-Jul-09 6:14

Thank You Manas

That makes sense, let me try that should fix me.