I have recently begin updating an old Progam that was classic ASP with SQL Server 2000 to VB.Net and SQL Server 2005.
I am displaying some data in a text box from a SQL Server datatype deci...
I am trying to write a vb.net process to create stored procedures from vss files.
They all contain multiple 'GO' statements in the script.
Everything is great till it hits the 'go' command...
I have a number of rich text boxes in a windows form and I'd like a function that I can call that limits the number of lines that can be input into each rich text box as these details are outp...
Hi all, I have a gridview that allows you to do an update. When the update is performed I perform an INSERT and then an UPDATE. Strange thing is on my INSERT I can only INSERT with values th...
Hello. We would like to send our clients data via email. The content of the email varies widely from customer to customer. The data is stored in various databases.
The requirements are:
1...
Good Day:
I am using VB.NET 2005 with SQL Server 2000. I would like to dynamically create and load the tree view control using the following 2 tables.
Table: NodeParent
ID (Identity Ke...
Hi All,
I am trying to make a program for my class where i have to use a function to make sure the weight i enter is between 0 and 500 and a number. I have made the function and it works, an...
I have a multi select listbox and i would like to select all the selectedvalues of the selected items.
I can get the selected text no probelm but it is the values i need. Can anyone help please.
Hi,
I have Visual Studio 2005 installed and I am in the process of setting users and roles for a WCF web sevice. I had VS 2005 installed but NOT SQL Server Express. I installed SQL ...
Hi experts,
is there a way to gray out items in a checked list box list in visual basic 2005? I have a list of items, but based on results of a query, some of those items need to be unselect...
Hi,
I have a varchar data type field in my SQL table (MS SQL 2005). set to 50 characters, now if i place a value of "bob" when i retrieve the value thru a dataset it is retrieveing the value ...
I am developing with visual basic 2005. I need to know how I can set a simple text box to behave as a masked text box in a way where I would not be able to enter anything "except" numbers. I...
In SQL I can use this statement:
SELECT RTRIM(AWDES1) + ' ' + RTRIM(AWDES2) + ' ' + RTRIM(AWDES3) AS DESCRIPTION, PartNumber, BIN#
FROM Query
WHERE (DESCRIPTION = @SearchDescri...
Using VB.NET, is there a way to do this? I want to open the .DOC to check on the text inside, but I do not want to open a full blown Word Application window.
I am trying to insert a table into a word document, but I can't seem to get the table to insert at the right spot.
the line that reads as
oWord.ActiveDocument.Tables.Add(oWord.ActiveDocume...
Hi,
I am running VS2005 and developing a Windows From using VB. I have
attempted to create a simple grid attached to a table adadpter which is
connected to a MSSQL 2005 database; and fo...
I am developing with visual basic 2005 and need to fill my OleDbDataAdapter so that I can pull data from two access tables related to each other by ClientId.
This is my statement but every ...
HI,
I am trying to Delete Record by DataSet and objectdatasource,
but its saying " There is no row at position 0."
Dont understand why.
Can you please have a look at my simple code and he...
Hi,
I have a datagrid on a page that displays records based on the value selected from a drop down list on the page.
I added a template field to the datagrid and placed a checkbox into t...
I need to convert the following VB6 code in VB.Net. Can someone please help me
I have a problem with VS 2005 where every tool in the Toolbox has the same icon. When I select one, for example a Button, the program create a Button when I drag it to the form. Menahile it ...
Hi all
I have two Questions about CrystalReport
The First Question :
How can I make CrystalReport get Data source Location from the Code (on Form load)?
because if I used wiz...
I am trying to implement a "rowenter" event for my datagridview control. What I need to be able to do is click on a particular row within the grid and for the values that have been entered in...
In my code I am setting the txtTelephone.text textbox to nothing if the record does not contain a number, but it still shows "( ) - ".
HOW DO I get rid of it?
If Not (IsDBNull(DR("Client...
Good Day:
I am using VB.NET 2005 Winforms with SQL Server 2000. I have a combo box called cboParent which gets populated with the following code:
Private Sub LoadParentNodes()
D...
