Hi everyone,
What's the SQL Server equivalent of the OLE Object datatype in Microsoft Access? I tried Binary, VarBinary and Image. All three of those datatypes give me a type mismatch when I try to insert an image into SQL Server.
The insert works when I insert into a MS Access DB with the...
Hi everyone,
Does anyone know how to connect to SQL Server using DAO?
Here's some code I dug up but it doesn't work.
Dim connString As String
connString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDatabase;Data Source=MyServerName"
Dim...
Hi everyone,
I was wondering if I could get your opinion on something. I was asked to design a quiz for HR.
Something in the form below:
Category I
(1) I am cool. Agree O Disagree O Don't Know O
(2) You are cool. Agree O Disagree O Don't Know O
Category II
(1) I am cool...
Hi everyone,
I have a text menubar that goes horizontally across the top of my page with the margin-left at 0, margin-top at 0 and margin-right at 0. The text in the menubar is an unordered list.
The problem I'm having is centering the menu items (text links).
Here's my CSS.
This is my...
Hi everyone,
Every application that I've compiled has a PDB (Intermediate file, according to Windows Explorer) in addition to at least one DLL file in my BIN folder.
What exactly is this PDB file? Is it ok to delete it? Hope someone can shed some light on it.
Thanks,
Keith
Hi everyone,
I cannot get into Design View after I insert this piece of code.
<asp:templatecolumn visible=False headertext="Edit Comments">
<edititemtemplate>
<a href="javascript:void window.open('comments.aspx?reqID=<%#DataBinder.Eval (Container.DataItem, "RequestID")%>','test','width=500...
Hi everyone,
I'm having a tedious problem that I'm trying to figure out. I would like to set the initial value of a dropdownlist when the user goes into Edit mode in a datagrid.
I'm trying to access the dropdownlist to set the SelectedIndex in the OnEditCommand event but the dropdownlist...
Hi everyone,
I am programming a simple editable datagrid and when I click on my EditCommandColumn to edit a row, I need to click it twice for some reason. It doesn't work if I click the EditCommandColumn once. This is driving me insane! =( Anyone ever come across this before?
Keith
Hi everyone,
Regular expressions seem like an interesting concept and I've been reading up on them lately. But most of the material I've come across uses the \regularexpression\ format. I've seen this format in Perl or Unix based grep utilities.
Does .NET use this format? It doesn't seem...
Hi everyone,
I'm trying to access Form1.TextBox1.Text from Form2. Someone suggested I try
msgbox Forms ("Form1").TextBox1
But I get
Runtime Error: 2465: Application-defined or object-defined error.
Can anyone help? Why can't I just do Form1.TextBox1.Text?!?
Keith
Hi everyone,
Does anyone know if VS.NET comes with a utility that enables one to compare code on a line by line basis? I recall seeing an ex-colleague use one but I'm not sure if it's included with VS.NET or not.
Keith
Hi everyone,
I'm trying to run the command "net send message" from the command prompt from a webpage, on the CLIENT side. This is for an intranet application and everyone is running IE.
set WShell = CreateObject("WScript.Shell")
WShell.Run netSendString
The error I'm receiving is "Object...
Hi everyone,
I'm having a bit of a problem with installing the getting the IE Web Controls to run. I've downloaded the installer and executed it. It created a folder C:\Program Files\IE Web Controls. I then built the file Microsoft.Web.UI.WebControls.dll using the batch file (build.bat) that...
Hi everyone,
I have a routine that reads and parses a bunch of files in a directory. After reading them, I close my StreamReader object but when I try to open the file or delete the file again with Explorer after my routine has ran, I get an Access is Denied error.
Am I missing something in...
Hi everyone,
I need your opinion with some speed enhancements. Currently, I am grabbing data from an IIS log file and then parsing it to get the data that I need. I then take that data and insert it into a small Access database.
The problem is I call my database insert function as many times...
I have two tables;a one-many relationship.
Table 1
1 2
1
2 3
Table 2
1 Susan
1 John
2 Judith
3 Paul
I need to display my results from table 1 as
Susan Judith
John
Judith Paul
How would I set up my join?
Keith
Hi everyone,
Quick question. If I am using Session variables, does that require the client to have cookies enabled on their browser? I remember reading some about it but I can't remember anything concrete as of now =)
Keith
Hi everyone,
I'm having problems creating a folder on a mapped network drive. The code works fine for a local drive but I get the following error when attempting to run the code on a mapped drive.
Error: Could not find a part of the path "R:\".
Here's a snippet of the code that I am using...
Hi everyone,
I'm having problems creating a folder on a mapped network drive. The code works fine for a local drive but I get the following error when attempting to run the code on a mapped drive.
Error: Could not find a part of the path "R:\".
Here's a snippet of the code that I am using...
Hi everyone,
Does anyone have experience dealing with Paypal and an e-commerce site? This is my first experience dealing with Paypal and its order processing system.
From the Paypal site, it says that in order to test order processing, you need to sign up for a Paypal account and register a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.