Search:
Type: Posts; User: brucevde
Search:
Search took 2.67 seconds.
-
ExecuteNonQuery is a function whose return value can be captured by
Dim X As Long = cmd.ExecuteNonQuery
As stated in MSDN, the return value is
Based on that info there is no need to...
-
How many records does the table contain? How many bytes does each record use?
A scan is quicker than indexes on tables whose number of records is considered small.
Jet 4.0 storage mechanism...
-
DotNetNuke - http://www.dotnetnuke.com - free
Insite Creation - http://www.insitecreation.com/ - $80USD
-
Cool. I am currently researching the same thing although my efforts are strictly for understanding the concepts. I don't have any projects requiring the use of Profiles.
Based on the following...
-
Highlighting is based on the value of the column. Its advantage is you can apply multiple Font formats in a single place. Unfortunately you can't turn it off or on conditionally.
Anyways, to...
-
Use the Layout template to define the headers.
-
Open the table in Access and hit the move last button. It will indicate you are on record # of total records.
or
Use the Count aggregate function - Select Count(*) From TableName
Execute...
-
The double quotes are incorrectly used and in the wrong place.
Try the following line instead
CR.SelectionFormula = "{SPINF.GRNO}=" & Me.txtGRNo.Text & " And {SPINF.CMBCAT}=" & Me.cmbCat.Text
-
or this
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.commandfield%28v=VS.80%29.aspx
All these methods basically generate/execute the same code at run time.
-
Either specify the CommandName argument of the ButtonField to indicate which action you want the GridView to process or handle the processing yourself in the GridView_RowCommand event.
-
See the Row_Number function in Books Online.
http://msdn.microsoft.com/en-us/library/ms186734(v=SQL.100).aspx
The following example returns rows with numbers 50 to 60 inclusive in the order...
-
In order to participate in ViewState, dynamic controls need to exist early on in the Page Life Cycle.
Data in ViewState is applied to all controls during the Load stage. Basically, dynamic...
-
I don't know if this applies to you but sometimes strange things occur in the VB IDE when its menus have been customized.
If you have done any menu customizations try resetting them
View menu...
-
For "minimum margins", set the margin styles of the body tag.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html...
-
VB6 and all its components are pre-installed on XP.
Most likely the computers do not have the Jet Engine installed. It use to be part of the MDAC installation but was dropped from version 2.7,...
-
There is no black and white answer. There are several factors in how you should approach this problem/situation for the most efficient process.
How do you import the data? Bulk Copy? Bulk Insert?...
-
maxLength is a property of the Text Object. Browsers are assuming you want to access that property not call a function.
Since Javascript is case sensitive, changing the function name to MaxLength...
-
The DateDiff function returns the difference upto the requested datepart portion only. Other datepart values are not considered.
For example in the following cases the return values will be 1...
-
TotalDigits = Len(Cstr(Integer variable))
-
First in your world, What is a Permission? What is a Group? What do they define?
Are Groups simply a convenient place to hold Users?
Are Permissions used to define low level activities such as...
-
Check the help file. There are additional clauses you can use with the Group By statement, which are new in SQL Server 2008.
In this case the Rollup or Grouping Sets clauses seem to be what you...
-
Specify the Container where you want to add the new control
Set lne = Me.Controls.Add("VB.Line", "Line", Picture1)
-
How is the report grouped? Why even group the data, nothing in the posted sample suggests a grouping.
-
It appears from your original post that a unique row is identified by the FactorId and Good_Id columns.
If this is true, Good_Id should be part of the Update statement's Where clause not it's Set...
-
To find dates using Like, without using Convert, make sure the criteria is based on the format mon dd yyyy hh:mi:ss:mmm which is the default (and equivalent to Convert date style 9 or 109)
...
-
Both the FromDate and ToDate would need to be used in the criteria.
To find employees on leave within a given date range
Where FromDate <= EndofDateRange And ToDate >= StartofDateRange
-
You can't.
The Data Report does not support printing images on a per record basis because the rptImage control does not support data binding.
-
In addition to abhijit's response
From and To are reserved/keywords and shouldn't be used as column names. If you must use those names surround them within [] (you will need to do that in every...
-
Research the SQL Join clauses.
In this case the SQL would be
Select STR_ITEMNO,ITEM_NAME,STR_QTY
From STRUCTURE Inner Join ITEM On Structure.str_ItemNo = Item.Item_No
-
The idea is the same whether your code contains the ASP.NET CheckBox and a Label, the ASP.Checkbox only or just HTML Input and Span elements.
As in post #2 - wrap controls/elements within Span...
-
As far as I know. Inline-block is partially supported by IE6/IE7
In those versions, inline-block can be used without problems on inline elements such as span but not on block elements such as div...
-
Is there a reason you are using a Label control for each Checkbox control?
By setting the Text property of the Checkbox control, ASP.Net generates the Label for you. An added benefit is the user...
-
In standard licensing practices, being able to use CreateObject would require a license key.
Regardless, the only way I know of to get around this would be to capture the error and process...
-
All UserControls have a UI - Click, Show, Resize events are part of a UI.
Exactly as it should. The Ambient property is only available after the UserControl is sited on a Form.
What code are...
-
That is not 100% true. It is possible to instantiate a control without placing it on a Form. It all depends on how the control was written.
Yes. Just like the Me keyword within the Form's code...
-
A book you might be interested in is "CSS: The missing manual" (OReilly). Having no HTML/CSS experience whatsoever, the book got me up to speed quickly when I first started using ASP.NET.
...
-
No. Most likely you are referencing the UserControl in one of its own initialization events or it has properties that can only exist when sited on a Form.
Post some code.
-
The IsNull function simply returns True/False
Use the NZ function
Nz («expr», «valueifnull»)
SUM(NZ(SUPPLY_TRANSACTIONS.QuantityOfTransaction,0))
-
Set the vertical alignment attribute of the TD tag. By default it is middle.
<td colspan="8" rowspan="4" valign="top"
The equivalent CSS style is
vertical-align:top
-
FCNDateDateTimePicker.Value = ds.Tables("FCN").Rows(inc).Item(1)
|
Click Here to Expand Forum to Full Width
|