|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Excel sheet is on the client and the data does not conform to a reasonable (any) format.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
rummer wrote: Dear Sir
You are too formal buddy.We are all from programmer's community.
modified on Friday, September 4, 2009 2:18 AM
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
Good. But you could have replied to the original poster not to me!
|
|
|
|
|
Oh! Mistake, Sorry Boss.
I will reply the same to him.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Hi Abhijit,
Thanks for your reply..Actually i am using VS 2003,So any javascripts can be used?
|
|
|
|
|
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';");
|
|
|
|
|
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
|
|
|
|
|
Plz avoid double posting.
|
|
|
|
|
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
|
|
|
|
|
Cross Post will not help you to get answer faster.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
