|
No I am not returning all the records.
exec sp_executesql N'SELECT Asset.*
FROM Asset
WHERE (AssetGroupId = @AssetGroupId)',N'@AssetGroupId int',@AssetGroupId=147
is the sql that runs which obviously is a very simple query. ran in sql takes less than a second.
please advise it takes about 20-30 seconds to load up a page when i change a AssetGroupId dropdown list
|
|
|
|
|
So, how many records does the SQL return ? How are you showing them ? If you're getting 10000 records and then using a paged control, odds are high that all 100000 are in viewstate, hence the delay
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I'm reading data from a file and the date is formatted as YYYYMMDD. What I need to to is calculations such date one minus date two = 30 days. Needless to say if I format the days as integer and subtact them I don't get the proper answer (eg 20070101 - 20060101) Jan 06 to Jan 07 isn't 10,000 days. Does anyone have any suggestions or better yet some related reading material. Thanks.
George
|
|
|
|
|
Read MSDN on the DateTime class, it holds all you need and more.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Use the DateTime.ParseExact method to parse the string into a DateTime Value. Then you can do calculations on it.
---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams
|
|
|
|
|
Any Good reading on the DateTime.ParseExact method. Something with examples if possible. I did a google search with less than impressive results. Thanks.
George
|
|
|
|
|
Hi, i have been trying to create my own version of the picture box, i did this by first creating a user control and then using the keyword inherits System.Windows.Forms.PictureBox
What i really want to do is that i wanna be able to create a button that is 50% transparent when mouse is no over it, and it will become opaque when the mouse hovers over it. I made it a picturebox because it will load a gif image from the resx file.
I have overrided the OnPaint function so that it will display the image in the control, the layout is as following.
I put this control on top of another PictureBox, and when I run it, it gives me a while box instead of displaying the image. I debugged it and find that the displaying of the image is fine until this onPaint is over, (i.e. when the pointer steps out of this method, and that the PictureBox underneath is displayed, this control will turn into a white box)
How can i fix this?!
Thx
Code:
<br />
Protected Overrides Sub OnPaint(ByVal pe As PaintEventArgs)<br />
MyBase.OnPaint(pe)<br />
Dim g As Graphics = Me.CreateGraphics()<br />
g.Clear(Me.BackColor)<br />
<br />
'-------------------call image from resources ---------<br />
Dim myAssembly As System.Reflection.Assembly<br />
myAssembly = Me.GetType.Assembly<br />
<br />
<br />
' Creates the ResourceManager.<br />
Dim myManager As New _<br />
System.Resources.ResourceManager("PictureResizer.Images", _<br />
myAssembly)<br />
<br />
Dim myImage As System.Drawing.Image<br />
myImage = CType(myManager.GetObject("flipccw"), _<br />
System.Drawing.Image)<br />
'----------------------------------------------<br />
Dim bitmap As Bitmap = New Bitmap(myImage)<br />
Dim clrMatrix As ColorMatrix = _<br />
New ColorMatrix(New Single()() _<br />
{New Single() {1, 0, 0, 0, 0}, _<br />
New Single() {0, 1, 0, 0, 0}, _<br />
New Single() {0, 0, 1, 0, 0}, _<br />
New Single() {0, 0, 0, 0.5F, 0}, _<br />
New Single() {0, 0, 0, 0, 1}})<br />
<br />
Dim imgAttributes As ImageAttributes = New ImageAttributes()<br />
imgAttributes.SetColorMatrix(clrMatrix, ColorMatrixFlag.Default, ColorAdjustType.Bitmap)<br />
<br />
g.DrawImage(bitmap, New Rectangle(0, 0, Me.Width, Me.Height), _<br />
0, 0, bitmap.Width, bitmap.Height, _<br />
GraphicsUnit.Pixel, imgAttributes)<br />
' Dispose<br />
g.Dispose()<br />
<br />
'imgAttributes.SetColorMatrix(clrMatrix,<br />
'ColorMatrixFlag.Default,<br />
'ColorAdjustType.Bitmap);<br />
<br />
End Sub<br />
|
|
|
|
|
First, you don't need a UserControl. All you have to do is create a class file and inherit from PictureBox. Which is what you actually did in the first place. All you did was change the inheritance from UserControl to PictureBox.
Next, it looks like all you're doing is replacing the PictureBox's painting code. To do that, get rid of the OnPaint function and move that code to the Paint event instead. You also won't need to call MyBase.OnPaint(). The OnPaint method is used to raise the Paint event, where the actualy painting occurs.
|
|
|
|
|
Trying to add reference to my project by referencing it in References of the project and Right click select add reference/projects tab and selecting the project to reference like Client from Temp but error comes up saying:-
A reference to 'ClientApp' could not be added. An assembly must have a 'dll' extension in order to be referenced.
Can anyone explain what i require to do.
|
|
|
|
|
It would appear the you tried to add a reference to a Windows Forms (.EXE) or ASP.NET project. You can only add a reference to a project that compiles to a .DLL, like a Class Library project.
|
|
|
|
|
Got it was adding reference to the class and not the client. Thanks Dave you refrehed my memory whne you mentioned class.
|
|
|
|
|
For the following lines of code I get an error, Can anyone tell me how to fix it. Thanks in advance
'Open data base
If mdbOpenDataSource(sDBaseName, "", "") = 0 Then
BugMessage("InitSystem: Can't open data base: " + sDBaseName)
InitSystem = False
Exit Function
End If
Error Message:
Unable to load DLL 'mdblib.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E
|
|
|
|
|
Which database are you using?? SQL Server, Access, MySql, ...???
The .DLL you mentioned doesn't come with any Microsoft products that I know of. Did you Declare any calls to this .DLL file?? What is this .DLL for??
|
|
|
|
|
s3rro wrote: 'mdblib.dll'
Where did it come from? Doesn't sound like anything from Microsoft.
|
|
|
|
|
Google says: Novell Minosse.
"Minosse is a complete SQL Relational DataBase System fully written in C#"
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
hi frinds
i need run some code when mytextbox willbe paint
but unfortunately this control donthave PAINT method.
how can i run this Code
thx
|
|
|
|
|
Hi,
saeed_rezaei wrote: unfortunately this control donthave PAINT method
Paint event belongs to Control, and TextBox inherits from Control, so it does have one.
This is what MSDN tell us about it: "This event supports the .NET Framework infrastructure
and is not intended to be used directly from your code.
Occurs when the control is redrawn. This event is not relevant for this class. "
I suggest you try attaching a Paint handler to it and see if and when it gets called...
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
The textbox does have a paint event, BUT it draws itself outside the paint event, owner drawing a text box is a real pain.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
TextBox is repainted by Form, therefore you may use form’s paint method to do custom drawing in text box.
Following is a small code snippet which may give you some idea about use of Form’s paint event-
Private Sub Form1_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles Me.Paint
For Each cntrl As Control In Me.Controls
If TypeOf (cntrl) Is TextBox Then
cntrl.BackColor = Color.Red
End If
Next
End Sub
I hope this helps.
-Dave.
Dave Traister,
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
Hi to all!
I am again in this fantastic and very active group, after I resolved a previous problem about TDateTime (with guideline of Dave Kreskowiak), for another problem:
Unfortunately, Compact Framework version of OpenFileDialog (may be also normal version), do not recognize the entire file system in Windows Mobile 2003 based devices, but his "scope" is limited to the "\My Documents" folder.
Absolutely, I need to implement in the code I'm writing, the possibility to choose a file to open (read with StreamReader function),through entire file system (included SD Card).
Is there some simple solution (inside VB .Net Compact Framework environment),to do this or necessarily I'll must to turn to use of others complicated (for me) solutions like use of API, to mix C++ with VB, mix unmanaged code with managed ...etc..etc?
Thanks in advance for help and/or suggests.
Marco
|
|
|
|
|
ok i got my grid all set up how do i add columns to my datgrid then put a name at the top
|
|
|
|
|
Just use the following code
Me.DataGridView1.Columns.Add("myColumn", "Extra Column")
hope it helps !
AliAmjad(MCP)
|
|
|
|
|
hi,
Just want ask anyone who knows how to validate input on textbox.
In such a way that it will only allow numbers to be placed in the textbox.
If letters on the keyboard are pressed, it will not show anything nor msgbox.
I made several searches but what I got is always showing msgbox and reset the textbox but still displays the letter pressed on the keyboard.
hope you can give me useful codes on this..
|
|
|
|
|
You can easily do this by just using the following code in the Textbox's KeyPress event.
If Not IsNumeric(e.KeyChar) Then
e.Handled = True
Else
e.Handled = False
End If
Hope it Helps !
AliAmjad(MCP)
|
|
|
|
|
that's great.. it works.. Thanks sir!
I have another question if you don't mind mr. AliAmjad..
Can I do the same thing or how can I do the same thing with the datagridview on just one column?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
