Hi, We have developed an (ASP.NET) Web Application in VS 2008 & developed a setup project for the same and successfully installed in our local environment (Windows XP/ Windows 2003 server). This web setup project contains the below: 1. Web Application (Primary output/ Content) 2. Primary output of BLL & DAL 3. Few custom actions 4. Few UI Forms to get the Database details/ etc from user 5. One Windows service This setup fails immediatley in the client environment. The client also using the Windows XP SP2/ 32 bit version. But the windows root folder is "C:\WINNT"; bcos the system has been upgraded from Windows 2000 to XP it seems. After that we have removed the custom actions and Windows service from the setup project (to narrow down the issue) & tried to install, it also failed. We dont have any clue on this. Can you please help... Thanks in Advance !! :)

Jey

Hi I am having the requirement like drawing the database relationship diagram. Please find the sample image in the below path. http://siebelunleashed.com/wp-content/uploads/2008/06/informaticasourcequalifierscreenshot.png 1. By default, each table icon is in the minimized state & is displayed as a clickable button. 2. If the user click on it, it will be maximized & all the columns displayed (with scroll, if number of columns exceeds its maximum limit) 3. The user can move the icons anywhere around the UI boundaries. 4. The user can minimize it back to an icon by clicking on the minimize botton. 5. There is a connector between related tables (primary/ foreign key relationship) Column wise connector is not required in my case. Only one connector between the related tables is required. 6. If the user clicks on the connector, the relationship details will be displayed in a popup window. How can we implement the same in Web UI using Silverlight? Till now, I have tried with WCF for the database connectivity & drawn few movable images (Image control with mouse event handlers) and connectors (line control) between them by created all the controls dynamically from code behind file (xaml.vb) Kindly help us with your valuable suggestions on this. :) Thanks Jeyakumar

Jey

Hi, I am having a requirement like 'Scheduling Jobs' in a ASP.Net web site. Each user can create 'N' number of projects & schedule each project to run in a particular interval (Daily/ Weekly/ Monthly/ etc). Similarly we have 'N' number of users. Each user needs to Edit/ Delelte the scheduled jobs & View the status. One of my colleague suggested the below. Does any one of you have used this open source framework? http://quartznet.sourceforge.net/[^] Can you please suggest on this?

Jey

modified on Wednesday, August 26, 2009 5:04 AM

Thank you Mujica. Definately It helps me... Thanks a lot. Please find my last comment for the complete solution.

Jey

Great Work :) I am really thankful for your effort spent on this & guidance :) I have used this logic for my case. BUT, the JOIN is the highlighting one :) Sorry, this is for fun. ON T1.INDICOLVALS = 10*T2.CODE

declare @cols nvarchar(2000)
declare @sql nvarchar(4000)

set @cols='Col1, Col2, Col3'

set @query='SELECT T2.CODE,
T1.COLS,
T1.INDICOLVALS
FROM
(
SELECT INDICOLVALS,COLS FROM

(SELECT Col1, Col2, Col3 FROM Table1) P
UNPIVOT
(INDICOLVALS FOR COLS IN ('+ @cols +')
) AS U
) AS T1
INNER JOIN TABLE2 T2
ON T1.COLS = T2.[Name]'

--print @query

execute(@query)

As the list of columns may change in future, we have used the below script to get the list of columns and using the CURSOR, it is stored in the @cols variable with comma seperated format.

Select name from syscolumns where id=object_id('Table 1')

Once Again, Thank You very much. :)

Jey

modified on Wednesday, June 17, 2009 11:03 AM

Hi, Thanks for your valuable reply. Please assume that I am always select one row from Table 1. Please refer my previous thread for the detailed requirement.

Jey

Hi, Thanks for your reply. I do aware of it. But my requirement is similar like this. I needs to get all the column names from the Table 1 & lookup on Table 2 and get the Code of that respective Column name. Let me explain: In table 1 there is a column called 'LoadFactor' & its value is 80 LoadFactor 80 Table 2 Code Name 1 LoadFactor Table 3 Code LSL USL 1 50 100 My Required Output: Code Name 'Actual Value' LSL USL 1 LoadFactor 80 50 100 Now. have u got it? This is a simple example that explains my requirement. I do have 500 similar columns with few input tables.

Jey

I am having the below secnario. Table 1 Col1 Col2 Col3 10 20 30 Table 2 Code Name 1 Col1 2 Col2 3 Col3 Expected Output: 1 Col1 10 2 Col2 20 3 Col3 30 How to write the SQL script (SQL server 2005) for this? Thanks in advance.

Jey

Hi, I am aware of www.w3schools.com Umer. :) I need some basic examples for my requirement, from where I can start work on it...As a expert you can suggest some best examples. I hope you understand.

Jey

Hi, Yes, I needs to create my own. I would like to understand the basics. Also kindly suggest any article where I can learn the basics. Thanks

Jey

Hi, I am new to HTML UI design. I am having a requirement similar to http://deluxe-tabs.com/templates/[^] We needs to create tabs like Glass style, Vertical style, etc. For each tab, we needs to have its respective div tag. Can you please suggest any good article, where I can learn the basics of the same? Thanks

Jey

modified on Tuesday, February 3, 2009 5:06 AM

Resolved this issue by using the property 'HyperlinkTarget' of the Crystal report viewer control. By default this value is '_self'; Changed it into '_blank'. Now the hyperlink in Crystal report is opening in a new window. Thanks.

Jey

We are using crystal report and asp.net. We have used a hyperlink in a crystal report field to open an aspx page for which values are passed in query string(URL) "/test/default.aspx?Parameter="+{value1} But the link opens in the same window. how to open the link in a new window? can it be achieved using <a> tag? Thanks in advance

Jey

modified on Tuesday, October 28, 2008 11:05 AM

Great Guffa... nicely explained.

Jey

Call your JavaScript function like below from your aspx page:

"JavaScript:Validate('<%= serverControlID.ClientID%>')"

Here, the Validate javascript function receives the Client Id of the server control & perform your required operation. I hope, it will help you.

Jey

??

Jey

Contents of the message will be the simple text message with max of 500 words.

Jey

Is it depends on the mail server capacity? Let me check with my Admin. Is it good approach to send mail to more no of users individually? (ie) Call the Send() method several times.

Jey

Is it only 50?? Than, Can I use send mail individually to all the users (one by one)?? Is it good approach?

Jey

Hi, I am using System.Net.Mail namespace for sending mail from my application. (ASP.Net/ C#.Net 2.0) MailMessage myMailMsg = new MailMessage(); would like to add the recepients (MailAddress) here in TO or CC or BCC. Question: 1. What would be the max no of MailAddresses can be added in the MailMessage object's To, CC & BCC? My expected no users will be around 2000 to 3000. 2. Is it good approah to call the Send() method of SmtpClient Class only one time? Can you pls suggest the best practice on this? Thanks Jeyakumar

Jey