Is there a way to include a person's logged in user name in an insert statement? Like, how could I detect which user is signed in, and then insert that username into my table in my database?
View 12 RepliesMy program connects to a Mysql Database. It allow registration and login. I Need this to update the "BankACCid" column(?) in Mysql for the current logged in user.This is the code that doesn't work
MySql Connection
Dim conn As MySqlConnection
conn = New MySqlConnection()
[code]....
here is my code so far:
Public Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click
Dim i As Integer
[Code].....
when i click the button, i get a error message saying "Syntax error in INSERT INTO statement". as far as i can tell, i have everything i need to insert a new row into the database, and i dont see why this problem is occuring.
item(0) is an autonumber key field, so that should make a new record by itself, and i have declared the input textboxes as the data() array
I am practicing abit with For Loops. My code works fine which i am very happy about. I have now moved on to inserting an IF statement. I want the IF statement to check if my textbox1 and textbox2 are blank and if they are to notify the user that they must insert a value. I thought this would be quite easy to do however i think i was again ignorant to the coding! See below.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim answer As Integer
[CODE]...
I want to concentrate on the IF statement only as the For loop is working just as it should. When i run the program and leave both textboxes blank and hit the button i receive an error saying 'Conversion from string "" to type 'Integer' is not valid.'
I am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2003.
The code seems to stop executing at the statement cmdJetDB.ExecuteNonQuery()
I am using the following code:
Dim conn1 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:Sample.mdb")
Dim conn2 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:db2.mdb")
conn1.Open()
conn2.Open()
[Code]...
Question: What is it that I am not doing. I opened both connections, stated my two SQL statements, yet it is still not working. I really need to get this application working. Please Help.........
I am using a MS Access database as the backend of my VB.NET application. I am entering users details into the database using an INSERT INTO statement:
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";")
cn.Open()cmd = New OleDbCommand("INSERT INTO blah blah blah...", cn)
dr = cmd.ExecuteReader
[Code]...
database - Checking if INSERT INTO statement was successful
View 11 RepliesI am trying to execute a command that inserts a row but I keep getting the error "Database error Syntax error in INSERT INTO statement." What am I doing incorrectly? I know for Ole Db refers to the parameters by sequence and I've done in the correct sequence. I left out the ID since it is auto generated could that be causing a problem?
[Code]...
I have an access database that I am writing a SQL query to insert data from my datagrid into a table that I created.I get an error that I have tracked down to field types that I have created as a DOUBLE. Here is my SQL Query for creating the table -
[code]
("CREATE TABLE [SSR Shts_" & FullName & "]([ID] AUTOINCREMENT,[Division] Text(255),[Bid Reference] Text(255)," & _
[code].....
How will I insert the output of my DataGridView to another table in the database? I have 4 Columns. The First and Second Columns are Check Boxes. The Third is The Stockholder Code. The Forth is The Stockholder Name. What I want to happen is, my selected records(The Stockholder Code, The Stockholder Name ) via check boxes will be inserted in my database.
Here's what I've done so far:
Try
For Each row As DataGridViewRow In DataGridView1.Rows
Dim cell As DataGridViewCheckBoxCell = CType(row.Cells("checkboxchild"), DataGridViewCheckBoxCell)
[Code].....
con.Open()
sql = "select * from songs"
da = New OleDb.OleDbDataAdapter(sql, con)
[code]...
it says syntax error in INSERT INTO
I developed a simple Access database and I create a VB .Net user interface. can't INSERT data into the Table here's my sample code..
Dim con As New OleDbConnection
Dim cmd As New OleDbCommand
Dim da As New OleDbDataAdapter
[code].....
solve the syntex error in INSERT INTO Statement I am using access 2003 as Database. Below is my code. tried all I know but failed.
[Code]...
I'm running an application under an account that is not the account logged-on to the PC.
Within the application I need check if the logged-on user is a member of the Administrators group. Below is the code I'm using. From what I've read, WindowsIdentity.GetCurrent() should return an object associated with the logged-on user. It doesn't, it returns the same information as the call to System.Threading.Thread.CurrentPrincipal. Which is the information associated to the ID running the application, not the logged-on user.
[Code]...
I cannot seem to figure out why VB keep throwing me this exception but here is the code
[Code]...
See
Public Class Form1
Dim sql As String
Dim conn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
[CODE]...
The problem, The INSERT statement works fine in the form load but not in the button click event?
I am using Microsoft visual basic 2010 for a asp.net site using c#.I am using the asp.net configuration for user registration. I have a comments form which I want to appear only if a user is logged in.I now there is a toolbox helper thing called Login View which does exactly what I want but as soon as I put a form inside the code won't compile because it cannot find the textbox fields.
I have the following in NewsArticle.aspx:
<asp:LoginView ID="LoginView1" runat="server">
<AnonymousTemplate>
<div class="postcomment">
[code]....
If I take the form out of asp:LoginView it works fine. Inside I get the following:
Error 2 The name 'txtTitle' does not exist in the current context NewsArticle.aspx.cs 59 53 Figmentville
Error 3 The name 'txtComment' does not exist in the current context NewsArticle.aspx.cs 59 68 Figmentville
(I work on VS 2005 with Access Database and C#)
I have my code as follows:
protected void Page_Load(object sender,
System.EventArgs e)
{
[Code]....
The logged-in 'UserId' and 'UserName' is getting displayed correctly, but now how do I use the string 'lmember' in my 'SELECT' statement when I need to display the related information from the table 'aspnet_Users' for the logged-in user? getting the following select statement:
SelectCommand="SELECT * FROM aspnet_Users WHERE (UserName= ????)"
I'm writing software in VB .NET (2005) which uses the Windows user information as login credentials - just the username. I've found Environment.UserName which works for the username (as you would expect).However, I need more information - I need the full name of the user (as shown on the Start Menu). It seems this information is stored... somewhere, as Windows is able to use it for things like permissions on file shares.
View 1 Repliesi have a problem with my project.in one form i have 2 textboxes in one i have displayed the serial number.in the second i want display the current user logged on software.how can i display the current user logged in ????? the code for the serial number is :[code].....
View 2 RepliesI keep a Session variable when the user is logged in. So that when the user click on btnLogout it must clear all my sessions and Log the User out for GOOD!!!
It does clear my sessions but if i click the BACK button in IE right after i logged out then i am still logged in! Meaning it goes back to screen where the user was still logged into.
My code on log out
protected void btnLogout_Click
{
Session.Clear();
Session.Abandon();
[Code]....
Is there maybe an option in code i can do that will disable the user from pressing the BACK button in the Web Browzer?
I need to create a spreadsheet of which kit is assigned to which person, within the company.
We have desktops & laptops, for the purpose of this post, we'll say desktops are named DESKTOP then a random 3 digit number (DESKTOP001, DESKTOP002 etc.) and laptops are named LAPTOP then a random 3 digit number (LAPTOP001, LAPTOP002 etc.)
I'm presuming the best way of checking which user uses each workstation would be to check who last logged in to it. doing this for ALL computers in a certain OU (lets say DESKTOP_OU for desktops and LAPTOP_OU for laptops in this example) (either with VB Script or PowerShell I would presume) and to export it to Excel.
I want to know if its possible to retrieve from a given address (IP) the currently logged on user.
View 5 RepliesI'm trying to get the Alias of the logged in user (Active Directory/LDAP environment/Exchange) .
View 8 Replieswhat i want is when the user inputs the username and password, his/her information will be showed in the textbox located at the mainform which shows the users information like where he live and his occupation. how to show users data in the textbox of another form when he/she logged in. im using vb.net and mssql
View 1 RepliesI have a windows login form, and it checks whether the user name and password match and lets you log in. If I wanted to say pull some information from a dataset later on in the program. How would i pull the data from the specific user that is logged in, rather than all the data from the database.
View 4 RepliesI have a client/server application running in a windows domain environment, the client application is started at log on by a scheduled task using domain admin credentials, i need to be able retrieve the username of the user who logged onto the workstation but all the methods i have tried returns the user that was used to execute the program.I have tried:
Environment.UserName
System.Security.Principal.WindowsIdentity.GetCurrent().Name
Environment.GetEnvironmentVariable("USERNAME")
All of these return the account i used to run the application, not the user who is logged on.
HTML
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles start.Click
Dim folderExists As Boolean
[Code]....
above i have a specific username in the little backup script i have created. in this section of the code, if the user selects this particular chkbox then hits "start" it backs up the above loacation to a "server" H.
how do i code it to automatically pull the username and place it where "godboubs" (aka the username) is?
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsKashifDesktopDesktop itemsvalid.mdb;")
View 2 Replieshow to get the user input in comment textbox and insert into my database and then retrieve the data to output in another webform.
View 3 Replies