|
Thanks for your suggestion
|
|
|
|
|
I have a VB.NET windows application where I want flat controls with a custom colour border.
To achieve this I am creating a control library to override the standard controls, like TextBox and ListBox.
I have created the desired TextBox that I want by Overriding the WndProc and catching the &HF message. I can then draw a rectangle around the perimeter of the control using whatever colour pen I choose. I only do this drawing if the TextBox border style has been set to fixed single, then provide a custom property to set the desired border colour to draw over it with.
The problem I have is doing the same with the ListBox, if the border style is set to fixed single, when I draw round the perimeter of the control, it draws within the border, which means I always see the outer black one. I can get the desired effect by setting the ListBox's boder style to none, as it then draws the perimeter inside the control and looks like the border. The problem is then when I select an item in the ListBox, and the selected item draws over the custom border. Is there anyway of drawing over the fixed single black border, or do I have to continue using border style none and redraw the border every time after draw item has happened to put it back again?
Any help on this matter would be appreciated.
Jason
|
|
|
|
|
Hello Jason
I might not be able to help you but may be you can help me by sending the code of textbox border color. which I am looking for..
I shall be thankful to you for your support
my email is
rbashir@gmail.com
|
|
|
|
|
Hi all !
I am building a form in VB.net. The function of this form is get all data from one table in Oracle Database and export or write into Fox format. The table in Oracle Database is very large. When I using the following :
With cm
....
.Parameters.Add("bg", OracleType.Cursor).Direction =
ParameterDirection.Output
end with
adp.SelectCommand = cm
adp.Fill(dataset, "bill_detail")
but this command execute very very low. I need all data from the table (about 20 million rows), how can I do ??
Pls, help me !
|
|
|
|
|
Hi,
A few things, are you only querying the database? Is this application an intranet/exrtranet or internet application? If intranet why not use a string to build your sql instead of a stored procedure?
Is this a one time export, how about doing the intial export within Oracle create a flat to export to Foxpro(I believe) and then create a a procedure that will only replace or add new records going forward. I don't know your server threshold but 20 million rows seems like an awful lot and multiple this times the number of columns could be a monster.
Hope this helps!!
|
|
|
|
|
Joe Contreras wrote:
why not use a string to build your sql instead of a stored procedure?
SMACK! Being on an Intranet is no excuse for being lazy and cutting this corner! SQL Injection attacks CAN and DO originate from inside corporate networks, not just the Internet.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
My mistake for not being clear or making that statement. Using the query would be use for troubleshooting, i.e. to determine if the issue is in the stored procedure. That's all I meant when I said to use a SQL query. You need to look at all avenues when you run into issues like this and I don't know how the sproc code base looks like. I'm just wondering why millions of records are being returned.
BTW I've been in some shops where they don't allow writing any objects (sprocs,views) to the Oracle database, SQL is the only option.
Thanks,
|
|
|
|
|
Hi,
I have nearly the same situtation. Here are some things you can try out:
1. Use ODP.Net (coming with any 9 or 10 oracle db) instead of the in-built Oracle provider of the .net framework. Its by far faster.
2. If you switched to OPD.Net consider changing numeric fields to the new binary field types (coming with oracle 10) like 'BINARY_FLOAT'. They reduce the datasize and thus the time needed to transfer the data.
3. Rethink if you really need all the data in one big DataTable. I dont think any user will look into all your data. Consider using a DataReader instead.
|
|
|
|
|
umm i made a office attendace program.. n i added a command form1.label1 = time() .. similarly the date... and this date and time is also saved in a back end data base.. but the problem is that it's taking system time .. which is a flaw in the system... i tried the local security policy in the administrative tools.. to lock the time of the system from being changed .. kindly give me a suggestion
|
|
|
|
|
If you changed the policy properly to deny the Users group permission to change the system time and are running the application under a userid that is in the Users group, this isn't a problem. If you're running your application under a PowerUser or Admin account, you're getting the results you asked for.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
A better option would be to have the database server record it's data/time, not the workstation your're using for timekeeping. Of course, the user's wouldn't have any access to the SQL machine, right?
The user would login to the timekeeping system on the workstation. Your application would have to verify the credentials, then, if access is granted, display a button to either "Clock-In" or "Clock-Out", depending on what the users current status in the database is. (While you at it, you could also retrieve the current time from the SQL Server through a stored procedure so you can show the users what time the Server thinks it is, not the workstation.) This button would then call an SQL procedure that takes just the users ID and a number representing either "Clock In" or "Clock Out". The database SQL code would use its own date/time, not one from the workstation.
This way, everyone could run your app from there own desks and not a central "timekeeping machine".
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hey all check out this tutorial, http://www.gamedev.net/reference/articles/article1308.asp[^]. I am trying to create a small window that flashes =
between red and white. The program is meant to read in a binary string =
of 1's and 0's where 0 =3D White and 1 =3D Red. I have added my own code =
into the Render function that you implemented, it is as follows:
Public Sub Render()
D3DDevice.Clear 0, ByVal 0, D3DCLEAR_TARGET, &HCCCCFF, 1#, 0
D3DDevice.BeginScene
Dim n As String
n =3D Main.Text1.Text
Do
If Left(n, 1) =3D "1" Then
Picture1.BackColor =3D RGB(255, 0, 0)
Else
Picture1.BackColor =3D RGB(255, 255, 255)
End If
n =3D Right(n, Len(n) - 1)
Loop While Len(n) <> 0
=20
D3DDevice.EndScene
D3DDevice.Present ByVal 0, ByVal 0, 0, ByVal 0
End Sub
It is pretty straightforward, main.text1.text is a string of 1's and =
0's. This code works but Visual Basic seems to flash these colours too =
fast to get a image, instead what I see is just a a white box with red =
lines constantly moving. I was wondering if you could give me some help =
on how I can improve this to make the red and white colours more clear. =
ie flash slower?=20
Thanks
Tim.
|
|
|
|
|
Have you tried putting in a delay at the end of your Render function? The Win32 API Sleep function does the trick nicely...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am developing the windows application in vb.net.
I am newbie to the crystal reports.
I have tried it with simple query and i got it very fine.
But if i try to pass a query with some parameter i am not able to get the report displayed it says invalid report source.
I tried this with my dataset.
I created a Plain dataset first and filled it with the table from which i want to filter the datas then created a dataset in the form thru wizard and filled it with the dataApapter i created with the dataset. the connection for the dataset was changed to my connection as the connection will change according to the user loged in. I used this dataset as my datasouce for my report
but it giving me the error
Thanks in advance
viji
|
|
|
|
|
look at the properties for your crystal report viewer. Make sure the report source is pointed to the right .rpt file.
|
|
|
|
|
hi,
i am designing a webservice in which i need to create a database from the details the user gives. how can i create a database in ms access having a specific name, specific table name and fields. note-- the databse should not exist before the web service is called.
pl help
|
|
|
|
|
It might be easier to have a pre-created template database, which you just make a copy of when needed.
|
|
|
|
|
hi,
i am using socket programming in vb.net. using a TCP client i want to send multiple messages of undetermined length and want to receive each message independantly and process further. the messages sent are not dependant on any response from the server and should be send once connection is established.
pl help
thanks
|
|
|
|
|
Hi, I have a prlblem with tab control in vb.net 2003. I have a project in vb.net and drag a tab control on the form1. I have create 3 tab page on the table control as the following example (in design mode):
Tab1 Tab2 Tab3
But when I run the project, the tab page did not locate as what i have design, it display as:
Tab2 Tab1 Tab3
or
Tab1 Tab3 Tab2
I don't know why it display like that, and don't know how to fix it too during the time that I design and run the project. If anyone have any idea or solution please let me know.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Check the following. Click on the Tab control, not on the tabe page. In the properties window find the property TabPages (Collectio) and click on the button on the right. This will open up the TabPage Collection Editor. In the left panel you will see the tab pages you have added to the Tab control. To move tabs to the order which you want click on the tab in the left and use the up and down arrows to change its ordering. When you run the program that should be the order that they show up in.
|
|
|
|
|
Thank you very much for your comment. I know the function of an up/down button that will arrange the order of the tab control. But the problem is when I arrange it and close the project and next time when I open the project again it start to move to the difference order again. I don't know what is the problem with that. I think there is a bug in this control. One more thing is I change the font format of the form and the tab control from the default font "Microsoft Sans Serif" to my language (Khmer/Cambodian font). Any idea to this issue???
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
I don't find any property to change such things. i think you while adding the tab you might have pressed the up and down arrow in the property page window of tab control. which must be changing the position. but as you mentioned in design view you can see properly.
There could be something in coding, reason for such behaviour.
Het Waghela
Be Humble in Victory and Strong in Defeat.
Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links
|
|
|
|
|
The property TabPages is on the TabControl
|
|
|
|
|
Hi, I found out the solution now. I make change to the #Region " Windows Form Designer generated code " In the section of Initialize component. I found that my tabpage is initialize in a differnce order. So I just copy and paste to right order then there is no more problem. Thank for your support before.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Thank you very much for your comment. I think the problem might be the difference font. Because I change the font to match my country language. I think there is a bug code in the control that design from US version.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|