VS 2010 Get Info From MSSQL
Feb 10, 2012[Code]...
If its saved succsessufully to display message that is saved. I want just little program to edit 1 table,
[Code]...
If its saved succsessufully to display message that is saved. I want just little program to edit 1 table,
I am trying to do is fill out a form with certain info, put the info into an array, and write it to a listbox using loops, arrays, and maybe a function if I need one. This is for VB2010 and here is what I have so far... I think there are ways to make it shorter but I cannot figure it out.... maybe just brain dead from all the coffee I have been drinking!
[code]...
I am aware about the COPY ALWAYS or DO NOT COPY features for files and database files.But my problem is the following:This is the
Public Sub New()
' This call is required by the designer.
InitializeComponent()
Dim mhkos As Integer = 1
Dim ypsos As Integer = 1
[code].....
where the MDF file is located I am getting an error...as the MSSQL server does not allow even to copy the file to an other location.
get information from wikipedia.So the info goes to TEXTBOX1.TEXT and then creator to label8.text and then the image will go to picturebox1.image.i have a listbox with all the videos?
View 4 RepliesI'm developing an application that will need to be used with a client.The software can be managed online ( at website ) and by desktop client.I can't find any information in how to send information to website and retrieve data from website. The PHP code is entirely written. how do I get something like:
Client -> PHP -> Create Account ( Send this to a file like create.php?user=USERNAME&pass=PASSWORD )
The PHP file ( stored online ) will run the information and create the account?How to send that information with VB .Net?After that, PHP will return a info if it's ok or not the user account creation.How to retrieve the results from PHP and show them in the client?
Is it possible to get the network information of another program/Process like Bytes sent and Bytes received. I looked under the Process class but that didn't yield any results.
View 1 RepliesI have a WebBrowser in a Windows Form, and I want to automatically fill out a login and password field, then send the data to the server to log me in. How can I do this in VB?
View 1 RepliesOk I got a variable named Accounts and stores the user accounts. They are seperated like this
Account|Pass|Admin&Account|Pass|Admin
As you can see after admin there is a symbol (the &) meaning that before the & its an account and after it its another. In other words its like this
Account|Pass|Admin
Account|Pass|Admin
so how can I make a loop to count how many & there is in the Variable named Accounts?
I have the following database setupWhat I want to see is the tblOpponent.oppTeam when given a matchID in tblGameI tried the following SQL string in VS 2010
strSQLString = "SELECT tblOpponent.oppTeam FROM tblOpponent WHERE tblOpponent.oppID = tblOppBowler.oppID AND tblOppBowler.oppBowlerID = tblGame.oppBowlerID AND tblGame.matchID = " & MatchID.ToString
[code].....
I am experimenting with Property info and getting their values etc. The below code gets the properties of a layertable record and creates my PropertyListViewItem
Dim ltr As LayerTableRecord = DirectCast(obj, LayerTableRecord)
For Each prop As PropertyInfo In ltr.[GetType]().GetProperties().OrderBy(Function(p) p.Name)
Try
[Code].....
I have a combo box appear if I click on an item that is not read only. What I want to do is populate that combo box with the values it can accept. ie If it is a boolean, add True and False etc.
I am working on a media player, and I would like to setup a local playlist feature. I am using a single ListBox and its "Display-" and "Value-Member" properties. The display is the song's Artist and Name, and the value is the song's file path (i.e 'C:UsersUSERMusicetc.').To write the file path to the .txt file, I believe I can use the following code:[code]
View 18 RepliesHow can i display a certain region/selection (rectangular) from an excel file into a form.
View 9 RepliesFor a class project I am supposed to search through the attached file, and write to a new file the years between 1789 and 2009 that are not present in the fifth field. What is my best bet for determining what years are not present?
[Code]...
Should I make an array of integer between 1789 and 2009, then search for every year in the file, then set a flag to false if not found; is there a simpler way to accomplish this using LINQ?
I am trying to get my project to be able to save the data been input from a user. I have uploaded a screen shot of the dialog I am currently trying to use. You will see that I have got a combobox for member at the top. What I want is when the "new" button gets clicked then I can add the desired information then click "Ok buttton which will then save the information.
I want to be able to select members from the combobox after multiple have been recorded to be able to delete or edit them. I have got as far as "changing" the combobox to a textbox for input purposes. I have tried a few attempts to get it. I am getting "ConfigurationErrorsException was unhandled"
I have 2 tables. I'm getting info from table1 which is loaded in an rtb.
vb.net
]Dim cmd_info As New MySqlCommand("SELECT kan_info FROM kan_info WHERE kan_id= '" & kt_id & "'", conn)
reader = cmd_info.ExecuteReader
While reader.Read
beslag_kanton_info.Text = _
"RB_REF: " & vbNewLine & _
"KT_REF: " & vbNewLine & vbNewLine & _
reader.Item("kan_info").ToString
End While
This works great, but I need to add extra info after "RB_REF:" and "KT_REF:" (e.g: RB_REF: 12345 / KT_REF:6789) Those values are located in another table. How do I change the code/query so it also get the necessarily records from that table? Obviously there is a column "kan_id" with same values. I can't merge the tables btw.
I have:
1 ComboBox(cboCultureInfoNumeric) with the required CultureInfo.
1 Textbox(txtNumeric)
1 Label(Label1)
When the user change the Culture info the decimal point or comma change in the textbox(txtNumeric) nicely.What i try is to change also the text in Label1 by the culture info.If the user change the CultureInfo to German the Label1.text = �German�If the user change the CultureInfo to Spanish the Label1.text = �Spanish� And so on�
What I have do is :
1 - Set the Form1 Localizable property to true.
2 - Set the form's Language property to "German (Germany)".
3 - Set the Label1 Text property to "German".
VB make the file -> MainForm.de-DE.resx with name: Label.Text and value: German
4 - Set the form's Language property to "Spanish (Spain)".
5 - Set the Label1 Text property to " Spanish ".
VB make the file -> resx
6 - Set the form's Language property to "French (France)".
7 - Set the Label1 Text property to "French".
VB make the file -> resx
8 - �The TextBox with the numeric value�s change when the user change the CulureInfo but not the Label1, why?It work perfect when I put �Thread.CurrentThread.CurrentUICulture = New CultureInfo("fr-FR")in the MainForm.designer.vb before InitializeComponent function and in the New function.But I want to use the ComboBox�
I`m trying to insert information in accdb. [code] I`m trying to write the LOMBART system..if anybody have exaples please give me or tell me what to do for this code.
View 3 Replieshow to create Quick info and/or parameter info for own code?
View 6 RepliesI am making a program, obviously, and I require some assistance. I found an explanation on how to read information from a Text file and have modified it for my needs. Here is my (modded) version:
Public Function GetInfo(ByVal playlistname As String) As String
On Error Resume Next
Dim PlaylistInfo As String
[code].....
I'm making a database app. I've finish the search, add new, and add function. What I'm trying to do is to expand the functionality of the add new item function.
View 2 RepliesI just made a project which a registration it has Tables/Database. [MemID] [Name] [Address] etc... I try to test this program i publish this to make a installer, after the installation, i run the program i put some information:
Example:
MemID : 1
Name : Julio Jose
Address : PO Box
Then I save all the information. While running the program I noticed that I forgot to put a remove/delete button. I close the program, and I edit my project to put the button (remove).. after editing i try to publish, uninstall and install the program. I noticed that the information I save in the program is gone. My Question is: Is it possible to update your program with out affecting the details/information of your program?
I am developing an application toolbar to be used with our companys CAD software and I have this portion of it Reading the lines of a text file into various comboboxes and such. However, if there are only 12 lines in the text file when I click a button to update and apply the new information i get an error because the file is already open. I need to figure out how to make sure its closed before WriteAllLines kicks in.
Imports System.IO
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If System.IO.File.Exists("c: emp est2.txt") Then
Dim theFile As String = "c: emp est2.txt"
[Code] .....
So I have a program that is supposed to support a small business. I have the work completed and the professor said it was correct but I wanted to go do a little extra.Basically, on the Order screen, you begin to type the name of a customer/supplier/employee into a text box and a list of names that fit the criteria pops up in a list box (lbMatchingAccounts). When you select it, you can hit enter new order and be transported to the Order Details screen to enter the new order.
What I wanted to do was to create a new list box (lbOrderId). What I want is to be able to select a person from lbMatchingAccounts and have all their Orders populate in lbOrderId.
[Code]...
I am exporting crystal reports information into an excel spreadsheet and now I am trying to open up excel so that the user can view the page but however I cannot SEE the excel file. in Task manager there is EXCEL.exe which shows that maybe excel opens up but the spreadsheet is not visible.
Imports CrystalDecisions.Shared
Imports Microsoft.Office.Interop.Excel
Imports Microsoft.Office.Interop
Private Sub btnPrintExcel_Click(sender As System.Object, e As System.EventArgs) Handles btnPrintExcel.Click
[Code] .....
Application.ProductName
WindowsApplication1
Application.CompanyName
have the project name, not company
Application.StartupPath
adds to end inDebug
I've changed all properties in the project but don't found any that points clearly to "company name" or so.also the startuppath adds the indebug ?how to avoid this?(sure I can find & replace the string, but I want the adequate path)also where can I change app name and prod name?
Since reinstalling VS2010, it has not been displaying proper debug info. I don't think I changed any settings but I have had a hunt through the options and can't see anything I might have messed up. I have had a quikck search and other people seem to have had the same problem but no solution. I'm running Windows 7 x64 with latest updates, if that matters.
View 1 Repliesunder my project I have the following
However when I use this code.
lblABOUT3.Text = "Version : "
lblABOUT3.Text += My.Application.Info.Version.Major.ToString()
lblABOUT3.Text += "." & My.Application.Info.Version.Minor.ToString
[Code]....
how to correlate info from a textbox based on a listbox item selection. For example the user will select an item from the listbox, enter say the length of a song in the textbox say 2:00 for song #1, select say song #2, enter the song time for that song say 3:00, click on song #1 again and have the same textbox display the length of that song and be able to do that until there are no more songs on the list.
View 5 RepliesI have been trying to extract the text between multiple tags on a web page with the same outerhtml info. For example:
[Code]...
I am using Visual Studio 10 Languague VB
It is web based and conects to remote SQL Server If i run a query on database connecting using Sql Server management studio this query give correct results which is to find minimum value in a column called TIME1.
The query on database is SELECT MIN(TIME1) AS Fastest
FROM Athletes
WHERE (ATHLETE = 'Joe Bloggs') AND (Session = '600m')
This works great showing correct result under Alias column name Fastest
My problrm is i want to get this result from code behind page
here is Query in code behind page
SqlDataSource1.SelectCommand = "SELECT MIN(TIME1) from Athletes WHERE (Session ='600m') AND (ATHLETE = 'Joe Bloggs')"
I need to extract min value of TIME1 and pass it to a variable