|
A few thoughts:
Check your path.
Don't use reserved words as your sheet name. Try "TheTime" or something instead.
I think you need to provide escaped quotes in the "Extended Properties" part of your connection string.
I.E.
<add name="ExcelConnection" connectionString="Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Documents and Settings\Steven\My Documents\example.xls;Extended Properties=""Excel 8.0"""/><br />
|
|
|
|
|
Hy!
I've found that GridView has a property: AllowSorting which can be true or false, but I didn't find out how to sort a column's information just by pressing the column header and nothing else.
I'm still looking for this, but i'm little hurry rigth now!
Thanks!
|
|
|
|
|
SortExpression="DatabaseColumnName"
think this will work
|
|
|
|
|
Thanks!
I'll try and tell the result.
|
|
|
|
|
There is a problem with the column header. Although i have set the AllowSorting with the true value I can't click the column's header.
|
|
|
|
|
Hi! I have one issue and I am sure that many guys here know how to help me. I am building a web application in ASP.NET with C#, and now I have a dropdownlist connected to the field in the database, and I have a label, and I want to display other value from the database there. Like, I am selecting my name in the dropdown list, and in the label it should display my second name. Thanks ahead
|
|
|
|
|
1. Select the data from the database
2. put in dataset or some sort of source
3. string value = some sort of source
4. label.text = string
something like that 
|
|
|
|
|
that's ok, but I want to make like if the username is selected, then display the password in the label from the same table, and how should I make that statement. Thx
|
|
|
|
|
use an onclick for when the username is selected
public onclick
set username selected as string value
stusername = ddusername
select password from table where username = '" stusername"'
that help?
|
|
|
|
|
hi to everyone! I have this problem, when I want to bind a data to label, i am going with:
Label1.Databindings.Add("Text", dataset1, "informations.username");
and i get this mistake:System.Web.UI.WebControls.Label' does not contain a definition for 'Databindings'
Any help? Thanks
|
|
|
|
|
textBox1.DataBindings.Add(new Binding("Text", dataset1, "informations.username"));
Try This It will work
|
|
|
|
|
Hi everybody.
I have this porcion and i want ,from the onclick event, to get a simple string that is in the first column of the clicked row, in the gridview
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Attributes["OnClick"] = ClientScript.GetPostBackClientHyperlink(this.GridView1, "Select$" + e.Row.RowIndex.ToString();
string thefistvalue = <---- what i write here?
}
please help me.
thanks
|
|
|
|
|
do you mean something like
GridView.DataKeys[i].Values[i].ToString();
set datakeys as one of the values you want
this might help
|
|
|
|
|
thank you a-+s-+p-+
wath is this "i"?
is int i = GrieView.SelectedIndex; ?
this give me index out of range.
|
|
|
|
|
the i that i've used is in a for statement, its up to you how you write the format of it
|
|
|
|
|
 need help
Hi quys,I stored a pdf file in database.. I want to open that pdf file in a IFrame...
please help
|
|
|
|
|
did the article i posted not help
please avoid re-posting your messages
|
|
|
|
|
You just need to stream it by using REsponse.BinaryWrite and setting the contentType appropriately.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
please help..
Any one know how to open doc, excel and pdf files in iframe using asp.net
|
|
|
|
|
check this out
http://geekswithblogs.net/narent/archive/2007/06/21/113361.aspx
|
|
|
|
|
Hi,
i have two textboxes to enter the start and end dates. I am using javascript calendar to populate these text boxes. Based on the chosen date values, i need to filter a treeview control.
The problem is, the ontextchanged event of the textbox is not firing, when the date is chosen from the javascript calendar. If you enter the date directly into the textbox, the event is firing.
I need to find out how to fire the ontextchanged event when the date is chosen from the javascript calendar. Please help.
Madhan.
|
|
|
|
|
madhan_mss wrote: how to fire the ontextchanged event when the date is chosen from the javascript calendar.
onTextChange fires only in case of editing the textbox by hand
Instead, you can put your code on SelectionChanged event of the calendar
Mohamed Gouda
Egypt
|
|
|
|
|
The calendar is a javascript. I am unable to trigger this event due to this. Is there any other way to achive this?..
|
|
|
|
|
just as a point maybe you should use asp.net calendar control
javascript can be disabled at the client end
|
|
|
|
|
Most people don't use that because it sucks, javascript ones are much nicer.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
