|
|
It looks like you are stuck in the mentality of using DataAdapters for everything. Remember that they are just higher level wrappers around existing functionality that is exposed else where. You are creating larger bulkier objects to do work that can easily be achieved with smaller more dynamic objects.
You should just create a SqlConnection and SqlCommand object and call ExecuteNonQuery() on it. e.g.
SqlConnection conn = new SqlConnection(myConnectionString);
SqlCommand cmd = new SqlCommand("DROP TABLE ea_CashFlowTest", conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch(SqlException ex)
{
}
finally
{
conn.Close();
}
I hope this helps.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
Thanks, I figured it out.
|
|
|
|
|
Hello,
Is there a way of adding a second header column to datagrid?
For example: first header will have "Pd1", "Pd2" .... headings
second header will have: "Jan", Feb", ...... headings.
Thank you
|
|
|
|
|
I try to call a java webservice from .NET. When calling one of the Webservice methods I get the error:
"There is an error in XML document (1, 339)".
I tracked down the SOAP XML response by a Tool called "TCPMonitor":
-------------------------------------------------------------------------------------
HTTP/1.1 100 Continue<br />
<br />
HTTP/1.1 200 OK<br />
Content-Type: text/xml;charset=utf-8<br />
Transfer-Encoding: chunked<br />
Date: Mon, 05 Sep 2005 17:07:28 GMT<br />
Server: Apache-Coyote/1.1<br />
<br />
2000<br />
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope<br />
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"<br />
xmlns:xsd="http://www.w3.org/2001/XMLSchema" <br />
...
-------------------------------------------------------------------------------------
I discovered that "Transfer-Encoding: chunked" and the "2000" mean, that the SOAP response is sended in chunked parts of 2000 (bits, characters ???) by the webserver. .NET doesn´t seem to be able to join the chunked parts back to one.
At least my question:
1. Is it possible to call the webmethod in C#, declaring to use only http/1.0? (to avoid the chunking of http/1.1)
or
2. Is it possible for .NET to read http/1.1, chunked SOAP messages in some way?
I still have to use .NET 1.1, so please do not refer to .Net 2.0.
(Sorry for the long text, but I thought the information could be interresting to anybody else with the same problem)
Thanks for any response
|
|
|
|
|
I try to call a java webservice from .NET. When calling one of the Webservice methods I get the error:
"There is an error in XML document (1, 339)".
I tracked down the SOAP XML response by a Tool called "TCPMonitor":
-------------------------------------------------------------------------------------
HTTP/1.1 100 Continue<br />
<br />
HTTP/1.1 200 OK<br />
Content-Type: text/xml;charset=utf-8<br />
Transfer-Encoding: chunked<br />
Date: Mon, 05 Sep 2005 17:07:28 GMT<br />
Server: Apache-Coyote/1.1<br />
<br />
2000<br />
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope<br />
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"<br />
xmlns:xsd="http://www.w3.org/2001/XMLSchema" <br />
...
-------------------------------------------------------------------------------------
I discovered that "Transfer-Encoding: chunked" and the "2000" mean, that the SOAP response is sended in chunked parts of 2000 (bits, characters ???) by the webserver. .NET doesn´t seem to be able to join the chunked parts back to one.
At least my question:
1. Is it possible to call the webmethod in C#, declaring to use only http/1.0? (to avoid the chunking of http/1.1)
or
2. Is it possible for .NET to read http/1.1, chunked SOAP messages in some way?
I still have to use .NET 1.1, so please do not refer to .Net 2.0.
(Sorry for the long text, but I thought the information could be interresting to anybody else with the same problem)
Thanks for any response
|
|
|
|
|
I ran into this problem a few years ago. I think the solution was to override GetWebRequest like this
override WebRequest GetWebRequest(Uri uri)
{
WebRequest request = base.GetWebRequest(uri);
request.ProtocolVersion = Version.Version10;
return request;
}
You probably have to do some casting and type checking for this to work, but I think this will do it.
I can imagine the sinking feeling one would have after ordering my book,
only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon
|
|
|
|
|
I want to be able to create 2 forms when I press a button. I am using the following code.
{
frmMy1 frm1 = new frmMy1();
frmMy2 frm2 = new frmMy2();
frm1.ShowDialog(this);
frm2.ShowDialog(this);
frm1.Dispose();
frm1.Dispose();
}
When I run this I have to close the first form before the second form is displayed. Is there any way to get them both up at the same time.
Thanks
Liam
|
|
|
|
|
There are two ways to show forms: modal and nonmodal. Modal means that the form being displayed must be closed before any further execution. This is like when you close Notepad before saving and it asks you if you would like to save. You MUST answer the question (and close the form) before you can click on the main notepad form or continue doing anything else in Notepad. This also means that your code blocks until that form is closed. In other words, frm2.ShowDialog(this); doesnt execute until frm1 is closed. The second, nonmodal, does not have these restrictions and is simply a normal form.
In .NET, the Form class has two methods, Show() and ShowDialog(). Show corresponds to a nonmodal form, and ShowDialog() corresponds to a modal form. To fix your problem, simply use Show() instead of ShowDialog().
|
|
|
|
|
Since ShowDialog() is a blocking call that returns a value, you can only have one Dialog open at a time. If you want both forms to be open, and usable at the same time, you'll have to show both forms using their Show() method, not ShowDialog().
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Ok I can see how Show instead of ShowDialog might work but I will add extra requirements.
Perhaps my requirements are that I want to ensure that frm1 is always above the main form. And also frm2 is always above frm1. Even if the main display is selected I do not want frm1 and frm2 to be lost behind the main form.
With a modal form this is the case but if it is modeless form then it looses that feature.
How do I get around it. I know this sounds silly but can I have a modal form that itseld creates a modal form? i.e. frm1 is modal based on the main form, and also frm2 is modal based on frm2?
Thanks,
Liam
|
|
|
|
|
Yes you can put a modal form on another (though in most cases it is not a correnct implementation)
In any way, is it necessary that frm1 will pop up and immediatly frm2 will pop up above it? or is frm2 dependent on an action in frm1 (which is a more likely option)?
If your case is the first case (i.e. frm1 should open an immediatly open frm2) - you should open frm2 from frm1's OnActivate method. just override it, call the base and open the frm2 using the ShowDialog method.
However, i recommend not doing so since it does not seem the right thing to do.
If you are using option 2 then there is no problem. When a certain event occurs in frm1 (such as button_click), simply open the frm2 and you will get a modal from on a modal form on your main form.
Good luck, hope this answers your question.
|
|
|
|
|
My exact situation is:-
Form1 is created from a button press on the main form.
Form2 is created on a timer event. When the timer elapes form1 may or may not be present. If not it should be created. If it is form2 is displayed.
But Form2 must always be at the top and main form always at the bottom. If I use modeless formas and select the main form then form1 and form2 are hidden - not what I want.
Thanks,
Liam
|
|
|
|
|
I didn't quite follow what the requirement is, but did you consider placing frm2 together with the main form in an MDI frame? This way they can remain open while still being non-modal. You can use docking on the MDI frame to dock the frm2 to the bottom and the set the main form to fill the rest of the screen.
Also if you can specify what are the roles of each form it might be easier to understand.
Good Luck!
|
|
|
|
|
I am drawing a polygon by drawing lines on mouseup. after closing the figure the two points are not behaving as one.
Where did i went wrong.
Any help
|
|
|
|
|
Begineer wrote:
after closing the figure the two points are not behaving as one
This is really vague. What do you mean by "not behaving as one"?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Sorry for not being able to explain my problem better.
I am drawing a polygon by positioning the mouse. when i choose the option close figure i am drawing a line from the current point to starting point.
After that it is not behaving as a closed figure. when i tried to drag i am able to drag two differnet lines on that last point.
Am i making sense.
|
|
|
|
|
Begineer wrote:
After that it is not behaving as a closed figure. when i tried to drag i am able to drag two differnet lines on that last point.
Try to drag what? One of the lines? Points? It sounds like your code isn't picking the correct points in your point array. Without seeing your drawing and dragging code, it's very difficult to say anything more.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Anyone know how to tell .NET to use another directory than /bin when it looks for referenced assemblies
I use "copy local" for all references ..... but want them to be copied into "bin/assemblies" for ex.
Anyone?
//Maw
|
|
|
|
|
Hello
You can try to use privatePath attribute. Look here[^].
With best regards,
Andrew
|
|
|
|
|
I'm currently working on a chart library project and encountered a conceptual problem touching interfaces, inheritance...
Facts first:
A so-called mapper class is responsible for mapping problem domain values to units (in terms of pixels). As there are different problem domains, there are different mapper classes, e.g.:
- MathMapper (numeric problem domain)
- TimeMapper (time domain)
- LabelMapper (non numeric domain)
This concept is implemented as follows. A interface called IMapper defines methods and properties all mappers have in common. (object globalMinimum, object globalMaximum, int minorUnitsPerMajorUnit, double pixelsPerUnit, double World2Unit(object obj)...).
Several interfaces are derived from IMapper to descripe specific mappers: IMathMapper, ITimeMapper, ILabelMapper. The derived interfaces define properties in terms of the problem domain:
- IMathMapper (double globalMinimum, globalMaximum...)
- ITimeMapper (TimeSpan globalMinimum, globalMaximum...)
...
This is the crucial factor: globalMinimum, globalMaximum... are defined in terms of the PROBLEM DOMAIN.
Classes implement the interfaces using explicit interface implementation thereby hiding the more general properties (object globalMinimum, object globalMaximum) and exposing the specific properties (double globalMinimum/TimeSpan globalMinimum...).
The properties mentioned so far should be known by the user (of the chart library) in advance. However for creating axes of dynamic range, the Maximum of a data series should be determined and stored in the mapper object (as MaxValue). Determing the maximum value is straightforward.
Given a series of data object[] dataSeries = new object[x] {12.9, 23.2, ...} the method World2Unit(object obj) of the underlying mapper object is invoked for each value, hence the maximum value can derived easily.
The challenge:
Problems arise when storing this maximum value in the mapper object. Currently this involves several type casts - not satisfying me. One has to distinguish between all possible mapper objects in order to store the value "problem domain dependent". Is there a way to avoid this discrimination? Sound solution needed!
Currently:
<br />
if (this.Mapper = MathMapper)<br />
{<br />
MathMapper math = (MathMapper) this.Mapper; <br />
math.MaxValue = (double) maximum; <br />
}<br />
else if (this.Mapper = TimeMapper)<br />
{<br />
TimeMapper time = (TimeMapper) this.Mapper; <br />
time.MaxValue = (TimeSpan) maximum; <br />
}<br />
else<br />
{<br />
each Mapper has to be listed.<br />
}
As it is my first major project and I'm not that experienced, could you please assist me in finding a better solution?
Thanks in advance!
Goebel
|
|
|
|
|
|
i wrote this code to create a marker file("TMP.txt) on another PC.
try
{
FileInfo TMPfile = new FileInfo(@"\\TERM1\\BOOTDRV\\TMP\\TMP.txt");
StreamWriter w = TMPfile.CreateText() ;
w.Close();
}
catch(Exception exp)
{
EventLog.WriteEntry(exp.Message);
}
Access to the path "\\Term1\\BOOTDRV\\TMP\\TMP.txt" is denied.
i wrote the same code in Windows Application and it's creating tmp.txt on term1.
*************
so with windows app i have access but not with windows services ?????
Please need help.
|
|
|
|
|
|
Windows Services, by default, run under the Local System account, which has no rights to any network resources on any machine. If you want your service to be able to get to a shared network resource, you'll have to change the account that the service runs under.
Right-click "My Computer" and click Manage. In the left pane of the MMC, expand Services and Applications. Click Services, then find your service in the right pane and double-click it. Click on the LogOn tab, then click on "This account". Type in the account name and password of an account that has permissions to the share you want the service to be able to get to, then click OK.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
