Insert An Conditional XML Tag Based On Whether Or Not A Count Is Above One
Nov 13, 2009
I've tried searching on this but can't seem to find an answer anywhere, so hopefully someone here can help. I want to insert an conditional XML tag based on whether or not a count is above one, but am not sure how to do it.For example, I have two XElements that are like this:
<Blob>
<Group>
Stuff 1
</Group>
</Blob>
[Code]...
But that is not working. Does anyone have a way to do this from within the XML Literal as desired above?
Have a column of dates which i need to compare to a specific time of the year, which establishes what calculation needs to be applyed then depending on the outcome apply conditional formating to highlight an adjcent cell, but need to remove the YY element as the contents spans multiple years.
if the date in A1 is between 1st Jan & 14th Mar use -8 if the date in A1 is between 15th Mar & 15th Oct use -17 if the date in A1 is between 16th Oct & 31st Dec use -8
Then deduct the above value from B1 to give a target for each row (from 3 onwards)if the target is < the value in n then change background orange in f
I am new to VB and I have two detail listviews with one full of items that can be droppedinto the other. I have three groups in Listview1 and I would like different forms to open up based on the group each dropped item belongs to. I was able to open Form2 on drop by adding Form2.Show() at the end of the ListView_DragDrop handler sub, but this opens forevery item and I want different forms to open depending on the ListViewGroup the item belongs to.I set the items and groups in the property windows and not in code; I do not know if this makes a difference. So here is the code I have on Form 1 where the listviews are:Public Class Form1
Private Sub ListView_ItemDrag(ByVal sender As Object, ByVal e As _ System.Windows.Forms.ItemDragEventArgs) Handles ListView1.ItemDrag, _ ListView2.ItemDrag
I have a fair bit of experience with VB.NET and C# (In this case I chose VB.NET, blame my laziness), but I do most of my professional work using PHP. I have no experience what so ever in using any database with VB.NET let alone MySQL.Just FYI, at the moment I am only trying to Query the database to gather the information required to activate. The Activation wizard and algorithm building (which is finished anyway), and everything else will come soon. I chose the MySQL database because I have experience with it, and it seems the best option for remote usage.The whole idea already works in PHP, I'm just have major issues moving it accross into VB.NET (Using the MySQL Connector.NET);I understand the basics, and all I need to know how to do is Count Rows and gain access to the other information in a row based on provoided information (in PHP, through mysql_ result)
So, here goes nothing, this is the Query code I am using in PHP to complete the job I want to do in VB.NET. [code] As you can see, I basically need to get the PHP code into VB.NET to fit into the 'btnQueryDB.Click' Command in VB.NET. By Equivalent, the Product ID in VB.NET will come from 'txtPID' and similar, Serial Number will come from txtSNUM. Once counted to be 1, the Activation Code and Status will be fed into 2 other text boxes in the form. (acCode, and acStatus).
I have a form that needs to create textboxes based off the count of rows in my dataset table. The amount of rows could vary from 10 to 20, so I need a loop to add the textboxes to add the textboxes on load. Right now I have the loop down and other things shown below.[code]...
I have a SQL database which I'm running a query against to return a list of names - eg using "select names from table"I would like to add all of these names to an array so I can use them later. To do this I would need to use a dynamic array as the number of names returned could be anything.Apart from first running "select count(names) from table", getting a value and then Redim'ing the array on the count is there another method I can use.I've seen there's a dataset row.count? Can I somehow use this?
connection.Open() reader = command.ExecuteReader() While reader.Read()
I am trying to figure the best way to programmatically re-size table column headers in ReportViewer.Basically, my current resolution is the following: ColumnWidth = Header Caption_CharacterCount * 0.32...Where 0.32 is an estimated width of a typical character using my current font size.The issue is that the width leaves a lot of whitespace for longer captions.The more characters a caption has, the more whitespace I end up with.The issue with estimating this way is that not all characters are the same width. A good example would the the "I" character, which takes up less screen width than the rest of the alphabet.[code]
I have two multiline textboxes, and I want to compare and count the text differences between them. The algorithm appears very complex.. To be exact, I need to check for the spelling mistakes (spaces and newlines can be ignored..)
I'm trying to figure the best way to verify the contents of a folder based on another count via a listbox. Here is my current code to count the number of PDFs in two different locations and total them together for a grand total.
'counts test1 pdfs Dim f As String, c As Long
[code]....
I have another process before this that will create the PDF's based on the files listed in the listbox.What I am having trouble with is verifying that the PDFs that are created in the Test1 and Test2 folders equal the counts from the listboxes. This count needs to match before running the next process. I'm kind looking for wait or loop until both counts match, again before running the next process.
i saw jim example in the codebank and i added the percent progress parameter to report progress method (to change the progress bar value)this is jim example:-
vb.net Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, _ ByVal e As DoWorkEventArgs) Handles BackgroundWorker1.DoWork
i have a sql database, and have created a dataset for a sample table in it.The dataset is HotelDataSet2 and data table adapter to insert to it is Various_itemsTableAdapter.
This always reflects the same count, before and after inserting..But if i execute this
[Code]...
it shows the new count to be +1 of the old one. So i concluded that everytime i change some data to the table via table adapter, i have to always refill the dataset?? How is that useful then??
I have added a column to a Datatable called CallsPerDay which is there to tell me how many telephone calls have been made on a particular day or days.Is there a datacolumn.expression which will allow me to Filter on the day, count the rows and then populate this added column with the result.
I have some reports that I use with the MS ReportViewer and I need to get a count of the physical pages (as opposed to logical page count) to use with a print dialog. I've implemented a workaround so the ReportViewer control displays the correct number of physical pages, but is there a way to get that value from the ReportViewer control? The only publicly accessible property gives the logical page count.
Basically, Is it possible to get a grids row count using jquery.if my grid has 20 rows in it not including the header or footer, i want to now the count of actual rows, this will tell my users how many tasks they have in their list.
designing a Windows based computer program that will allow a user to enter some number (n) and a choice of a count up or count down for that many numbers. So for example, the user enters 5 as their number and selects the count down option, the message box displayed would contain the message: "Here are your numbers: 5,4,3,2,1,0"
Declare some class level variables that will keep track of the sums for each column. For example:
[Code]....
During the RowDataBound event, retrieve the data from each column and add it to the appropriate sum. I'm not sure if you are developing an ASP.NET application or a Win-forms desktop application so I cannot help you any further at this point. What have you tried so far to solve the problem?
this its a very silly problem i have with CheckBoxList control, i dont know if its just me or what but the whole idea of the control its just great but the implementation its very confusing.
im trying to eval something like this
if CheckBoxList.Items.Item(CheckBoxList.Items.Count-1).Checked=true then..... or something like CheckBoxList.CheckedItems.Item(CheckBoxList.Items.Count-1) = Checked then...
the problem its that i dont know how does the checkboxlist works but it just sucks that they had to make it so confuising....
i've handled lots and lots of collection controls and they all work in a similar and simple
The template I use for all of my pages looks at the style.css to get the header image. I want to change it so that it looks at who logs in and displays an image based on who they are.
Is there a way to set a variable in VB.NET in an IF statement. I would like to do the following:
[Code]...
Is there some way I can get the last "ElseIf" to work? I know I can re-write it to get it to work but is there some syntax that will make it work the way it is?
In this query against a datatable i'm trying to do some conditional filtering.The check against Timeband(index N) should only be done when the Index exists. (the base code only had three item fields, i've converted them to a simple list)
Dim res As DataTable = ( From dr As DataRow In dtTimedRow.AsEnumerable() Select dr
[code]....
The above code triggers an Exception if the count = 1. It executes the code next to imeBands.Count > 1 which it should not. What would be the correct solution for this code.In the mean time i've added a simple filter function.
I am very new to VB and was thrown into the water with a very big project done in VB.What I am trying to do is this:1. The initial search is for locations within an area of 200 miles.2. If no locations are returned search for locations within 500 miles.Seems easy enough but I cannot seem to figure out how to do part two.If thunder.apps.ddr.franchiseconnect.bll.Current.Settings.Location.hasValue Then'we run this procedure to get the location's value from ZIP db for lat, long assignment
I have a datagrid in asp.net and vb.net, and i'd like to show the status of the item of a certain row with two possible icons.I have a function that checks validation and returns a boolean value that uses some fields of the datagrid.
I have some textboxes on a report in VB 2005. There are three "Status Types": A, B and C. I want an expression like this to work on a number of textboxes:
I have two combo boxes: cboRepairCategory (plumbing, landscaping, etc) and cboVendors. I am using Stored Procedures in SQL to store the data from my database and then load them into the combo boxes.The cboRepairCategory will be loaded first. Once the user has selected what type of repair it is I want it to restrict the amount of vendors that can be selected, so instead of saying:CREATE PROCEDURE dbo.up_Fill_Vendor_Combo
AS SELECT VendorID, CompanyName FROM Vendors
[code].....
I would select only the vendors that have the RepairType of say Landscaping, so thecboVendor would load now only Vendors with Landscaping instead of all vendors.My question is this: Is this done in SQL in my Stored Procedure or is it done in VB in my functions for my combo boxes. I've never tried this before I am totally lost on it. I have fiddled with the code on both ends but to no avail.
