Thanx, but we are using .net framework 2.0. Is it possible in 2.0?

We have to generate some graphs like Pic chart etc, based on data stored in sql server. We have to use   C# only. 1. I am not sure what's the approach for this, I mean which control etc to be used 2. Is this requirement simple one or do we need to use some plug in? please share if u have any sample code in C#.

I tried with different user, I am getting similar error: The Microsoft Office Access database engine cannot open or write to the file 'C:\Users\Public'. It is already opened exclusively by another user, or you need permission to view and write its data.

I am posting the exact error that i Got at oledbConn.Open(); Exception ex ex.message returns "C:\Users\vikas_aggarwal01\Desktop\Kapil.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides." ex.source returns " Microsoft Office Access Database Engine" The above error comes only when another user tries to do it.

i have not got u completely. see code is on webseerver. we r calling from any other machine. When local machine try to access webserver, it asks for username and password, but after that does not open excel file. I did not get "But you have the file data, why not write it locally and read it from there ? "

I am agreeing that issue is with some permissions. It is web based application, any one can use it. After accessing the URL from local machine, any user can try to select excel placed in any location on his desktop. So how to do settings on IIS so that any user could do it, not just who configured IIS.

Label1.Text = FileUpload1.PostedFile.FileName; containing name and path of excel file

I have written a code to upload data from excel to oracle database in asp.net.This code is working fine on local machine. I have hosted this code on web server IIS 5.1 using my credentials(OS window XP SP3, so default IIS is 5.1). Problem : When I login on the server machine using my login id ,the application runs fine. If I try to run this application from another local machine other than server(using same my login id) then also there is no problem. But if someone else logs in into a local machine and tried to run the application using his id   then it’s not working.. This is my connection string: OleDbConnection oledbConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + Label1.Text + ";" + "Extended Properties=Excel 12.0"); The code fails after oledbConn.Open(); when someone else logs in into a local machine

no error as such. It does not return anything, i mean return null.

I have applied your code. st = <% withparam(10) %>;->It does not work. Please let me know the solution.

ASP.NET function: public int withparam(int x) { int y; y = x + 10; return y; } HTML button function Button1_onclick() { <% var st = withparam(10); %>; document.write(st); } When i click on button, it says var st could not be found. Please let me know where the syntax is wrong and is this the right way

That I got. But what's the solution?

whether use asp button or html button, does not matter.

Hi Christian, You are right. After entering emp id in text box, if i directly click on any button, textchanged event takes place. So could not get any solution yet how to stop textchanged event if we click on a button. Note:As button is HTML control, so i am using onclick event only.

I let u know about a simple reproducable code. Drag an asp text box control. Drag an HTML button control. Make the autopost back of textbox=TRUE protected void TextBox2_TextChanged(object sender, EventArgs e)       {                Response.Write("hi");       } function Button1_onclick() { alert('clicked button'); } Run it. Enter any text in text box and click on button. Button will display "hi", it will not trigger its own event. So I want that on button click, TextBox2_TextChanged event should not take place. IN any other condition, it shold work fine.

Hi, There are some text boxes , one "back" and one "reset" button on screen. One text box is employee id. After entering employee id, it populates the rest details in other text boxes. This code is written in text_changed event. it works fine. Issue is with following scenario: Suppose I enter emp id in text box and directly jump to Back button and click it. Now text_changed event take place, rest of details will be populated, we will not go to back page. We will have to reclick back button to go back. Same holds true for reset. So how to avoid this i.e. data should not be populated when we directly jump from text box to back button, should go to back page. same for reset button.

Just providing more details about my requirement: I have a gridview that has a dropdown column. All works fine until I go to edit mode. Here if change any value in dropdown, I can select that. But what about the original value? how to fetch that?

I have to update a table based on some values in different dropdowns. One of these values is part of composite primary key also. In row_updating event, I have written the code to update the tabel. Update table xyz set order=order_dropdown.selectedvalue, some more values... where emp_id=3,order=order_dropdown.selectedvalue. Now in "where" and "set" clauses, order_dropdown.selectedvalue has used. "where" should pick up the old value ideally but it will pick up latest value. Due to this, updation does not take place. So how to capture the original value in row_editing event and pass that original value in row_updating event?

1. Used ASP.NET controls: dropdown and textbox. 2. For the 1st time at page load, some default values should be populated in dropdown and 1st value in text box. Written the below code protected void Page_Load(object sender, EventArgs e)       {             if (!IsPostBack)             {                   DropDownList1.Items.Add("a");                   DropDownList1.Items.Add("b");                   DropDownList1.Items.Add("c");             TextBox1.Text = DropDownList1.SelectedValue;                         }       } 3. Set the autopostback of dropdown=False. So "DropDownList1_SelectedIndexChanged1" will not work. I have done this because after selecting any value in dropdown, post back should   not take place. 4. Now we have values in drop down. I want to select a value in dropdown and same selected value should be visible in text box. I want a java script for this. Not able to write it as not able to find any client event for dropdown. Actually there is event "onclientclick" for an asp.net button control, but did not find any such event for dropdown. So how to write java script code.

PUT A FORM ON THE PAGE !!!! I have inherited master page. Now I will have to paste controls on Content. Can we still post a form, there is so speciic control as such