your 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]....
I am trying have a data grid selection populate a form. I am new to this.Basically I have a connection persistance object and I would like to call that and call a stored procedure with the value of the selection. The datagrid is bound to an object.
[Code]...
I am reading data from a mysql database table.I have populated a dropdown with the relevant slections, i want the rest of the form to load data once i select the plate number .[code]...
View 1 Repliesi hve create combobox & text box and add database source to my project...i know how to binding data or load data to combobox using SELECT query..but can i change SELECT to INSERT query cz i wont when i type data into textbox,data will be in database...second..can i binding without add database to project..i mean mydatabase in debug folder..i hve problem binding data if database is not in myproject..
View 7 RepliesSynopsis: 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.
i 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]....
I am trying to essentially allow the user to merge data from a database onto a document and print it. I am new to working with the PrintDocument, but I believe this would be the way to accomplish this. I know how to print the text onto the PrintDocument at a certain position, but what I am trying to figure out is how to deal with the coordinates of the text I am drawing on the PrintDocument. Ideally, I would love to click on the PrintDocument in a PrintPreviewControl and capture the coordinates of the PrintDocument.
View 9 RepliesOn a word document I would like to populate same data captured via User Form on multiple locations of a document... i.e. LastName I would like to appear on salutation paragraph and also in the body of the letter... I used REF LastName on the document when using VBA but it seems the same document when it is being populated via a VB application this skim does not work and instead "Error! Reference source not found." appears where ever the REF LastName has been used..
View 3 RepliesI'm using the Details View control of VWD asp.net 2008
I have a users database table. One of the columns contain the "uniqueidentifier" user's profile ID, created by VWD (from the automatic profiles table).
From my table, I would like to select only the data pertaining to the logged in user.
How do I get the current unique user profileID in general and then how do I use that for my query?
In the configure data source option of the control, I select the check box for "Return Only Unique IDs" and the WHERE option. In this new window I select the Column to the profile userID ... "=" and then assumed I should select Source: "Profile".
Now what should the parameter properties or value be to select only the current logged userID?
OR how can I do this just in C#? There doesn't seem to be any code behind after instering a DB with the VWD controls?
I have created a program in Visual basic 2010, the program contains many different objects e.g. datagridview, textbox, buttons, graphs etc, which can all be modified by the user. The user can also select a file using 'SaveFileDialog'.
Is there a way to save all the properties associated with each object to this file and later load the program back to exactly the same state it was saved in, after the user has selected saved file using 'LoadFileDialog'? Preferably in binary.
I can do this the hard way in ASC11 format by interrogating objects user editable properties and saving them. I would rather not use this method as it will require a lot of code and any future program changes will require a lot of extra work.
I have created a program in Visual basic 2010, the program contains many different objects e.g. datagridview, textbox, buttons, graphs etc, which can all be modified by the user. The user can also select a file using 'SaveFileDialog'.
Is there a way to save all the properties associated with each object to this file and later load the program back to exactly the same state it was saved in, after the user has selected saved file using 'LoadFileDialog'? Preferably in binary.I can do this the hard way in ASC11 format by interrogating objects user editable properties and saving them. I would rather not use this method as it will require a lot of code and any future program changes will require a lot of extra work.
I have a vb .NET 2005 form that needs to load data based on a selected month by the user. Because there is a large amount of data in the table (60k+ records per month) it is taking the query a long time to pull the dataset back and populate the form. how I can decrease the overhead associated with querying a large dataset to populate a base form?
Note, I have created an identity key on the main table but haven't yet indexed any other fields (Though I could use some suggestions on how I should index).
See the following example of the Stored Proc that is run before my .net form is launched:
Dim cmd2 As New SqlCommand
Dim ConnectionString As String
Dim TheDatabase As System.Data.SqlClient.SqlConnection
[CODE]...
So, I run a select statement in SQL and then it has something like " where clientName = 'John Doe' " I can generate a datagrid or dataset off the SQL statement, but it will only be good fro one client...... I would like to be able to populate a dataset/grid using the select satement and then having something like a combo box of names the USER can choose. Then the user selects the name and the datagrid is populated with that clients info or w/e........
[Code]....
I have a VB2005 winforms application that will loads city data from my database table. This is to ensure that the user enters the correct city spelling, in order to receive an accurate quote. Currently, there are about 150K cities that are being loaded to the dropdown listbox on page load. It takes about 30-40 seconds for that page to load. My initial thought was to allow the user to select the state first. Then load the city values. But the user has the option of going back and requesting a quote for a different city / state.
View 2 RepliesLoad a combobox with a selection from another?[code]....
View 2 Repliesthere are three tables in dbf , table1,2,3 respectively all are contains similar structure but different data Structure : S.no Quiz Question i want the query which select the Quiz Question/records through user given Range from Textbox1.text to Textbox2.text
View 3 RepliesI am trying to get so users can select there dates from a calendar and those selected dates will put into a sql query to pull from a database. I am stuck on how to get strings of the dates to fill the query.
Imports System.Data.SqlClient
Partial Class TEST
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code] .....
This is my first time to be here and is a total newbie with Visual Basic 2008. I have background in VBA Excel and would like to try Visual Basic 2008. I would like to start off on a certain project and I am currently in trying to load image (in jpg format) into the picturebox thru listbox selection. I have found this code here and is trying to modify it to suite my needs but is having quite a tough time to set it right. [code]....
View 7 RepliesMay i have a working sample on how to retrieve records from a DB & populate the relevant textboxes after a selection at a dropdownlist. What i have is definitely not working & im working on VS 2008. Can anyone show me the way?
[Code]...
I have two forms, forms a and b. Each form has a combo box. The user selects an item from form A's combo box and saves their selection to a database by pressing a button. How can I display their combo box selection from form A in form B's combo box on form B's form_load event?
View 1 Repliesi had this working and i foudn the info on this forum, but i cant for the life of me renemebr how to do it, and searching for the thread all i can find is this:
[URL]
Which is not it, the method i used only involved a few clicks per item to set up and it made it so what ever selection was chosen in a combobox for example was saved, and then that selection was loaded on the apps next run, i know i had to do something in the application setting/databinding area of the properties.
I got this text document that is opend by my server and is edited by my server the whole time. Now i want to load this document into my program only it says its in use what is normal... but is there a way to use it ?
View 5 RepliesI'm trying to export data from a sql query into a xml document. I need to automate this process because I have over 40 of these type queries that I have to post shortly after midnight each day. I've been trying to figure out how to do this for a few days now.
My xml document
<?xml version="1.0" encoding="utf-8" ?>
- <Envelope xmlns="http://Schemas.xmlsoap.org/soap/envelope/">
- <Body>
- <SubmitRequest xmlns="http://abc.org/dart/xml">
[code]....
What would be the fastest way to put XML nodes in memory? I can use generics, arrays, list arrays and so on but how to get the nodes first? All of the following are taking too long:
XmlDocument.Load
XmlDataDocument (used it by accident)
XPath.XPathDocument("path")
I can loop through 500 000 Nodes and get the 30 000 uniques in less than a second instead of 3 hours previously but loading the nodes takes whole 20 seconds. Never thought this would be the bottleneck.
how to load data (Book) to text box when user just enter the book code?how to load data (student) to text box when user just enter the student id?how to write the code when user click the save button , the book quantity(Book) will reduce 1 and the all the data in textbox will save in database(Issue)the interface is like
[URL]
the database is show at
[URL]
the code is
Public Class frmIssue
Dim dt As New DataTable()
Dim rowIndex As Integer = 0
Dim rowIndex1 As Integer = 0
[code]....
I am currently using the code below within a VB.Net application to find specific text in a Word document. The text is surrounded by symbols represented by the character codes in the .Text statement. The code below is working fine. The issue now is that sometimes the desired text within a document has been marked for deletion and appears as tracked change within the document. I would like to find only the desired text that has NOT been marked for deletion. Does anyone know of a way to determine if the found text is a deletion?
[Code]...
In VB.net when loading in XML documents using System.Xml.Xmldocument is there a way that I can specify a relative path to the file?[code]...
The XML doc I'm trying to load is in the same directory as the VB class. But I'm having trouble accessing it without using a full path to the XML doc.
I was making a treeview favorites for my browser and got this code, however, nothing happens on startup, like the treeview stays emty
Heres the code for the Load handler
If System.IO.File.Exists(FavFile) Then
Dim xdoc As New Xml.XmlDocument
[Code].....
the exact same code works for the orginal project, and I have the same xml document in the same subfolders for my project
I'm trying to load a XML file into a XML Document without the headers. The XML file does not have the XML Declaration header.
<?xml version="1.0" encoding="utf-8" ?>
This is my XML File. Please note there is no header.
C:TestFile.xml
[code].....
I would like to convert a image query, found here [URL]..In vb2005.net to the xmldocument which I can then cruise around and grab the data with, current code using the webclient isn't giving me a good xml document to use. Any ideas how I can fix this?
[Code]...