thanks!

I'm using the full version so there may be some differences in Express (I'm not familiar with that product). That said, one way to determine where your .mdf / .ldf files for your db are located is to script the database. Right click on the database you've created, select Script Database As from the popup menu. You may have to follow slightly different steps in Express, but the general idea here is to generate a CREATE DATABASE script. Having done so, you'll notice something along these lines: CREATE DATABASE [YourDbName] ON PRIMARY ( NAME = N'YourDbName', FILENAME = N'C:\Whatever\The\Path\Is\YourDbName.mdf' , SIZE = 45056KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )... There's more to the script of course, but the FILENAME portion will show you exactly where the db file lives. Sql Server uses .mdf files for the database, and .ldf for the log. If you want to move it to a new directory, be sure to move both files. Hope this helps - Christopher Duncan www.PracticalUSA.com Author of The Career Programmer and Unite the Tribes Copywriting Services

Hi, again me, I found one potential prolem to check the authorize, it displays the folloiwng informaitn, "The server is configured to be used to access the specified physical path pass-through authentication with a predefined account. IIS Manager can not verify whether the built-in account has access. Make sure that the application pool identity has Read access to the physical path. If the server is connected to a domain, and the identity of the application pool "Network Service" or "Local System" is to make sure that has <domain> \ $ <computername> read access to the physical path. Try these settings again." Do you think is this cause the problem? if so, then what does it mean exactly?

Yaah... Right... Server.UrlEncode expects the parameter as string .. :) Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

You need to post some code and examples of how it displays wrong, because what you're saying, makes no sense. Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

I think this is not good practice to write the response. Rather use this.ClientScript.RegisterStartupScript(this.GetType(), "myscript", "alert('sth is here!')", true); RegisterStartupScript is there to write javascript output to the client, so why use Response.Write. :) Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

If the user is behind a proxy then REMOTE_ADDR will be the proxy IP address and HTTP_X_FORWARDED_FOR will be the client IP address. HTTP_X_FORWARDED_FOR can consist of multiple comma separated IP addresses for each proxy the request passes through. Generally, client IP is the first of them. Finally, you can rely on the above methods only for Transparent proxies. There is no way to trace the actual IP in case of Anonymous or Distorting proxies. One more good tool for finding country from an IP is this one[^] on codeplex.

I tried as follows, but nothing is special, the line is always displayed on the top! <table style="width: 100%;height:100%"> <tr> <td> <hr /> </td> </tr> </table> modified on Saturday, September 12, 2009 11:15 AM

A simple newline puts character 13 on the input. So if you store it in the database it will hold only character 13(\n) In case you show in DataList, the formatting is done using HTML, so you need <br/> to have new line. Replace \n\r with <br/> and it will work. Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

thanks, actually I have read this two articles before I asked the question here. I found that my problem is different with those mentioned in the articles. My prblem is originated from the save of the multiline text into database. I have checked that if I use 'return' by hand during input text, then the text is correctly saved into database (SQL), but if I do not use 'return' by hand, then the multiline text becomes automatically one line in the database. By the way, I have used 'Text' format to save the text into SQL datatable. i.e. now the problem is becoming: how to let SQL tabel knows the input is multiline text. one strange thing is that: the set width (even small) of DataList control can not display the text into multilines.

thanks for both o you! I got it!

yes.. Actually Take comes as Extension Function to all Enumerable objects. You can use them easily. Only thing is to add System.Linq namespace to your project. The Static class Enumerable defines all those Extension Methods to IEnumerable objects. :thumbsup::thumbsup: Cheers.. Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Well Seraph, The only case that your textbox value doesnt appear to the server side may arise if you textbox is either Enabled = "false" or Readonly = "true" 1 In case of <asp:textbox Enabled="false" The form that holds the textbox doesnt submit itself. So the textbox will always appear to contain ""(Empty string) in the server side. 2. In case of <asp:textbox ReadOnly="true" The form submits the textbox, but always the original value which is used to create the form retains in the server side. Thus any changes to the control doesnt appear. Check whether your textbox is enabled or Readonly. To transmit text from one page to another you might use querystring. Just place in your address yourpage.aspx?x=name&y=age But if the text is coming from the database, I would rather recommend you to fetch it from database every time, because, as this is web, the user might paste the link directly to the address bar rather than coming from the previous page. :cool::cool: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

well, AFAIK there is no way to determine whether the file is actually downloaded in this way. The file is downloaded once you postback totally. :doh: :doh: If there is any other way around, of this.. .please let me know. :thumbsup: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

You can use RowCommandEvent like this. e.Command name give thename of your button you gave in aspx. Now do whatever you want to do. You can also use RowdataBound event. protected void gvCardFeesRReport_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName) { case "First": gvCardFeesRReport.PageIndex = 0; break; case "Prev": if (gvCardFeesRReport.PageIndex > 0) gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageIndex - 1; break; case "Next": if (gvCardFeesRReport.PageIndex < gvCardFeesRReport.PageCount - 1) gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageIndex + 1; break; case "Last": gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageCount - 1; break; } } catch (System.Threading.ThreadAbortException) { } Inderjeet Kaur Sr. Software Engg

Well, Response.End will force the Response to end even if there might be a large no of lines being executed after that. It is better to use Response.Clear before download and Response.End after transmitting the file. :thumbsup: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Generally, before calling any javascript function, you need to add the source to the head element of the page using script tag. RegisterStartupScript just does this. It adds the script src to the page so that you can call it later. Generally, Startup scripts which are added by ScriptManager is not required to be registered by yourself. As ASP.NET controls adds up those for you. But if you need some custom script to be added to your page, you can use this function. :rose: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

use expressions width: expression((documentElement.clientWidth < 725) ? "725px" : "auto" similar to this. Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

You can use div and in the style attribute use absolute positioning with y axis and x axis.

Why your file's name must have sharp (#) character as part name of file? I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com