Search Result

Djiber · May 3 '12, 02:49 PM

Is it possible and how to disable selection of 1'st row in dataGridView.

I made it select some other row, but even so when u try to move with arrows on keyboard it'll select 2'nd row(cause 1'st row was selected initially and you can see it's selected on RowHeader-1'st/Left Column)

This is my code for selecting row:

Code:

dataGridView1.ClearSelection();
dataGridView1.Rows[BoPrI].Selected = true;

...

MOzgaf · Dec 20 '11, 11:28 PM

Hi,

The problem is I have a list that i want to send to other file(php) but I want to send two corresponding variables. I was wondering if this is easy with the hidden field.

Code:

<select id='myselect'>
    <option value='1'>A</option>
    <option value='2'>B</option>
    <option value='3'>C</option>
    <option value='4'>D</option>
</select>

...

Josh Andrews · Nov 25 '11, 05:31 AM

Hi, I have an application that automates the Reference Number (or Ticket Number) for every new record encoded in the database in this pattern/hash:
REQ1111-0001
where: 'REQ' is a string (my prefix for request),
'11' - current year (4th & 5th char);
'11' - current month (6th & 7th char);
'-' dash (1 character; 8th place);
'0001' - number that increments every time a new record is added.
...

Joel Marion · Nov 2 '11, 04:06 PM

I'm new to MS Access SQL and I'm trying to compare data to a table of multiple ranges in order to return yes/no results. I.e.: If this number is between X and Y, do this, else do this. My problem is that there are multiple ranges to be examined. These ranges are stored in a table (let's call it Range), and are all 3-digit numbers:

Code:

I'm trying...

dfn77 · Oct 17 '11, 10:53 PM

Hi,

I'm having some trouble with the following piece of code:

Code:

string getAllNew = "SELECT * FROM dbo.HeaderAndDetail WHERE ProcessedToCsv = 0";
            conn.Open();

            try
            {
                SqlCommand cmd = new SqlCommand(getAllNew, conn);
                SqlDataAdapter dAdapter = new SqlDataAdapter();

...

slingblade · Sep 28 '11, 07:21 PM

There must be a way to do what I want to do without using a cursor, but I can't think of it. FYI, I'm a marketing analyst and not all that good with sql.

Here's the scenario:

SITE table

Code:

ID  NAME          AD1          CITY          STATE  MONTHLY
1   JOHN DOE      11 MAIN ST   BIGCITY       FL     30.00
2   JANE DOE      22 MAIN ST   BIGCITY       FL     25.00
3   BOB SMITH     33

...

Niheel · Sep 10 '11, 11:17 PM

One of my applications collects a lot of data and is outputting it to a group of analysts that view it in all sorts of ways. To speed up things we've been using a lot of indexes on our main tables.

At some point, i wonder what kind of problems we can run into with all these indexes we've created.

What's the a good number of indexes for tables with over 10 million rows? Do the number of indexes have an impact on queries...

NeoPa · Aug 26 '11, 06:22 PM

Overview

It is often required to prompt the operator of an Access project to select a file or folder. Sure, it's possible to allow them to type it in freehand, or even paste it in from another application, but generally operators are more comfortable with the facility to select it from the existing file structure as they would in most Windows applications (with a file/folder selectioon window).

This is perfectly possible...

mcelrob5 · Apr 14 '11, 03:39 PM

I am working on a SQL statement the works on relationships mapped amongst software and hardware.

The result I am looking for from the following statement should look like this: (the example table is in code style for formatting purposes)

Code:

-----------------------------------------------
| App Name | Server | Environment | DR Server |
-----------------------------------------------
| App1     | svr1

...

Cocea Razvan · Feb 8 '11, 09:16 PM

Dear all,

Probably this is a stupid question but I'm new to access.
I am trying to select from "Ora" column in the table (picture attached) values between 18 and 6. All my filtering works until here. "Ora" is defined as integer, data is inserted into the table by an external app. I cannot modify this field as the external app cannot send the date/time in a different format.

Istoric_Turnari...

Charles Ndethi · Jan 24 '11, 01:54 PM

Here is sample pseudocode to capture the logic.
Attached is the sql export.

if ( lab_sessiontime .Start_time > NOW())
then lab is free for Start_time - NOW() minutes
_______________ _______________ _______________ _______________ ____

else if (lab_sessiontim e.Start_time < NOW() )
then check if ( NOW() > lab_sessiotime. End_time
if true then lab has been free for [NOW() - End_time]...

maryam raj · Jan 14 '11, 09:43 AM

Code:

 


SqlConnection dbCon = new SqlConnectio(connectionstring);
SqlCommand sqlCom = new SqlCommand();
sqlCom.CommandText = "SELECT FROM rizha";//comment:rizha is a table
     try
    {
    SqlDataReader dr;
    dbCon.Open();
    dr = sqlCom.ExecuteReader();
    if (dr.HasRows == true )
    {//comment:I run with break piont and I undrestand this line never

...

Andy Sauer · Dec 16 '10, 10:09 PM

Hi, I want to enter data about when people attend a group session and which session they attended.

On a Form:
I have a Multi-Select list box of people's names.
I have a text box where I type in the date.
I have a drop-down box for the group session name.

In a Table:
I have a column for name, a column for date, and a column for group session name.

On the Form, I want to...

cheryl culwell · Dec 14 '10, 08:23 PM

The data in the table well_summary.ye armonth is defined as varchar(7) - I need to retrieve the previous month, get the current year & use those variables in a select to retrieve the previous month's data. I have formed the following select, but get an error with the "+" trying to add the '/' for the date. can someone help me correct the select?
thanks

select CAST(DATEPART(m , getdate())-1 AS VARCHAR(2)) /*last...

cheryl culwell · Dec 14 '10, 06:05 PM

I have a table, let's call it table, with a variable as yearmonth defined as varchar(7) and entered data as '2010/05'. I need to write a 'view' to be used by a 3rd party software which will select data from table for a specific month - i.e. previous month this year - how can I select only those records?

Search Result

dataGridView Selection?

Change hidden field value when dropdown list changes

SQL select query

SQL Syntax: IIF(Between (select x from a) and (select y from a),"yes","no")

SqlDataAdapter select command not returning correct results

Help with SQL script

Right amount of indexes to use on a big table?

Select a File or Folder using the FileDialog Object

how do I join two complex Statements with different number of targets

How to query for an interval between 18 and 6 (hours, as integer in the table)?

How to return name of free lab from query?

How can I write a true SELECT statement?(for accsesing and using a data in database)

How can I get MultiSelect list box to populate individual rows in a table?

how can I retrieve the data '2010/05' by using the getdate variable

how to select specific year/mo from table stored as varchar(7) '2010/05' in query