|
I'm assuming that you're talking about ADO.NET and not classic ADO, so all that you have to do is return a SqlConnection or OleDBConnection from the method.
[WebMethod()]
public SqlConnection GetSqlConnection()
[WebMethod()]
public OleDBConnection GetOtherConnection()
any idiot
can write haiku you just stop
at seventeenth syl
-ThinkGeek Fortunes
|
|
|
|
|
Yes, any derivation of ADO will do, i guess 
Thank you very much for your answer. I'm just starting with all the .NET stuff, but i'm getting there, thanx to valuble suggestions;)
Cheers!
|
|
|
|
|
Sure...no problem.
I'd recommend the following books for .NET development:
(MSPress)
Applied Microsoft.NET Framework Programming
Inside C# Second Edition
ADO.NET Core Reference
any idiot
can write haiku you just stop
at seventeenth syl
-ThinkGeek Fortunes
|
|
|
|
|
Hi, all:
I am totally stuck, please help. I have a datagrid on the WinForm ( using C# ). I am trying to create a combobox for one of the columns. I use the technique described in MS KB Article 323167 ( coded in VB.NET) and I port the code to C#. It works fine for the existing rows. Whe I click on the * row ( i.e., try to create a new row) on the datagrid. The combobox seems there, but when I click on the down arrow, the combobox does not dropdown. Occasionally, I can get the dropdown, but when I leave the cell, the changed value goes to the previous row ( strange!). The primary key is AutoNumber, when I click on the new row ( with "*" in front of it), I sometime get little pencil in front of the row, but sometimes I do not get it except the autonumber ( almost like it does not treat as a new row ).
Has anyone use this combobox technique and work on the new row successfully? I include the code snippet ( handling the events) here, if you can spot anything I did wrong, please let me know.
Any help is highly appreciated. Thanks in advance.
Dion
************ Code Starts here ***********
private void dataGrid1_Paint(object sender, System.Windows.Forms.PaintEventArgs e)<br />
{<br />
if ( dataGrid1.CurrentCell.ColumnNumber == 1 )<br />
{<br />
cbType.Width = dataGrid1.GetCurrentCellBounds().Width;<br />
}<br />
}<br />
<br />
private void dataGrid1_CurrentCellChanged(object sender, System.EventArgs e)<br />
{<br />
if ( dataGrid1.CurrentCell.ColumnNumber == 1 )<br />
{<br />
cbType.Visible = false;<br />
cbType.Width = 0;<br />
cbType.Left = dataGrid1.GetCurrentCellBounds().Left;<br />
cbType.Top = dataGrid1.GetCurrentCellBounds().Top;<br />
cbType.Text = dataGrid1[dataGrid1.CurrentCell].ToString() + "";<br />
cbType.Visible = true;<br />
}<br />
else<br />
{<br />
cbType.Visible = false;<br />
cbType.Width = 0;<br />
} <br />
}<br />
<br />
private void dataGrid1_Scroll(object sender, System.EventArgs e)<br />
{<br />
cbType.Visible = false;<br />
cbType.Width = 0;<br />
}<br />
<br />
<br />
private void dataGrid1_Click(object sender, System.EventArgs e)<br />
{<br />
cbType.Visible = false;<br />
cbType.Width = 0;<br />
}<br />
<br />
<br />
private void cbType_TextChanged(object sender, System.EventArgs e)<br />
{<br />
if ( dataGrid1.CurrentCell.ColumnNumber == 1 )<br />
{<br />
cbType.Visible = false;<br />
<br />
if ( ( dataGrid1[dataGrid1.CurrentCell] + "") == "" )<br />
{<br />
SendKeys.Send("*");<br />
}<br />
<br />
dataGrid1[dataGrid1.CurrentCell] = cbType.Text;<br />
} <br />
}
|
|
|
|
|
I want to build a snap-in with C#.
How can I do this?
sadegh
|
|
|
|
|
Hi, all:
I am using Datagrid control in my WinForm application. I have two questions regarding the usage of the datagrid control.
1. In MS Access Database, you can specify a column "Lookup" to another table for available values ( show up as List when clicked on the cell ). Can I do the same thing in Datagrid control?
2. I'd like the user to update the data in the datagrid, but not add a new row. I will programatically add new rows through Dataset. Is this possible?
Thanks for your help in advance.
Dion
|
|
|
|
|
Hello All,
Am I missing something or did MS decide not to implement Tristate Checkboxes in the .Net framework. I really liked having that feature in good old Win32/MFC. Oh well, maybe in version 2.
-Scott
|
|
|
|
|
Hi,
I'm working on a C# Winform application to manage content in a electronical schoolbook. One of the key feautures is a WYSIWYG HTML editor, where the author can format the output text on her own.
At the moment I don't quite know where to start building this feauture. I've done some research, and figured out that there are two components i could use, a) the DHTMLEdit ActiveX component, or b) the MSHTML COM objecct (correct me if I'm wrong). Most of the information i could find about the DHTMLEdit is datet 1998/1999, and is "old". I've allso seen some newsgroup post saying that Microsoft is outfasing DHTMLEdit, and are suggesting you to use the MSHTML object.
What i wan't to know, is witch one of these two components i should use to build my WYSIWYG HTML Editor. What's the main differences, and how could i as easy as possible implement the feauture in my application. The best thing whould be if i could buy a out of the box editor, witch I could include in my project. I know there are plenty of webbased editors out there, but i wan't something that's winforms.
I would allso appreciate any kind of good information about witch path to take.
Thank you
Jonas Follesø
Developer, GreIT AS
http://www.greit.no
|
|
|
|
|
Hello,
I created a COM DLL. (with VC++.NET but this is not important).
And created some assembly the has a function, that create instance from the
COM class, and call some function from the COM object.
When I call the functions of the assembly as simple as possible, from some
console app, this is work.!
But if I do it via remoting, it isn't work!! and give this exception:
Unhandled Exception: System.InvalidCastException: QueryInterface for
interface ScreenCamaraASM.IScreenCapturing failed.
Server stack trace:
at ScreenCamaraASM.CScreenCapturingClass.GetNumber()
at RCServerNP.RCServer.GetScreenPicture() in d:\mydocs\visual studio
projects
\remotecommunication\rcserver\rcserver.cs:line 24
at
System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(M
ethodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInC
ontext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMes
sage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
req
Msg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgDa
ta, Int32 type)
at RCServerNP.RCServer.GetScreenPicture() in d:\mydocs\visual studio
projects
\remotecommunication\rcserver\rcserver.cs:line 21
at Testing.Class1.Main(String[] args) in D:\MyDocs\Visual Studio
Projects\Rem
oteCommunication\Testing\Class1.cs:line 36.
Please, any solution?
Thank's, Itay.
|
|
|
|
|
Hi, all:
I have a simple WinForm application. I added a HelpProvider control to the form and I can provide Help to individual controls and form. I can not figure out how to call the TableofContents from a menuItem ( say &Content ) under main Menu Help. ( the old MFC way ). What should I do inside the menu item event handler? Thanks in advance.
Dion
|
|
|
|
|
Hi,
I am unable to log the errors in to a log file
during installation of the Redist Dot Net setup
following is the command line I am using
dotnetfx /q:a /c:"Install /l /q"
Thanks
Rupang
|
|
|
|
|
I'm trying to access an MS Access database that exists on a Novell network drive from within a Windows service. I keep getting the following error:
'\\mcgs1\mcgv3\Dsys2002\prudent\copyprud.mdb' is not a valid path. Make sure that the path name is<br/>spelled correctly and that you are connected to the server on which the file resides.
This IS a valid path, because when I use the exact same path in a .vbs file on my local drive, it connects fine.
Here's the relavent code:
Conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Doc.DocumentElement.SelectSingleNode("PrudDB").InnerText & "; User ID=admin; Password=")
Conn.Open()
It's when I call the Conn.Open that the error is thrown. Any ideas?
Thanks in advance.
Kyosa Jamie Nordmeyer - Cho Dan
Portland, Oregon, USA
|
|
|
|
|
Do you know the difference between \ and \\ ?
|
|
|
|
|
Um. Yes. I did use '\\' at the beginning of my network path to the database. I tried using a drive mapping as well, and got the same results.
Kyosa Jamie Nordmeyer - Cho Dan
Portland, Oregon, USA
|
|
|
|
|
Jamie Nordmeyer wrote:
I did use '\\' at the beginning of my network path to the database.
If you dont add a "@" you will need to escape each \ e.g "\\\\localhost\\sharedpath\\file.mdb" or @"\\localhost\sharedpath\file.mdb" or (if you wanna be ultra cool) "//localhost/sharedpath/file.mdb".
Oh the Friday blues 
MyDUMeter: a .NET DUMeter clone
"Thats like saying "hahahaha he doesnt know the difference between a cyberneticradioactivenuclothermolopticdimswitch and a biocontainingspherogramotron", but with words you have really never heard of."
|
|
|
|
|
 Thanks for the reply, leppie. Actually, I'm programming in VB.NET, so the escape charectors don't exist, which is unfortunate (whatever moron at Microsoft decided that Microsoft.VisualBasic.vbCrLf was better than \n needs to be shot). The code seems to run fine when it's from a command line app, so I'm gonna try putting the meat of the thing in a command line app, and just have the Service itself spawn it.
Kyosa Jamie Nordmeyer - Cho Dan
Portland, Oregon, USA
|
|
|
|
|
You need to set the service to run under a user account with permission to access the file. By default, it will run under the SYSTEM account, which has no permissions on other machines.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
Hey Richard. Thanks for the reply. I've tried running the process under both my name (I have system administrator rights), and as the network admin account itself, both with no success. The code seems to run fine when it's from a command line app, so I'm gonna try putting the meat of the thing in a command line app, and just have the Service itself spawn it.
Kyosa Jamie Nordmeyer - Cho Dan
Portland, Oregon, USA
|
|
|
|
|
Hi,
I have a problem with peformance counters in C#.NET.
What I want to do is get a number of packets just like the number of
send/received packet that can be found in the Status windows, if
you click at the bottom right of your screen to your network
connection icon (the two small in/out screens flashing the network
activity).
The Received Datagrams/sec decription goes like that:
Datagrams Received/sec is the rate, in incidents per second, at
which IP datagrams are received from the interfaces, including those
in error. Datagrams Received/sec is a subset of Datagrams/sec.
But I want PACKETS not RATE. Is there any way I could somehow use
this rate to get packets?
I want to start my application, get the counter data, do somethings,
get the counter again and found the number of packets received
through the use of my application.
I could also do the following: Run my application and while running
it, I can have a Timer in another thread getting the values of the
counter each sec. So each second I pick a value-rate of the
connection, just like the Performance monitor in Administrative
Tools (control panel) works. But even then I don't get packets.
Is there perhaps a calulation I have to do to get this?
Sure there must be a way since the network activity on the Network
Status in the right bottom on Windows can do it.
BTW, I also run into this counter: Network Interface,
counter:Packets Received/sec with the following description:
Packets Received/sec is the rate at which packets are received on
the network interface.
Same here; rate.
Please help me if possible. This has become a nightmare for me.
Thank you,
Stefanos
|
|
|
|
|
I submitted the following to the microsoft.public.dotnet.framework.windowsforms newsgroup:
I've seen a number of posts about threads, forms and controls. I
realize that you shouldn't operate directly on a control from a thread that isn't the control's creating UI thread.
What I want to know is this. In the old Win32 days, your application could create multiple what-they-call UI threads. Each thread had a message pump. You could create a window (say your frame window) on one thread, and create a child window on another thread. The messages for each window would be handled in the context of the window's creating thread.
Some posts have said you can't do that in .NET. Well, I did it.
And it sort of worked.
I created a normal C# Win Forms app. I created another thread. This new thread created a couple of controls. The key is that the
framework prevents you from using the controls's and form's Parent
property to properly hook up the window hierarchy. But you can get
the handles to the form and the controls, and you can call the Win32 SetParent API to hook them up. This works and I can handle events in the proper thread context.
I tried it using a PictureBox control and got a strange result. The strange result was that the picture box control "disappeared" if I set the BorderStyle to anything other than None. I mean, if I look for the picture box in Spy++, the window was real gone, man.
I'm hoping to have some uSoft wizard tell me a couple of things.
First, can I really not use the 1.0 framework to have multiple UI
threads, where one UI thread serves child windows of another UI
thread? Second, any idea why my experience with picture box half
worked?
Thanks. Isn't this interesting???
john.
|
|
|
|
|
jjreilly wrote:
any idea why my experience with picture box half
worked?
When the border style is changed, the underlying window is destroyed and recreated (!). Hence the handle in Spy++ vanishes. But the picture box is there again after recreation, with another handle.
Here is the key executed code :
public void set_BorderStyle(BorderStyle value) {
if (!(Enum.IsDefined(typeof(BorderStyle), value)))
throw new InvalidEnumArgumentException("value", value, typeof(BorderStyle));
if (this.borderStyle != value) {
this.borderStyle = value;
this.RecreateHandle();
}
}
protected virtual CreateParams get_CreateParams() {
CreateParams local0;
BorderStyle local1;
local0 = this.CreateParams;
local1 = this.borderStyle;
switch (local1 - 1) {
case 1:
local0.ExStyle = local0.ExStyle | 512;
break;
case 0:
local0.Style = local0.Style | 8388608;
break;
}
return local0;
}
|
|
|
|
|
Thanks. That did the trick. How did you find this out?
john.
|
|
|
|
|
I have a ASP.NET application that needs to check for changes on the client side for a file. This file is constantly being changed and I need , that everytime the file is changed to open the file and check for new data to transmit to my ASP.NET app, so what do you advise ?
Building a dotnet service(it's possible wihout com interop ?) that's is constantly checking the file on the filesystem,or using some javascript function using the filesystem object and a timer to check for changes of the file, or some other way ?
Thanks in advance,
Joao Vaz
And if your dream is to care for your family, to put food on the table, to provide them with an education and a good home, then maybe suffering through an endless, pointless, boring job will seem to have purpose. And you will realize how even a rock can change the world, simply by remaining obstinately stationary.-Shog9
Remember just because a good thing comes to an end, doesn't mean that the next one can't be better.-Chris Meech
|
|
|
|
|
I am not aware of such stuff inside the .NET CLR.
You've got dedicated functions in the WIN32 File I/O APIs, including ReadDirectoryChangesW, etc.
Now this require WIN32 interop.
Adding COM or ActiveX interfaces would allow you to execute it from Javascript code.
|
|
|
|
|
.S.Rod. wrote:
I am not aware of such stuff inside the .NET CLR.
You've got dedicated functions in the WIN32 File I/O APIs, including ReadDirectoryChangesW, etc.
Thanks , I resorted to another technique , using win32 api on one client side app , and recording the data on the database on the Server side.
.S.Rod. wrote:
Now this require WIN32 interop.
Oh well, perphaps on the 2nd version, they'll put the rest of the windows api on it (insert dreamer icon here...)
Cheers,Joao Vaz
And if your dream is to care for your family, to put food on the table, to provide them with an education and a good home, then maybe suffering through an endless, pointless, boring job will seem to have purpose. And you will realize how even a rock can change the world, simply by remaining obstinately stationary.-Shog9
Remember just because a good thing comes to an end, doesn't mean that the next one can't be better.-Chris Meech
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
