I'm creating a web project for one of my uni modules using Visual studio 2010. I'm using asp.net membership and have all of my sql-server tables set up correctly (I'm pretty sure).I have a form that I have created myself that inserts into the database using sqlDataSource.insert(). I had some problems initially with not being able to insert any data into the table at all, but I have cleared that up.My problem now is that I need to insert the currently logged in user's userID into one of the columns of the table. But every time I hit the submit button, I am told I cannot insert null values in the userID column.
I can retrieve the userID using this snippet:
Dim userID As String
Dim memUser As MembershipUser
Using the following code, a user inputs a date into a textbox control and then clicks a button. A new record is created in table [rms_Report] and then I retrieve the ID of the record that was just added. I pass this ID onto page "CreateReport.aspx" via a response.redirect and query string.
I need to retrieve the UserId of the currently logged in user and insert it into table [rms_Report]. I need this to occur after the new record is inserted, but obviously before the response.redirect. I know how to retrieve the UserId, but I'm not sure how to incorporate into the other code.
I've spent a couple of hours trying to find the answer to this, and although there are tutorials all over the 'net none of them work for me (or I am too n00b to understand what they're telling me.I'm creating users in asp.net using Membership. What I want to do is add the generated UserId to a column in a custom table I've created, to link the stuff in the custom table with the user created in aspnet_Users.
I'm calling a GUID with a system function and trying to insert it into a database as a primary key. i'm using vb 2010 .net framework with sqlce server making my datatables. the column is AutoNumber which i set up to be a uniqueidentifier. the length is not adjustable and set at 16. i got all kinds of not parsing query errors. i've edited the insert statement a bunch trying to figure this out. i've went so far as changing the table schema of AutoNumber to be just a nvarchar with length of 100. it's something to do with how i'm inserting the GUID. in the code below i'm converting it into a string then inserting it into my table. is this wrong?? i've tried finding other ways of doing it but it's a little confusing. everything else in the code works perfectly it's just this part that is keeping me from completion.[code]...
I have one table here with a list of UserIDs, Users, and ClientCodes.Each user can be assigned a client code to view that client's data else where.Right now I have to change it for everyone via SQL Server and actually going into the table manually, but I'm trying to make a simple little program that will let the user change it themselves.All I need is a textbox that pulls the user based on a certain UserID from the table, and a drop down list that will not only show the current ClientCode they're set to, but allow me to change it and save that change to the table in the database.What's the best way to go about this? I tried using the wizards but I guess that's not the best way to go about it.I have it displaying the correct user and their current ClientCode but that's about it.
im workin on a task that will get the current computers Default Gatway, So i chose the easiest option, using the Registry, in most cases i find this with no problem at all, here's the code im using right now,
Public sHost As String = My.Computer.Registry.GetValue _ ("HKEY_LOCAL_MACHINESYSTEMControlSet001servicesTcpipParametersInterfaces THE GUID NEEDED HERE ", "DhcpServer", Nothing)
Which works fine, if i put My GUID in where i've stated in above code, I get the right value ect..., no what i was woundering is how would i get the program to preform this task on another Computer as their GUID will be diffrent, if their away i can do this with simplicity?
I do this in Oracle databases just in a snap, but now I have to do it in VB using ADODB and I don't know how to do it.
I have two Access 2007 tables. Table A contains: Col1 (text), Col2 (text), Col3(date), Col4(amount), Col5(text)
Table B contains Col1(date), Col2(amount) What I need to do is to insert into table B the records of table A (col4 summed) grouped by date of table A. The date is a variable contained in a text box so it cannot be hardcoded into the SQL statement.
In an application i am developing, I have to put an entire table in a cell of different table using vb.net . The process of creating a table is completely automated as per the input.
and what I'd like to do is when users edit something on this form that they post the changes to a table called exceptionsedit which is not part of that dataset. What I don't know how to do is to how to insert those edits to the exceptionsedit table.
I have a csv file that I need to import into a sql table, this portion is working correctly. The code grabs the data, displays it in a datagridview and then imports it into the sql table. What I need to do is add an additional field that will automatically number itself by the amount of rows inserted at that perticaular moment. Let me explain a little clearer. The data I grab from the csv file is a day snapshot broken down to the hour. So lets use todays date 6/28/2010 will be broken down in the csv file like this:
i am using visual studio 2005 and database sql server 2000. i want to read table of database and readed data insert in temporary table again update that inserted record.
I am currently learning .net and am building my first real website using .net.I was just wondering if people considered it ok to use the generated membership UserId in the query string? and also to use this as a foreign key in a database to link relevant information to this user?
I want to count length of a userId and change the string to that many asterisks. I also want to take the account number and replace all characters except the last 4 XXXX.
Public con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\KarthI\sample\db1\WindowsApplication1\WindowsApplication1\bin\Debug\phm_pharmacy.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True") con.Open()
[code]....
I am using this code to insert four values into the table quotation_t11...When i run this code it shows the msgbox that the Data is added successfully The problem is i cant find the data what i inserted in that table..I can able to retrieve the values from the tables but i cant able insert?
City table has 4 coloumns: CityID, CityName, Pincode, DescriptionI have placed Button1 on Form and want to add some data to City table by clicking this button. When I click this button, i get an error msg like Connection Property has not been initialised.
I am trying to create an application where using a vb.net form u can enter data into sql tabel (I am using visual studio 2005 and sql server 2005). I am only able to get data from sql table using "data source configuration wizard".
Private Sub FrmImport_DragEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles Me.DragEnter ' e.Effect = DragDropEffects.Link
[Code]....
when i click button to insert image to table he give me this message "Empty path name is not legal."
i am now want to insert data(fault and visual(bold)) into the table. After done the calculation, i would like to insert the fault and visual value into my table summary. My field name in table summary for fault(fo_ratio) and visual(visual) So below is my coding. How can i save into the database after done the calculation.[code...]
I have a number of different data bases (all local Access.mdb), each with the same stucture but different data (this data will not be changed it is only the basis for the program - only one database will be used at any one session). Is there a simple way of using a single Dataset to access different Data bases depending on a user selection? - In VB6 the basic query looked something like this;Database A.Execute "INSERT INTO TableA SELECT * FROM " & TableB & " IN '" Database B at location "';"
i'm a beginner in vb.net.i have a form with two sections.header part and detail part.header part contains some text boxes and detail part includes datagridview.when i enter the values to datagridview while runtime ,i want to insert the datagridview values to sql table.when i insert the first row of datagridview will save to sql table but another rows willn't save to sql table and showing an error"Procedure or function Insert_Sales_Detail has too many arguments specified".how can i save all rows in to sql table?
