Hi I need help. Have drag-and-drop for the components eg. dataset, bindingsource and table adpters. There is now a default connection string in my app.config file. The user can now ,using FileOpenDialog on the main form, choose a different database if they want. I simply take this path as a public static string and assign it as the new connectionString. obviously now the dataset must change accordingly. which is does on this main form. but as soon as i load a child form and still want to use this new dataset obviously, the connection string is changed in the designer code of the tableAdapter.fill() method back to the default connectionstring in the app.config file. Declaring my connection string as a public static variable worked perfectly in another project where i actually programmatically created my dataset,bindingsource and table adapters. Is this one of the limitations one has when using drag and drop components??:confused: Please if someone could help me..

Thanks for the response. Did what you said in another project, where i had programmatically created my dataset,binding source and table adapters etc. it worked 100 %. but the problem with this project is that i drag and dropped the components. And now when I call the tableadapters.fill() method on the child form, in the autogenerated designer code, it gets its connection string from

ProjectName.Properties.Settings.Default.StaffConnectionString

which is in the app.config file. Is this one of the limitations of using drag-and-drop components?Or is there a way of working around this? I really hope there is a way around cos this is going to require alot of recoding. Thanks again for the response..

Hi Im havin problems with my connection to my databases. I have a default connection string hardcoded in the appconfig file. I have a main form where i use opendialog to connect to another database of my choice. Everything works fine on this form, it connects to the new selected database. BUT now as soon as i go to a child form, it seems to loose that connection to the selected database and then makes use of the default hard coded string in the appconfig file. How do i keep the new selected connection over all my forms? Please if anyone could help me..would greatly appreciate it. Thanks

i think it was more about my query..i can see now that i need a subquery.

Thanks for the reply, I think i figured out what was wrong. It was expected to return alot of records.in the high thousands. Thanks again for reply

Hi I hav a problem with my stored procedure, its taking far too long. I have used simple JOIN statements, but unfortunately I have 7 tables to JOIN and therefore 6 JOIN statements in this one procedure. There is also a simple SUM calculation happening within this query as well. But this procedure is takin far too long to get the results. Was going on 18 minutes and counting when i cancelled it. :( Can anyone help me out?

hi I cant seem to add 24 hours onto a datetime variable. i have a startTime value and with that i want to add 24 hours to it to get a endTime. what i have right now is: DateTime startTime = DateTime.Parse(Request.QueryString["LogonDate"]); DateTime endTime = startTime; endTime.AddHours(24); startTime's value is for eg. "2007/06/01 12:00:00AM" but its not adding 24hours to endTime variable. It stays the same as the startTime. Please somebody help me..

Hi Im using Fusion Charts. My problem is that i have a page that generates a chart BUT the page itself does not seem to be able to store the value of a variable. Cos I want to print out the objects values in a panel next to the chart. It looks like the Fusion Chart uses Javascript, i dont know if this is the problem here. What i think could solve my problem was if i could create a page within a page. So ie. my panel could be in one page and the chart in another.Kind of like Outlook. If this will help, will someone please help me out with how to go about doing this??

Hi Im using Fusion Charts. My problem is that i have a page that generates a chart BUT the page itself does not seem to be able to store the value of a variable. Cos I want to print out the objects values in a panel next to the chart. It looks like the Fusion Chart uses Javascript, i dont know if this is the problem here. What i think could solve my problem was if i could create a page within a page. So ie. my panel could be in one page and the chart in another.Kind of like Outlook. If this will help, will someone please help me out with how to go about doing this?? here is my code,in case problem is with the code: string username; username = Request.QueryString["Username"]; lblUsername.Text = username; //following gets the specific users dailycount for the last week PCUserDetails[] userArray = dbComponent.GetWeeksUsage(username); //xmlData will be used to store the entire XML document generated string xmlData; xmlData = ""; //loop running through each object result in array of users, and creating rest of xml foreach (PCUserDetails user in userArray) { //Convert data to XML and append xmlData += ""; } //Close element xmlData += ""; //Create the chart - Column 3D Chart with data contained in xmlData return InfoSoftGlobal.FusionCharts.RenderChart("FusionCharts/Column3D.swf", "", xmlData, "CountMp3Week", "400", "300", false, false); } Thanks

hi How does one populate a grid with an array of objects? this is the code for populatin a dropdown list control. Author[] authorArray = dbComponent.GetAuthors(); foreach (Author a in authorArray) { ListItem item = new ListItem(); item.Text = a.FirstName + " " + a.LastName; item.Value = a.AuthorID; ddlAuthor.Items.Add(item); } but i want to populate a grid control... could anyone please help. Thanks

yes, it works. its GETDATE() for sql server. Thanks Alot!:)

hi i want to be able to give the user the option to select either Top 10, Top 20 or Top 30 from a result set. In my page they select from a drop down list and it must produce the graph accordingly, I would like to make 'Top' figure to be a variable so i only have to do one stored procedure.Not one for each Top 10, Top 20 or Top 30. Is this possible? Or do i have to create a stored procedure for each and then just call the appropriate procedure in my code? Thanks

thanks for the reply. i tried that DATE() function but its not working, im using SQL Server.dont know if thats the problem. Is that 'DATE()' suppose to give me the current date?

Hi I want to use a Windows Service to call certain stored procedures once a day. It needs to pass the DateTime.Now as a variable to these stored procedures. If someone could please help me out as to how i implement a timer and call stored procedures and pass the current datetime to the stored procedures. Thanks

Hi.. could someone plz help me out.. I want to create a number of classes. i was told to use nested classes. but im a bit unclear as to how to do this. Looking at my tables in my database, i have the followin tables: User(list of pc users), Logon(has date,user and pc), File(the file on that PC), PC, Group(the group to which that pc belongs). With these tables i want to generate reports. Ive started creating the class for User but now how do i go about creating the rest?

thanks for the reply. i have a table "DailyUsage", which has 3 fields, namely Username, TheDate, DailyCount. primary key is a combination of Username and TheDate. Now, because this table is pretty big, cos its storing daily usage for the last year, I want to do a sort of round robin methodoligy so my reports can run alot quicker. So, ive created a table called "weeklyUsage" which will have Username, TheDate, and WeeklyCount. tbl WeeklyUsage will have only for example the last 3 or 4 weeks of data in it. So, I need to do a SUM of DailyCounts for each username for the last 3 or 4 weeks and then insert into tbl WeeklyUsage...

hi. could someone please help me out. im tryin to take data from one table, summarize it, and insert it into a new table. what i have is a current 'daily' stats table for a user. but now what i want to do is take that data and add up 7 days worth of stats for each user. so, in other words, i have the last weeks stats for each user. basically i need to know how to select data out daily table and then insert into weekly table. Thanks!

Sorry..i just figured it out! it was a very small thing. on the 2nd content page,within one of the content placeholders, i right-clicked and saw the option of Default to Master's Content. Solved all my problems! Thanks for the help though

all i did was make a master page. place 2 images and a menu control in the masterpage. Then added a new web form and selected the masterPage to inherit. It did not inherit the controls until I added a content placeholder to the masterpage.It then showed the controls in the webform.worked perfectly..but now i wanted to add another webform to the site.which i did, and also selected the masterpage but its not showing any of those controls from the masterpage. dont understand why it worked perfectly for the 1st page but not the 2nd. If u have a simple mock up for me i would greatly appreciate it.

Thanks for the reply. I have only placed the controls so far on my masterpage. The first content page that i created, that inherits from the masterpage, worked perfectly.but then i added another webform and specified that it must also inherit from the masterpage.. but its not showing the controls that i placed in the masterpage.