|
I think you will find the INFORMATION_SCHEMA views to be the most usefull. They are supposed to remain unchanged between versions.
SELECT *
FROM INFORMATION_SCHEMA.SCHEMATA
|
|
|
|
|
hi,
yes ,we can get databases Name from above query in local SQL server.But How do we collect databases Names in other SQL Servers...Suppose that another SQL Server is in my Network.I want to get databases Names from that...So How do I collect databases Names from Various SQL Servers in other machines.?
Thanks...
|
|
|
|
|
I guess I don't know what your asking because the only response I can give is:
Run the query on the other servers....
I sense that is not the answer you are looking for.
|
|
|
|
|
I have added 3 tab pages to a form. On each tab page the same user control has been added. On the control there is a left docked treeview and a right docked text boxes. I have added a splitter between these controls so that I'm able to change the size of the treeview. Once I change the size of the treeview in one tab the splitter should be located accordingly in the other tab pages as well so that I don't need to resize it. How can I achieve this?
samitha
|
|
|
|
|
Hi Smitha,
Problem lies in the layout of the userControl
In your case the constituent controls of the userControl should be put in the following sequence:
Step1.Put treeView control on the userControl, with Dock as Left
step2.Put splitter control, with Dock as Left
Step3.Put a panel on the userControl, with Dock as Fill
Step4.put all the textBoxes of the userControl in the above mentioned panel.
This should solve your problem.
Do revert back whether you could solve the problem or not?
(Note: Please delete all the constituent controls from your UserControl and start from Step1)
Regards,
Jay
|
|
|
|
|
Jay_sh_s wrote:
(Note: Please delete all the constituent controls from your UserControl and start from Step1)
That's not necessary and would be a waste of time, especially if lots of code was already written. You'd have to reset all the properties and hook the event handlers back up.
See my reply for how to fix this without removing all your controls and starting over with a fresh layout.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
Dear Heath,
Thanks a lot for the added informations. Though I was knowing it roughly but had never tried. Now onwards, I will do exactly what you have suggested.
Regards,
Jay.
|
|
|
|
|
What Jay said is partly right, but don't delete all your controls! Whatever the designer does is also manually possible. Remember that most design-time serialization is your actual source code file.
You need to set the TabIndex of each control accordingly. So, the order that Jay was talking about is the order you should use for your TabIndexs for each Control.
Then, in Controls.AddRange (the method to add controls to a parent control that you'll see in your source code), add the controls in the reverse order you did above. Internally, AddRange iterates through the control array in reverse. You could also just use Controls.Add - in which case you add the controls in the TabStop order - but you could potentially break the designer (behavior varies; it really likes using AddRange).
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
Heath Wrote:-
You could also just use Controls.Add - in which case you add the controls in the TabStop order -
1.It should be TabIndex order...NOTTabStop order...am I right? seems to be typing mistake on your part.
2.I just tried it, actually it is adding in reverse order, not in the tabIndex order. like below:
this.treeView1.TabIndex = 0;
this.splitter1.TabIndex = 1;
this.panel1.TabIndex = 2;
this.Controls.Add(this.panel1);
this.Controls.Add(this.splitter1);
this.Controls.Add(this.treeView1);
Please clearify.
Regards,
Jay.
|
|
|
|
|
I said that if you use Controls.Add you must add the controls in the order of TabIndex. You only reverse the order when using Controls.AddRange. Please re-read my post for clarification.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
Hello,
Can anybody explain me here how i can make periodically every five seconds screen shots on the Pocket Pc? - Means that automatically every five seconds should be made a screen shot of the display of the PocketPc and should be saved. Respectively is it possible that a screen shot of the display of the PocketPc is made when any event on the PocketPc occurs?
Thanks in Advance.
Regards.
Patrick
|
|
|
|
|
You do this the same way you would in Windows, with calls to GetWindowDC and BitBlt to copy the source bitmap to a compatible desination bitmap.
If you're doing this in .NET (you are in the C# forum after all), you have to P/Invoke these calls.
Read the article Capturing the Screen Image in C#[^] but keep in mind that not all managed and unmanaged APIs are available on the Windows CE platform (on which Pocket PC is built). More APIs are available in Windows CE .NET 4.x than in Windows CE 3.x and below, but both should have enough to get the job done (basic GDI APIs).
As for the timer, the System.Threading.Timer class is the only timer class supported by .NET CF. See the .NET Framework SDK documentation for more details, or write your own timer. It's fairly straight-forward to use and I have discussed it in regard to .NET CF before, so you can also click "Search comments" above this message board and search for that thread.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
Keep in mind though that you don't have GB's of storage available. (unless you have a 2 GB CF card)
|
|
|
|
|
Thank you i developed a screen capturing class and it works.
regards
|
|
|
|
|
Probably is it possible to get noticed when a new window or a new tab pane on the PocketPc is opened? - this would be very good, because then i would make screen shots when a new window or tab pane is opened.
regards
pat
|
|
|
|
|
How can I send a fax using C#?
|
|
|
|
|
|
|
I made WinForm project.
And I made a label and it has a font of 12 point and Comic Sans MS.
And below of it,
I made a textbox too and it has a font of 12 point and Comic Sans MS.
both of it are multiline.
and I give a words in this.label1.Text="I found a reason for me to change who I used to be. A reason to start over new. And the reason is you.";
and I runed my program and I typed same as above on textbox.
and position of the text of textbox is more left than label text.
I hope it's position of left to right is same.
Someone help please. StreamFormat? or anything?
Image will remind us some feelings and if I can ask someone about a problem, that's not a bad life.
|
|
|
|
|
I made a small test program and did the same thing that you describe. I see that I had to make the textbox narrower so that the text wrapped thesame way. I also have to make the textbox taller.
I saw that the textbox had the characters 1 pixel to the right of the label. Also the spacing between lines for each was different too. It looks like it might be about 1.5 pixels or so added to each line in the textbox that the label does not have.
With VS.Net 2005 (at least on my system), when you move a textbox it goes transparent and you can see what is underneath. I put the text in both the label and the textbox and it was very obvious that the line spacing was off and the left-right spacing was off by 1 pixel as well.
Sorry I could not come up with something more than confirming what you see even on the new compiler.
Steve Maier, MCSD MCAD
|
|
|
|
|
In addition to what Steve said, you can also adjust the position of the text in a Label using the TextAlign property. This is also available to set in the designer with a useful UITypeEditor similar to what the Dock property exposes.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
I am looking for a ListView control capable of being used in "virtual" mode. I have to display large amounts of data (from datasets too).
|
|
|
|
|
What do you mean by "virtual mode"?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
The list items aren't actually read-in in their entirety, but the scroll bar is adjusted accordingly. This is nice for large lists or for lists that grab their items from a slow data source.
See my reply to the parent post for more information if you're interested.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
You might try searching google for virtual ListViews. IIRC, there might be one or two mentioned here on CodeProject.
As far as binding DataSets (and keep in mind that bindable controls in the .NET BCL actually bind against IList and/or IListSource, not just DataSets), there's really isn't any support for this in the .NET BCL. You must add this yourself. How complex you make it is a question that you must asked based on your requirements. I've done simple one-way "binding", but it's not true binding.
The ListView in .NET 2.0 will contain support for virtual lists (among other things) and, IIRC, support for data-binding, although you might find a better alternative based on your requirements from GridView.
You can find more information about these components on http://lab.msdn.microsoft.com/library[^] and from various articles you can find on http://msdn.microsoft.com[^].
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
