Validation for dropdown - ASP.NET Discussion Boards

Mycroft Holmes3-Sep-09 20:06

3-Sep-09 20:06

I have a need to gather data from an Excel spreadsheet, I have no information about the sheet but I want the user to be able to link a cell in a datagrid or a text control to a cell in an excel spreadsheet.

I have looked at some of the spreadsheet controls and have found no mention of remote referencing capability.

I could set up the read capability if it was winforms but am I going to be limited by the lack of IO via the browser.

Re: Browser link to a spreadsheet

N a v a n e e t h3-Sep-09 20:37

N a v a n e e t h

3-Sep-09 20:37

Mycroft Holmes wrote:
but I want the user to be able to link a cell in a datagrid or a text control to a cell in an excel spreadsheet.

What do you meant by link to a cell? Do you mean linking to excel file and when it opens, focus should be on a specified cell? If yes, I believe it is not possible because of the limitations you already aware.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: Browser link to a spreadsheet

Mycroft Holmes3-Sep-09 20:58

Mycroft Holmes

3-Sep-09 20:58

Actually I want to configure a web form so when I click a button the form will go get the data in the cells from the xls and populate the form.

I am currently thinking I should be able to use a DLL (this is behind the firewall) to get the data for each cell, can't think of any other way.

Re: Browser link to a spreadsheet

r a m e s h3-Sep-09 21:05

r a m e s h

3-Sep-09 21:05

If you want to populate a DataGrid or GridView, You can do it using System.Data.OleDb namespace in ADO.NET.

Refer this link for reading and writing Excel using C#.

Read the Excel sheet into a DataSet and bind the GridView.

Re: Browser link to a spreadsheet

Mycroft Holmes3-Sep-09 21:14

Mycroft Holmes

3-Sep-09 21:14

Part of the problem is that the data structure is so crappy that OLEDB spits the dummy and won't talk to the sheet. Each branch has it's own flavour of sheet that does the same thing. The only way seems to be to link textbox to cell. These are very high level reports so there are limited cells to link.

Re: Browser link to a spreadsheet

N a v a n e e t h3-Sep-09 21:50

N a v a n e e t h

3-Sep-09 21:50

Mycroft Holmes wrote:
Actually I want to configure a web form so when I click a button the form will go get the data in the cells from the xls and populate the form.

This is possible if you have the excel file on server. Use Excel interop or OLE DB to read data from excel.

Navaneeth

How to use google | Ask smart questions

Re: Browser link to a spreadsheet

Mycroft Holmes3-Sep-09 22:31

Mycroft Holmes

3-Sep-09 22:31

Excel sheet is on the client and the data does not conform to a reasonable (any) format.

Validation for dropdown

rummer3-Sep-09 19:52

rummer

3-Sep-09 19:52

Dear Sir

I am taking three dropdown and searching data according to three ddl,1st ddl for Employeecode,2nd is Month,3rd for Year.In the selection time we want user 1st select employeecode ddl ,if he select 1st month ddl

then show a message like please select 1st Employeecode.

i am showing all data in selected index of ddlyear.so what i do.........

thanks and regards

vivek sachan

Re: Validation for dropdown

Sachin Dubey3-Sep-09 19:57

Sachin Dubey

3-Sep-09 19:57

You Use Compare Validator That Will Validate ur Month and Year Combo And that will compare with Employee combo

Like for that u hav to take 2 compare validator one for ddl month 2 nd for ddl yaer

and both have same property of Control to Compare which is ddlemployeecode

All The best

Re: Validation for dropdown

Arun Jacob3-Sep-09 19:58

Arun Jacob

3-Sep-09 19:58

You can do it either by javascript or from Server side.
In server side you can use OnSelectedIndexChanged of month and
then check if SelectedIndex of 1st ddl is -1.

Smile | :)

Arun Jacob
http://codepronet.blogspot.com/

Re: Validation for dropdown [modified]

Arun Jacob3-Sep-09 20:03

Arun Jacob

3-Sep-09 20:03

rummer wrote:
Dear Sir

You are too formal buddy.We are all from programmer's community.
Smile | :)

Arun Jacob
http://codepronet.blogspot.com/

modified on Friday, September 4, 2009 2:18 AM

Re: Validation for dropdown

N a v a n e e t h3-Sep-09 20:32

N a v a n e e t h

3-Sep-09 20:32

rummer wrote:
we want user 1st select employeecode ddl ,if he select 1st month ddl

then show a message like please select 1st Employeecode.

That is a poor design. If you want user to select the employeecode first, why to show other two? Or why to preload data to other two?

Navaneeth

How to use google | Ask smart questions

Re: Validation for dropdown

deepseeindeepsy3-Sep-09 21:52

deepseeindeepsy

3-Sep-09 21:52

First load data to the first ddl.After selecting a record from first ddl(Write code here to load second one, accordingly) then u have to load third one same as above. If user select 2nd ddl before selecting from 1st,he will find empty data in it. Smile | :)

Re: Validation for dropdown

N a v a n e e t h3-Sep-09 22:08

N a v a n e e t h

3-Sep-09 22:08

Good. But you could have replied to the original poster not to me!

Navaneeth

How to use google | Ask smart questions

Re: Validation for dropdown

deepseeindeepsy3-Sep-09 22:20

deepseeindeepsy

3-Sep-09 22:20

Oh! Mistake, Sorry Boss.
I will reply the same to him.

Re: Validation for dropdown

deepseeindeepsy3-Sep-09 22:22

deepseeindeepsy

3-Sep-09 22:22

Hello,
First load data to the first ddl.After selecting a record from first ddl(Write code here to load second one, accordingly) then u have to load third one same as above. If user select 2nd ddl before selecting from 1st,he will find empty data in it. Smile | :)

Audio and text Captcha Both In One

Sachin Dubey3-Sep-09 19:41

Sachin Dubey

3-Sep-09 19:41

Hi every Body...

I Have to implement Audio as well as Text Captcha In Asp.net Page.
As Far As Captcha Image is Concerned i hav done this.. But for audio i am in dillema..
So Can Anybody Show Me the way...

Thnx Very Much

Re: Audio and text Captcha Both In One

N a v a n e e t h3-Sep-09 20:44

N a v a n e e t h

3-Sep-09 20:44

You will get some text-speech utilities and using that you need to make an audio file. When user clicks on audio icon, play this audio file.

If you know the characters your CAPTCHA produces, record sound for each character and when requested by the user, combine all the required audio files and produce a single file. This single file can be provided to user.

Doing all these won't be trivial. You will be better off with some third party controls which has all these features built-in. Here[^] is one.

Smile | :)

Navaneeth

How to use google | Ask smart questions

About displaying label

Prasadsm3-Sep-09 19:18

Prasadsm

3-Sep-09 19:18

Hi all,

I want to display a label on button click for some time, and in the same button click event it should be made invisible....Here the label text is "Please wait,Loading Report". As soon as report gets loaded,the label should be made invisible....how can this be done?

Thanks in advance,
Prasad

Re: About displaying label

Abhijit Jana3-Sep-09 19:21

Abhijit Jana

3-Sep-09 19:21

This is not like that, that you are thinking.

You have to use AJAX for that. Beause you dont know how much time will it take for load the report.

Use AJAX UpdatePanel and Update ProgressBar.

These will resolve your problem.

For your Ref.
The UpdatePanel and UpdateProgress Controls[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: About displaying label

Prasadsm3-Sep-09 19:33

Prasadsm

3-Sep-09 19:33

Hi Abhijit,

Thanks for your reply..Actually i am using VS 2003,So any javascripts can be used?

Re: About displaying label

Sachin Dubey3-Sep-09 19:44

Sachin Dubey

3-Sep-09 19:44

On Page Init Event On your Server side Code You Can Do Like

txtSearchSelect.Attributes.Add("onClick", "if (this.value == 'Search Keyword') this.value = 'Please wait Report is being Generated';");

Problem in asp.net ajax updatepanel progress

Shahdat Hosain3-Sep-09 19:04

Shahdat Hosain

3-Sep-09 19:04

Hi Dear, I've a serious problem, that is:
I've three asp:Contents in my content page. Content1 for head, Content2 is activated when user is logged in; By contrast, Content3 is for anonymous user.
In my program asp:UpdatePanel works properly in both content(Content2 & Content3). asp:UpdateProgress works properly in Content3(used for anonymous user) but doesn't work for Content2(used for logged in user)

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
           <asp:UpdatePanel ID="UpdatePanel2" runat="server">
                 <ContentTemplate>
                 <%=DateTime.Now.ToLongTimeString() %>
                     <asp:Button ID="Button1" runat="server" Text="Button"  OnClick="UpdateButton_Click"/>
                 </ContentTemplate>
            </asp:UpdatePanel> 
             <asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="UpdatePanel2">
              <ProgressTemplate>
                    <img alt="Loading..." src="../Images/ajax-loader.gif" />
                    Please wait...
                </ProgressTemplate>
              </asp:UpdateProgress> 
</asp:Content>

<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    
            <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                 <ContentTemplate>
                 <%=DateTime.Now.ToLongTimeString() %>
                     <asp:Button ID="UpdateButton" runat="server" Text="Button" OnClick="UpdateButton_Click" />
                 </ContentTemplate>
             </asp:UpdatePanel> 
                <asp:UpdateProgress ID="UpdateProgress2" runat="server" AssociatedUpdatePanelID="UpdatePanel1">
              <ProgressTemplate>
                    <img alt="Loading..." src="../Images/ajax-loader.gif" />
                    Please wait...
                </ProgressTemplate>
              </asp:UpdateProgress>
</asp:Content>

I don't understand which is my fault. Could you help me?

shahdat

Re: Problem in asp.net ajax updatepanel progress

Arun Jacob3-Sep-09 19:15

Arun Jacob

3-Sep-09 19:15

Plz avoid double posting.
Big Grin | :-D

Arun Jacob
http://codepronet.blogspot.com/

Re: Problem in asp.net ajax updatepanel progress

Shahdat Hosain3-Sep-09 19:25

Shahdat Hosain

3-Sep-09 19:25

OK boss, I am highly worried about my problem. But I don't get any answer yet within 9 hours ago.

Plz help me. If it's not beyond your capacity.

shahdat

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