You should try using a dataset instead of making mutiple calls to the database. When you use a dataset, you'll make one query to your database and populate the dataset with that information. At which point you can bind that data to your controls. The link below is the msdn article for working with Datasets. http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx[^] hope this helps

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

There should be a folder within C:\Documents and Settings\user\Local Settings\Application Data or C:\Documents and Settings\user\Application Data folder i can't remember exactly where its at but if you browse those two locations, you should see a folder with your program name and in that should be your config file. Hope that helps.

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

Here is an example of how it can be done. On the main page i have a label that reads the value of the dropdownlist and once the dropdownlist updates it re-populates the label. the main page

Update1
Update2

and the code behind

protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = DropDownList1.SelectedValue;

    }

This is a quick example just to point you in the right direction. Hope it helps.

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

I'm not sure if this is what your looking for, but this shows you how to redirect users to any page after a session has expired. In your case the user would be manually ending the session and this could also work for you by redirecting the users to the login page after logging out. http://www.codeproject.com/KB/session/redirecttimeout.aspx[^] Hope this helps.

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

This link will show you how to switch to a from debug to release in Visual Studio, once you build the project you will notice that in the project folder there is a bin folder that should contain a debug folder and release folder. Inside these folders are the executable you need for distributing. You can zip up your files or use on click installers to package your project. This link is for vs 2005: http://msdn.microsoft.com/en-us/library/wx0123s5(VS.80).aspx[^] if the above doesn't help try this link: http://social.msdn.microsoft.com/Forums/en-US/winforms/thread/865ea184-70a5-4905-8dd7-089fd9714209/[^] hope this helps

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

Before doing your insert you should check first to see if the table exists, at which point you can specify another name for the table. I would dynamically set the table name in your code as a variable, and do a count on how many tables with that name already exist, and then create a new table based on that name and the count. This link may help you with the code on checking first to see if the table exists. http://dotnetmonk.blogspot.com/2007/07/check-if-table-already-exists-in-sql.html[^] hope this helps.

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

I would suggest just doing it in your code behind. This is a bit of c# code that works. On the aspx page : in the code behind protected void TextBox1_TextChanged(object sender, EventArgs e) { Button1.Enabled = false; } Now take note to the field AutoPostBack="true" this will update the button automatically after you click out of the textbox itself, which will cause the page to update. If you want to manually update the page you can just remove that line. Hope that helps

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

This article should help you. http://www.codeproject.com/KB/session/redirecttimeout.aspx[^]

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

This should help you out http://msdn.microsoft.com/en-us/library/5cf8zcfh.aspx[^]

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

You may need to authenticate to your email server so you would need to add that to your code. Below is a code snippet using cdosys, that i tested answering a similar question the other day. Set myMail=CreateObject("CDO.Message") myMail.Subject="Sending email with CDO" myMail.From="youremail@yourdomain.com" myMail.To="youremail@yourdomain.com" myMail.TextBody="This is a message." myMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2 'Name or IP of remote SMTP server myMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver")="youremailserver" 'Server port myMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport")=25 'authenticate myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 'email address for authentication myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "youremailaddresshere" 'email password myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "youremailpasswordhere" myMail.Configuration.Fields.Update myMail.Send set myMail=nothing Hope this helps

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

Your code is correct when i copied that code into my editor and ran it on an empty dataset it produced the desired results. My only theory is that sales.Get_Stock_data(item,frmdate,todate) is somehow is not empty or populated with null values giving the impression that its not empty. I would check that portion of your code because what you've posted is correct and works on my end. Hope that helps.

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

You can do it with css using float:left to make sure they all left align, or you can do all this within a table as well. example (C#):

This would accomplish what you were asking with just tables. As far as css i would suggest doing google searches for good css tutorials. Hope that helps Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

Another solution for you if the others do not work, SqlDataReader reader = cmd.ExcecuteReader(); int count = 0; while ( reader.read){ // do your normal code for gathering column info count++; } when its done reading you'll have your data and your count. Hope that helps.

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

You could trim your string before entering into the database, example: string str = "my blank spaces "; str = str.Trim(); This will trim all whitespace from front or back of the string. Hope that helps.

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

This usually means that your unable to send mail via that smtp relay. 1. does your email/website provider allow smtp relay? 2. do you login to your email with your full email address or just username Basically the cdosys script is working but unable to connect to the email server for what ever reason. If your mail server doesn't require authentication (although all most do) then you will not need the username/email address and password. If they do require authentication you will need to make sure that the username/email address and password are correct as well as the server name and port. If all that information is correct you may want to ensure you can send mail on port 25. To do that you can try and telnet to your mail server on port 25, if this doesn't connect try port 50. The default smtp mail port is 25, but there usually is always an alternate port such as with our company which is port 50. If neither of these work then you should contact your email provider and find out what ports they allow smtp relay on, that is if they do. Hope this helps.

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

I think the easiest thing to do would be to create a link to a printable version and convert your document into a pdf file for printing. Doing this will also give your end user the ability to save the document as well as print it. This link should point you in the right direction for get thing the libraries you need to create a pdf on the fly. http://csharp-source.net/open-source/pdf-libraries[^]

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

It sounds like you just want to create a list of files within your project, you can use the directory info class to loop through the director and list your files. This link should help you with that: http://msdn.microsoft.com/en-us/library/5cf8zcfh(VS.71).aspx[^]

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

This article should help you out. http://www.w3schools.com/jS/js_form_validation.asp[^]

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

I usually use IIS ASAPI Module, and here is an article that will help you setup php in IIS for the ISAPI module http://www.hostmysite.com/support/dedicated/general/installphp/[^] Hope that helps

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

This link will help you with setting up a virtual server in IIS. http://www.hostmysite.com/support/dedicated/IIS/virtualdirectory/[^] Here is another link that has some more useful IIS tips http://www.hostmysite.com/support/dedicated/iis/[^] Hope that helps

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com