I have two tables and the form contains a text box so I need to add rows of Table 1 to Table 2 and taking the value in the text box for each row is added to Table 2.i have insert syntax but it is need to modification:
INSERT INTO table2(column3,column4)
SELECT column1 + @parameter FROM table1 WHERE column2=true
table1: column1 column2
[code]....
I have two tables and the form contains a text box so I need to add rows of Table 1 to Table 2 and taking the value in the text box for each row is added to Table 2.[code]...
View 9 RepliesI have two tables and the form contains a text box so I need to add rows of Table 1 to Table 2 and taking the value in the text box for each row is added to Table 2.
i have insert syntax but it is need to modification:
INSERT INTO table2(column3,column4)
SELECT column1 + @parameter
FROM table1
[Code]......
Is it safe to place the code of INSERT Sql command inside my While End While
[code]...
User need to select their prefferable data to show in report. What i did is i have a clear command first to delete the temporary table. The temporary table is basically a table to stored user selection parameter data. After the clear command, i have
a insert command to insert user selection data into the temporary table. What happened now is when i run the program exe, first run of the report is work fined, but not the second and the following times of execution. It will return null or blank report. The weird thing is when i execute it from development environment, it seem like the report is able to pick up user selection parameter and run the report for the first times and the subsequent execution.
One of the things that I think is really cool about VB.NET is how built-in functions and subs have extra help text in their ToolTips like "Expression: String expression to search for replace string." as well as the usual "Replace(...parameters...) as string" text. So are the pop up boxes with things like "CompareMethod.Binary" or "CompareMethod.Text." And finally I like how some functions and subs have different sets of parameters for the same routine. For example, New FileStream() starts with either a path (string) parameter or handle parameter, but none of the 15 sets of parameters contain both path and handle parameters. Is there a way that I can set up the classes and functions I write to use these things or do they only work with built in classes and functions? If there is a way, what are the proper names for them so I can look them up in the VS/VB documentation? I would be happy enough if someone would give me an example of them, but it would be nicer if I could go through the documentation and find out if there are other cool things that are related or near by.
View 3 Repliescould someone tell me what i am doing wrong in this codeProtected Sub insert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Insert.Click
[Code]...
i need to run a dos command with parameter and write out on text file from my win form
Dim a As String = Shell("D:docmd5.exe *.* > 'F:projectdocinfo.txt")
and
Dim a As String = Shell("D:docmd5.exe text.txt > 'F:projectdocinfo.txt")
but its not working i have vb 10
Is it possible to execute a command like this?
select * from tbl where col1=somefunction(@param1)
or will the parameter throw off the function? I have been unsuccessful in getting the command to work so far.
Please let me know if this needs any further explanation
I want to create a shortcut that do following:Link back to "my application"with command line parameter so that it will not do anything.
View 4 RepliesI am developing vb.net windows application. I am trying to insert data with insert command.I am getting the insert data as long as the application is running. But when i close the application and reopen again the inserted data was not in the access database and i am getting no result. what is the problem, is it in code? i am using like
strsql=" Insert into table(col1,col2) values(val1,val2)"
selectCommand as new oledb.command(strsql,strConn)
selectCommand.ExecuteNonQuery()
Not inserting in the database but showing in application. how?
I am firing up a cmd console from my .net app with some parameters, is there a parameter to specify that the cmd console is not visible?
-- Edit - Adding Code I know this isn't the standard way of starting a process in .Net, but it is being run from a Silverlight Client.
Dynamic cmd = AutomationFactory.CreateObject("WScript.Shell");
cmd.Run("C:WindowsSystem32cmd.exe /c *myargs*")
i want to pass this parameter to my sql command
[Code]...
What function in VB.NET simply takes a string parameter and runs a command? It would work just like the OK button in the Start -> Run dialog.[code]
View 3 Replieswith vb 2008 express is there any EOF & BOF properties if not is there any alternative for the same any sample line of code (2) what is the place holder for MySQL parameter with command object?
View 1 RepliesI am working on a Asp.net based project and my requiremnent is to generate a PARTNO with the combination of MaterialType+ProductID and - 4digit random number?
NOTE: ProductID is Primary key and also set it to output parameter for example If material type is 500 and product ID generated 55 and random no generated 5434, then part no become 555-5434 how could I store partno in same table, I am somewhat trying like that
Connection.Open()
Dim trn As SqlClient.SqlTransaction
trn = Connection.BeginTransaction
Using trn
[code]....
I want to UPDATE query instead INSERT INTO using this code?
Dim cmd As New OleDbCommand("INSERT INTO tblPurchase_Order ([Order_Id],[Supplier_Id],[Address],[Project_Id],[dtpDate],[Material_Id],[Material_Name],[Unit],[Quantity],[Unit_Price],[Amount]) VALUES (@Order_Id,@Supplier_Id,@Address,@Project_Id,@dtpDate,@Material_Id,@Material_Name,@Unit,@Quantity,@Unit_Price,@Amount)", conn)
[code].....
I created a report viewer app that takes a command line parameter, the report filename, and opens the report. I also created a ODBC File DSN that I want to redistribute. However, currently, the DSN needs to reside in 'c:program filescommon filesodbcdata sources'. Is there a way for the report to look for the DSN in the application directory? Also, what components besides .NET 3.5 are required to redistribute the report and report viewer app?
View 1 RepliesI'm trying to create a parameter insert statement for an SQL server Db. when i've used similar code for an access db, it works fine. can anyone tell me what i'm doing wrong? Public Sub SubmitMyData(ByRef getArray)
Dim MySQL As String = "INSERT INTO WebSurveyResults(Q1,Q2,Q3,Q4,Q5,Q6) VALUES
Dim myConnString As String = "Data Source=jasonwucinski1.db.1111111.hostedresource.com; " _
& "Initial Catalog=jasonwucinski1; User ID=jasonwucinski1; Password='myPW';"
Dim thisConnection As New System.Data.SqlClient.SqlConnection(myConnString)
[Code]...
How can I insert a negative number into a byte parameter?
Something like this:
Dim b As Byte = -111
Here is some code I use for creating a table and the data adpater for it...
vb
Dim cmdString As String = String.Format("CREATE TABLE {0} (" & _
"EventID INT IDENTITY(1,1) NOT NULL, " & _
[code]....
I seem to be banging my head with this INSERT INTO command:
[Code]...
when I try to run the code. Can anyone see anything wrong with what I'm doing as I don't fully understand why it's throwing this exception.
I am trying to use the insert into command in VB.net and having cod error on the following code.
"INSERT INTO xyz.TblPayHistory (prac_no, Num_pats,PayAmt,Period_startdate,Period_enddate,PayRate,PayMethod,PayAccNo,PaySortCode,PayDate,Type)"
"SELECT prac_no,
[CODE]...
so I have this code here which is *supposed* to save the contents of the user details form into an SQL database. However, when I run the program, always gives the following error:
[Code]...
I am trying to do an insert into a table called Policy. I keep getting an error that says parameter @Split has no default value. To try and resolve the problem, I set the default value of the split field (of type text) in the Policy table to "0" in Access 2007. I am passing in the value of a string "0" into the parameter before the insert statement executes.
Dim connection As OleDbConnection = PaulMeadeInsuranceDB.GetConnection
Dim insertcommand2 As New OleDbCommand(insertStatement2, connection)
connection.Open()
[Code].....
I'm running VB 2008 express, I'm connected to a MS access 2007 database. I get the following error
Syntax error in INSERT INTO statement.My code is as follows
Imports System.Data Imports System.Data.OleDb Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code]...
i am using the following query as the insert command for a dataset linked with a DGV,
INSERT INTO [Template]
(GrpId, GrpName, GrpNum, Code, Name)
SELECT (Select t0.GrpId from Header t0 where t0.GrpName = @grpName ) AS GrpId,
@GrpName AS GrpName,
[Code]...
i'm still developing my project bout evaluation of employees. I'm using the code below,I want to multiply the values of the two specific row/column inside my datatable and then insert the product in the KPIGRDEQUI field in the KWEEKDTL table.Is it possible to be done?
[Code]...
the codes run with no errors, but the data is not save in the sql server table event though the codes run.Dim connection As New SqlClient.SqlConnection
connection.ConnectionString = ("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DB.mdf;Integrated Security=True;User Instance=True")
connection.Open()
Dim command As New SqlClient.SqlCommand
command.CommandText = "INSERT INTO [studentsummary] (sum1,sum2) VALUES (@sum1,@sum2)"
command.Connection = connection
[Code]...
how to write the AT command in the serial port. I have connect a modem to the comport. I have this code that I get from my teacher. But it does not show any AT command in the code
Private WithEvents serialPort As New IO.Ports.SerialPort
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'---display all the serial port names on the local computer---
[code]....