Is it possible to create database queries on the fly with VB?
For i = 0 To (UBound(WeekNo) - 1)
For NLoop = 1 To 50
WeekRow(NLoop) = WeekSinceLast(i, NLoop)
Next
Next
I want to write each WeekRow to the database for each week (= i). WeekRow contains 50 elements, each of which needs to be placed in a separate field.
So, can I generate a SQL query that is constructed on the fly? If so, how do I go about it?
I'm using oledbdataadapter for query lets say i have a fields Firstname, Surname, Location, Gender
Firstname| Surname| Location| Gender
Angel David Alaska Female
David Leonard Alabama Male
Michael Reeves Indiana Male
i want to filter data so that if I put a keyword %david% and select combobox as "MALE" it will search david on the first three fields and return
David Leonard Alabama Male
I have a MS sql database (not server), my program reads file structure from my 2 TB external drive and saves the list a records in database. I write around 80k records every time and it takes a great time.I am currently writing records by dividing them into 2 background Worker thread 40k each. My pc is Quad core Phenom II.What is the best way to achieve this and also would there be any benefits by increasing the number of threads because mine is only a 7200rpm hdd and not raid. What I mean is HDD might be a limitation?
View 2 RepliesI have an access database that has nested queries. For example, the querydef below is called qs_Pedon_type: SELECT qs_Pedon_basic.peiid, metadata_domain_detail.domain_id, metadata_domain_detail.choice, qs_Pedon_basic.siteiidref FROM qs_Pedon_basic LEFT JOIN metadata_domain_detail ON qs_Pedon_basic.pedontype = metadata_domain_detail.choice_id
[Code]...
I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
I have an Access database with some table and some queries.Here you see one query which returns 2507 records:I also added this database to a vb.net project.However, if i try to fill the datatable of the query with the specific tableadapter, the datatable stays empty. Also when I click the query in the dataset and choose 'preview data' I get none of the 2507 records:Any idea why he won't load the records into the dataset?
View 2 RepliesI've written an application and I'm trying to utilise a database behind it. I've created a mysql database, and table which all appears to work correctly. I appear to have connected to the db correctly too. And hit a bit of a brick wall. As a side-note, within Visual studio connected to the database using the add data source wizard, I then dragged and dropped my db table's column onto my form that intends to display them all (6 textboxes, including primary key) and that now displays the first record of the table. It confused me, because i did this as soon as I had setup the database with no visual basic code assisting, so there wasn't even a connection string?!
One functionality i want to have is to press a button and cycle through the table's records using the form by the unique id, how would I do this? I'm essentially asking how can I enter a number in a textbox which would then return me the relevant primary key and data attached to that record.
I have a rather complicated application (for me anyway). I have a word template setup with text controls. A web app with ASP controls and vb backend code binds data to the text controls using an xml file.
[Code]...
Is this possible programmatically? Getting the names of stored queries or checking if a query with a specific name exists?
View 3 RepliesI have written a program that queries an sql database displays it in a detailed listview, no problems so far. The only problem I am running in to is when I got to print the listview. When I do a regular printdocument.print() It prints out the listview exactly how I have it set up to do so. Which is a title , then column headers, next comes the listview, and then a total of some the columns. When I do a printpreview everything looks great. When I click the print button within the printpreviewdialog only the Title, Column headers, and the totals print. [code]
View 7 RepliesI have a database where the data contains some special chars. I retrive the data from the dbase (dbf) file with a sql statement and write it into a text file using vb.net. When I write the text file some of the special characters are not written the same way as in the dbf file, its written as a box. I'm using:
Using sw As StreamWriter = New StreamWriter(dbfFile, False, System.Text.Encoding.Default)
while writing to text file. I'm not sure how to read the exact data from the database.
We have recently updated our SQL Server to 2008 (from 2000). I moved all the data over to the SQL 2008 server by exporting from the 2000 server. All the tables open just fine, and all the data appears to be present. Within the VB.NET app, however, any table reference that uses a parameter generates an error: The data types text and text are incompatible in the equal to operators. The table adapter works just fine with full table previews, but not with either parameters or filter values (i.e., Field1 <> '0'). I should confess that I am new to SQL 2008. What do I need to do to get these parameter queries operational?BTW, I have downloaded and installed the VB2005 plugin that enables working with SQL 2008 (VS80sp1-KB954961-X86-INTL.exe).LDC
View 3 Repliescan i perform sql queries on xml files?
View 9 RepliesI am using Visual Basic 2008 / MYSQL
Basically i have 2 tables in mysql called Data and products
The first sql query i want to do is something like this to scroll through the recordset of products and bring back information;
dbquery.commandtext = "select quantity, sku, condition from products"
But then what i want to do is bring back information from the Data table based on the sku and condition of the first sql?
so it would be something like this
subquery.commandtext = "select lowestprice from data where sku = *SKU FROM FIRST TABLE* and condition = *CONDITIONFROM FIRST TABLE*"
There is not a VB.net database forum, and there is a HUGE difference (unfortunately) between ADO and ADO.net. I have a connection to a MS SQL database, which I understand is capable of handling multiple SQL statements in one Execution, ie
Using cmdExe As New System.Data.SqlClient.SqlCommand
sSQL = "Delete * from mytable where UniqueID=123;Insert into mytable (UniqueID, Field) values (123, 'something')"
.CommandText = strSingleSQLLine
[Code]....
There are two questions here actually...can I add the parameters before setting the command text, and do I have to add the same parameter over and over again?
I will start a new project, use the queries and dealing with databases using LINQ or SQl ,Which is better to start ???
View 4 RepliesI've recently ported my website from 2005 to 2008, and I'm using LINQ Queries to implement a search. The issue is that none of the fields are mandatory, so I've had to implement a dynamic LINQ Query (sic?). Here's the relevant code -
Public Function searchQuery(ByVal titleType As String, ByVal titleName As String, _
ByVal configMgr As String, ByVal lifecycle As String, _
ByVal CIType As String, ByVal recordsPerPage As String) As IEnumerable(Of
[code].....
I've got a couple of drop down lists for languages. I bind them to a language list that comes from a query. Then the fields are also bound to the row in the DB they relate to. I have several panels with the language drop down - each "tied" to a different table in my DB. When I call up different records on the same panel the drop downs immediately "set to the position" of that rows language in the list. But when I call up another panel - tied to another database table - I see that language in the drop down.
[Code]...
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
I am new to working with SQL databases (and databases in general) so I do not have a lot of experience with how queries work and how I can practice them. When I was first learning xml and XPath, I found XPath Visualizer incredibly helpful after someone on stack overflow mentioned it to me.Due to this, I am wondering if a similar tool exists for SQL databases?Basically a tool that will allow me to connect to a database,enter queries and see somehow what the results would be like.
I have looked online a bit, however I have found relatively few options in terms of any utility that would do what I want, and that looks reliable.I will ultimately be writing an application to interact with an SQL 2008 server in vb.net, however for now I am just experimenting so I will know what I am doing when I actually want to create my application.So far I have managed to connect to the database using an OLE DB connection, but I am now looking for a way to experiement with queries without just querying and figuring out a way to interpret the results in my program. Basically I want to be able to remove the programming aspect of things so I can experiment with queries without needing to question anything in my code that is unrelated to the specific query.
My Visual Basic 2008 can insert a new row to a dataset, but the dataset does not insert new rows into the actual Access 2007 database. The database remains unchanged and there are no error messages. How can the dataset write the new row to the database? [code]
View 1 Repliesthe way im connecting to database is different than any turtorial i found im using access and i need to write a ssn from a form to the database field.[code]
View 9 RepliesIhave been working on database but Though iam able to create But Cannot Write in data base..
Dim ADOXcatalog As New ADOX.Catalog
Dim ADOXtable As New ADOX.Table
Dim ADOXindex As New ADOX.Index
[Code]......
how to create Rows .. imean Adding data Under each colum .. like Names under Name colum and ID's under ID colum....
I am trying to re-write an Access Database I have, in VB...
In my MSADB I have a button that imports an XML into a table simply with 1 line using [code]...
i need to read and write to a database (access 07) using visual studio coding in vb.
View 3 Repliesas a comparative newbie to VB, I am having trouble with a program I am writing in Visual Studio 2005 in order to insert a value into a table I have previously created with SQL Server. Here is the function that is giving me trouble
View 10 RepliesDisclaimer: I didn't place this in the Database forum because since I'm so new to VB I might not even know of some kind of ingrained function for the saving of data. I have NEVER used standalone VB (I have 2010 Express now) -- I've always used VB 6 in MS Excel for the storage of data, so I really DON'T KNOW what is possible with VB6. (I also don't want to learn ALL of VB just to see what direction I need to go in, I'd rather get a direction -- even if vague -- and learn from there)
Goal: I want to write a standalone application for the creation of, storing of, manipulation of, etc records in Visual Basic 2010.Specifically what I want to do: IN VB, type in a bunch of client information in a variety of fancy windows, and when I'm done, have that client record saved in some kind of database.
Problem: I've tried Googling a ton of things about reading and writing from files (txt seems easiest for me at this instant) and I also see APPENDING to the end of a file. I don't see how a record in the file can be UPDATED. I see saving, I see loading, but I don't see (for example) the identification that I'm trying to save another record for Client 1234 so that it saves over the old client's record with the updated information.
1) Is this possible?
2) What database format would be preferable? (Right now I'm aware of txt, xls, csv, or access as possible options) I'm sure there are strengths and weaknesses to each but if there is general watered down version that would be awesome (I'm not trying to suck away anyone's life force)
3) Sample code, if possible, for whatever record solution you recommend using?(And I know that Access is generally pretty darn awesome, but the final project that I'm hoping to build to is likely to surpass the 'reasonable size limit' of Access that I've been told about)
I have NEVER used standalone VB (I have 2010 Express now) -- I've always used VB 6 in MS Excel for the storage of data, so I really DON'T KNOW what is possible with VB6. (I also don't want to learn ALL of VB just to see what direction I need to go in, I'd rather get a direction -- even if vague -- and learn from there)Goal: I want to write a standalone application for the creation of, storing of, manipulation of, etc records in Visual Basic 2010.
Specifically what I want to do: IN VB, type in a bunch of client information in a variety of fancy windows, and when I'm done, have that client record saved in some kind of database.Problem: I've tried Googling a ton of things about reading and writing from files (txt seems easiest for me at this instant) and I also see APPENDING to the end of a file. I don't see how a record in the file can be UPDATED. I see saving, I see loading, but I don't see (for example) the identification that I'm trying to save another record for Client 1234 so that it saves over the old client's record with the updated information.
Have been struggling to write a database into a msgbox. This is the code:
[Code]...
How hard is this. i need to send information from a text box to a website(i not done the website yet) which is anothing il be asking abot.I have basic vb.net skills. so can follow what i am doing. just not great
View 8 Replies