Please anybody help about how to create two dynamic combo box. Like Country and province.. when I select country conutry Combo box then Province Combo box automatically show same country province.[code]
View 5 Replies
I have a query (qryTallyMedalInformation) that i bound on datagridview and it has 5 columns ( country, athlete, medal, game and date). Instead of having country in the datagrid, I want to use it in a combobox to display records base on country selected.what i did (with wizard) doesnt work fine though. My country combobox shows duplicate data and the datagrid is showing all the records from different country. In one word I JUST DID NOTHING.
View 12 Repliesi need to create sql tables based on user needs lets say a guy needs a table of 4 rows 5 columns other user needs 3 rows 3 columns each with different types so how is the best way for letting them choose like they write in a text box ( this will be the value of rows)4 and another text bvox the count of columns and i have those 2( rows and columns needed) numbers i create the table as is.based on those. by default i create type as varchar max then later on we must fill the table using datagrid.
View 14 RepliesI am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
If I am to update table 'Province' in databse get "Value of type 'Boolean' cannot be converted to 'System.Data.DataRow" Is there any other easy method to update table in Access Database?
Imports System.Data.OleDb
Public Class Form4
Inherits System.Windows.Forms.Form
Dim myadapter As New OleDbDataAdapter
[code]....
I'm a junior VB programmer and looking for some advice on this subject. I'm trying to create a chunk of code that will create dynamic storage for variables for use later by dynamic custom controls.
For example:
An INI file might have an entry in it that looks something this:
....
[var1] <-- this becomes the Storage name
description=My Variable
type=System.Int32 <-- this could be any valid VB type
last_val=456 <-- Other code would save the last value
....
And I want to access the data using a standard "property set" like so after it's created:
var1_reference.value = 55
I've tried using a generic class which works ok as long as I declare the variables at design time from within the design environment. But when I try to create them from the INI file it gets messy.
Here's the simple generic class i've constructed to test this:
Public Class GenericVar(Of T)
'
' Generic Symbol Class for data storage
'
Private VarName As String
Private VarType As Type
[Code] .....
Also, as each object is created (and they could be different types) I store a reference in an array to make it easier to keep track of, but I'm having a hard time getting access to the objects and their properties, and certainly cant seem to assign an event handler to it once its in an arraylist because the design time code doesn't know what "Type" it is in the arraylist of objects.
is it possible to create typed data set tables dynamically or modify columns and the data types of an existing table. what i'm trying to achieve is to read the sqlString from an external file and populate a typed dataset table in order to use it as a crystal report data source.
View 3 RepliesI am trying to create a combo box that would display data from a dataset, and also a 'Please Select' as the first item. I have written the following code which derives from a combo box and it works fine in visual studio 2003 but in 2008 would not display the comboboxtext (which is 'Please select').
Public Class DoubleDataSourceCombo
Inherits ComboBox
Dim myDataTable As DataTable
[Code]....
I've been into programming, I've landed a job with a local company, the entire project the gentleman is paying me to do is incredibly easy, with one hitch, the original project I'm converting is built using access databases, for efficiency, and easier online transfer, I'm wanting to switch to using an SQL database, I've got plenty of experience inserting, modifying, and controlling an access database, but where should I start to learn how to essentially set up, create tables, and modify data within an SQL database?
View 5 Repliesi can connect to only one Data Base with dataset in Visual Basic . but i want Have Dynamic connection to data base i mean in want to my appliction users have ablity to connect to any data base they want (For Example : Choose file from menu and then open and then Select any Data base.)
View 4 Repliesi have a question in vb about inside a data grid view i need to create a combo box...
View 1 RepliesI am new in this forum, also new in VB.Net I need to create a public class for insert and delete data to database Public Class My_DBFunctions
[Code]...
I use Visual Basic 2010 Express. I want to create a WinForm app in which there are several buttons "table1", "table2"... Each button must display the corresponding table of a database in a specified region of the same form.
I'm able to link a MS Access database (.accdb) file to the app. But, how do I create that dynamic area whose content would be one of the database tables of the linked database? I tried using DataGridView, but I'm a newbie and I'm missing something; it doesn't work.
This code doesnt work it gives an error saying invalid column OrderNumber..
Dim cmd As New SqlCommand
Dim s1 As New SqlDataAdapter
Dim s2 As New DataSet
[Code]......
How can I use dynamic fields in LINQ in the PART OF THE where query? I mean that I want to write where x = *dynamic fields* I want to do the select query in all of the tables that are in the dataset, not on one datatable.
View 1 RepliesI want a to create a combo box that gets the selectable items from a table and when I save the form I want the selected item saved to a different table. I'm sure this is simple I'm not a database wiz and still very much a newbie.
View 4 RepliesI have Joined two tables into a datagridview and i want users to be able to update the table values but i have this error,which is the title of this thread.Is there any alternatives of updating a joined table in datagrid view? here are my codes
Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
con.Close()
Dim cmd1 As OleDbCommand = New OleDbCommand("SELECT LECT_NAME,LECT_ADDRESS,LECT_CONTACT,SUB_SEMESTER,SUB_ID,SUB_NAME FROM
[code]....
Is there a way to make a pop up (like a msg boxs) if the mouse goes over a panel?
View 1 Repliesi wish to run a program with 2 forms form 1 will have 2 radio buttons and a textbox and form 2 will have 2 textboxs i wish to use the radio buttons to select wich information is bieing displayed from either form2 textbox1 or textbox2 using the radio buttons on form1 then display the information in textbox1 of form1.
View 4 RepliesI've created a form with two check boxs and one button. I added this code Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Bg1.txt As String = "C:UsersJoshDocumentsBg1.txt"
Dim objReader As New System.IO.StreamReader(Bg1.txt)
TextBox1.Text = objReader.ReadToEnd
objReader.Close()
End Sub
End Class
to the button thinking it would open Bg1.txt when clicked but it's not working?
I have tried to realign the image by down and right one pixel, but still only part of the first row and column are visible when zoomed.I can't find exactly what I'm looking for online.
My computer is an HP-Pavillion dv9600 Notebook PC.
OS: Windows Vista SP2 32-bit
The following code reproduces the problem:
Public Class PictureBug
Dim pxlColor As Color
Dim img As Bitmap = New System.Drawing.Bitmap(My.Resources.TestBug[code]......
how to resolve country name from ip address.
View 3 RepliesI signed up for a free 30 of Azure. I logged in, created a database. I am able to connect (=Test Connectivity). But that's it. I don't see anyway to create tables, etc. Also how can I connect this db to vb.net (I am using vs.net 2010)?
View 3 RepliesI would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.
Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
I have two questions:
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it
I currently have a sub that has a string builder that I'm wish to use as the content of a CSV which I will email later from a webpage. My stringbuilder is creating the content for the CSV but I don't know how to create the CSV dynamically (I don't want the CSV on disk).
Private Shared Sub BuildClientTrustBalanceCSV(ByVal sb As StringBuilder, ByVal clientsWithTrustBalance As List(Of NonPaymentHistory))
If clientsWithTrustBalance Is Nothing OrElse clientsWithTrustBalance.Count = 0 Then
[code]....
I have two data tables within my data set that are loaded onto my form on form_load using statements written in code (not the designer. When I change a value for the first table via a text box the change is made to the data set. But when I try the same for the second table, the change doesn't remain in the data set when I switch to a different company and come back. I query the second table using the primary key of the first table but no code is needed when I change the values for the first table so I don't understand why the same doesn't work for the second when I change a value via a data-bound text box....
Here is my code that initially binds the data:
'This is used to read our data from the data base
Public Sub Read_Data_SQL()
Call Clear_Bindings()
[CODE]...
Here is the code I call when the selected index of my company combo box changes to have the second table reflect that of the first:
'This sub populates any information contained in the Contact2 table
Private Sub Update_Contact_2()
Dim Company As String = cmbCompany.Text.Replace("'", "''")
[CODE]...
I was create a web services(Ip2Country)
i send my visitor Ip to this service and return his/her country information(like US|USA|United State of America)
and it's work correct.
BUT if our visitor connect useing (vpn or proxy) it does not work correct
Dim hostname As IPHostEntry = Dns.GetHostEntry(TextBoxIP.Text)
Dim ip As IPAddress() = hostname.AddressList
TextBoxIP.Text = ip(0).ToString()
I have a windows form with the code above to get the ip address of the user. what would be the easiest way to get the country location of the user? based on the IP in the textbox. The solution doesnt need to be 100% accurate but good enough to work most of the time. the simpler the better.is there are any work arounds or built in fuctions for pulling a users country or language, this would be better than creating or managing a giant database.
