|
but the prob is not coz of loop.its because datas r not getting appended in datatable.
|
|
|
|
|
ok i looked at the code , i dont understand why you loop. ok i see you fill the dataset and you give the name, now take that name use it in the grid's datamember property and try it again.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
What a load of crap! Seriously, you code is flawed.
You don't need a for loop here. Add 7 days to the date and have only one query. Also just for displaying to grid, you don't need a DataSet. A simple reader should do. Here is the code with some improvements.
string connectionString = ConfigurationManager.AppSettings["conn"];
string query = "select * from appointment where DATE >= @StartDate and DATE <= @EndDate";
using(OleDbConnection connection = new OleDbConnection(connectionString))
using(OleDbCommand command = new OleDbCommand(query, connection);
{
command.Parameters.AddWithValue("@StartDate", selectedDate.ToShortDateString());
command.Parameters.AddWithValue("@EndDate", selectedDate.AddDays(7).ToShortDateString());
connection.Open();
using(OleDbDataReader reader = command.ExecuteReader())
{
GridView1.DataSource = reader;
GridView1.DataBind();
}
connection.Close();
} Note: Code written directly on CP editor. You may need to correct some compilation errors.
|
|
|
|
|
I am developing an application in ASP.NET. I need to do two things:
1- The user who logges in the application (through my login.aspx page) must also be authenticated by Active Directory since every user is also registered on AD and has the same user name.
2- After login, the application must run under his AD account instead of anonymous user, IUSR_MachineName.
any code example will be highly appreciated. Thanks
|
|
|
|
|
Which Authentication you are using?
|
|
|
|
|
I have set both Integrated Windows Authentication and anonymous access in app setting from IIS console.
|
|
|
|
|
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.
|
|
|
|
|
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. ![Smile | :)](https://codeproject.freetls.fastly.net/script/Forums/Images/smiley_smile.gif)
|
|
|
|
|
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. ![Smile | :)](https://codeproject.freetls.fastly.net/script/Forums/Images/smiley_smile.gif)
|
|
|
|
|
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
|
|
|
|