I have a vb application sitting on sql 2005 database i want a scenario where the application can check the number of records inserted into a particular table(Users) , if the number of records inserted into that table after 1wk since the last insert is less than 100 records it should pop up a warning alert with the total number of records
View 3 Replies
i have a query as follow:
gconn.BeginTrans
strSQL = "INSERT table_name (....) " & _
"SELECT fields_name FROM table_name2..." & _
[code].....
How to check the inserted test in a textbox is number?
In vb windows phone application.
I am trying to make a basic ATM system, iv got all the interface done and I have made the link to my SQL database etc. the part i'm stuck on is how I can run a check to see if a bank card number matches up to the users PIN number. To simulate the user putting a card into the machine I've used a combo box, and that lists all the cards, that haven't been flagged as confiscated (there's a column in my ATMCards table that I can set to true or false) then after the user has selected a relevant card there's another text box where they can enter in their PIN number.
Now what I want to do is, if they chose the card number 1234567890123456 in the combo box and they enter in the PIN 1234 into the text box, then, after clicking the check PIN Button if the pin is correct they need to be taken to another from where they can check their balance etc., and if its wrong they got three attempts after which point i want to flag that card as confiscated.
i have a sql table which has 2 fields number & name
1 abc
2 xyz
Situation is that the app finds out max of number and increments it by 1 to get new number.The problem is when two users enter some record sometimes two records get saved on same number.
[Code]...
I have a form in which I am updating records to table Users in database China.accb. The btnClick sub successfully updates the Dataset. However, the actual table Users never gets the update. What am I doing wrong? The code is below.
[Code]...
I'm using VB.net 2008 and I just want to know the syntax or the command that gets the number of records in a table.I saw numerous syntax on the net like this
count = " SELECT count (*) FROM payroll_table "
but it doesn't work for me.
is there a method check the number of records in data reader? like the count of rows. ?
View 2 RepliesI've found a sql string like: "SELECT Count(*) FROM table"My question is: how can I use this string and get the result into a variable in VB2010? I used to program with VB6 for years, but now things are very different.
View 1 RepliesI need to count the number of records that match on the GIDs from the 'Directories' table (GID) and the 'ClientSubscriptions' table (DirectoryGID), and also the 'FranchiseGID' from both; as follows:
Dim iSubscriptionCount
SQLCommand = "SELECT COUNT(*) AS Counter FROM Directories.GID, ClientSubscriptons.DirectoryGID FROM Directories, ClientSubscriptons WHERE Directories.GID = ClientSubscriptons.DirectoryGID;"
[CODE]...
I need to determine whether or not to show a menu option based on the above.
Full Code: Default.asp
<!--#include virtual="/System/Startup_Admin.asp"-->
<!--#include virtual="/Admin/FranchiseAdmin/DirectorySetup/i_Directory.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
[CODE]....
I am using VS-2005 and database is on SQL Server Express. The application is a vb.net windows application.Following is the table structure
:Customer_ID nvarcharCustomer_Name nvarcharCustomer_Address nvarcharCustomer_City nvarcharCustomer_PinCode nvarcharCustomer_State
[Code]....
But the table still remains blank. The value of every column shows only "Null". Not a single record can be inserted. I have changed the value of the Database property "Copy to Output Directory" to "Copy if newer".What should I do ?
I'm working on a project and my boss insists I use a DataGrid for this. The grid holds information for work orders, one of the cols has a check box in it. I need the user to be able to select any number of those checkboxes/rows and then return a value to the table "stamping" that users ID. This is what I have so far to get the grids populated... I'm using 2005 with a 2000 Access Database if that helps. Though this will be changed to SQL Server once we get it working (yay more work)...
[code]...
I removed the code from the second grid to make it easier to read, obviously once I can get one to work the second shouldn't be as much trouble.
This is the check box: dgvNewBiz.Columns(1).HeaderText = "Select"At this point if someone knows how to get it to recognize the click event of the check box and pass that row info to a variable that would be super as I'm sure I could probably figure it out from there.
I've got a code using SQLClient that loops though all users in a Users table inside each loop i want to preform another search in the UserOrders table, thus doing a count of all orders.
I get this error
HTML
There is already an open DataReader associated with this Command which must be closed first.
Here is my code
vb.net UserLists.Items.Clear()
Dim connection As New SqlClient.SqlConnection(My.Settings.ConnectString)
Dim command As New SqlClient.SqlCommand("SELECT * FROM Users ORDER BY PersonName",
[CODE]...
I'm trying to delete a number of records in a table from the last and forward. My idea is to use sql like this: delete top " & variable & " * from table where ID = something It gives me a general sytax error. Is it at all possible? Fuga. Edit: I also have the order by statement there. I just forgot to put it in the question.
View 5 RepliesI have a database with 3 tables: Student, Unavailability and Duty.The fields for Student are entered in a form I have. One of the fields in Unavailability is filled by a form, the other fields are an autonumber and a foreign key to the Student table.ow I want records in the Duty table to be created and automatically filled in depending on what the values of the fields are in the Student table.For example, If the Boarder field in the Student table is 'yes' then I want the Duty Number field in the Duty table to be '1', '3' and '4'. If it is 'no' then I want the value to be '2' and '5'. I recognize it will have to create several different records to incorporate the different duty numbers for each StudentID. Obviously this will require an if statement, however this is my first time implementing a database with my limited experience with programming and Visual Basic, so I don't know how to refer to the specific fields in a table and set the value of other fields depending on the data in other fields.
View 6 RepliesI wrote the following code for inserting the value in table company_db & database is Company_DB but the value are not inserted into the table table shows null values the [code]...
View 6 RepliesI've just intserted a row into a database, how can i return the ID number of that row that's just been inserted?
Here is my insert code
vb.net
Dim command As New OleDb.OleDbCommand("INSERT INTO StaffData(PaxTitle, FirstName, Middlename, Lastname, DOB, @LastUpdated)", connection)
command.Parameters.AddWithValue("@PaxTitle", TitleTxt.Text)
command.Parameters.AddWithValue("@FirstName", FirstnameTxt.Text)
command.Parameters.AddWithValue("@MiddleName", MiddlenameTxt.Text)
command.Parameters.AddWithValue("@LastName", LastnameTxt.Text)
command.Parameters.AddWithValue("@DOB", DOBTxt.Text)
command.Parameters.AddWithValue("@LastUpdated", Now.ToString)
this is my coding i run no error message but the data is not inserted in the table.[code]......
View 1 RepliesSay I have a table called tblTest in MS Access with the primary key called field0 which is set to autonumber and a few other fields, say field1, field2 and field3. Say also, I inserted a new row using:
SqlO = "Insert into tblTest (field1, field2, field3) Values (value1, value2, value3)"
Dim cmdO As OleDbCommand = New OleDbCommand(sqlO, conn)
cmdO.ExecuteNonQuery()
[code]......
I have a data set with a table named IEA_Transaction_Test2.After executing the below codes to insert a record into the SQL server table IEA_Transaction_Test2, how do I get the identity value (auto number) of the record that just got inserted?
Me.Validate()
Me.IEA_Transaction_Test2BindingSource.EndEdit()
Me.IEA_Transaction_Test2TableAdapter.Update(Me.MyDataSet)
Dim Customer As New Customers
With Customer
.Name = txtName.Text
[Code]....
After saving I want to get its ID and pass it to another table. how or what is the proper way to do this.
All I need to do is only allow the users to add new records, I am not using a datagrid rather a details form (i.e. individual text boxes etc...).
I do not want the users to be able to view current records or edit them. If I just used plain text boxes then that obviously would be simple but I've already designed my rather detailed forms using the data objects (so taking the fields straight from the Data Sources mainly because it saves me writing the connection strings and stuff.
Hope this is possible without going back to using normal text boxes and writing the connection string out my self, only because that's a long way back to go right now.
I'm using ASP.net to add a record into a table:
With SqlDataSource1
.InsertParameters("Name").DefaultValue = fldName.Value
.InsertParameters("Email").DefaultValue = Text1.Value
.InsertParameters("tContent").DefaultValue = taLE.Value
.Insert()
End With
I now realize that I need to get the id (a Unique Identifier that Auto Increments by 1) of the record I just added.
I have the following code running but it only inserts the first char of each param value into the table.For example: first name is john, only j is inserted.
Dim ColParameter(15) As SqlParameter
Dim dal As DAL.SqlDAL = New DAL.SqlDAL
Dim procname As String = "pr_cust_create"
[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 doing a project, uses vb.net as front end, ms sql as back end.my application insert bulk of rows from a datatale to the table in server.it uses dataadpter.update to send all the rows to the server.
View 2 RepliesI have this piece of code wich works perfectly when inserting records into one table using records from another table. My question is that now i need to create another table by using records from 3 other tables (tables are related). Can i use aliases on the column names, like on Oracle SqlPlus? How will be the syntax of the 'INSERT INTO SQL statement?
Dim MyConn As ADODB.Connection
Dim MyRecSet As ADODB.Recordset
Dim tmpSQL As String
MyConn = New ADODB.Connection
[code]....
I have a DataGridView bound to a non-SQL Server database.I need to allow users to edit existing records but under certain circumstances I need to intercept the edit and instead of committing and updating the dataset I need to delete the edited record and re-add it as a new record.I have tried using every event I can think of to do this but haven't managed to get it right. [code] This almost works but sometimes completely messes up and re-adds rows twice and all kinds of other bad side effects.
View 9 RepliesI have a DataGridView bound to a non-SQL Server database. I need to allow users to edit existing records but under certain circumstances I need to intercept the edit and instead of committing and updating the dataset I need to delete the edited record and re-add it as a new record. I have tried using every event I can think of to do this but haven't managed to get it right.
The closest I have got is with this:
Dim theRow As DataGridViewRow
Private loading As Boolean = True
Private rowLeft As Boolean = False
Private WithEvents cm As CurrencyManager
Dim copiedRow0 As String
[Code] .....
This almost works but sometimes completely messes up and re-adds rows twice and all kinds of other bad side effects. It seems a really simple thing to want to do but I just can't get it working.
I am using VB.net (FormView and ObjectDataSource) and Sql Server 2005.
I want to get last inserted @@identity in table on FormView1_ItemInserted
Protected Sub FormView1_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs) Handles FormView1.ItemInserted
End Sub My issue is that I want to redirect my FormView to readonly mode after FormView1_ItemInserted but for that I need to show the inserted record in readonly mode and that is only possible if I get my last inserted @@identity.
