Hi, Please help me in checking the condition.I am displaying information in a html table. I have two grids in asp and On click of first grid items it should be added to the second grid. Always items with same satus we should add. Example :I have 5 records in First grid. No Status == ====== 1 closed 2 Open 3 Open 4 Open 5 Open if I select different status records and click add button on the page it should throw an error message, If I select same status then it shouldn't through an error message. I have code like below. Here rs means the number of records in the second grid. If rs.RecordCount > 0 Then rs.MoveFirst If trim(rs.Fields.Item("Status").Value) <> trim(grid.Columns.Item("Status").Value) MsgBox "Items should be with same status." Exit Function End If End If Please let me know how to how to validate the above condition.
siddisagar
Posts
-
Help required in grid conditon -
Invoke schedule task using .NET programHi Dave, I have an exe file which is placed in scheduler Tasks(Control Panel--->Scheduled Tasks). I need to have a dotnet program which should run this scheduler automatically from my program. The above scheduled task is installed on my machine.
-
Invoke schedule task using .NET programHi All, How to run the schedule task from .NET application? Thanks in advance.
-
How to do insertion automaticallyHi All, I have two databases Example -A1 and A2, both are linked in SQL Server2008. I am pulling 3 tables information from A1 database and putting it into A2. But I am doing this manually by running the below queries Example : insert into TMP_ITEMS select * from A1..DEX.items How to make this as a automatic process. Thanks, Vidya Sagar
-
Unable to copy inside Programme Files FolderHi Experts,
Why my VB.NET setup file unable to copy inside C:\Programme Files in win7 machine, How to fix this issue? Same setup is working inm
Thanks to all repliers.
-
Deployment issue in Win7When we install the Windows application setup file then it is giving different results. If I install in Windows XP it is copying the files in the path C\Programme Files\Application. In XP application is working without any issues in all machines. But if I install same setup in Win7 then it is copying in the C\Programme Files\ only.All the files are placed in C:\Programe files and application is not working. If I copy individual files and paste inside the C:\Programme Files\Application then again it started working. Request you to help me in resolving this issue. Thanks in advance.
-
Problem with the Win7 environment for VB.NET applicationI have a VB.NET application which is workig fine with the XP environment. But when I install the same windows application in WIN7 environment then it is causing below error. Unhandled expection has occurred in a component in your application. ------------------------------------------------------------------------------------ Error details: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.ArgumentException: Resource 'App.ico' cannot be found in class 'Control_Panel.frmMain'. at System.Drawing.Icon..ctor(Type type, String resource) at Control_Panel.frmMain.frmMain_Load(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Request you to please let me know how to resolve this error. There was no errors so far with the XP environment.
-
SSRS Table row should be visible and Invisible based on Input parameterI have one table with two rows in tables 1. Employee Details 2. Employee History Details Depending on my input parameter I have to show only one row and other I have to show to make hide if @hisId=0 then I have to show Tablerow1 if @hisId=1 then I have to show Tablerow2 Kindly Tell me solution.
-
Query to copy the table with Data and Constraints in SQL ServerI could not see SQL Server Option so I Posted here. Please Take it forward
-
Query to copy the table with Data and Constraints in SQL ServerHow to copy table with Data and constraints from one database to another database Database A have 300000 columns I need above table to copy in Database B but with constraints I am using below Query but here constraints are misssing SELECT * INTO Table1 FROM A.dbo.Table1 Pls suggest me correct Query
-
SSRS Chart issueHi Frds, I am getting problem in SSRS Chart control. My output of SP is ------------------ Inc NAME NO% Yes% ---------------------------------------------- A1 Bujji 90% 100% A2 Bujji1 30% 50% B Type Acceptd Rejectd B1 abc 20% 1% B2 xyz 10% 2% Above output is generating from SP Only. Here B Type Acceptd and Rejectd added like coloumns but those are part of Report now I need to create a chart x- axis should have A1,A2,A3....An values and Y-axis should have bars with Yes% and No % Here I am getting the Accepted and Rejectd values also. So please tell me how to prepare a chart putting condition for Inc in A1,A2
-
Need SSRS format helpI have done through SSRS Grouping. Question is not related to ASP.NET But I could not find the SSRS Questions here? So Where can I post SSRS Related Queries?
-
Need SSRS format helpHi Need to hide the Repeated District name only in SSRS I am getting Query output like this District Name Date count ------------------------------------- VSP TL 01/01/2009 20 VSP AM 01/06/2009 10 VSP TM 01/08/2009 100 Hyd TL 01/01/2009 20 Hyd AM 01/09/2009 10 TPT TL 01/01/2009 20 TPT TM 01/06/2009 190 Expected Output I need out put like this in SSRS District Name Date count ------------------------------------- VSP TL 01/01/2009 20 AM 01/06/2009 10 TM 01/08/2009 100 Hyd TL 01/01/2009 20 AM 01/09/2009 10 TPT TL 01/01/2009 20 TM 01/06/2009 190
-
Row should be bold in SSRSThx it is working for me
-
Row should be bold in SSRSHi Team, I want to show one row as bold in my SSRS report. That row is static always but it can change the row no. Ex some times it may come in second sometimes it may come in 5th. but the row is constant always this needs to show in bold So how to handle this problem Thanks
-
Merging common Rows in SSRS -
issue with Date Format in SSRSHi Team, I have two textboxes for taking startdate and enddate. If I give start date 10/01/2009 and Enddate 10/12/2009 then report should display 01st - 12th Oct'09 If start date is 10/02/2009 then it should display 02nd -12th Oct'09 Kindly help me
-
How to change the Legend Colour in SSRSHow to change the Legend Colour in SSRS. I need combination which are not there in Palatte
-
SSRS Date format help requiredHi Team I need to show date in this format in my report -----------Dec'09 I am getting format like this Dec2009 for this I am using (MonthName(Month(Parameters!sdate.Value),TRUE)& Year(Parameters!sdate.Value)) Please kindly help me how to get format Dec'09 and also How to display previous month date also Nov'09 (Need formula)
-
New window should open in another browserHi Team, I am having problem with window. I am having one path I am taking in String. On button click I am calling Response.Redirect (str) where str=path of the url. I need to open the url in another browser how to do this? Thanks in Advance