Hi, I am really struggling to work with the parameters in Crystal Reports in Visual Studio 2008 C#. I keep on getting the annoying parameter input dialog which i dont want. Can anyone suggest a good book for Crystal Reports XI for Visual Studio 2005 or 2008? Also i work with SQL 2005. The books i have found online do not have any good reviews and user comments :/ Thanks

Hi, Does anyone know how to send parameters through to a crystal report in VS 2008? I keep on getting this dialog that asks me to enter the discrete value of the parameter. I would like to send the parameter value through code once the user has selected their filter choice. This is for Windows Form application and I'm using SQL 2005 Express as the database. I have googled but cant find a working solution. Thanks

I did that by using message boxes and it worked but then sometimes it just doesn't work. I have changed some values it seems to be working now but i still feel unsafe. Will do more tests thanks.

I was doing this but gets too complicated to run one procedure say at 13:00 everyday and 2 other procedures on different time intervals. If i run a procedure under a timers tick event, isn't that set in its own thread too? I'm just worried that if two different procedures run at the same time so they don't crash or something.

Hi, I'm sitting with a weird problem. I created an application in C# 2005 Express. It has 3 timer controls in it. The first timer runs as a clock (system clock) and once this timer reaches a specific time during the day it runs its procedure (this works fine) The 2nd timer has its Interval set to 10min. So every 10 minutes it needs to run its procedure.(doesn't do it) The 3rd timer has its Interval set to 10Sec. So every 10 second it needs to run its two procedures (doesn't do it either); Now when i run this app in debug mode everything works perfect. Breakpoints are being reached all the time, I don't see any problems. But once i publish the app and install it on a users machine it doesn't always run the procedures :confused: As u probably realized is that this application is an auto update app which auto updates data (retrieve data from webservice then update the local SQL database) Any help would be greatly appreciated. I need to get this working by midday tomorrow. Any other suggestions would be great. Thanks

Thanks alot this looks exactly what im looking for. Will put it to the test :)

Thanks for your response. The thing is im not calling anything to close the app as the app needs to run all the time unless the pc shuts down. So basically once the user shuts down the pc my app needs to somehow know that the pc is shutting down so it can exit itself. But another question is why doesn't windows kill the process because its trying to shutdown? Thanks

Hi, Ive written a small app which runs in the system tray and runs calls from a web service on a timer much like a windows service. I'm using C# Express so i had to write this as a windows application. Everything is working great. Only problem is that users are not allowed to exit this application. Only way to kill the app is by killing the process in task manager. Anyway if the user tries to shutdown his PC it just doesn't shutdown until the process of the app has been killed. :confused: Anyone have a reason as why this is happening? Thanks :)

Well i read that tables slow your app down. Even tho this app will only be used as intranets on networks so should be fine then. I agree that using tables is the easiest way to setup "input/forms". I do use div to setup the main layout tho. Do you know of any resources on where I can find more info regarding writing actual web apps like windows apps not just normal web apps with a contact form. Im looking for help on writing websites which is based on alot of server side work. Thanks for your reply :)

Hi there, Screen Shot I need some help regarding the screen shot above of my current windows application. What would be the best way to design this layout in ASP.Net? I'm trying to avoid as many tables as possible. When should I use tables and when should I use div tags? Any link or resources on where to find tutorials on converting windows apps to web apps would be greatly appreciated. I tried googling but no luck. Thanks :)

Hi there, Can anyone recommend the best book to learn ASP.Net 2.0 and C#. I have been developing in these languages for a while but I need a good refresher book with good examples and easy understanding. I need to buy myself a decent book asap. Thanks :)

Hi, Can anybody please assist me with the following.I have googled but no luck. I receive a dataset from a webservice which contains all data i requested. How can I simply insert all the rows which are in the dataset into SQL database? The dataset contains three tables and the sql database destination has the exact same tables and columns. any help, suggestions or articles will be greatly appreciated.

Hi, I know that you cannot connect remotely from SQL server 2005 Express to any other sql server. But is it maybe possible to connect remotely from SQL Server 2005 (full edition) to SQL server 2005 express? Thanks

Hi, Im writing an auto update app in vs2005. I would like to call an update procedure from a web service automatically at say 19:00 everyday. What would be the best way of achieving this? I dont need any code or anything just wanna know the best easiest or safest way of doing this and then start googling :P Thanks

Hi, Mmm wasnt sure what to put in the subject lol anyways, Im busy with a web app and one of my pages contain quite a few controls for input. There are a few conditions of when certain controls need to be visible or not. Can anyone please give me some advice or suggestions on how to write proper code in working with conditions in this situation instead of hardcoding everything in a messy way. Please let me know if I didnt explain properly. Thanks

Hi, Would this be a good way to prevent some SQL Injections? I am trying to find the best easiest way to use of command parameters whenever i receive user input to query a database. I have alot of queries so im trying to find a easy reusable procedures to make use of sqlcommand parameters. SqlConnection conn = new SqlConnection(_WebConfig.ConnectionString.ToString()); try { DataTable dtVal = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SELECT ID, Full_Name, Surname " + "FROM Users " + "WHERE Full_Name = @LoginUname " + "AND Password = @LoginPword", conn); da.SelectCommand.Parameters.Add("@LoginUname", SqlDbType.VarChar, 30); da.SelectCommand.Parameters["@LoginUname"].Value = LoginUname; da.SelectCommand.Parameters.Add("@LoginPword", SqlDbType.VarChar, 15); da.SelectCommand.Parameters["@LoginPword"].Value = LoginPword; if (conn.State == ConnectionState.Closed | conn.State == ConnectionState.Closed) { conn.Open(); } da.Fill(dtVal); if (dtVal.Rows.Count == 1) { return true; } else { return false; } } catch (Exception ex) { throw ex; } finally { conn.Close(); conn.Dispose(); } Any advice or other methods would be greatly appreciated Thanks

How can I add this script to my page when I already have the button click event from server side in the onClick event in my asp code? Am not very familiar with adding javascript code within a server side C#/ASP.Net web application. Thanks

Hi there, Im sitting with some weird problem here, ok here goes: Well i have a queries application and users select files from a folder list and adds them to a customer they searched for. The file they selected the file path with a subject and note gets saved to the database. Problem is that some times the exact same file path, subject and note gets inserted twice into the database and some times 3 times. I have searched line by line to find any possibility that the insert function runs more than ones but it doesnt. the user select a file then enters a subject and note and then presses the capture button and the data gets inserted. My prodecure only gets executed once and it executes fast so there is no time to maybe click the button twice and even if they did i have a confirm box first before it executes the insert function. :doh: Does anyone know what the problem might be? Pls :(( If you need any more info or code just lemme know. Im programming in VS2005 C# and its a web application. Thanks :)

Hi, I am writing a web app in ASP.Net 2.0 and server side C#. what i am trying to achieve is this: multiple users work of a gridview and user A selects a row in the gridview to work with, now when user B selects the same row while user A is still busy with that row, user B must be notified that that specific row is in use by another user. A notify message or a row lock or anything to prevent user B from working with the same record as User A. Does anyone have any idea how i could work around this one? :doh: Thanks alot Kind Regards GermanD

I have written a C# application (not a add in) to access outlook. I work with emails in the Inbox folder and also save the attachments to a directory. But when i use the application I get a Security warning that pops up from outlook stating that -A program is trying to access email address..Do you want to allow (Yes/No) and also it asks the time duration for access. is it possible to remove this or some how work around it? I know of redemption and some other tools you could use but its expensive to purchase. I found some code in Delphi 7 and VB6 which automatically presses the buttons on the warning form with api calls could i use this too if its the only option? Thanks Kind Regards