i know how to use parameters on INSERT, UPDATE and DELETE into sql server.like:
VBNet
updateCMD = "UPDATE table SET somevalue= @valueparam1 WHERE ID = 2"
Adapter.SelectCommand = New SqlCommand(updateCMD)
[code]....
I am working on a desktop application in VB.Net (4.0) There will a lot of SQL scripts which contains a lot of insert queries Currenlty we are running the scripts using SMO (http://msdn.microsoft.com/en-us/library/ms162557.aspx)For performance, we have planned to change the sql scripts to xml file ( instead of insert queries, it will have xml data with a proper xsd defined )Loads xml to dataSet and Using SQL Bulk Copy we are trying to insert to SQL Server.
[Code]...
Parameterizing an SQL IN clause? am using a following procedurehere i use "in clause" for attendancecodeid which accepts inetger value,how i can pass parameters for my "sql procedure in clause" from vb.net,i tried many thing nothing worked for me looking for a solution,
alter procedure MPEX_SP_ActivityException_Select
@startDate date,@endDate date,@AttCode nvarchar(max)
as
[code]....
I have about 4 different tables with the exact same column names. What I would like to do is select the top 4 records out of all of these tables combined ordered by date (as date is one of the columns that they all share).
View 1 RepliesUsing SQL Server 2005 and VB.Net..[code]When I try to run the above query it was showing error.How to execute a stored procedure with conditions?
View 4 RepliesI just got into VB 2010 with SQL 2008 Server Report. I was able to create a report as my wish and it's vieable via direct url (URL). But I want to pass login Information and Selection parameters to the report. But I don't want to pass them thru URL, So I want to load them from the application (winform) and launch the report in iexplorer.
View 1 RepliesI'm trying to execute CREATE USER with a given username (via sql parameter)
exec sp_executesql N'CREATE USER @LoginName
FOR LOGIN @LoginName;',
N'@LoginName varchar(5)', @LoginName='myuser'
Heres the code thats generating the above:
Dim myCommand As SqlCommand = New SqlCommand("CREATE USER @LoginName
FOR LOGIN @LoginName;",
ClassDatabaseConnection.CustomInstance)
[code].....
I get and error:Incorrect syntax near '@LoginName'.I think this is due to the parameters being passed as VarChar causing 'MyUser' rather than MyUser Can I not do this with sql parameters?
The report sits on the Report Server and requires ONE parameter "GROUPNAME". my code gives me a cast error when I try to set the parameters.
Imports Microsoft.Reporting.webforms
Partial Public Class _Default
Inherits System.Web.UI.Page
[code]....
I want both the client and server to write and read resp. at a constant rate (which can be configured on the GUI of the client) to the buffer.I am able to send from the client at 150 bytes per packet Now, I should be able to read also at 150 bytes per packet on the server too Since, both are connected through a socket, can we retrieve the socket params (set on the client size, like 150 here) from the server end, using the tcpServer object.Or is it must to send an initial setup packet which tells about these client params and so accordingly the server can continue?
View 1 RepliesI'm using a stored procedure to updateinsert data into a table using MERGE. One of the items being inserted is a VarBinary file. Now if I wish to add a new file it's just a case of using ReadAllBytes as below, to remove the file I pass DBNull. Now what if other fields are being updated but the file is not being changed? I want the field to remain untouched unless I'm replacing the file or deleting it as above. I cannot add the file via the parameter again as it may only exist in the database, unless I read it first and write it back which seems pointless. [Code]
View 1 Repliesi can write the xml i need which looks like:[code]This shows me the value fine! when i change the attribute name to another field like: MessageBox. Show((XMLItem.Attributes("postingHiddenFieldsCount").InnerText))i get a null reference error,
View 9 RepliesI'm getting this error when try do a simple task of selecting a tab in a thread. What does it mean and how do you solve it? [Code]
View 1 RepliesThis is another question on my who wants to be a millionaire game.I have 15 questions per game, when i select question 1 , it displays the question in the textbox, how do i tell vb that if "A" (label1) is selected then msgbox "Final answer ?"
i know i can do it on label1 click event , but i want the results for this question only.
Heres what i tried: Private Sub question1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles question1.Click
[Code]...
I am trying to upload a file to Mainframe machine from my VB.net application. I am getting the following error.The remote server returned an error: (501) Syntax error in parameters or arguments
[code]...
i have a button and what i select i want to be underlined. is it possible to do it?
View 11 RepliesI need to select all the comboboxes on a form with a for each loop. I have about 19 comboboxes and I need to select each one. I tried to do
for each box as combobox in me.controls
But that gave me an error and i now tried this:
for each box as control in me.controls
if box.name.contains("ComboBox") then
...
end if
next
That selected only the comboboxes but the problem is i need to access some data that is specific to comboboxes (aka the selected item(s), if its blank) but those properties are not present since "box" is a control, not a combo box.
i have 2 labels that are 1 for minimum damage and the 2nd for maximum damage,how do i make it so if when a person clicks a button it deals damage between the 2 [code]so if i press the button it were to deal (subtract) damage in between the 2 numbers. from a label box (opponent health)
View 16 RepliesI am pretty familiar with how to use the webbrowser control. I know how to autofill forms using the getelementbyid code but I'm having a problem selecting from drop down menus.
Here is the html source
<select name="birthday_mon">
<option value="0">---</option>
<option value="1">January</option>
[Code].....
I am placing 2 of these on my form and want to do the following:
1. When the control is not Focused and the user clicks inside the control, I want to highlight all text within the control. I expect to use SelectAll() to accomplish this.
2. When the control IS Focused and the user clicks inside the control, I want standard actions to occur; i.e., the user can click-and-drag to highlight, double-click to highlight,
3. When the user leaves the control (clicks on something elsle), if the control is empty, I want to populate it with pre-defined text. If it's not empty, leave text as-is.
I'm having problems, though, with figuring out #1 and #3. I have tried Enter/Leave, GotFocus/LostFocus to no avail. With Enter/Leave, the text will highlight the first time a user enters the control, but I can't seem to get the program to think the user has "left" the control. That is, the "Enter" code will not fire again.
I also thought about using the Click event, but I don't want the SelectAll() code to fire for EVERY click in the TextBox controls.
I'm writing a query to select all records that has any part of parameter. I have one table called Employees. Some people have name like this: John David Clark If the parameter is
[Code]....
I should be able to get result back as long as there's a match in the parameters. If I use Function Contains (q.FirstName & " " & q.LastName).Contains(employeeName), I will not get any result back if employeeName is "John Clark" Function Contains looks only for next words from left to right. It doesn't match a single word at a time. So that's why I used this in the Linq to SQL:
[Code]....
[Code]...
I'm doing an application where I open a specific process. And after opening that process I need to send data to him like username and password.
[Code]...
how to move a textbox or any control by selecting its borders like in ms publisher 2007 and creating an application like publisher
View 3 RepliesI have a typical data entry form to show one Customer. All textboxes, controls, etc. are bound to a BindingSource.
Clicking a button, I pop up another form with a DataGrid to show all Customers in a table, this way:
VB
Sub btn_Click
Dim frmPopUp As New frmSearch
frmPopUp.BindingSource1.DataSource = Me.BindingSource1
[Code].....
How can I populate the fields in Form1 selecting a row of the grid in frmSearch?
What I need, is to synchronize the databindings (I think).
I'm selecting a customer from a listbox of surnames...I need to address to display, and the date arrived back...Can't get anything to go into the textboxes, if dr.hasrows is showing up as none I think... not sure how to go about remedey"ing" it though...
Listbox
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged
Dim ConnectionString As String
[code]....
Heres the code im using to select images from a directory , i also have a timer delay between each image , but my problem is when i start my app , it start by selectind image 1 (Images are numbered 1-15) but i want to select the images randomly ?
Private Declare Auto Function SystemParametersInfo Lib "user32.dll" (ByVal uAction As Integer, ByVal uParam As Integer, ByVal lpvParam As String, ByVal fuWinIni As Integer) As Integer
[code].....
I posted a while ago about having issues with a database, and selecting a value from the database. I was told that there were things missing from my code, and I've not gone back and added the things I was advised to. Now, my code seems to be working more, but outputting the wrong value.
[Code]...
I am getting error [07002] the # binded parameters < the # of parameters makers, i checked both parameters were perfect even though i am getting this error here is my code
[Code]...
I want to put a persons National Insurance Number into a label but I want to put *** in place of the first 5 characters and then display the last 3 characters as normally.
View 1 RepliesI'm trying to select a 'Username' value from a table called 'tblUsers' where the 'UserID' is 1 and assign it to the 'Text' property of a field. The SQL command is fine, but I don't know how to assign the value to the file. I've changed the SQL command to select the value I want. I just don't know how to assign it to a field:
'Use these import statements, so you don't have to fully qualify the Oledb Object names:
Imports System.Data.OleDb
Imports System.Data
Public Class Register
Function Register()
[Code] .....
I have a TreeView that I am using for display purposes only. I don't want the user to be able to select any of the nodes. Setting the enabled property of the form to False doesn't suffice since it changes the entire look of the nodes.
I tried canceling the select action in the BeforeExpand event. It kind of works. It selects, then de-selects the item. I'm going to play around with other events to see