i am creating login page with database connection.In my database i have 4 column which is Name, phone, address and department. I also use query in my stafftableadapter to retrieve data. i want to know what is sql command should i use if i want retrieve data where department is counter. Below is my code but i got an error. SELECT * Name, phone, address department From Staff WHERE department = Counter
View 1 RepliesI want to run "RUNDLL32.EXE shell32.dll,Control_RunDLL access.cpl,,2" this command in vb.net 2005.
I have tried using 1.>SHELL("RUNDLL32.EXE shell32.dll,Control_RunDLL access.cpl,,2")
but it brings a new window same as the one i am working on.
2.>PROCESS.START("RUNDLL32.EXE shell32.dll,Control_RunDLL access.cpl,,2")
ystem.Diagnostics.Process.Start("F:VBMedia RipperMedia RipperinReleaseconvert.bat"This line in the bat file does not execute?
View 1 RepliesIm trying to insert a row of data into a table in a mySQL Database.I finally got the syntax right, but now when I try and run it i get the error:Error: Unknwon Column textID.text in field listI am using the following
Try
cmd = New MySqlCommand
cmd.CommandText = "INSERT into STAFF (ID, Name, Address1, Address2, Address3, Post_Code,
[code]...
DataReaders are read-only forward-only but DataAdapters have their own insert,update,delete and update command.then how to use the insert command of the DataAdapters?
View 2 RepliesI'm currently in the middle of a Console Application. I have done everything and it's ready to be handed in. However, I don't want to hand it in like this. I want to build upon it.
One of the ways I'd like to build upon this is with an e-mailing system. I'm find it hard to include the e-mail code in to the project and would like to request assistance. I'm uncomfortable posting the full code on the net as it is for my A-Level Computing and anyone that is doing the same course as me will be able to claim it to be there own.
Is there any way i can run a Quest AD management shell command (not a plain powershell command) from Vb 2005 ? i mean do i need to register a snap-in within vb or register a dll or something ?for eg. i need to create a simple script to add multiple users to multiple groups then i can quickly design the front end in VB with 1 textbox for users & 1 for groups & then in background can i run a quest ad management shell command to actually add the groups (using add-qadgroupmember in this case)
View 3 RepliesI need to replicate the ping in command prompt. I'm currently using the following:
Try
If My.Computer.Network.Ping(mtbIPAddress.Text) Then
rtbLog.AppendText("Response")
Else
rtbLog.AppendText("Reject")
End If
Catch ex As Exception
rtbLog.AppendText("Reject")
End Try
But I need to get the same response as the ping in command prompt i.e..
Pinging www.l.google.com [74.125.71.104] with 32 bytes of data:
Reply from 74.125.71.104: bytes=32 time=240ms TTL=53
Reply from 74.125.71.104: bytes=32 time=313ms TTL=53
Reply from 74.125.71.104: bytes=32 time=256ms TTL=53
Request timed out.
Reply from 74.125.71.104: bytes=32 time=251ms TTL=53
How do I get the bytes, time and TTL?
I'm rewriting a small application and I'm working on moving the data access logic from the form to a separate class. All was working will when I had all the code in the form. Lets say I had code similar to this in my form:
[Code]...
If TextBox1.Text has atleast one number 0 or 1 or 2 or 0 (it may have text too, with numbers) then End If Also what command is it to get window position coordinates and what winpos[x] and winpos[y] are. All I found was setwindowpos
View 2 RepliesI'm programming in VB using Visual Studio 2005 Professional. I have a code munger perl script that generates some of the *.vb files that I want to compile. The script and the associated files are in my project directory, and when I run the script from the OS command prompt, it writes the files in the same directory, which is what I want. Rather than do this, I want to invoke the perl script as a pre-build event. I've gotten it to work ... almost. The only issue now is that the files are now deposited in TargetDir (/bin/Release e.g.) instead of ProjectDir. I could just change TargetDir to be ProjectDir, but that seems like I'm asking for trouble. Is there a way to separately specify the target directory for pre-build commands? Or change it to ProjectDir, then change it back after I'm done with the pre-build?
View 1 Replies[Code]...
KEYASCII command does not work with visual studio 2005. What is the new code we should use?
If I execute any shell command in VB application How can I capture the return code from the shell command. I have written something like this
shell(db2look ....,AppWinStyle.Hide)
Now I want to know the return code of the above command which ran using shell script.
I've got a program where the insert/update SQL was created with the values coded directly into the SQL string. I've changed this to use the Command's Parameters.AddWithValue method and all worked well. I'm now in the process of separating the data access code out into it's own class. I've got the Select code working using a DataSet in the form that I pass ByRef to my data class so it can populate or refresh it. My sticking point is in how to pass the parameters for the Insert/Update commands to the class since from the form I no longer have access to a Command object. Do I need to make the Command object in the data access class available to the form?
View 6 RepliesI am trying to execute a command line EXE (busobj.exe) with required parameters through VB.Net. Because of unknown reason the report is not being generated. Here's the commandline:
Shell(txtBOExecutable.Text & _
" -user " & txtUserName.Text & _
" -pass " & txtPassword.Text & _
" -system " & txtDomain.Text & _
[code].....
I've found alot of examples for add/edit/delete a single table. In VB6 ADO you could load multiple tables into a recordset using the join command. Then manipulate or modify the data.
I've found how to retreive multiple tables like,
Da = New OleDb.OleDbDataAdapter("Select groups.groupid,groups.userid,lots.groupid,lots.lotid from groups inner join lots on groups.groupid=lots.groupid order by groups.groupid asc", DB) But the only way I have found to update is to use seperate Update commands for each table.
First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
I always have trouble with this every time I create a desktop app which needs to update data from a database.So, I have created and coded my form to load data into a data grid view control, I can add data to the data grid view and it updates fine but when I come to delete a line, I get the error message below
System.InvalidOperationException was unhandled
Message="Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information."
Source="System.Data"
[code]....
i am developing a small tool by using VB.Net. I want to display data in comboboxes from a table which is in an access database. I using SQL query. Its a simple problem , I think the problem is in my COMMAND. I want to display data as DISTINCT(No repeating data). I am including the code and design form.My code(for form) is
///
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cn = New Data.OleDb.OleDbConnection
cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\CTCRI-STUDENTSRajeev R NairRajeev.Dept.ESSVariety FinderVariety FinderTuber.accdb"
[code]....
I'm trying to use a VB button to insert data into a database, but it keeps bringing up the error message I have in place for exceptions.
why this does not update the database?
Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim sqlCnn As SqlConnection
[Code]....
So this is my code... most of it autogenerated... i have created a database, and one table and i stucked trying to update items in table...
Here is the code:
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
I have this in creating table but did not work. Having invalid table name error.
Imports Oracle.DataAccess.Client
Imports Oracle.DataAccess.Types
Public Class dump
[code]......
I am working on a project for my final in vb.net and I have a weird error when I try to insert info into my database. When I run the application it errors out on command.ExecuteNonQuery()and the error is Syntax error in INSERT INTO statement. I have the fields in my database are set as text at 255 chars. I have both inmports statments at the top, and as far as I can tell my statement is right.
Here is my code.
Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source =../../Base/LogTextCopy.accdb;Persist Security Info=False;")
Dim StrSQL As String = "INSERT INTO TIMEANDDATE(DATE, TIME) values(@date, @time)"
Dim command As New OleDbCommand()
command.CommandText = StrSQL
[Code] .....
I am using VB 2008 Express, connected to a MS Access database for some reason my update command is not updating my database.i may have something wrong [code]whats wierd is when i change UpdateCommand to SelectCommand, it will update the database, but it makes other things in my program malfuncation, so i cant have that as SelectCommand, there must be a way to have it all work with the Updatecommand ..
View 4 RepliesI'm trying to add information to a SQL database. I've had trouble getting it to update (and I'm only doing one entry at a time!). However, even one at a time gives me trouble. The red line of code gives me this error: Update requires a valid InsertCommand when passed DataRow collection with new rows. what I'm doing wrong--I think it may be syntax, but I'm think the parameters are correct.
[Code]...
i use this command to open my ms access database file, but it is not working, what is the problem.... i learn this command from internet tutorials. [code]
View 3 RepliesI have a problem with the code below as a SQL command string. Note: Using .Net Framework 4.0 in Visual Studio 10 Professional. Database is a Microsoft Access file. The idea is that this SQL command string will update a password within my database. Also note that I have tried the string below with and without the ";" at the end and it does not work either way. The problem is most likely extremely obvious, but I can't seem to find it. I have commented below the code what each part of the String is.
"UPDATE Users SET Password='" & tbx1.Text & "' WHERE Username = '" & sUsername & "';"
' Users is my Table name within the Database.
' Password is the field that I want to edit within the Users table.
' tbx1.Text is where the password is stored within a text box.
' Username is the field which I would like to compare with sUsername which is a variable within the code.
Solution was square brackets, Command string now looks like this:
"UPDATE Users SET [Password]='" & tbx1.Text & "' WHERE [Username]= '" & sUsername & "'"
I posted a while ago about having issues with a database, and selecting a value from the database. I was told that there were things missing from my code, and I've not gone back and added the things I was advised to. Now, my code seems to be working more, but outputting the wrong value.
[Code]...
I'm trying to delete a record from an access database using the command object in vb.net 2010 express but can't seem to get anywhere.If I run the code below, I get no errors but nothing happens. The connection opens fine but the db does not update.the table has only two columns.The variable strCrit is so that I can build the sql string with exclamation marks, When I debug.print the sqlupdate string it seems to read fine.the routine is called from a form with a button.
Dim sqlupdate As String
Dim strcrit As String
strcrit = """"[code].......
How do i check if the command insert new data in my ms access database this is my code so far.[code]...
View 12 Replies