"|DataDirectory|" is a substitution string that represents where the database file is stored. To set where |DataDirectory| resolves to, you have to call the AppDomain.SetData method. If you don't set the DataDirectory property, |DataDirectory| will default to App_Data for a web application or the "Application Data" folder (I think) for a winforms app. If you're having trouble getting your connection string working correctly, this website[^] can be quite useful. Hope that helps.

hi, first initial catalog not initial catalogue :) second Initial Catalog and AttachDbFilename tags are ways to specify database place if use Initial Catalog mean that database is on server which Data Source tag says and connection must be opened toward database which it's name is in Initial Catalog and if use AttachDbFilename we specified physical place of database file if database file is on local machine and is not attached to local SQL server use AttachDbFilename else use Initial Catalog :thumbsup:

Nah, I just skimmed it, and noticed the bold sections, which may have indicated that's where the OP thought the problem was... I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

Hello, See computer does what we ask to do.. It's not a magic or cannot play games with us.. right :) So what I think is that, check whether really that table is there or not in the database.... I mean to say that check the data source of ur crystal report. May be something happened without ur knowledge..who knows? :-O :) Niladri Biswas

thnx 4 reply.my reports not contain so much code it simply bind a record with a button. protected void Button1_Click(object sender, EventArgs e) { ReportDocument cryRpt = new ReportDocument(); cryRpt.Load("C:\\WebSite1\\CrystalReport2.rpt"); CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.RefreshReport(); }

Do you have the vaguest idea what this code does ? Have you stepped through it to see where it gets stuck ? Are the values being passed in correct for your database, or did you just copy random code ? I am guessing you don't have a Coupon Management.mdf, or you have some other issue that's causing the database connection to time out, hence the wait. Either way, programming and copying random code off the web, THEN asking us to make it work for you ( without even giving us the info we need to try to work out why it's not running ), are two different things. If you're being paid for the latter, you should tell your client you don't know what you're doing. If you're trying to learn, you shouldn't start with random code snippets, you should start with a book. 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.

This should really be posted in the asp.net forum, bur the process is the same as for winforms. First, move the connection strings from the AppSettings into the specialised connectionStrings section(you'll have to google for this as I'm replying from my phone). This has a few advantages, first you can get a Connectionstring object, the connection strings can be encrypted in config separately and (most important in your case) the connection strings are now separate from the other app config. Now all you need to do is iterate over the set of connection string and add the names to the dropdown list. Note that sending the strings themselves down to the client is a security risk. Once the client has responded with a selected name you can use it to look up the string from the config. CCC solved so far: 2 (including a Hard One!)

The code you have copy-and-pasted is almost certainly wrong. I don't know the 1st thing about Crystal Reports (thank higher-being of your choice), but a quick search on the web brought up this (which is similar to your code) public void SetParameter(string name, object value) { //Access the specified parameter from the parameters collection CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition parameter = _reportDocument.DataDefinition.ParameterFields[name]; // Now get the current value for the parameter and clear them CrystalDecisions.Shared.ParameterValues currentValues = parameter.CurrentValues; currentValues.Clear(); // Create a value object for Crystal reports and assign the specified value. CrystalDecisions.Shared.ParameterDiscreteValue newValue = new CrystalDecisions.Shared.ParameterDiscreteValue(); newValue.Value = value; // Now add the new value to the values collection and apply the // collection to the report. currentValues.Add(newValue); parameter.ApplyCurrentValues(currentValues); } So it looks like ApplyCurrentValues is a method on the parameter. CCC solved so far: 2 (including a Hard One!)

Dear First you tell me on which Architechture your website is?? after that For silverlight you have to Make a Custom Usercontrol of dropdown... But Vertical Horizontal bars are inbuilt in ASP.net..but for horizontal it cant be posible in ASP.net Only Solution You Set a width to your Dropdown And you Put only this dropdown in your TR Or TD

thnx 4 the suggestions but i want to get Date parameters value at run time.what should i do?

I'd guess the SQL or database forums are appropriate, you posted SQL. 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.

thnx Nigel now its working when i change its datatype. again thank u very much

Christian Graus wrote: and deliver a project that is poorly written, unmaintainable, and totally insecure. Whatever Christian is pointed out is right but If proper code review is there it won't happen. right? Arun Jacob http://codepronet.blogspot.com/

Thanx 4 ur kind suggestions. I will try my best to work on the issues u have mentioned in ur reply.

:thumbsup: Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

there is no error the code u suggest but on run it not show gridview.

This article may help your for your further development of gridview. Maintain GridView Scroll Position and Header Inside Update Panel[^] This is just for your reference :) Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

Why do you say it does not Work. Do you get some sort of Error Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

I forget to add this code in aspx file now its working. Thread end here <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager>