Search:
Type: Posts; User: gtrahern
Search:
Search took 0.03 seconds.
-
-
I'm building a sql server 2008 r2 database to store blob data for an imaging system. This link (http://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx) recommends using the filestream...
-
i have a list(of string) i want to sort although I want to sort by the last 3 characters of each string, which will be numeric. example:
dim listtest as new list(of string)
listtest.add("test...
-
thanks for taking the time to answer Bill, I got what I needed.
-
I have a table that tracks changes to fields in other tables:
CREATE TABLE #TempTable1(
REN char(16),
FieldNumber char(3),
FieldDescription varchar(40),
MaintenanceDate date,...
-
Wow, drastically faster and works correctly now. Thanks DataMiser, sometimes you just need a second pair of eyes on things to see something simple like that. Also added the close methods, thanks for...
-
I have a large tab delimited text file to process each day (usually around 25 mb) consisting of usually well over 100,000 lines. The file is actually made up of about 9 or 10 reports separated by...
-
datagridviewcolumn.headertext=string
-
figured out the problem, final code:
CREATE PROCEDURE dbo.ImportAccounts
AS
CREATE TABLE TempTable
(Account varchar(9),
ShortTitle varchar(36),
-
The create table and bulk insert are working correctly. By the way, I did have to change the reference to the text file to include the entire path. It is the merge section that is showing multiple...
-
I'm using SQL Server 2008 R2 Express Edition and am trying to create a stored procedure that will import a text file to a temporary table, then merge that table with an existing table simply updating...
-
Is the exe and db in the same folder?
-
Thanks Gary, I appreciate it.
-
No, I don't even really need the system, just want a challenge for learning purposes and want to know what subjects to focus on when researching and practicing.
-
I am interested in building an intranet document management system to be used from Internet Explorer using ASP.net, VB.net, and MS SQL Server but have no experience in doing a project like this....
-
Is the selectnextcontrol function what you want? Signature is below.
Public Function SelectNextControl(ByVal ctl As System.Windows.Forms.Control, ByVal forward As Boolean, ByVal tabStopOnly As...
-
from the publish tab, click on application files and make sure your db is included
-
I have now decided that I should just be able to do it like below although, I receive an error that says the value for column 'DateAddedToDB' in table 'Transactions' is DBNull. Can someone tell me...
-
I have a dataset and am committing changes to the database using tableadaptermanager.updateall. My datatable has a column called DateAddedToDB. When saving to the db, some records will have this...
-
-
I noticed that autogeneratecolumns was not listed as a property in my designer for the datagridview but the line you gave, equal to false is in the designer file for the form. Can it be set at design...
-
It worked, thanks ram2curious, although I'd like to understand why that was necessary? Anyone know?
-
In my datagridview i have changed the ColumnHeadersDefaultCellStyle to be bold font. It looks exactly how I want it in design time. At run time, the column headers are regular and are not bold. It's...
-
Sounds like you need to use the form.showintaskbar property
-
For fun you could have two input boxes, one that asks for the beginning integer, and another that asks for the second integer. If this wasn't homework where you have to follow certain guidelines, you...
-
Me.DateTimePicker1.Value = Me.DateTimePicker1.Value.AddMonths(1)
-
Thank you Gary, I didn't even think about that...obviously. I'm using IE8 and deleting all the temp files worked perfect. A lot of time was wasted trying to figure that out.
-
I'm just getting started in ASP.net and am building a site. I made a change to a style sheet to change the color of the links in my menu control on my master page. It looks great in the designer and...
-
Maybe something like this?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim i1 As Integer
Dim i2 As Integer
...
-
total = (bill * ((tip/100)+1))
Also, I would recommend using decimal data type instead of double.
-
looking at the documentation (found here), it appears that the largechange property datatype is integer, so .5 wouldn't be acceptable.
For your 2nd question, I would just use a label control and...
-
I know it's not cool to change the users input but here is what I did:
Shared Function ValidateTextLength(ByVal TB As TextBox) As Boolean
If TB.Text = "INVALID" Then
Return...
-
Here is my code:
Public Class FormUtilities
Shared Function ValidateTextLength(ByVal TB As TextBox) As Boolean
If Trim(TB.Text) <> String.Empty AndAlso Trim(TB.Text).Length <>...
-
I was able to create just a small little test app again to test out @@IDENTITY and it worked great. The code I used is below:
Public Class Form1
Private Sub Button1_Click(ByVal sender As...
-
Here is my code:
Private Sub ESignSubmitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ESignSubmitButton.Click
Me.Validate()
...
-
I'll give it a try tomorrow when I'm back at work and then post what I find. Is there a way when viewing the table in access to see more detail than seconds?
-
I created a small test app just to make sure it wasn't something weird within my app. I made a little test database. Here is my code.
Public Class Form1
Private Sub...
-
This one is really making me scratch my head.
I have an access 07 db with a table named "860". One of the fields is a date field called "submissiondate". My app adds records to the table and it is...
-
Thanks kevininstructor, just what I needed.
-
I have the following code:
Private Sub ClearAllEditableControlsInGroupBox(ByVal GB As GroupBox)
Dim myControl As Control
For Each myControl In GB.Controls
Select...
|
Click Here to Expand Forum to Full Width
|