|
I have written a program that it has a grid with about 800 person information
my database is access but the speed of load and sqrulling the grid is low .
what shoud I do . please help me about this program .
|
|
|
|
|
Your question isn't answerable. Since we know nothing of your code, how your populating the grid, the structure fo the database, the query you're using to retrieve the data, whether the database is local to the machine or on a remote server, ...., no nothing, ... there's nothing anyone can tell you that would do you any good.
|
|
|
|
|
How many people are accessing the access-database?
Reading 800 records into memory is something that takes time - you might want to try to limit the amount of records that you are reading. You could do this by adding extra filter-options, for example, showing only the Persons from Tokyo (one place at a time).
You may also want to consider upgrading to SQL Express, a free SQL Server version that has a somewhat better performance as a database-server.
Lastly, you might want to check your SQL-statements and indexes, and run them through a profiler 
I are troll
|
|
|
|
|
Hi,
since you did not show any code and did not provide much detail, here is a wild guess:
maybe you are adding records to the GridView/DataGrid/DataGridView one by one, causing Windows to recalculate and repaint the grid every time, instead of just once. There are ways to improve this:
- keep the grid invisible till it is filled;
- use SuspendLayout() and ResumeLayout() once;
- use AddRange() instead of Add();
- use data binding.
If the wild guess is way off, tell us more and/or show code.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
i am using same user control in two forms . i need to get the form name which is using the user control currently .and the form name i should get inside the user control methods.pls help me
|
|
|
|
|
What do you mean by name ? The text on the form, or the class name ? The control has owner and parent properties. You can use the is keyword to find out if the parent is an instance of a specific class. However, doing so is poor design, your form should work regardless of where it is. If it has one behaviour for forma and one for formb, I'd add a property you can set to choose which behaviour you require.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
thanks for the response
here i have FormA and FormB
in both forms i m using usercontolA
i need to adjust the position of label in UsercontrolA . lets assume the label.left =50 when i open FormA and lebel.left=100 when i open FormB.
thanks in advance
|
|
|
|
|
Take a look at the Control.FindForm method.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
|
Your control should not care, AT ALL, what form it's on. Proper technique would be to expose a property in your control that would control the position of the label, NOT the name of the form the control in sitting on.
|
|
|
|
|
Hi all,
I'm designing a simple user interface for non/partial english speakers. I want to use visual cues and user generated discriptions and images. I want a panel (or other) docked to the left of my form.
1.The panel contains a vertical list of buttons
2.Buttons have embedded images aprox 120X70 (yeah, yeah aspect ratio later  )
3.The first button is for adding a new item -adding itself dynamically to the list
4.Buttons then have images and words assigned by users to provide simple mnemonic cues
5.The user will scroll up and down selcting the relevant item
Now do I have a panel and dynamically add buttons as the users adds new items?
Do I utilise something such as the toolstrip container?
I really don't want a treview, I want nice big clear pics and text on large buttons
Now, I'm moving to 2008 and there's so many ways of skinning a cat that any tried and tested advice would fantasic.
Oh, I'm playing with importing and resizing images from digi camera's. I've a few methods but if anyone knows of a truly fantastic and simple one that would be good too.
I always appreciate others hard won experience. So many thanks in advance for any replies.
RobS
|
|
|
|
|
Not entirely sure about what you want but look into
FlowLayoutPanel
TableLayoutPanel
You can add controls to either one off those (tablelayoutpanel you'll need to dynamicly add a row for each control added)
The scrollbar will appear when the amount off controls exceeds the height of the panel.
|
|
|
|
|
Thanks 
I'll play. Hope you get my point about skinning cats. I just sat there and thought. "Right, now which of five ways am I going to approach this"
As ever, any other insights etc....
|
|
|
|
|
i am developing a VB code to generate CRC-CCITT for my data frame
which is
(0x01 0x10 0x01 0x20 0x02 0xF0 0x04 0x02 0x23 0x10 0x63 0x02 0x03 0xFA 0x33 0x04)
so if i send 0x01 0x10 0x01 0x20 0x02 0xF0 0x04 0x02 0x23 0x10 0x63 0x02 0x03 to a crc-ccitt function i should get crc 0xFA 0x33 which i will add to my data and put an end of header then send via comm port
this what have tried but i am not getting 0xFA 0x33 as required by the protocol
'************************************************************************************
'test with this hex string 0110012002F004022310630203 i am suppossed to get crc FA33
' Or testing with 0110012016F004022310590203 should give crc 5F06
' CRC-CCITT Polynomial: 1021h = x16 + x12 + x5 + 1 (LSB first mode)Start value: FFFFh
'******************************************************************************************
Private Sub CommandButton1_Click()
Dim crc As Long
Dim n As String
Dim values(13) As Byte
Dim k As Integer
Dim i As Integer
crc = &HFFFF&
n = text1.Text
k = 0
For i = 1 To Len(n)
values(k) = "&H" & Mid(n, i, 2)
i = i + 1
k = k + 1
Next i
For k = 0 To 12
crc = calc_crc(crc, values(k))
Next k
MsgBox ("Crc " & Hex(crc))
End Sub
Private Function calc_crc(ByVal crc_buff As Long, ByVal inp As Byte) As Long
Dim i As Integer
Dim x16 As Long
Dim values(13) As Byte
For i = 0 To 12
If ((crc_buff And 1) Xor (inp And 1)) = 1 Then
x16 = &H8408&
Else
x16 = 0
End If
crc_buff = crc_buff \ 2
crc_buff = crc_buff Xor x16
inp = inp \ 2
Next i
calc_crc = crc_buff
End Function
please urgent
|
|
|
|
|
In troubles again?
BTW you know, marking a request as 'urgent' will make it fall to the bottom of the stack. 
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
singende wrote:
Private Sub CommandButton1_Click()
Dim crc As Long
Dim n As String
Dim values(13) As Byte
Dim k As Integer
Dim i As Integer
crc = &HFFFF&
n = text1.Text
k = 0
For i = 1 To Len(n)
values(k) = "&H" & Mid(n, i, 2)
i = i + 1
k = k + 1
Next i
For k = 0 To 12
crc = calc_crc(crc, values(k))
Next k
MsgBox ("Crc " & Hex(crc))
End Sub
That's a bit rubbish. Try with:
Private Sub CommandButton1_Click()
Dim crc As Long
Dim n As Integer
Dim values() As Byte
Dim length As Long
Dim sval As String
sval = text1.Text
length = Len(sval) / 2
ReDim values(length) As Byte
crc = &HFFFF&
For n = 0 To length - 1
values(n) = CLng("&H" & Mid(sval, 1 + n * 2, 2))
Next n
For n = 0 To length - 1
row = n + 1
crc = calc_crc(crc, values(n))
Next n
MsgBox ("Crc " & crc)
End Sub
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
Private Carlo,
You have been called Blessed and Schmuck now.
By your own principles, you should not support CRC code whatsoever. 
Your MVP status is at stake here.
The Klingon-General
|
|
|
|
|
Luc Pattyn wrote: You have been called Blessed
Klingons don't like it.
Luc Pattyn wrote: and Schmuck
The Klingon warrior will soon kill the offender (you know, honour...)
Luc Pattyn wrote: By your own principles, you should not support CRC code whatsoever
That wasn't really support. My code didn't need any fix. His one, on the other hand...
And, yeah, Mon General, Klingons shouldn't give support, anyway:
VB6 programmers are really, really cursed people, pietas is noblesse oblige with them.- What the fu*k: Klingon warriors obey no General!
Luc Pattyn wrote: Your MVP status is at stake here.
Klingons don't care about whatever MVP status (just kidding Chris, just kidding... )
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
|
Thanks in Advance...
modified 28-Nov-12 4:42am.
|
|
|
|
|
You've been asking this for days. Have you tried stepping through your code to see what's going on ?
Looks to me like some lines have more than two spaces that you need to remove.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
|
Recursion.
But in the manner you'v written it your not going to be able to do it (at least not easy).
Why are you still doing your actions directly in the loop that reads the file?
Go back to one off you previous post where I answered a lot off you questions. And go trough them again.
It is going to be far easier to do all that you want in memory (eg datatable)
Steps:
0) read text file into memory (datatable)
1) go over your datatable and do your actions onto the datatable (delete / insert / alter the rows off the datatable)
2) write the datatable to a new (or overwrite the existing) text file.
|
|
|
|
|
First one Open File and Read the file by line wise.
Then By using Trim ,LTrim ,RTrim ,Left,Right,Mid,Instr,Space,Format Function you can get a real Output.
Best Regard
Anubhava Dimri
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
