|
Giorgi Dalakishvili wrote: You can find more connection strings here: www.connectionstrings.com
Darn, Giorgi, you beat me to it 
|
|
|
|
|
it is important to know that the client does not have an sqlclient in his machine
10x regards.
etretyertyery
|
|
|
|
|
If the client does not have SQL Server on his machine, I assume he can see SQL Server over his local network ? If so, it makes no difference. If not, how do you expect this to work ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i expect to use a dcom server implemented as a windows services that allow the client to connect to the sql server by invoking a method
if any idea plz give me a help
bye.
etretyertyery
|
|
|
|
|
Hallo
Does anybody know how to change the height of an item in a checkedlistbox control. I have tried setting the drawmode to OwnerDrawVariable and drawing each item myself but with no success. Any clues would be greatly appreciated. Thanks
-- modified at 1:47 Tuesday 15th May, 2007
There are 10 types of people in the world, those who understand binary and those who dont.
|
|
|
|
|
When the DrawMode property is set to DrawMode.OwnerDrawFixed, all items have the same height. When the DrawMode property is set to DrawMode.OwnerDrawVariable, the ItemHeight property specifies the height of each item added to the ListBox. Because each item in an owner-drawn list can have a different height, you can use the GetItemHeight method to get the height of a specific item in the ListBox. If you use the ItemHeight property on a ListBox with items of variable height, this property returns the height of the first item in the control.
|
|
|
|
|
That only works for a listbox though. If you try that on a checkedlistbox it wont work. The checkedlistbox is inherited from the listbox and hardcodes the height to its fontsize + 2. The only way to change the height is to change the font size or alternatively draw the checkboxes to an ordinary listbox that is set to OwnerDrawVariable.
Thanks though, you wouldn't believe how long I was stuck on this 
There are 10 types of people in the world, those who understand binary and those who dont.
|
|
|
|
|
This works in VS2013 net FrameWork4.5
Put declare and constant at top of class
Usage put rest of code in Form_Load as in example code.
Private Declare Function SendMessageByNum Lib "user32" Alias "SendMessageA" _
(ByVal hwnd As IntPtr, ByVal wMsg As UInt32, ByVal wParam As IntPtr, ByVal lParam As IntPtr) As IntPtr
Private Const lB_SETITEMHEIGHT As Integer = &H1A0
Private Sub Form_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim ItemHeight As Integer = Me.Font.Height + 4
SendMessageByNum(CheckedListBoxControl.Handle, lB_SETITEMHEIGHT, CType(0, IntPtr), CType(ItemHeight, IntPtr))
End Sub
Douglas Peterson
Senior Application Developer / Chief Technical Officer
The Professional PC / ERIC Systems
|
|
|
|
|
Thanks, I've been trying to figure this out for 8 years, I can finally move on with my life now
|
|
|
|
|
I'm trying to modify the filtered query example in the Noyes data binding book (ch 8) and have come up with a problem that I expect is reasonably standard:
If a user filters outside of the data set, ie the data filter returns 0 rows from the binding source the column names populated in the combo box a cleared.
The basic question then is how can I get the shape of a dataset, specifically column names from a dataset with no rows.
This is an issue for performance in my case as in the first instance I need JUST the shape of the data set to which the binding source is bound. ie I don't want to retrieve the 100,000 rows in my table and then filter them, I need to apply the filter then refresh the dataset (think search engine).
and I would prefer to do this from a control library.
Any suggestion would be most welcome.
Thanks,
Paul
|
|
|
|
|
Hi Paul
Use "FillSchema" method to get only data structure and call "Fill" method when you need to get data.
eg.
yyy.FillSchema(dt, ....mapped)
xxx.DataSource=dt
|
|
|
|
|
To reproduce:
1. run code, select upper
2. press Tab
Observed:
combobox contains lower
Expected:
should contain upper
How to fix ?
using System.Windows.Forms;
using System.Data;
class testForm : Form {
ComboBox comboBox1;
testForm() {
DataTable t = new DataTable();
t.Columns.Add("displaymember");
t.Columns.Add("valuemember");
t.Rows.Add("lower", "a");
t.Rows.Add("upper", "A");
comboBox1 = new ComboBox();
comboBox1.DisplayMember = "displaymember";
comboBox1.ValueMember = "valuemember";
comboBox1.DataSource = t;
comboBox1.DataBindings.Add("SelectedValue", new bo(), "controlsrc");
TextBox tb = new TextBox();
tb.Top = 100;
Controls.AddRange(new Control[] { comboBox1, tb });
}
class bo {
string t;
public string controlsrc {
get { return t; }
set { t = value; }
}
}
static void Main() {
Application.Run(new testForm());
}
}
Andrus
|
|
|
|
|
Have you figured this out or still working on it?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I found solution: by default search is case insensitive.
Andrus
|
|
|
|
|
Hi,
I have a created an application using Windows Forms, which is aimed at novice, and potentially young users (teenagers). I would like to maybe change the appearance of the standard menus and buttons, etc, or mayve curve the corners; or anything really that would be more appealing to younger people.
I'm fairly knowledgeable with .NET's Windows Forms, but not with changing their appearances, etc - apart from applying images/colours.
Is there any articles/tips on this sort of thing? To honest my time doesn't allow for much research into this sort of thing, so if it's not possible *easily*, it's not possible.
Thanks,
Cormac
|
|
|
|
|
|
Thanks for the advice.
Cormac.
|
|
|
|
|
After i have created a services in c# using the processservices class, this services contain only a method GetDate().
but can any body tell me how can i interacte with this sevices. for example, i should have a method instead of GetDate (): Establishconnection(param..) that help me to connect to an Sql2005 server (this method is with the services). And after, i should connect to this services from a client application and call this method and then get the connection with the SqlSever without having an sqlclient in the client machine.
regards, bye.
etretyertyery
|
|
|
|
|
If I understand your question, you want this "service" application to provide the connection to you client applications without having a SQL Client installed on them. I do not think this could easily be done. However, you should look into creating a WebService to get your data if you do not want your clients to have the SQL Client.
|
|
|
|
|
i think that u have understand the idea that i need.
i think that the solution is to use a dcom server implemented like a windows services.
but what is dcom i don't know
any way 10x
etretyertyery
|
|
|
|
|
I'd like to add a trusted site to a bunch of computers. Is there a registry key I can adjust or add using a .reg file?
|
|
|
|
|
How can I build a table on a Windows Form?
|
|
|
|
|
Don't post in multiple forums. There is a reply in c# forum so reply to that post 
|
|
|
|
|
Hallo
I can't seem to change the ItemHeight property of my listboxes in C#. The property isn't readonly but if I try to change it in the properties pane in VS 2005 or even in my code they just stay the same. Am I missing something really obvious here?
There are 10 types of people in the world, those who understand binary and those who dont.
|
|
|
|
|
You need to set the DrawMode property to OwnerDrawVariable.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
