I would like to be able to select a row in the datagrid without having a select button. Then, when I click "Edit" button on the form, one of the values from this row should be pulled into the querystring on another page created for editing.
I understand I should somehow mimic...
I have a datagrid that is bigger than screen size, so I have vertical and horizontal scroll bars. My problem that the screen "eats" right and bottom datagrid borders. Is there any easy way to solve this problem?
I'd like to add a footer to the datagrid, span all columns in it, and then add a link that would lead to the top of the page. Is it possible to do that? Thank you.
Hi,
Here is my question. I am in Excel workbook that contains a list of users with their e-mail addresses. In VBA code I am looping through the list and send a slightly different e-mail to each user. I also want to be able to attach a Word file to my e-mail messages, but SendMail method does...
I am pulling data from the database (DB1) in the following format:
DepartmentID DepartmentDesc
AABB Sales
AAAB Marketing
ABAB Customer Service ext.
Another database (DB2) has a table that also has DepartmentID and DepartmentDesc columns, but not...
I am looking for the code that would change the dropdown value while the user is typing what he needs. The usual dropdown will accept only the first character, but I have a long list of options where the first character is the same, so I'd like to be able to type two or three characters, and...
What transformation task should be used to delete data from the table before loading. I tried OLEDB Command, but it requires input columns. What input should I provide for the delete command? I attempted to put this command between source and destination (looks really weird), but it works in one...
Hello,
I'd like to build a datagrid that will have the first and second columns rowspaned. The quantity of rows in rowspan is fixed. There should be three of them. Could anyone point me to the source where I could get an idea how it can be done? Thank you.
I need to clear clipboard from Excel 2003 SP1 VBA. I found couple codes that should do it, but none of them work for me.
This code returns an error message "User-defined type not defined":
Public Sub ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""...
I have a logon screen and main menu stored in the separate folder on dev server. When I login, I create a cookie for the user id to use it in the entire system, and I can read this cookie from the mainmenu. As soon as I click the link that should connect me to the system with the files stored...
I have two drop-down menus: one is for the department, and another one - for the associates in this department. I populated the first one from the database. Now I want the second drop down to be populated from the database depending on the value selected in the first drop-down. To execute the...
Hello. I am very new to .NET programming, so my question is probably easy to answer. Or, maybe someone can direct me to the web source where I will be able to find the solution. Anyway, I need to populate a drop-down list with the results from the stored procedure. I was able to write a...
Hi. Here is a question. How do you change the career inside the company? I am an analyst/programmer in a non-technical department, and I am currently trying to move to an analyst position in the technical department. It’s a real problem! I like coding more than data analysis, but I like...
Here is an error message:
Active Server Pages error 'ASP 0221'
Invalid @ Command directive
/PlanWeb/WebForm1.aspx, line 1
The specified 'Page Language="vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="PlanWeb.WebForm1"' option is unknown or invalid.
I tried to change the...
This code runs:
USE pubs
DECLARE @s VARCHAR(50)
SET @s = 'SELECT * FROM publishers'
EXEC (@s)
What if @s is greater than VARCHAR(8000)? If I replace VARCHAR with TEXT, I get an error message: "The text, ntext, and image data types are invalid for local variables".
I can open the document and read it, but it does not let me make changes. When I go to Tools/Unprotect, it asks for the password. Is there any way to recover the password without buying any additional software?
I would like to retrieve server time for a particular machine. I have several web servers in different time zones, but I want them all to lock the submit button on the front-end when my database server updates the records. I know how to do it in JavaScript, but the code will require the...
Is there a way to check for the particular character in the column, and then put the first part of the word (before this character) to one place, and the second part (after this character) - to another?
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.