I am not that good with sql/visual basic but I have a sql database hooked up to visual basic and I would like to know how to make a picture box change pictures.
For example:
in sql : picture= 0 in VB: if number = 0 then display.nopicture
in sql: Picture = 1 in vb: if number = 1 then display.Picture01
This is for avatar use in my program.
I started coding my first "real" stand-alone desktop application in VB 2008 Express. I was led into believing that using SQL Express Compact Edition was the thing to use for my database since it would reside on each PC (laptops) that I installed the program on. I created all my tables and about 6 forms and all was going well until I came to the point where I need to display a grid showing data from multiple tables using what i think is supposed to be a view. Now the problem is that CE doesnt allow views. Here are my questions:
1. Can I convert my CE database file into an SQL Server Express file?
2. Do I have to re-write all my forms that are using the database? I am planning on creating my SQL Server Express database with the same table names and the same field names, data types, etc.
I want to be able to click a picturebox with an image and then load 3 other pictureboxes with images and then be able to click one of those 3 images and have it show in a bigger picturebox. How would I go about doing this? If its to confusing I will attach an example project I put together.
View 3 RepliesI'm trying to make my own clone of space invaders as it's been about a year since I've done any programming, and I imagine this will be a good way to get back into it. The main issue that I am having right now, is that I am basically clueless as to how I go about moving the player on a keypress. I have the code for the keyboard input correct, how to move my picturebox.
Here's my code so far (in a nutshell):
Dim PlayerPositionX as integer
Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown
Select Case e.KeyCode
Case Keys.Left
[Code] .....
I imagine I probably messed up very badly on this, but I'm completely lost!
I have a connection string in my app.config:
Code:
connectionString="data source=.sql2008 ;Database=Database1; Integrated Security=FALSE; Persist Security Info=True;" />
How do I change to another database (one of many) without using multiple strings? Can I change while the connection is open?
Code:
Dim myConn As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString"))
I'm trying to make my datagrids datasource change when you select a particular item from a drop down menu but all I get is blank cells! any ideas? I don't think it is changing the colums property automatically either.
If chooseType.Text = "Add / Edit Players" Then
updateDB.DataSource = PlayersBindingSource
[code].....
In my app (written in VS 2003) I use OleDbDataAdapter's to load data. I have some functions that enable be to change the OleDbDataAdapter.SelectCommand.CommandText at run time, by adding a "WHERE" or "HAVING" section to the SQL command, or updating the "WHERE " or "HAVING" section. This way I have have generic load data functions. (load all invoices for Customer 123, load all invoices for the year 2009, or load all invoices for Customer 123 for the year 2009).
With the new VS 2008 TableAdapter, the TableAdaper.CommandCollection property is Protected. How can I edit the TableAdaper.CommandCollection(0).CommandText at run time?
I have a report viewer that i would like to display different data in depending on the report button that the user clicks. The data is stored in access databases. I am able to retreive the data and display the initial report but i have not been able to change the report/data that is being displayed.
View 1 RepliesI am trying to make a 'puppet' change into a ball when I press e.g. the right arrow key. I used getasynckeystate(keys.right) to check for the key in a timer. The moving is working well but I don't have an idea how I can make it change in a picture of the 'puppet' changing which then changes into a ball. Does someone know how to do this?
View 3 RepliesToday i am working on a project for one of my college courses. I have a picture moving by button command. ex: up, left, right, down.
I need the image to react as each button in pressed for example the arrow is pointing up when i press left button the arrow needs to change to point left.If i could get some help that would be great. I have all of the images and i also need to know how to link them.
I have a timer that on tick checks to see the value of a an element in an array using a counter on another form as well. The picture boxes are initially set to false for visible and they should become true when the timer ticks and the element is equal to 1. I know that the pictureboxes have a valid picture in them because if I initialize them as TRUE first, it shows up properly. I also know that I am entering the IF statement because I can put a simple MsgBox with any string in the IF statement and it will display when the requirements are set. But yet the pictureboxes still do not change.
Public Sub test_timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles test_timer1.Tick
If tron.left_arm_full(tron.left_all_on_counter) = 1 Then
[code]....
What I have done is named a bunch of picture boxes "Q," "W," "E," etc. (the whole alphabet) and named picture that correspond to these picture boxes ("Q.png," "W.png," and so on) and added them to my resources.
For example, the following code would give the picture box named "Q" it's corresponding image "Q.png":
vb
Q.BackgroundImage = My.Resources.Q
Of course, it's kind of a pain in the backside to copy and paste this code and change all the Q's to W's and so on, so I was hoping to create a function to do the job for me:
vb
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
'So that I can run the letter as a string through the function,
[Code].....
Hopefully I've provided enough detail so that it is obvious what I'm trying to do.
Obviously, the code I tried above (the second block) doesn't work - it gives a syntax error. I need to change/write to make this function functional.
Any thoughts on what might cause a thread error like this?Error:InvalidOperationException was unhandledCross-thread operation not valid: Control 'Form1' accessed from a thread other than the thread it was created on.
Relavent Code:
Private Sub SerialPort_DataReceived(ByVal sender As System.Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived
[code].....
I have textboxes and lables (e.g. displaying changing filenames etc) which I hope to display the latest value when a program run.But the fact is, I found content of such textboxes and lables are not updated when the program run (under debug mode) although I'm sure that I've issue such command as textbox.text="xxx" or label.text="yyy" etc.What should I do in order that the textbox and lable can always display latest value when a program run?
View 5 Repliesusing Vb.net 2005 with sql 2000 and I want to display DatagridView. In VB 6 u can do something like this.
Adodc1.ConnectionString=myConnection
Adodc1.RecordSource= "Select * from Staff"
set form1.DataSource= Adodc1
Adodc1.Refresh
What's the Equivalence in VB 2005?
I work with both vb.net and c# in Visual Studio 2010, and something which annoys the hell out of me is that XML Summary blocks display differently between vb.net and c#Opened summary blocks look like this
VB
''' <summary>
''' This is the summary of what the method does
[code].....
I'm using this code:
Dim cListItems As New System.Collections.Generic.List(Of Combobox_values)
cListItems.Add(New Combobox_values("One", "1"))
cListItems.Add(New Combobox_values("Two", "2"))
[code].....
when i run following code it runs ok and problem is that during running code when i minimize the form and then restore again the form, it not display changing value into label1 and progressbar also the form looks like hang what is its solution?
[Code]....
I have a picture box on my form. I can load images which I read from a database into the box.
The problem is that the images are all sorts of different shapes and sizes. Some are square. Some are portrait. Some are landscape.
How do I configure the imagebox so that the pictures are reduced to fit, and keep their proportions. As I've got it at the moment, the rectangular ones are distorted into a square, which makes some of them look pretty strange.
How can i display picturebox in datagridview.......
View 1 RepliesOn my form i have a picture box that i want to put a random image in. im my code i have a random number generator. the number generated will correspond to a picture in my.resources. i.e if it generates 1 there will be a file called 1.jpg. what i need to know is how to tell the picturebox to display the image that corresponds to the generated number? i tried:
dim pic as string = random
picAnimal.BackgroundImage = My.Resorces.("& Pic &")
this does not work, it says identifier expected (between the . and the vairable), can anyone point me in the right direction?
I have a table in Access called 'tblRealTime' with a few rows of data and I want to display it in a DataGridView object on my form. When I run the program I get no errors but nothing shows up in the datagrid. My code is below:
[
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|K0201227Project.accdb;Persist Security Info=False;"
SQLStr = "SELECT * FROM tblRealTime"
[code]....
I have an Access table that contains "Customer Number".
I have an ODBC dataset (iSeries IBM Client Access, or AS/400 data) with a customer table in it. I want to link the customer numbers in the access table to the ODBC table so I can show the customer number from the access table and the customer name, city, and state from the ODBC table.
I want to display this information in a grid. I also want to be able to add records to the grid (which adds them to the access table). What is the best way to get started doing this? I am using VB2005. I could use MS Access and have it done in about 2 minutes, but I want to take the plunge and learn VB2005.
But this VB2005 and .net thing seems like they re-wrote the book on programming and I cant seem to get a grasp on it. I have tried several projects like this in hopes of learning, but ended up abandoning them in frustration.
I have a table I made in MS Access and I want to import/display that table into a DataGridView.I am VERY amateur but I am able to pick apart some code and see what is happening.The thing I know I need is a connection between the two programs but again, have no idea about how to pull it off.I have the free version of VB(2008 Express Edition)
View 1 RepliesI am trying to do two different things in one giant query. I am trying to specify a custom sort order which i have working in the following query:
Code:
SELECT Count(*), Status, 1 as OrderCol FROM tblSurvey WHERE Status = 'Complete - CD Sent to Customer' AND SurveyTable = 'tblSurveySoVA' GROUP BY Status
[code].....
I am trying to have my application display an image in the picturebox named picResult based on whether or not a person gets the answer to a math problem right. How to load a smiley face image (happy.png) or a sad face (sad.png) into the picResult picturebox when the question is answered right or wrong? Here is my code that check the answer:
Code
'btnSubmit instructions
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
'Error message displayed if textbox is left blank
If txtAnswer.Text = "" Then
[Code] .....
I have a datagridview in which i have info from a database.when i click o a row i want to be able to display the image in a picturebox.
View 8 RepliesDoe any one have a code to display a Image from a folder (C:***My ResepteWater lilies.png")) in a PictureBox?
View 2 RepliesI am new in vb.net. The image has been stored in sql server as and i dont know how to convert it to display in picture box.[code]...
View 14 Repliesi'm using VB.NET 2005 and mySQL server 5.0. Can i ask how do i retrieve the image from database and display images onto picturebox? mySQL column name is pictures then the data type is varchar. and how should i write on the database? eg. abc.jpg?
View 2 Replies
