C# - Create A Query String On Load Without Touching The URL?
Jan 14, 2010How can I pass a paramator to another page without using Session variables or passing the Querysting in the URL?
View 1 Replies
ADVERTISEMENT
In A Winform Can Pre-Load A Query
Sep 12, 2011I am writing an application that on first time run checks if a user is in a database. If the user exists it closes itself.I was wondering if I could pre load in vb .net a current or up to date query from the database. That way I dont have to open that initial connection to the DB.
View 4 RepliesLoad Array From A LINQ Query Using Program?
Oct 25, 2010I am new to LINQ, but have been able to query SQL using LINQ to SQL and then I can data bind the results to a GRID or DROPDOWN LIST with no problem. What I would like to do is load a column into an array. I have seen examples for something like this in C#[code]...
View 12 RepliesLoad Form Faster, May Be Using A Query Instead Of The StrSQL ?
Apr 19, 2011I read that by using queries instead of SQL, the form can load faster, however, I have this code that has categories and sub-categories how can I shorten this code to have the form load fastr?
[code]...
Load Two Dimensional Array From LINQ Query?
Dec 14, 2010I'm using VB.Net and have the following LINQ Query...
Dim ACFTTail5 = (From tailcounts In db.TailCounts _
Where tailcounts.Model = "UH-60A" _
Group tailcounts By _
tailcounts.Tail, tailcounts.Model _
[Code].....
But get the following error...
"Unable to cast object of type 'System.Data.Linq.DataQuery1[VB$AnonymousType_42[System.String,System.String]]' to type 'System.String[,]'."
Putting A Date String Made From String Builder In An Sql Query
Jun 24, 2010i'm currently making an app that needs to run a query between two dates. this app will run automatically, so i need to put the dates as today and yesterday, essentially.
[Code]...
Changing Query To Load Specific Data In Report?
Jun 18, 2012Synopsis: I have a report generated from the report wizard in VB that works, but I only want to load data from the same department as the current user.
Details: The application connects to MySQL using the MySQL Connector/Net. I have a users table in the database, one of the fields is "Dept_ID." The report I currently have works loads data and everything fine, but I only want to load some of the data from the table, specifically where Dept_ID matches the current user's Dept_ID, basically adding the "WHERE" clause to the select statement.
I used the report wizard to generate the report and data table, etc, just followed from step one. I've looked around and have found something about using parameters, but can't seem to figure out how to pass a variable to the parameter, or if that is even the best option. Using the wizard, I don't have any code to show for it and the report works like it should, I just need to figure out how to configure it further.
Load XML Document And Query Data On User Selection?
Feb 13, 2012your life whatever you are doing.I have a big question. Well, it's a big job for me. I tried to google and follow some tutorials frist but finally realise rom stackoverflowers.I have a one big xml file such below. I have no control over its structure as it already exists with data.
<?xml version="1.0" encoding="utf-8" ?>
<root>
<Category Cat="A">
[code]....
Updating Records In Table Using SQL Query On Form Load?
Aug 27, 2010I am new to VB.net and want to know how I can execute SQL queries from within VB.net code. Example: I want to update some records in a table using SQL query on the Form Load event.
View 2 RepliesVS 2010 How To Load Child Data When Query A Parent
May 30, 2010i have a one two many relationship on a form that loads empty so that the user have to do a search in order to populate the data into the form. To acomplish this, i created a filter (query) in the dataset. The filter works fine for the parent data, but how can i load its corresponding child data?
This is the code generated automatically when i created the filter in the DataSet:
VBCode
Try Me.TblConfidencialesTableAdapter.Buscar_Confidencial(Me.ConfidencialesDataSet.tblConfidenciales, TablillaConfidencialToolStripTextBox.Text)
Catch ex As System.Exception
[Code]....
Autocode Generate - First Query Finding Max Of A And Second String Take String A
Mar 15, 2010Private Sub txtname_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtname.TextChanged
myConnection.Open()
[CODE]...
I want to four digit code like Abneesh than first query finding max of A and second string take string A than code generate like A001----------A999
.net - String Query Error Conversion From String "iif(CurCons = 0, " To Type 'Double' Is Not Valid
Jul 4, 2011I make a query in coding. But I got conversion error.My query is below
Dim strSelect As String = ""
strSelect = "SELECT " & _
"Description As [Desc], " & _
[code].....
Exception error is like
Conversion from string "iif(CurCons = 0, " to type 'Double' is not valid
Actually, in my report, i wanna show if it's zero then '-'. If i set it in this string.I got another error like below The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value.
From da.Fill
Dim cmd As New OleDbCommand(strDynamic, m_DBConn)
Dim da As New OleDbDataAdapter(cmd)
da.Fill(ds, "tblCur")
Can't Load A String Into A String Variable?
Apr 12, 2009I am using the MODI DLL (Microsoft Office Document Imaging) because it has an OCR engine. That's working fine, but I'm having trouble capturing the resulting text into my own string variable (weird, huh). Modi has the result stored in the following Modi string variable:
img.Layout.Text
I've tried three ways to capture this value, only one of them works (not the one that I need to work)
(1) Dim txt as string = img.Layout.Text 'fails
(2) MsgBox(img.Layout.Text) 'fails
(3) M = new Msg(img.Layout.Text) 'succeeds
Method 3 (the only one working) is a custom msgbox I built in VB.Net, and it accepts a regular .Net string variable. I need Method-1 to work. The error thrown is this:
"Attempted to read or write protected memory. This is often an indication that other memory is corrupt." I even tried it like this:
(1) Dim txt as string = img.Layout.Text.ToString.Trim
Here's the complete code:
Dim doc As New MODI.Document
doc.Create("C:VCR.tif")
Dim img As MODI.Image
[Code].....
How To Create Between Clause In Query
Aug 15, 2010How should I create between clause in my query?
View 3 RepliesCreate A New (for Example) RTB And Load The File?
Jun 20, 2011Let;s say I have a text file which is already associated with my software. When I double-click the file my software open fine, but how do I tell my software to create a new (for example) RTB and load the file I have double clicked.
View 4 RepliesLoad Instead Of 9 To Create Label Should Be Only One?
Mar 25, 2010My friends when I form this code used to load instead of 9 to create Label should be only one, but it provides this option when I write I button well this Code while working How can i label when the form was loaded to the View
[Code]...
Create A Conditional Statement After Sql Query ?
Sep 20, 2011I created a sql query to check if the mobile number is registered or not. If its registered, it will send the new pin code to the customer and if its not, the customer will get a message that "This number is not registered or you are not authorized to this"... something like that... Sending of new code is already working. I just dont know how to make it as conditional statement like PHP. After you query on PHP, you can just set a variable and make a conditional statement..Here is my script in vb.net:
Private Sub CheSMS()
Dim SQLServer As String = My.Settings.SQLServer
Dim conn As SqlConnection[code]......
Create A Dynamic Query To Entity FW ?
Apr 7, 2011I'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].....
Create A LINQ Query Based On SQL?
Sep 25, 2010i try to convert this kind of sql query into linq in visual basic, but i get stuck on how to make a percent.. I also don't know how to use linqpad for creating this linq
SELECT CASE RIGHT(PICName, 3)
WHEN '(P)' THEN 'Problem'
WHEN '(R)' THEN 'Request'
[Code].....
Create Sql Query For Search Program?
Oct 21, 2011Trying to figure out the right way to query a MySql database and find a user defined variable from a Textbox.Text property. I'm not sure what to put for the where clause in order to search every cell of every row for a match. I have looked at coalesce and contains, but neither are really making sense to me and I'm not sure if they are my best option. I'm thinking that the query string will look something like this:
View 2 RepliesSql - Query Array Or Create A Temp DB
May 9, 2012Is there any way to query an array of mine in VB.net? I just need something temporary in order to query it for a report but I do not want to make an external database just for something that's going to be temp. I just need to be able to say select * from tempTable etc etc.
View 2 RepliesVS 2008 : Create An EDI 837 /X12 File From A SQL Query?
Nov 22, 2009create an EDI 837 /X12 file from a SQL query. I will be creating a temp table then inserting data to the file.The X12 file has essentially 3 parts: The Header, The Detail, and The Footer
The Header looks like this
ISA*00* *00* *ZZ*HIS199 *ZZ*300002373 *060920*2314*U*00401*000000089*0*P*:~
GS*HC*HIS199*300002373*20060920*2314*43*X*004010X098A1~
ST*837*000000001~
BHT*0019*00*90*20060920*2314*CH~
[code]....
What method choices do I have to choose from to assemble this to a file?
Asp.net - Looks Like A Query String But Won't Act As A Query String
Nov 11, 2011I am working with VB in asp.net, The basic problem is, I want to pair up the elements in a string, exactly like request.QueryString() will do to the elements in the query string of the web page.
[Code]...
Options To The User In A Menu - Create Sub-string - Replace A Word In The String
Feb 28, 2010Problem: Your task is to take input from the user in string and give the following options to the user in a menu.
1- Find a String
2- Create sub-string
3- Erase a portion of a sting
4- Replace a word in the string
5- Count number of words and characters in the string without spaces.
6- Capitalize first character of each new sentence and convert the rest
of the characters to lower case.
7- Sort all the words in alphabetical order. (Use Bubble sort algorithm to perform sorting).
To perform all the above mentioned tasks you can only use pointers. Create a function to perform every task.
Create A Datatable And Try To Load Sqldatareader
Apr 6, 2010Scenario is this; I've a sqldatareader query that seems to be returning nothing when I try to convert the sqldatareader to a datatable using datatable.load.So I debug into it, I grab the verbose SQL query before it goes into the sqldatareader, just to make sure it's formatted correctly. I copy and paste this into SQL server to run it and see if it returns anything. It does, one row.I go back to visual studio and let the program continue, I create a datatable and try to load the sqldatareader but it just returns an empty reader. I'm baffled as to what's going on. [code] Ok I've done a loop to count the rows of the datareader before using the datatable.load method. In my test query I'm getting 4 rows (the correct amount) in the datareader, as soon as I use the datatable.load method it says the datatable is empty, what's going on?! So it seems a datareader is a one-way thing, iterate through it to get the row count and it's essentially empty as far as any other bit of code is concerned. Didn't realise it was forward only and wouldn't 'reset' once read through.
View 1 RepliesCreate Several Pie Charts At Form Load
Jan 31, 2012I would like to create several pie charts at form load. I have a database and I'm able to populate the pie chart dynamically but what I want to know is that is it possible for the system to create multiple pie charts? The pie chart represents the amount of free and used disk space.. obviously a server has multiple drives. I would like each pie chart to represent each drive.. but I don't want to drag and drop a chart control each time.
[Code]...
DB / Reporting - Create The XML That A Record Set Can Load
Mar 7, 2010I have a dataset; I want to create an equivalent record set. What I really want to do is create the XML that a record set can load; I have no other use for the record set per se. I want to be able to load recordsets on other machines (which use VB6 ins of vb.net) with this data. I found some code that loops through the columns in the dataset and creates the fields in the record set; that's executing. However, the code given to open the record set fails with "incompatible or incorrect parameters" or some such. [Code] I can see that a recordset is a construct meant to bridge between running code and a data store of some sort, but in this case the data is "stored" in the dataset, not anywhere else. I want to put that data in the XML form that the recordset uses, so that other code that can only use recordsets (ins of datasets) will be able to read it.
View 2 RepliesLINQ To SQL Query - Select Customer From Dropdownlist And Then Gridview - Load All Items Of All Orders Of That Customer
Oct 4, 2011I have the following problem: I select a customer from a dropdownlist and then the gridview should load all items of all orders of that customer. I have the following query:
Dim allorders = From ord In db.Orders
Where ord.CustomerID = Convert.ToInt32(CustomerDropDownList.SelectedValue)
[CODE]..............
I also tried to modify the query as follows:
Dim orderitems = From oi In db.OrderItems
Where oi.OrderNumber = (From From ord In db.Orders
[CODE]...........
But this does not work. I just started using LINQ.
Create A Form That Allows U To Query Tables In Access?
Mar 18, 2009Im trying to create a form in VB that allows the user to perform queries on a number of tables which are in access.
View 3 RepliesCreate A Report From A Query Using Multiple Forms?
Apr 21, 2010which contains a combobox with two Gender options, Male and Female. When the form runs the user can select either male or female to perform a query. I made the ComboBox public and shared so that it can be viewed by other forms. On another form i added a ReportViewer and a dataset based on my database (MS Access 2007 database with 1 table named tblStudents). I don't have any problems when i try to run a simple query without parameters, but there is a problem with my
View 13 Replies