|
From the following code line
content-disposition to "attachment"
Remove content-disposition to attachment it will not ask you for the save/open dialog...
Try it out....
I was born dumb!!
 Programming made me laugh !!!
--sid--
|
|
|
|
|
Hello All
How can i fetch the records from an excel sheet for a particular date.
i want to pass the date from frontend and fetch only those records which satisfy the condition.
my code is:----------
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
Dim cnCSV As New OleDbConnection(strConnectionString)
cnCSV.Open()
'Dim cmdSelect As New OleDbCommand("SELECT * FROM [sheet1$] where [Tube Dia]=22", cnCSV)
Dim cmdSelect As New OleDbCommand("SELECT * FROM [sheet1$] where [Invoice date]='14/04/2006'", cnCSV)
cmdSelect.CommandType = CommandType.Text
Dim daCSV As New OleDbDataAdapter
daCSV.SelectCommand = cmdSelect
Dim ds As New DataSet
daCSV.Fill(ds)
Oledb is treating my date as string
how to convert my string parameter('14/04/2006') to date.
|
|
|
|
|
Iam very good in OOP but ...
why Event of controls in asp.net defined as protected
aj123
|
|
|
|
|
I would guess it is because they didn't want anyone overriding them.
Ben
|
|
|
|
|
I'm pretty sure they don't necessarily have to be, thats just the way VS adds them in, no reason they couldn't be public (they can't be private as the page that ends up as a subclass of your code-behind has to access them).
|
|
|
|
|
A page class instance exists only for a single postback. As it has no persistence, nothing external is ever going to access the event, unless it's in a control, but the fact is, it cannot be private ( as the aspx is turned into a class DERIVED from the code behind ), and it shouldn't be public ( no external class should be calling an event handler )
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi everybody! I have a problem! I have some usercontrol, tell me how I can load each usercontrol when I need with only one palceholder?
Thanks!
THT
|
|
|
|
|
its very simple .............if u want one usercontrol ata time.
if u want to display one user control place it in a place holder when pageloads by keeping placeholder id and runat="server" attributes. and when the data changes place another usercontrol when needed.
Like
In source declare those usercontrols as <%@register and.............>
and place a placeholder with id and runat="server" attributes.
//Creating an instance of UserControl
usercontrols_UserControl1 uc = (usercontrols_UserControl1 )Page.LoadControl("usercontrols\\UserControl1 ");
//loading the user control dynamically
//assign the label text a value
phUserControl.Controls.Add(uc);
|
|
|
|
|
Hello,
How can I add dynamic controles to my web form at run time and working with its events and values.
Thanks.
Dad
|
|
|
|
|
TextBox txt = new TextBox();
Button btn = new Button();
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
btn.Text = "Test Button";
btn.Click += new EventHandler(btn_Click);
Page.Form.Controls.Add(txt);
Page.Form.Controls.Add(btn);
}
void btn_Click(object sender, EventArgs e)
{
btn.Text = txt.Text;
}
We Can Do Anything, If We Want It
|
|
|
|
|
Thanks that is great
but I want to add these controles when I click a button ,The probleme is that when the page come back from the server it lose all my controles.
so what can I do?
thanks .
Dad
|
|
|
|
|
The problem you are having, has to do with way the page is constructed during a webrequest.
The site constructs the basic structure of the page and fills in the values after the controls are constructed. This is done with every webrequest, so you have to inject your controls during the period that the structure of the page is constructed.
One thing you can do is add the controls to a list in the session state and rebuild the structure from that every time the page is initialized. You will also need to fill in the values that the controls originally had.
WM.
What about weapons of mass-construction?
"What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson
My blog
|
|
|
|
|
If you cuse dynamic controls, it will lost in postbacks.
So i think u should keep its value (textboix value) to a hidden filed and and recreate it after postback and assign this hiden fild value to the dynamic control...
i didnt think it is not a good idea to use dynamic controls.It defenitley affects the perfomance..
All I ever wanted is what others have....
CrazySanker
|
|
|
|
|
hi,
I used UpdatePanel in one page.there is some controls in this UpdatePanel.
then I added ModalPopupExtender to page and set it's properties and then run the page. I faced with this Error :
"An extender can't be in a different UpdatePanel than the control it extends"
Please Help Me.
Thank you.
|
|
|
|
|
Its pretty self explanatory - you've put an extender control on your page that extends a control within a different updatepanel. This is a restriction of the extender framework (unfortunately, I've come across troubles with it before), an extender MUST be inside the same updatepanel as the control it 'extends'.
|
|
|
|
|
|
|
Thank You Very good Answer Its working for me..
|
|
|
|
|
Hi friends
i have one page in which i put iframe.
In iframe i have one dropdownlist and one submit button.
I want to get values of dropdownlist on click of submit button in parent page.
plz help me out
thanks in advance
GOD HELP THOSE WHO HELP THEMSELVES
|
|
|
|
|
Hi
U want to say that u have to populate DropDowList only.
From where u want to populate DropDownList?
Cheers
Chandu
|
|
|
|
|
what is the difference between
<%#databinder.eval(container.dataitem,"")%?
and
<%#eval("")%>
|
|
|
|
|
I think use <%#databinder.eval(container.dataitem,"")% for 1.1 and <%#eval("")%> for 2.0. But I'm not sure!
THT
|
|
|
|
|
I am new to ASP.Net I have visual studio 2005 to be used as development tool.
Can anyone guide me how to make a guest book that simply add a new guest and also we can view all the guest in grid view.
What should I do ?
Whether I should create a database?
I should use disconnected connection?
When should I update original database?
Please guide me.
Thank you.
|
|
|
|
|
1 - obviously
2 - ADO.NET only allows a disconnected model, which makes sense
3 - When someone adds an entry
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi
In my application, I am sending an unique value through QueryString to the next page and I have retrive the Query String value in the next HTML page and to get focused on the Text not on the TextBox or Value that is presented no the same page.
I have to get the QueryString value only in the HTML page as I have to use that value in HTML.
Is this possible?If yes How?
Please suggest me an Example.
Thank u
Chandu
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
