I'm getting ok connection to the database... but it's always telling me that I don't have permission to use the SELECT command with some table called 'proc'.
View 1 Replies
first of, here's what i'm using.
Visual Basic 2005 Express Edition
Oracle Database 10g Express Edition
i created a procedure stored in the oracle database create_user and accepts a few parameters...
procedure create_user
( p_user_num out tbl_users.user_num%type
,p_username in tbl_users.username%type
[Code].....
so i run the form, click the AddNew button in the BindingNavigator, enter the data in the textboxes and then click Save. i receive no error but the values of the textboxes are not being passed to my stored procedure. it is creating records but all columns are null.
i checked this by using an SQL Editor to query the table back-end.
Sqlserver Table1 has following data
CODE:
I want to get following result
CODE:
That is grouping on date.
What command should I write to get above result
I see the examples where I can export a table into an Excel Worksheet by using
SELECT * INTO [Excel 8.0;Database=C:Book1.xls].[Sheet1] FROM [MyTable]
But I can only use [MyTable] if it is a binding source correct? What i would like to do is something like:
[Code]...
I have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but dont know how to compelte the rest.
Imports System.Data.SqlClient
Public Class cbo2
Private Sub cbo2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]...
i have seen this in many codes, just not sure where to start and how to call the command. what i'm talking about is having code as such (this is for save file dialog):
[Code]...
I have a vb.net app using plain old ado.net to run a s'proc on the database server. The proc simply inserts a record that contains binary data.When this executes, I can see the exec call on the proc being made from within sql profiler.ado.net claims everything worked, no errors. However, a record isn't inserted. There are no key collisions or anything like that.I copied the query I saw from profiler and ran it directly within management studio. When I run it there, the record is inserted.For whatever reason, sql server and ado.net were conspiring against me. The user account I was attempting to execute the s'proc under did not have execute rights for it. After I set those rights then it was proceeding as normal.Now, the problem I have is that there should have been some type of warning, error, exception, whatever that said "hey, you can't do this" instead of simply saying "Everything is good" But that's a question for Microsoft.
View 2 RepliesI am converting a lot of projects from VB6 to VB.NET. Many of these projects use the DAO method CreateQueryDef, something ADO.NET does not. I know there is a way to replicate this method in ADOX using Catalogs, but I wanted to stay with pure ADO.NET. I have been using CREATE PROC to do this, but some of the query def's in the VB6 version mention tables/queries that are not created until later. For example,[code]The way the projects are, it is not possible to simply flip these two lines. I was wondering if there is a way to force CREATE PROC a AS SELECT FROM b even though b does not exist yet, or if there is a different option in ADO.NET to replicate the CreateQueryDef functionality.
View 1 RepliesMy code Adds a New Row from a Source Table called "objTablaOrigen" To a final table called "objTablaDestino". This tables are passed ByRef because they come from a DataSet respectively. objRowNuevo is The Row that will be added to "objTablaDestino" The data from "objRow" is well copied to the "objRowNuevo" (that is the new Row with type of objTablaDestino).
'The problem occurs when the instruction Add is executed. ¿What happens? The new row is added as well, but this generates an Exception with the next message:
[Code]...
Im doing that when delete button is clicked in the listview:(code simplified, it delete as it should)
Protected Sub rlvCarts_ItemCommand(sender As Object, e As RadListViewCommandEventArgs)
If e.CommandName = RadListView.DeleteCommandName Then
[Code].....
The issue comes when deleteting it will perform itemdatabound twice (but listview prerender once).
In VB2008 I would like to create a GUI for a command-line based exe called psftp.exe which can be downloaded here and basic usage here.I need to be able to carry out commands on the fly for example...
On Click of Button1- Connect to host
On Click of Button2- Prompt for username
On Click of Button3- Prompt for password
As these commands all relate to previous commands, they need to be carried out in the same instance of the command prompt.I have tried using the attached solution from an older post however it just doesnt work when trying to connect to a host (it works perfectly fine when using the standard command prompt).I'd also like to read any outputs from the command-line so I can create events on errors thrown for example...
On Click of Button1- Connect to host
On Click of Button2- Prompt for username
On Click of Button3- Prompt for password
If command-line throws "Access Denied"- MsgBox(The password you have provided is incorrect)My alternative to this is to buy a SFTP .NET component .
Using "del xxx.txt" command line in vb.net on Windows, however, permission deny occurred
View 4 RepliesOk ive managed to figure our most of my problems, and get help , from u nice people. i have 88 buttons and 1 is visible by default the rest are invisible so if you click the first button you get a open dialogue to select a program for my app called winhome after that i need the second button to become visible, and so on,any quicker way to do this instead of manually copying/pasting if statements?
View 15 RepliesI've been trying to create a table element like this in VB I just can't find one that matches in the toolbox.
[URL]
what it's called.
My problem is with the tickets table, I have listed the user that created the ticket, the tech who will solve the ticket and a user that over sees the ticket. All three users reference the users table. So how do I can I query the tickets table and get all three users that reference the same table storing the users?
Table1: Tickets
1) Ticketnumber
2) EnteredBy User 100
3) Issue
[code]....
What I can do now is something like this:
Select Ticketnumber, EnteredBy, Issue, UserName FROM Tickets INNER JOIN Users
ON Tickets.EnteredBy = Users.UserID
I have a field in my table called RentPaid, its set to bit data type. On my form I have a button called Pay Rent, when the user clicks that button I want my checkbox set to true.
I've tried both of these:
Me.chkRentPaid.Text = True
Me.chkRentPaid.Checked = True
Neither seem to be written to my SQLExpress database, however EVERY other field on my form does. The field shows up in my datasource for that form, I just dragged it over to my form with the rest of my fields.
I have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName
CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _
Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _
Select log.LogId, emp.FirsName, emp.LastName, log.Value
This is code I use to display Date from Access Database Table called RecordList
Sub RC1Fill()
ADBConnString2()
conn = New OleDbConnection(NewAdbconnstr)
cmd = New OleDbCommand()
daRC1 = New OleDbDataAdapter
[Code]...
I was wondering how do I add a command button called "Start without Debugging"? Is there such a thing in Visual Basic?
View 2 RepliesMy.Computer.FileSystem.DeleteDirectory("folder location here", FileIO.DeleteDirectoryOption.DeleteAllContents)
I created a program which was deleting a particular directory for me. The program was compiled and working. Today I run the same program...did not do any system updates and now it won't delete my specified directory. I ran tests to make sure the directory is there when testing...I keep getting access/permission errors.
I rebooted system, ran my application...still gave me error. I turned off Windows Defender...still got error. If I manually delete the directory...no problem.
Is there a way to get system permission to delete the directory? I am being given an 'access denied' error...I do not have permission. I tried running my application as administrator...no good. - VB 2008 Express - VISTA OS
I have a Gridview that I want to filter. My gridview is in an update panel and my filter button is not. On button click i have the following
protected void bttnfilter_Click(object sender, ImageClickEventArgs e)
{
if (TextBox1.Text != "")
{
[Code].....
So i add to the select command but I'm getting an error. How should I go about this? I don't want to use dynamic sql.
I have more than 100 controls (labels, textboxes, menu, Gridviews etc).I want onclick a button to turn all these controls to visible = true Now I need to code them one by one. Is there a code (in VB if possible) to make it applies to all in the control ?
View 2 RepliesI have a select statement, the code i have selects the item numbers from table(OrderItems) that is filtered with a combo box.[code]...
View 2 RepliesIs there a command to select all controls ?
View 3 RepliesOn button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn't work. What am i doing wrong? [code]
View 2 Repliesi have use this code to search the records of my datagridview and put it on my datetimepicker, there's no error occuring but it's not working either?
Public Sub SelectRecordM()
Try
Dim dbConn As OleDbConnection
Dim dbSelect As New OleDbCommand()
[code]....
I need to filter a measurements table that consists of 63 measurement objects that may or may not be tested more then once. The entries are put in a Batch table on a SQL server in the following fashion:
ID: | Serie | Test object | Min Amps | Max Amps | OK?
DateTime| String | Integer | Double | Double | Boolean
So there may be multiple entries in my database with the same series and testobject number but with (slightly) different results.
Currently I just select: SELECT * FROM Measurements WHERE Serie = 'XXXX' and use a datareader object to fill a datatable and then I let loose a routine on it that will either: Get the last result that produced a good measurement, so OK = 1 and max ID. Or the last result that produced a bad measurement if there are no good ones. I then end up with a list of 63 either good or bad measurement objects with the last good result, and if there isn't one then the last bad result.
Now I know that SQL is quite powerfull and I suppose that it must be possible to directly query for these results without a programatical routine re-filtering the results. I suppose it's like Selecting within a select statement..
I'm trying to create this select command against Access Database----Keeps giving me error saying operator is missing I just can't seem to figure it out
da2.SelectCommand.CommandText = "SELECT RecordList.RecSchNo, RecordList.RecTitle, RecordList.RecReasonCode" & "FROM DispReasons INNER JOIN RecordList ON DispReasons.ReasonID = RecordList.RecReasonCode" & _
"WHERE DispReasons.ReasonID =?;"
SchultzMan
I use a Datagridview control, in which I need to display info and after that to export it to an excel document(but the export to excel part it's not important right now). I need to display in the Datagridview 2 fields:name and item, from a table(here 's where I thought I should use select) and also the value field which has to be calculated using a certain formula...
Let's say value= a+b
My SelectCommand.CommandText is:
dtaadpPoints.SelectCommand.CommandText = "SELECT TOP 1 * FROM PointsTrans WHERE UserID=" & UserID & " ORDER BY PointNo DESC"
This should select the top row from the table PointsTrans where the UserId is what has been declared earlier when sorted in descending order.
But when I stopped the code to see what was happening there dtaadpPoints.SelectCommand.CommandText containe
