VS 2010 Return XML Values Sorted?
May 28, 2012I havew a smal xml file which looks like this:
<?xml version="1.0" encoding="utf-8" ?>
<fv>
<flv url="http://www.mysite1.com">Windows</flv>
[code].....
I havew a smal xml file which looks like this:
<?xml version="1.0" encoding="utf-8" ?>
<fv>
<flv url="http://www.mysite1.com">Windows</flv>
[code].....
i need to create a function for transforming an xml document using xslt. I am able to copy the document using xsl:copy-of, however it's not copying the root of the source xml document. As shown below, the root of the xml should be <List xsi:noNamespaceSchemaLocation ~>: [Code]. My IDE is Visual Basic .Net 2008. I need to reproduce the xml file with the SName attributes sorted in ascending order.
View 3 Repliesi want to get two output values in one Function is't possible ?.i am just using String data type and split the values.but have any other easy way to get two output values
View 1 RepliesI am trying to do this:
Dim viewdata2 As DataView = fxts.fxtsdata.Tables("clients").DefaultView
Dim viewsorted2 As DataTable = viewdata2.ToTable("clients", True, "Surname", "Name")
[Code]....
how do i simply query the database and return values to my textboxes etc? all i can fiqure out is the default views but that is not what im after, also how to add data as well (lets say i have a text box with data and i wish to add it to the database)im sure its simple but i cant figure it out, in vba i just used the current sheets or tables but this is beyond me. i will admit it.
View 23 RepliesI am developing a vb.net app that should read cell values from excel. However, it is not returning any results and I thought that it would be really simple. I have imported all the references viz. Microsoft Excel 12.0 Object Library.
Following is the function in my class file which should read the excel file
Dim mobjApp As Excel.Application
Dim mobjWB As Excel.Workbook
Dim mobjSheet As Excel.Worksheet
[Code].....
How can I sort data in a sorted list using values instead of keys from highest to lowest?[code]...
View 2 RepliesI am unable to load the dat into the data Grid. Here is where I keep getting stuck.
dgvOleDb1 = table.Select
dgvOleDb1.DataSource = DataGridViewEditMode.EditProgrammatically
dgvOleDb1.DataSource = ds.Tables(0)
I am confused; I am using VB2010, IBM.iSeries.DB2 on an as400 V5R4. I am trying to establish an OLEDB connection, and return the values from the selected table to a DataGridView. I had one of the admin's make me file named GARBAGE, in the Rprtaccess catalog. In the past, I have been able to connect via access and an ODBC connection. My project is too big for access, and the SQL middleware we have is clunky and not user friendly. This is a program that will generate the SQL statements, specifically the WHERE: clause and populate the datagrid with the selected criteria. In essence I am making a user friendly striped down program, that has variables that are manipulated by the end user, and the rest, referenced tables and libraries are coded.
Imports System.Data.OleDb
Imports System.Exception
Public Class Form11
[code]....
I have a DataTable in a DataGridView, one of the columns has data that I want sorted. I can click on the column header to sort it and it's fine. The problem is that I don't want that column sorted automatically when some of the data changes in it. I want it sorted only when I click on the header.
View 3 RepliesI use this code to return records in a DataGridView:
[Code]....
i want to get two output values in one Function is't possible ?i am just using String data type and split the values.but have any other easy way to get two output values actually i want to checking a folder how many jpg files are Horizontal and vertical [code]finally i split the values with "|" character.have any other options to get two values as separate in one functions.i have no moew idea about Dictionary,
View 2 RepliesIf a use the NPV() function in Excel (2010) with a discount rate of 5% and 10 cells that each contain 505,000 the resulting NPV function call "=NPV(5%,C2:C11)" returns the value of 3,899,496.
If I use the Financial.NPV() method in the Microsoft.VisualBasic namespace (in my C# application) and pass in a discount rate of 5% (as a double) and an array of 10 doubles with a value of 505,000 each, the VB function returns the much lower value of 100,999.99 (plus a few more decimals).
When I do a
Request.Querystring("key1")
Request.Querystring("key2")
The system doesn't seem to parse the second ?/value out but treats it as if key1 was all one string, e.g. [URL] ...as if it completely ignores or doesn't parse out the second (or other if more) key/value pairs.
Need to return the greater of 3 values. Each value is based on user input and system calculations. Requirement = the greater of (Req1, Req2, Req3) Have tried a number of "If" "Else" and Ifs within Ifs "<" and ">" combinations without consistant results. This may seem simple to some but I am relatively new to VB. My search on MSDN was not fruitful.
View 11 Replies[size="5"]How can I return two values from the same function?? I need to return an arraylist and an integer...the arraylist is already returning now i need to add the integer
View 3 RepliesAssign SQL return values to Array
View 2 Repliesok here is the thing, in my application there is 2 forms, in the main one (not an MDI)it has some textboxes and a picture box, the other small form contains only a ser enters his search criteria in the textboxes in the main formand presses a button to show the results,t opens the second form and displays the results inthe listview(results are names of pictures).
View 2 RepliesWhat I need to do is to have my program look at 2 different values then return a value.
Here's an example:
If my tube material = SA-214 and the tube gauge = 20 then my tube wall thickness = .032. The thing is I have 5 different types of tube material and 12 different tube gauges so based on which tube material is selected and which tube gauge is selected the tube wall thickness will vary. So if I select a TM of SA214 and a TG of 14 then my tube wall will be .076.
Is it possible to make a function that returns both a datatable AND a list(of custom class) at the same?In my GUI layer, the main form (the application is MDI) calls this function and it has to fill the datagrid on one of its child forms and it also has to fill lot of other child forms with various information that is calculated from my custom class properties.Both the datatable and the class properties are created from the same external database and that's why I don't want to have two separate functions.
View 3 Replieshow to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....
I have created a function that takes a Car Registation as its argument and I want it to return 3 values (Make, Model, Price and of course True).The code itself works fine (it returning each Individual value but can't find a way to get ALL of them from 1 function) However I need to actually return all 3 values, and I cannot see how to do this with a simple function.
View 8 RepliesI have following codes in my Project
[Code]...
Now I am calling Get_Values(). But I am not getting the values in variable G1,G2 & G3.
the stored procedure is within a transaction. I want to get the inserted values after calling the stored procedure. My problem is, I don't know if that is possible because the transaction is not yet commited.
View 1 RepliesI have a form which calls other form to achieve some functionality. How can I pass values obtained on other form to the calling form?
View 10 Repliesi am having a few problems with something i need to create. it firsts needs to get source code of a url i specify, after which i need to click a few buttons so it gets different parts (extract) of the data that i need from the source code and display it in a different text box if possile. (while leaving the original sorce code intact)
[Code]...
I am trying to get '[NewsLink1234]' from the textbox. I think the Regex code is correct. I need the results to show:
[NewsLink1234]
[NewsLink12333444]
[NewsLink12]
Depending on which ones are in the textbox as the numbers will be ids.
Here is the code:
Partial Class Hertscricket___Test_admin_Default
Inherits System.Web.UI.Page
Public StringVariable As String = ""
Public strValue As String = ""
[Code] .....
I'm having trouble with a function returning two values. Each value contains a string, how can I return these values and have each one of them be stored in one independent variable. [code] I'm trying to return the hashed text with the salt and the generated salt, how can I do this?
View 18 Repliesive got command below to query db for result = false.I want the switch names returned to be displayed in a textbox. the PROBLEM is only the first result is being returned. I think this is because ive chosen execute scalar but none of the other options seem to work.
Using con2 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:Network Map.mdb")
Using command As New OleDb.OleDbCommand("SELECT SwitchName FROM tblSwitch where Result = false", con2)
con2.Open()
Dim faileddevices As String = CStr(command.ExecuteScalar)
RichTextBox5.Text = faileddevices
[Code]...
> Function LoginPass() As Boolean
> Dim LogPass As New waxClass
> Dim Ldt As DataTable = LogPass.LoginPass(LCase(UserName_TextBox.Text),
> LCase(UserPass_TextBox.Text))
[Code]...
When I try to use the above function it gives a Warning saying:
Function 'LoginPass' doesn't return a value on all code paths. Are you missing a 'Return' statement?
currently, I use this code:
[Code]...