|
Hi thanks Sandeep,
Well, this works for IE but unfortunately it won't work for Fire Fox
for some reason...
|
|
|
|
|
Respected
How we Import ExcelSheetData into SqlServer2005 Table,by using Asp.net with C# .
Thanks.
|
|
|
|
|
Rather convert your file into .csv(comma delimeted file) and use bulk insert like:
USE your_database_name
Go
BULK INSERT [your_table_name]
FROM 'C:\FolderName\FileName.csv'
WITH
(
FIELDTERMINATOR=',',--this means that your fields(columns) are separated by commas
ROWTERMINATOR = '\n'--and it says that new line is a row terminator
)
GO
From Excel, go File > Save As > Save As file type, look for csv
Good luck.
|
|
|
|
|
I have installed Windows 7, VS2010 and .NET40
I'm getting the error below.
Error Summary HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid. Detailed Error Information Module IIS Web Core Notification Unknown Handler Not yet determined Error Code 0x80070032 Config Error The configuration section 'system.web.extensions' cannot be read because it is missing a section declaration Config File \\?\C:\inetpub\wwwroot\web.config
i am confused as to what this means. because i have the <system.web.extensions> in my web.config. thanks in advance for helping out.
|
|
|
|
|
Check the permissions for your web site.
me, me, me
"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven
|
|
|
|
|
A detailed answer can be found here[^], along with screen shots, detailing the fix.
Basically, IIS is set up so that the DefaultAppPool is running under .Net 2.0 and you need to change it to run under .Net 4.0
|
|
|
|
|
Thanks for attending to my question. i guess i figured it out and it's working fine now.
I did have an error in my web.config file, which when fixed worked fine.
I had to change the true in compilation debug="true"' tag with false
So instead I declared it with false and it worked.
|
|
|
|
|
Hi,
I want to send a message to the parent page when a button is click on the ascx control.
How can i accomplish this?
Thanks
|
|
|
|
|
form ascx page button click do something like this.
parent.document.getElementById("ParentControlID").value="your message";
Raju.M
|
|
|
|
|
|
in ascx codebehind add
protected void Page_Load(object sender, EventArgs e)
{
Button1.Attributes.Add("OnClick", "javascript:alert('your message');");
}
 try and tell us how it worked 
|
|
|
|
|
Hi
I have a gridview which has button that allows a user to click and download an xml file stored else where using force download - Response.AddHeader whether.
However, whilst this all works fine, when file is downloaded it prompts the user to save the file first and then opens the saved file in a new window. What I want to do is not to save the file first, but to immediately open the file in a new window without saving. I have tried all sorts of things, but none have satisfied the design I want to implement.
Thus:
1) Response.ContentType = "Applicaton/vnd.ms-xml"; This cause the user to save the file first before opening in a new page
2) Response.ContentType = "text/xml"; Opens in the window without saving first but opens in the existing window without allowing the user to go back to the gridview from where they clicked.
Does anyone have a way round this where I can open in a new window without saving?
Thanks
|
|
|
|
|
Create a separate page for Xml. Use window.open from the GridView Click where you can use your Xml writing logic.
|
|
|
|
|
Hello,
I am trying to set up a Master-Details feature with two distinct lists of links on the "Master" side and one control on the "Details" side, all displaying on the same page. For example, the Master control(s) would display a list of links to item details, separated into two sections:
Teachers
link1
link2
link3
Students
link1
link2
link3
...each of the links under both "Teachers" and "Students" would populate a single Details control with data appropriate to the selected link.
Right now I have a simple Master/Details on a single page using a single column gridview as the Master (<asp:ButtonField CommandName="Select" />) and a FormView control for Details. The Master Details relationship is handled declaratively with a <SelectParameters> in the Detail control's SQL Data Source. However, this arrangement only allows for a single column of Master links, i.e.:
Teachers & Students
link1
link2
link3
link4
link5
link6
...is there any way to
1. have two Master controls feed to the same details control?
2. have a Details control for each Master list, but swap visibility for each Detail control so it appears that there is only one Details control on the page?
3. have a Master control like a gridview or datalist display two sections of links, one on top of the other, each section with its own HeaderText, controlling the same Details control?
4. or perhaps use a pair of Master Gridviews nested within a parent Master Gridview leading to the single Details control?
I'm not sure what the best way to proceed is - thanks for any advice!
|
|
|
|
|
Hi
How to get unique session id that generated same for all browser tabs and different and always unique when we close and open new browser in asp.net code.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Could you please phrase your question clearly?
FYI,
You will get an Unique Session ID only when the Session is created.
|
|
|
|
|
Sessions are usually based on cookies and it would be upto the browser as to whether tabs can share cookies or they are persited after the browser is cleared (provided you've set an expiry date).
A new session is created when a valid session cookie isn't found by ASP.Net.
|
|
|
|
|
I'm developing in apsx.net and vb.net 2005.
I have 3 pages in my application that are longer than one viewing screen, causing the uwser to scroll to update and see data down the page. The first is of static size, that is the actual page size does not change, there is just a lot of information on the page and the user needs to be able to see all and make changes before processing.
The other two pages are dynamic in nature based on choices that the client makes.
The problem I'm having is that each time the user makes a change that required him to scroll down the page, when the page refreshes, it returns to the top, forcing the user to scroll back down the page to see the affect of his changes.
How do I get the page to refresh with the same view the user had when the change was made.
Thanks in advance for your assistance..
Chuck..
|
|
|
|
|
Anchor tag is your friend. Look at the named anchor tag. When you post to the page, pass the anchor tag and the page will scroll (automagically) on refresh.
Anchor Tag Help[^]
|
|
|
|
|
Thanks for the start..
I have 2 followup questions:
1) does that mean I have to put 'a name="[name of field]"' on every field that can be updated, including the dynamic fields?
2) how is the reference invoked upon refresh, please show code snippet?
Thanks again..
Chuck..
|
|
|
|
|
Ok, the general notion is that you add named anchor tags to your page, say something like
<a NAME="ID218395" HREF="#"><a>
notice the title for the anchor tag is blank, so it can not be seen by the user. If you want to be click-able then give it a title
<a NAME="ID218395" HREF="#">My Cool Link<a>
now call the page as
myCoolPage.aspx#ID218395
that is all.
|
|
|
|
|
I have the same prblems with my long page, pls is there no way
other than using the anchor tags?
thanks.
|
|
|
|
|
Enobong Adahada wrote: I have the same prblems
what is your prblems problems. speak up (properly) and you may be heard. What is wrong with the named anchor tag. I use it on very long page and a have plenty sprinkled though out the page.
|
|
|
|
|
Yusuf, this looks like something that will really work for me.
First I have never used anchors before so there a little be of confusion here on my part. This is an asp.net with vb.net as the code behind.
So when something is changed that causes a postback then the code behind is invoked. How do I activate the anchor location so when the page is redisplayed it envokes the target anchor because there will be at least 20 anchors on each page?
So just to be clear I don't have a problem with creating a hundred anchors if necessary, it is just how to activate the appropiate anchor. If for example an entry from the travel dropdownlist is selected I will need to process the selection then redisplay the page. Upon selecting the dropdownlist theI will need to know its anchor. After exceuting the AutoPostBack routine I will want to return to the anchor for that dropdownlist location.
I hope I am not making this too complicated.
Thanks again..
Chuck..
|
|
|
|
|
MacIntyre wrote: First I have never used anchors before so there a little be of confusion here on my part.
Chris, don't feel bad. We're all there one day or another. We'd to start from zero.
MacIntyre wrote: This is an asp.net with vb.net as the code behind.
No matter what you are using, behind the scene, it will spit out HTML code. So, you need to hone your HTML knowledge. Anchor tags are one example.
MacIntyre wrote: How do I activate the anchor location so when the page is redisplayed it envokes the target anchor because there will be at least 20 anchors on each page?
Well, what is causing the page refresh? Is it button click? or other user action? If it is button click then you need to add the anchored tag to your Response.Redirect() page.
If you give us some more detail about your code we may help you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
