I wrote a function ReadXML().This function reads XML file and returns a string.The string contains all the XML file nodes values to duild SQL query dynamically. Any way My code is working. Is this right way? Can you please suggest me the unnecessary code(loops...)in this function, So that I can do the code in a better way.[code]
View 1 RepliesIm currently working on a project to build an application for Windows Mobile 6.I have a SQL query string:
Dim connectionString2 As String = "Data source = " + path + "HC.sdf"
Dim cmdText2 = "SELECT * FROM BigC_Rangsit_0_"
I want to substitute the table name ie. BigC_Rangsit_0_ with a variable which contains the table name.say, during runtime the user selects a table from the dropdown list , that variable should be substituted with the selected table name dynamically in the SELECT statement.
Dim cmdText2 = "SELECT * FROM "selected table name VARiable""
well, I need the right syntax for this.
I am receiving this XML file and I need to receive these values from there using an XDocument or XMLFileReader, I just can't figure out how to go through all the nodes to receive my values:
(Values I need: both results, address1, address2, city, state abb., and zip)
<?xml version="1.0" encoding="utf-8" ?>
- <ResponseArray xmlns="urn:mdWebServiceAddress"
[code].....
I cannot get anything back from the following code... it always pops 0, and the _Qry is never populated, even though _MBXml is populated properly (hovering during debug shows it)
_MetaBasePath += "IIS6-MetaBase.xml" '"metabase.xml"
_MBXml = XDocument.Load(_MetaBasePath, LoadOptions.PreserveWhitespace)
_Qry = (From n In _MBXml.<IIsWebServer>
[code]....
I have the following xml document which would be taken from the web and stored into an XDocument object.
[Code]...
When I read XML in RSS 1.0 or 2.0 the following line works perfectly:
tmp_str_a = feedXML.Root.<channel>.<title>.Value
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?>
[Code]......
I have to get all the Entity Source,Entity Target,Property Source and Property Target values in list respectively.[code]...
View 1 RepliesI'm trying to build an application to monitor a site to build statistics from the data being read. This HTML looks like this.
<div id="history">
<h4>HISTORY</h4>
<table border="0" cellspacing="0" cellpadding="0">
[code]...
Now I can read the html and put the text anywhere, I just don't how to read specific parts so I can separate the data out.
I would like to bind a DataGridView to a different LINQ query every time (in order to reuse the same form/DGV for different queries), like this:
[Code]....
but the "Qry", and the number of comboboxes, and their field names would change every time.
For comparison: something like the shirt builder application at [URL]Say, if I have fabric image and want to generate base, collar, cuff etc. How should I do it on server side in .NET, and generate different components of shirt.
View 1 RepliesI wanna load XML file with XDocument.Load method and lock it. How to do it?
View 5 Replieslock from reading/writing/copying a loaded XML file with XDocument.Load [VB 2010]?
View 1 RepliesIs there any free tool available that can be used to build Active Directry query also can i execute active directry query through c# code because while connecting to active directory through object model and iterating through each property of the active directory specially when all the property is not requierd the performance cost is comming. What I want is to query Active Directory domain get some property value ans save it in the sharepoint list, I am using object model to do this but at the cost of the performance. I am thinking to execute the query through C# code same as any Active Diretory Query tool to pull the value and then save it into the list.
[Code]...
In my program I have a combo box that the user selects a date from and a list view that the user selects an employee ID from. How do I properly design my database query string to use both the date selected and the employee ID selected? The date is stored in a variable called YearMonth and the employee ID is stored in a variable called EmpID.
Here is what I am trying to do with my query:
Dim ExactQuery As String = _
"SELECT * " & _
"FROM[JobTypeExact_Query] WHERE (EMPID = ?) AND WHERE (YEARMONTH = YM)" 'Define Exact job type query
[code]....
I have been trying the following but it returns unexpected results:
Dim xd As XDocument = _
<?xml version="1.0" encoding="utf-8"?>
<root>
[code].....
The above result returns both 'element' nodes however it should only return the first where element/subelement@id=1/subsubelement@id=3 However if results.Ancestors. is used it returns the correct 'subelement' and if that line is not included it returns a single 'subsubelement' whih is also correct I don't understand why when mvoing to the 'element' it returns both (I realise both have a subelement with id=1 but I thought each further query would filter out the presvious results)?
I want to write a query that the "where" in the query is a string something like"
Dim query as string= "Name =xxxx and Date > 10 "
Dim t = from book in doc.Descendants("books") Select _
[Name] = book..value, [Date] = book..value....
Where (query)
I build the query string on run time
I have a sql query that set data to a dynamic text box. Can some one explain how i have to make this query
"Update Clientgegevens set Clientnaam = '"
& TextBox("& T.ToString &").Text &
"',
What I am about to do build is a UI that will allow a power user to build complex queries.
This is non-trivial, but very common. So before I re-invent the wheel, I would like to see if anybody can point me to some already-written free code or release some of their own.
Required:
To be able to specify some 'where-clause' type logic like this: Age>21 and (Citizen=True or HasGreeCard=True) but without having to type the query code, instead, use a UI with constrained options and on-the-fly syntax checking (e.g., no unclosed parenthesis or ending a term with an Operator).
I've seen this type of thing in many line-of-business apps, where you can say 'add condition' and another line appears on the UI like this:
Dropdown of fields Dropdown of ops (=, >, etc) Blank box for entry
And you can add more lines, and the lines are all and'ed, but you can also decide to OR a few, or insert parenthesis (explicity or via indenting), NOT a line, insert, delete, and move lines around, etc.
Not required but nice:
WPF - I could convert from winforms. Extensibility using OO constructs. Validate the sanity of the query. Emit a System.Linq.Expressions expression tree - or similar data structure. If it attempts to execute the query I don't need that; but I don't mind removing it.
I have a listbox which users can select from a list if Towns, I want to be able to build a LINQ query based on the selected items in the list e.g.
[Code]...
I'm need to do the equivalent of a t-sql statement like this using LINQ:
SELECT * FROM mytable WHERE idnumber IN('1', '2', '3')
so in LINQ I have:
Dim _Values as String = "1, 2, 3"
Dim _Query = (From m In mytable Where idnumber = _Values Select m).ToList()
Not sure what to do with _Values to make idnumber evaluate each value in the string.
I'm triying to create a dynamic query to Entity FW (i'm using Self tracking Entities over EF)
This is what i'm doing:
Public Class Specification(Of TEntity As Class)
Private _predicado As Expression(Of Func(Of TEntity, Boolean))
Public Sub New(ByVal columna As String, ByVal condicion As OperadoresComparacion, ByVal valor As Object)
[Code].....
How do i great dynamic linq query in VB.net?
View 3 RepliesI'm currently trying to loop through an array (two values) and use both values in a query inside the loop Right now my code doesn't work. I'm trying to populate dynamically the "appType" parameter within the "SelectParameters" tags of the SQLDataSource, but this won't work.
[Code]...
Can we execute any string like "Button1.Text = Value"
Question arises from sql server where we can store a dynamic/static query in a string (varchar) and execute it and it will put the value to the button1.
Im working on a project that includes a TableAdapter for filling data. I usually use parameters for queries I create, but what would be the best way to create a query that may have a wildcard without creating a bunch of queries?
[Code]...
I have a table called Foo and I have two columns: Lorem and Ipsum, so the scheme of the table is:
Foo(Lorem, IpsumID)
I also have a table called IpsumTypes, which looks like this:
IpsumTypes(IpsumID, IpsumName)
I would like to write a LINQ query which will have the following result:
Headers: Lorem, IpsumName1, IpsumName2, ..., IpsumNamen
Values: Loremi, count(IpsumName1), ..., count(IpsumNamen)
Each row represents a group of Lorem value and the number of each possible IpsumID in the group. New rows can be added to the IpsumTypes table, rows can be deleted too, so I need dynamically generated columns, because at the time of writing the code I'm not aware of the possible values of Ipsum. How can I achieve this? Is there a magical Linq query which solves this problem, or should I get the values from the database and parse them separately, if speed counts?
I am trying to send a query to a device over http with the url:
[code...]
What I want to do is retreive this xml file over http and save it with my VB.NET application. To do
that I am trying the following function, and it works to retreive the page source for normal web
sites, but it fails when trying to retreive this particular page.
[code...]
I think that the problem is that the code is counting own a present length in the header, which is
not the case for a dynamically created page. (i.e. you dont know the length until you are done) As
such, the code should be written to read the entire reply.
I have an untyped dataset returned from my WebService. The user wants to dynamically construct a query referencing tables and columns and specifying values to test for.I have looked at Lambda Expressions and the Expressions.Expression Namespace. I think these provide the answer I'm looking for, but I'm not certain how to go about contructing the linq expressions to extract the datarows I'm looking for.
I plan on limiting the result to one datatable that the query will result in and i"ll provide the joins from the user's constructs.For a simple example I have a DataTable with (n) rows called "Table", and in it there is a computed column called "b_IsActive" that has the expression "Convert(IsActive, 'System.Boolean')". The user wants to retrieve all rows in "Table" where field "b_IsActive" is true.
trying to write a dynamic sql query that fetches data from oracle 10g database. My Where criteria is giving me real problems but i guess it has to do with the oracle data format. The data column is a TIMESTAMP data type storing values like 25-JAN-09 07.06.01.000000000 AM. Am trying to get rows having the columns matching a specific date( ignoring the time values), my where looks like this
WHERE to_date(COMPLY_RUN_DASHBOARD_DATE,'DD-MON-RR')='" & Now.Date & "'"i get the following error :CheckError ORA-01830: date format picture ends before converting entire input string
I've created a new ASP.NET Dynamic Data website and have used LINQ-to-SQL for the framework. I start up the application and it displays my tables fine and I can browse them - but it doesn't give me any create/update/delete abilities - all I can do is read? I didn't change anything from the defaults - what gives?
View 1 Replies