New to using SQL and I am having trouble accomplishing something that I figured would be simple.I am trying to create and INSERT that will insert the MAX() value from the first column in one table to the first column in another table while the rest of the columns will be filled with parameters.
I have tried switching my code around to see if I just had the syntax wrong but I've had no luck and I'm not even sure what I'm trying to do is possible (at least in a single INSERT).Here is what I have at the moment:
INSERT INTO [Table2] VALUES(SELECT(Number FROM [Table1] WHERE Max(Number)), @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10)
I need to insert data in a new column ,first I use select and do some calculations on the data,then I want this data to be inserted to the database in anew column I used Insert query but no data inserted
[ Dim sql, sql2, var As String Using conn As New System.Data.OleDb.OleDbConnection conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\AymAN\Documents\Database13.accdb"
I am displaying the data in the datagidview and wanted to select all the data using the checked box. I can only select one by one but not the select all.
I'm developing a piece of a system that basically migrates data from one set of tables to another set. Everything works fine, but I've decided to employ transactions instead of just failing on things that are partially completed. (That is, if some exception occurs, I want to rollback instead of having partial data migrated.)
I have a service (in the 3-tier architecture way, not web) which begins a transaction on the data access layer. The data context is shared in the data access class which contains many methods. Those methods use various LINQ-to-SQL techniques to update/insert/delete. All the LINQ-to-SQL "selects" are within CompiledQueries. [code]...
There are plenty of SELECT (...) VALUES (...) statements and Parameters phrases to go with the VALUES. Those appear unhelpful to me as I have no form fields or datagrids and will be working with all the rows in a DataTable in a DataSet. Once started, this application will run to completion, writing as few as 10000 rows or as many as 250000 rows
My Task is to write out the contents of each specified DataColumn in the DataTable, one DataColumn at a time. The insert will also include the key columns and use the datetimestamp of the records as a criterion. Nulls in the specified columns are included.
My source is a DataTable, my target for the Insert is a "tall-skinny" table in an Access database. There is a smaller DataTable that is related to the source DataTable, if I was writing from within the AccDB I would use Joins. I have created a DataRelation, but have no idea how to use it in this context..
I have tried many different SQL statements but they all fail on Select. Here are snippets of the code:
'now, instantiate the specified DataTable from among the DataTables filled above strDDTableNm = CStr(rsDDTblNms.Fields("Table_Name").Value) Dim dtSrcTable As DataTable
I've just switched from classic ASP to .net and I always used the following to SELECT, INSERT, UPDATE and DELETE from my MySQL databases:
' Create db connection Function dbConn() Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "driver=x;Server=x;Port=x;Option=x;Database=x;Uid=x;Pwd=x"
I am trying to do simple insert, update, delete, select statements within VB .NET to access a MS Access database. I have tried all kinds of solutions offered on the web and while the code seems to work, no rows are inserted. Also, I have tried, unsuccessfully, to use the Try/Catch to see if there's an error with no success. I have attached the versions of VB .Net and MS Access I am using: Here's the code:
what i'm trying to do is to select some csv files and insert them into datagrid view but the problem now i can't manage to perform a find and replace ,and here's the code
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click For RowsCount = 0 To DataGridView1.Rows.Count - 2 For Each dgvr As DataGridViewRow In DataGridView1.Rows
[code]....
but isn't working it gives me " null reference exception was unhandled "
[code] Public Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand If e.CommandName = "Select" Then
I am working asp.net vb application. I have set of values to be inserted to Database.But their some fields are optional to be filled. I need to check the textbox empty. If empty I should not enter the value to Database. How to work on this?
I am making a database project in vb.net. I have one table which has 9 columns. I am using ms access database as server side. my question is that, how to insert rows with values in a table.
Having abit of trouble with inserting values that i have in my form into my sql database.Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to insert 3 values into my database under column names that i already have.
The table name is Trnsaction. it has the following coloumn names: Trnsaction_id Member_id Album_id issue_date return_date members_date days_delayed fine The last 3 coloumns(members_date ,days_delayed ,fine) are values i wish to add to my database. The values days_delayed and fine only pop up when i have selected my date (thats members_date) form the datepicker and selected the calculate button
I'm using some HTML with vb.NET and would like to know if it's possible to pass data back and forth. I need the value of an option in a drop down box passed down:
I have a select box call 'ToLB' which takes in value items from another select box. I need to extract those selected values from 'ToLB' and print it on a label, this is how I do it but apparently it's not working as in no error message but nothing was printed to the label.[code]
I have a javascript function below to move from select multiple box A which is populated from database to another multiple select box B, in the event of a postback my values in B which are moved over from A got lost. Initially I thought because I included a "runat="server"" tag for server side actions but apparently it's not the case. I read about Form.Request but ain't have a clue how to go about it. I just need to retain those values in multiple select box B.[code]...
We have a listbox in our MVC View and the user has the ability to highlight multiple values. I'd like to be able to save those selected values(if possible?) as a comma delimited cell value in our '08 SQL Database.
The image below shows what I am attempting to explain. Note the selection in the LISTBOX
This is where we save the passed in values from the Positionnumber DDL (Listbox w/ mulitple highlights).
> <HttpPost()> > Function Edit(wsmonitor As WSMonitor, ByVal vbpositionnumberDDL As Integer, ByVal PassedCounty As Integer, ByVal > MonitorTypeDDL As String) As ActionResult
I am creating a page in which I need to show a drop down List. From this drop down List a user can select multiple values. I know I could use a check box list like:
but if there are more than 50 or so values then that will consume a lot of space on the page and will look odd. So kindly tell me how can I select multiple values from drop down list or if there any alternatives so that I can select multiple values and show many records on a minimum space but not a grid?
Here is my select stament to store values when username and password and check boxes are check
com = New OleDbCommand("INSERT INTO Users (UserName,Password,IsAdmin,Read,Write,Change,REMOVE,User_st) VALUES ('" & txtusername.Text & "','" & txtpassword.Text & "'," & CInt(chkIsadmin.Checked) &
[Code]...
My problem is this wehen i add new record to my db it saves values like this the value of read column is as follows read = 1 when check box is checked and read = 0 when check box is checked but i want to save true or false instead 1 and 0 how to achieve this using vb.net and my db is Oracle.
