I have an application that works together with a SQL database. This database has more than 40 tables and my applican has to extract different situations from those tables.
I have predefined some queries for the situations that I know they need to be in the application.
The idea is that I need kind of a module in which an user can create his own situation based on the tables, views, functions and procedures that already exist in the database. Something like it is in SQL. There has to be a library or something which will read my sql database directly from my application and which allow the user to create his own queries and situations.
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.
I have a small-scale WPF application using VB.net as the code behind and I want to add certain features, but i'm concerned about performance.
1) My app interacts with a third party database to display "realtime" data to the user. My proposed method is to create a background worker to query a database every 30 seconds and display the data. I query about 2,000 records all long integer type, store them in a dataset, and then use LINQ to create subsets of observable collections which the WPF controls are bound to.
Is this too intensive? how much memory am i using for 2,000 records of long int? Is the background worker querying every 30 seconds too taxing? will it crash eventually? Will it interfere with the users other daily work (excel, email, etc)?
2) If an application is constantly reading/writing from text files can that somehow be a detriment to the user if they are doing day to day work? I want the app to read/write text files, but I don't want it to somehow interfere with something else the person is doing since this app will be more of a "run in the background check it when I need to" app.
3) Is there a way to quantify how taxing a certain block of code, variable storage, or data storage will be to the end user? What is acceptable?
4) I have several list(of t) that I use as "global" lists where I can hit them from any window in my application to display data. Is there a way to quantify how much memory these lists take up? The lists range from lists of integers to lists of variables with dozens of properties. Can I somehow quantify how taxing this is on the app or the end user?
give me some example code to insert rows of datagridview into a sql express database table? Also, how do I manage concurrency as it is a multi user application?
Im a new in this VS2008. But i have some foundation of programming in VB6.0. So im planning to create this application using VB since im familiar in that language.I downloaded a Visual Studio 2008 and SP1 - now on its 90-day trial, and planning to buy the full version depending if it will meet my needs. I just read afterwards the conditions and how to buy it. I hope its free shipping and credit card is acceptable.^^
I need to make an application something like a reporting system, my plan application is a client-server application. Currently im reading the How to topics and some walkthroughs so far so good. Now here are some sort of details and target need to fulfill.
1. An interface from client that will input the data from the multiple-user , including images and these data will be saved in database/table remote server (center database server) LAN.
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 a problem related, not only to VB.net, but also Oracle.I have a simple application that runs queries from an Oracle db (Oracle 9i) and creates reports from it. I am using the official oracle.dataAccess component.I need a very simple report that returns a list of usernames. Something like "SELECT userName FROM users".(userName field is a VARCHAR2).Problem with this query:The top 50 rows are OK.All the remaining are strange characters.
I am sure some of you have seen this project before. I need to create an application that queries customer name (first and last) and there addresses. I need more than that but once I figure what i am doing wrong with that, I should be able to figure out the rest on my own. I am using VS 2010. I can not figure out the proper syntax for String.Format. I can only get it to display the first and last names of the customers.This is the code I have so far:Public Class Form1
I'm building an application that will be using several (7) SQL queries, I'm wondering whats the best way to approach this since I've never built an app with this many queries in it. These queries really won't change, just the start date and end date and I have query in my first form that finds out the next available date by checking a table. What I'm wondering is if it would be better to construct these queries in my application or if it would be better to use stored procedures on my sql server to do the same thing and not have the application carry the load of the queries.
I'm developing an application with Visual Studio 2008 (with visual basic), first of all, I'll give a brief of what I'm planning this module will do.
It's an accounting application, that I use to administrate some of my company's movemets. The application links directly with MS SQL server 2005, and sends queries to the database like: client name, employee Id, transacion type etc. Right now I'm developing a contracts module, wich is intended to be used with Microsoft Word 2007. We want the module to do the following: (It's a contract document; the document should get the variables from the application like contract type [that would change the template of contract used in microsoft word depending on the type], Client name, Salesman name, today's date, name of the company's representative)
1) After the data has been captured from the application (the application has a capture module that sends the info to the database), instantly send the capturer to microsoft Word, to a layout that has variable fields that should fill themselves with the database information ( I don't have a clue on how to do that )
2) The capturer should be able to change text in the contract layout and fix the variables info in case they were misstyped, adn when he/she saves the document; if there were any variables edited, they should get updated in the database; and the application should be saved with a name that has variables on its name ( 1)today's date in DDMMYY format, 2)First 2 letters of the client's name, 3)last 3 digits from tye contract number), save the file in a directory where all contracts are in .docx format (could use any frmat, it actually doesn't matters), and send the file location to the databse; to a table field named "file" wich only has the file's route.
3)From my application, when consulting the data, give the app access to the file directly; simply by getting the query form the database.
I am having some difficulty with an xPath expression. I am using an XML document to store queries / stored procedure names in an ASP application. I use a utility function to load the xmldocument (if it isn't previously loaded) and I am attempting to select the node set from the document that matches an Id element. [code] the node variable only returns the first element. I have verified the that the qry string that is used to SelectSingleNode IS the correct Id value (i.e. USER002) - however the node is getting loaded with the USER001 element. It is obviously the xPath expression that is messed up. What do I need to tweak on the xPath expression so that I can return the correct <Id> element and corresponding child <Sql> element.
I have a total of 102 values associated with a fieldname called ArrivedFlag.Then I have a TextBox control with an id of txtFlag on the markup page.In my codebehind, I have an if statement that says:
If txtFlag <> "value1" and txtFlag <> "another value" Then lblMessage.Text ="You don't have the ability to view details" end if
This works fine.However, given that there are 102 values, I feel that doing an IF statement 102 times is a bit inefficient.
Dim allowedFlags = New List(Of String)() With { _ "value1", _ "another value"
I was asked by a client to create a tool that would let a user add/modify/delete/read content from a database. The content can be read from TextBoxes.
My question is, what is the best way to manage GUI locks/unlocks for the different states of the program. IE: If I'm in a "insert" mode, some GUI elements should be enabled, and some not. If I'm in the "read-only" mode, a bunch of them should be disabled... etc.
I am writing a program that uses an array with three columns and a varying amount of rows. I need to load info on a list of files in an archive(specifically: file name, size, path), and I am wondering what the most convenient way to store strings(to be loaded into the array) is.
For example: I tried creating a new .resx file in my project, and writing a function to be executed on form1_load that reads the strings from the .resx file and places them in the array in their correct column, but unfortunately had no success.
I really have no idea how resx files work, I can put strings in them using the resource editor, but I don't know how to retrieve them using resourcemanager.
I would just put the info straight into an array, but it's much easier to update a .resx file when the archive changes than it is to update the code.
Could someone please tell me how to use .resx files in vb.net? Or an easier way of accomplishing my goal?
I import decimal values from my SQL Server into the TextBoxes 1-4, which works fine. But when I try to add the values together into another textbox the answer is just the values combined like a string...?The column of the table in the SQL server has a datatype decimal(18, 2)I have also tried to convert the values in the textboxes into int, str, double... Nothing seems to work...
I am now convinced there is no such thing using VB 2010 Express. I have read, re-read, studied, copied and pasted code to no end and all I get are error messages galore. It appears there is a big gap between what's on line as far as tutorials and the code that VB 2010 Express will accept. I hate to sound so lost but at the moment I am. I used to program in BASIC and QBASIC. I was a master at opening up ascii text files, reading them in sequential order, sorting, manipulating, then re-writing them. It was all so easy, like this: [code] That's all I want to learn how to do for the moment. But every tutorial or article I find goes off in to wild tangents about How to Manage Directories or it reads the entire text file into one giant object. Or worse, there's some code which looks promising but it won't run under VB 2010 Express or it might run but the author leaves out important parts of the code that have to be declared ahead of the subroutine....you all know what I mean. It can't be this difficult to just read a text file one line at a time, therefore it shouldn't be so difficult to find an accurate and up to date article on this.This is for really rough programming. I don't need an interface of any kind. The user, will not even need to know that anything is happening. I simply want to read text files, manipulate what's in them and then re-write the edited text.
im using dreamweaver and i have a table in which i have an image. When i add another table under the table existing it comes right at the bottom. What should i do to that table so i can move it and place it anywhere around the page. displaying my data wherever i want. And another problem is that, when i place something on the top it doesnt show up there it comes slighty away from where i had placed.
Id'like to pass some variables (string and integers) to a class, and when I call a method of that class, it has to change the original variable.I know it was not impossible in C#, but I'm using VB2010, I made a C# project into my solution, but methods using pointers are hidden into VB. How can I make that kind of change?
An example:
Sub ChangeValues() Dim A As Integer = 1, Str As String = "Start String" Dim X As MyClass(A, Str) X.ChangeInt(2)
What is the best way for me to have several datasets ?i've thought about creating a routine for creating datasets with a number in their names, each one with the desired data, but that's not very intelligent (although might work)i'd like to create what would be like an "ARRAY OF DATASETS"
[Code]...
(obs, i've done the same code loading one XML to one dataset and it works perfectly, i've gone back and forth more than one time to assure that it isn't just a logical mistake, it's syntax and lack of programming knowlegde.
What I want my program to do is to make a selection from the ComboBox and it will be added to the ListBox. If the selection is already in the ListBox, a message will appear.
Note: Project / Properties / Option strict is On This is my codes, but the If-Else doesn't seems to work.
For Each country As String In lstCountry.Items Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbxCountries.SelectedIndexChanged [code] .....
I have data source and table that I can bind to my controls and datagridview. I can add records to data table and i can view on datagridview but I can't update and Delete records using datagrid. I have following code.[code]
I'm creating a small program in Visual Basic, using Visual Studio 2010, which communicates with a GSM modem via serial port.The connection works, I can even communicate properly with the modem and I can also send sms and mms .. But I can not handle the modem answers ... I'll explain:If I send a command like AT + CSQ modem replies with + CSQ 22.0. This command gives me the value of the signal as a response on a scale of 0-30 ... I can see on the screen (in a dedicated console) but I would like to manage the response in the sense that I would do something like that
IF (answer.text = "+CSQ 22,0") Then label1.text = "Good" ELSE label1.text = "Bad" END IF
I am now building a project where I need to regulate the monitor brightness from software using vbnet.I have now put 2 buttons (+ and -) but I cannot adjust brightess monitor from code usinf these buttons!=!=!=!
I am new to using Visual Basic. Normally when designing other projects, CAD for PCBs, C source code, Mechanical parts etc, I maintain a sequence of design files with minor revision name changes such as r1, r2, r3 etc as I develop the design/debug process. This makes it easy to go back a step if the recent changes I've made prove to be a problem and need to be deleted. I am not sure how to do this using Microsoft Visual Basic 2008 Express Edition.
I am reading data from an XML file. This local XML file will be updated by another application, and I will need to periodically re-evaluate the XML file, and only import new data into a list box. Furthermore, I want to be able to click on a particular item in the listbox, and display the other values about that particular XML entry.
So, I suppose this is a multi part question. What is the proper way to import only NEW data into the program, what is the proper way to store the data, and how do I associate a value in a listbox with the data stored elsewhere?
I've considered multidimensional arrays, but have been told that strings to char arrays and then back to strings is a terrible way to manage the data, but was never offered an alternative.
The first thing that I have found difficult to manage is when a program has several forms. Basically what I do is just hiding one and showing up the other form. it does not look that nice. I was thinking of having one form and laying all the other forms on that one. Let me explain myself more thoroughly. Let's say to the left hand side of my form, i have few group boxes with buttons. So when clicking a button, it should automatically close the form and show up the new one on the main form. Its like refreshing the form. So what I mean is that there is only one main form and clicking each button will show another form.
I am making a application to help manage your files and notes on different projects, you can organize your notes, images and videos, However i am stuck on what coding to use to manage the project, what my.settings etc.
