Shorten the String - C# Discussion Boards

MrJJKoolJ1-Jun-04 6:13

1-Jun-04 6:13

Hi,

I need to send changes to database in web service sitting on another machine with DB. I was thinking of using the following code in order to
do the update:

<br />
<br />
SqlConnection myCon = new SqlConnection(sCon1);<br />
SqlDataAdapter da = new SqlDataAdapter();<br />
<br />
da.SelectCommand = @"INSERT INTO MidnightReadings " +<br />
                   "(MR_Date, Coal_Feeder_Tot, Coal_Silo_Level_Prct, Coal_Barn_Inv_Prct, Limestone_Feed_Total, LS_Silo_Level_Prct, Ammonia_Totalizer, " +<br />
                      "Prop_to_Burn_Totalizer, TwentyFourHr_SO2_Reduct, Limestone_Received, Ammonia_Received, Prop_Received, Est_hours_Dry_Oper_Hours, " +<br />
                      "Est_hours_Dry_Oper_Mins, LAB_Sulfur_Content_Prct, LAB_High_Heat_Val, CEMS_SO2_Daily_Avg, SO2_Daily, Raw_Water_Pump_Meter, " +<br />
                      "Reservoir_Level, Comments, Date_Rec_Added) " +<br />
					  "VALUES(@MR_Date, @Coal_Feeder_Tot, @Coal_Silo_Level_Prct, @Coal_Barn_Inv_Prct, @Limestone_Feed_Total, @LS_Silo_Level_Prct, " +<br />
                      "@Ammonia_Totalizer, @Prop_to_Burn_Totalizer, @TwentyFourHr_SO2_Reduct, @Limestone_Received, @Ammonia_Received, @Prop_Received, " +<br />
                      "@Est_hours_Dry_Oper_Hours, @Est_hours_Dry_Oper_Mins, @LAB_Sulfur_Content_Prct, @LAB_High_Heat_Val, @CEMS_SO2_Daily_Avg, " +<br />
                      "@SO2_Daily, @Raw_Water_Pump_Meter, @Reservoir_Level, @Comments, @Date_Rec_Added); " +<br />
                      " SELECT MR_ID, MR_Date, Coal_Feeder_Tot, Coal_Silo_Level_Prct, Coal_Barn_Inv_Prct, Limestone_Feed_Total, LS_Silo_Level_Prct, " +<br />
                      " Ammonia_Totalizer, Prop_to_Burn_Totalizer, TwentyFourHr_SO2_Reduct, Limestone_Received, Ammonia_Received, Prop_Received, " +<br />
                      " Est_hours_Dry_Oper_Hours, Est_hours_Dry_Oper_Mins, LAB_Sulfur_Content_Prct, LAB_High_Heat_Val, CEMS_SO2_Daily_Avg, " +<br />
					" SO2_Daily, Raw_Water_Pump_Meter, Reservoir_Level, Comments, Date_Rec_Added FROM MidnightReadings WHERE (MR_ID = @@IDENTITY)";<br />
<br />
SqlCommandBuilder cb = new SqlCommandBuilder(da);<br />
				<br />
da.Update(dsDiff,"MidnightReadings");<br />
myCon.Close();<br />
<br />

Does the code look correct for building my update?

Heath had said this is the most efficient way in order to update db.
As you can see my insert statement is big. Is this common to have such a
big sql statement or is there a short version I should be using?

Thanks,
JJ

Re: Setting Up Update

flow55551-Jun-04 6:24

flow5555

1-Jun-04 6:24

As far as the length of the command is concerned, the more information you get into one command is better, since you don't have to reopen the sql connection, and execute multiple commands after each successive command is executed. So, its perfectly fine to do so.

Re: Setting Up Update

MrJJKoolJ1-Jun-04 8:16

MrJJKoolJ

1-Jun-04 8:16

Hi,

With the way I have this setup do I also have to add parameters to the DataAdapter for each of the values?

JJ

Re: Setting Up Update

flow55551-Jun-04 11:22

flow5555

1-Jun-04 11:22

yea, you definately want to do that!

How to hide a form if the user close it?

Ariadne1-Jun-04 6:07

Ariadne

1-Jun-04 6:07

If the User hit's the "Close Window"-Button (on the right upper corner) the window should be hide.

How can I stop the closing process and set a this.Hide(); command?

Thanks!
D'Oh! | :doh:

Ariadne

Re: How to hide a form if the user close it?

LongRange.Shooter1-Jun-04 6:37

LongRange.Shooter

1-Jun-04 6:37

You want to setup an EventHandler that will handle the ClosingEvent in the form. To be capable of closing the form eventually, you need to manage the state of shutdown. (Was it invoked by me or was it invoked via the X button being clicked?) A [Close] button would handle the actual shutdown and the Closing event handles what to do based on the current state of the form.
So you have something like this:

using System.ComponentModel;
...
this.Closing += new CancelEventHandler(this.ClosingEventHandler);
bool ShutDownInvoked = false;
...
public void CloseRequested_Click(object sender, EventArgs e)
{
    ShutDownInvoked = true;
    this.Close();
}
public void ClosingEventHandler(object sender, CancelEventArgs e)
{
    if (ShutDownInvoked)
       return;
    this.Hide();
    e.Cancel = true;
}

______________________________
The Tao gave birth to machine language.
Machine language gave birth to the assembler.
The assembler gave birth to ten thousand languages.
Each language has its purpose, however humble.
Each language expresses the Yin and Yang of software.
Each language has its place within the Tao.
Beauty exists because we give a name to C#.
Bad exists because we give a name to COBOL.

Re: How to hide a form if the user close it?

Heath Stewart1-Jun-04 6:45

Heath Stewart

1-Jun-04 6:45

Handle the Form.Closing event (or override OnClosing in a derivative class), set CancelEventArgs.Cancel to true and call Hide:

public class MyForm : Form
{
  // ...
  protected override void OnClosing(CancelEventArgs e)
  {
    e.Cancel = true;
    Hide();
  }
  // Make sure you have a menu or some other way to close the form, though.
  private void mnuFileExit_Click(object sender, EventArgs e)
  {
    // The handler for a <code>MenuItem</code> to exit the application...
    Application.Exit();
  }
}

There's other things you can do, such as handling the proper Windows messages like WM_QUERYENDSESSION or WM_ENDSESSION, but you may not have to (and familiarity with Windows messaging is helpful).

Microsoft MVP, Visual C#
My Articles

Shorten the String

Adam °Wimsatt1-Jun-04 5:22

Adam °Wimsatt

1-Jun-04 5:22

This has been done so many times it's not even funny, but what is funny is I can't figure out the correct phrase to type into google to find my answer. I need to shorten a paragraph of text into a summary of about 20 to 25 words followed by '...'. Using C# of course. What phrase would you use in google to search for such a method?

I made my own kewl little solution... let me know if you can think of a better way ...

<br />
string temp = mystring;<br />
if (temp.length > 200) // only do it if temp has more then 200 chars<br />
{ <br />
  temp = temp.substring(0, 200); // gives me a maximum of 200 chars<br />
<br />
  // find the last space and put the '...' there.<br />
  temp = temp.substring(0, temp.lastIndexOf(" ")) + "...";<br />
}<br />

Re: Shorten the String

LongRange.Shooter1-Jun-04 8:13

LongRange.Shooter

1-Jun-04 8:13

int len = mystring.Length > 200? 200: mystring.Length;
string temp = String.Concat(mystring.SubString(0, len), "...");

How do compile a dll and load it to the assembly in runtime?

Louis Riel1-Jun-04 5:12

Louis Riel

1-Jun-04 5:12

I am building a "generic" web service testing app in c#. The way I have it working now is I add the Web Reference in the IDE and compile. The prog will go type discovering for any class that inherits System.Web.Services.Protocols.SoapHttpClientProtocol in the assemblies of the current domain. It then lists out the methods and associated params available in that class. It will also get the definition for all the classes the respective namespaces of the WS classes and provide an "editor/viewer" of those complex types to either view return values of method calls or create instances of those complex types for use as input parameters to the web method.

What I would like is for my app to be able to:
- call wsdl to generate the .cs for for the web sevice (already done and working) Big Grin | :-D

- call csc to compile it into a library (already done and working) Big Grin | :-D

- Load the dll in the current assembly so that it "typed discovered" and instinciated. (type discovering works but instinciation raises a TargetInvokationException) Confused | :confused:

I get the dll as a byte[] and then load it with AppDomain.CurrentDomain.Load(rawAssembly). The assembly load correctly, the types are browseable but I can't instinciate them.

Thanks for your time, Louis.

My witty signature.

Re: How do compile a dll and load it to the assembly in runtime?

Heath Stewart1-Jun-04 6:36

Heath Stewart

1-Jun-04 6:36

There was a recent article in MSDN that covers the two alternatives and how to use them. See Code Generation in the .NET Framework Using XML Schema[^]. It also discusses building types from WSDL - which of course you compile into an assembly - though it leaves much of the implementation to the reader. The basics are discussed.

If you're new to building assemblies (building types and filling in IL, aka "Reflection emit") or using the CodeDom, read Emitting Dynamic Assemblies[^] and Generating and Compiling Source Code Dynamically in Multiple Languages[^].

Why do you need to build an assembly to dynamically invoke methods on an XML web service, though? The classes already support configuring a class and you can always use HttpSimpleClientProtocol.Invoke to invoke methods (and properties, since they're just getter and/or setter methods). See the System.Web.Services.Discovery namespace documentation in the .NET Framework SDK for more information about classes and methods which help you discover information at runtime that you can use to "build" and invoke methods on the XML Web Service without having to compile an assembly at all.

Microsoft MVP, Visual C#
My Articles

Re: How do compile a dll and load it to the assembly in runtime?

Louis Riel1-Jun-04 9:12

Louis Riel

1-Jun-04 9:12

The reason I wanted to go with a compile approach is that I am more familliar with type discovery than I am with code generation using XSD. The main reason why I compile the assembly is go get the definition of the complex types to provide the user with an editor and so, I need the definition of the classes. I got that from the Type definition. Also, I use the Parse function of ValueType types to easily convert from a string to the actual type. I will look into using the type builder from xsd and then use them in the call to HttpSimpleClientProtocol.Invoke if need be. It would have been nice though to consume a DLL that is build for you by .NET SDK tools instead of parsing the WSDL and build the types in code.

Thanks, Louis.

Re: How do compile a dll and load it to the assembly in runtime?

Heath Stewart1-Jun-04 9:18

Heath Stewart

1-Jun-04 9:18

Instead of using Parse, use the TypeConverter. Often, the TypeConverter for a particular Type will use a Parse method if it exists, but using a TypeConverter (which you can get using TypeDescriptor.GetConverter) is abstract.

Also, what I mentioned before is that the classes in the .NET FCL already do the discovery for you, providing method names along with their parameters. Than all you have to do is use Invoke. Generate a source file for an XML Web Service in VS.NET, for example. Then show hidden files in your project and look at the source code. You'll see this is all the source code contains.

Compiling and loading assembly has further overhead because not only is it unnecessary, but you can't unload an assembly from your AppDomain. So, if someone uses your application for a while with many different web services, the machine will be at a loss for memory and - even with proper disposing and garbage collection (though you should rarely force it) - your application will grind the system to a halt (or slow enough that users may think the machine has froze).

Microsoft MVP, Visual C#
My Articles

Re: How do compile a dll and load it to the assembly in runtime?

Louis Riel1-Jun-04 9:49

Louis Riel

1-Jun-04 9:49

Thank you for the TypeConverter tip. I will change my prog to use the approach you pointed out (instead of generating code then Frankenstein on to my running program). It is a much better/.NETy approach than what I was going for. Thank you for taking the time to point me in the right direction.

Thanks, Louis.

Re: The Error

Peter Vertes1-Jun-04 4:15

Peter Vertes

1-Jun-04 4:15

There is no namespace called Microsoft.Win32.Interop. Instead just use Microsoft.Win32.

-Pete

How do I get a full list of assemblies and their versions of the GAC??

IrishSonic1-Jun-04 3:16

IrishSonic

1-Jun-04 3:16

Hiya

How do I get a full list of the assemblies stored in the GAC and their assembly info?? I can get an assembly info using LoadFrom().

Some code would be most helpful.

Thanks.

Re: How do I get a full list of assemblies and their versions of the GAC??

Dave Kreskowiak1-Jun-04 4:42

Dave Kreskowiak

1-Jun-04 4:42

Try here[^] for a start...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

tooltip problem

gulucay1-Jun-04 3:13

gulucay

1-Jun-04 3:13

Hi everybody,

I have created a custom user control(#1). It has textboxes on it. But these textboxes are custom user controls(#2) too. Input to those textboxes can be masked (string,number or character). I set tooltips on these textboxes. When I put my user control(#1) to a form tooltips can be shown. But on one form tooltips could not be seen on run time(At design time it can be show). I could not find anything about the reason. Can anybody help me?

Please advice best TreeList controls for .NET ?

vgrigor1-Jun-04 3:09

vgrigor

1-Jun-04 3:09

Please advice best TreeList controls for .NET ?
I need to choose what to buy.

DevExpress suite -to compare with.

What is else best graphical suites there are on market for .NET ?

Thanks.

What is the best from that : ?
http://www.componentsource.com/Catalog.asp?fl=&gf=+BUSFUNCLISTCO&gd=Treeview+and+List&bc=&sc=CS

Re: Please advice best TreeList controls for .NET ?

Heath Stewart1-Jun-04 6:27

Heath Stewart

1-Jun-04 6:27

I've always liked XtraTreeList from Developer Express, which you mentioned. You already have a list it seems of tree views. What's best is what fits your requirements for the cost you're willing to pay.

Microsoft MVP, Visual C#
My Articles

Re: Please advice best TreeList controls for .NET ?

vgrigor1-Jun-04 22:01

vgrigor

1-Jun-04 22:01

It is better to pay twice if abilities of control is twice,
due to next work will be too easy with same control,
but not new one need with new learning curve,
and new curve to conect them and loose consistency.

Need good control for most basic functions and most
need in advanced programing.

Re: Please advice best TreeList controls for .NET ?

Heath Stewart2-Jun-04 2:43

Heath Stewart

2-Jun-04 2:43

Not if you won't use those extra features. The Developer Express XtraTreeList is a very extensible control, as are most third-party controls on the market. The best way to determine which is best is to download the trials (they all have them) and try them out. Again, it comes down to whether or not a component fulfills your requirements that determines whether it's a good component. Only you can answer that question.

Microsoft MVP, Visual C#
My Articles

Re: Please advice best TreeList controls for .NET ?

vgrigor3-Jun-04 4:54

vgrigor

3-Jun-04 4:54

Thanks you for qualified respond.

This control lookinsatisfying our basic requirements,
but task - is to satisfy best, most usual features,
to enchance controls, in the future..
That is about experience who used this controls,
or know something.

This control is
Best - strategy for productivity in the future in common ?

problems binding my combobox

robmays1-Jun-04 1:16

robmays

1-Jun-04 1:16

I have a combobox populated from a DataTable setting the DispalyMember and Value member properties. I want to set the selectedText to a text value i get from a table in a database which is one of the values of my Displaymembers in the comboBox?

Re: problems binding my combobox

Heath Stewart1-Jun-04 6:24

Heath Stewart

1-Jun-04 6:24

Programmatically set it. After setting your data source and binding your control, you can set the SelectedIndex to 0 or whatever index you want (based on where your would-be text is stored in the DataTable). This also depends on the DropDownStyle for the ComboBox. For the default - ComboBoxStyle.DropDown - SelectedText is only text that is selected - it does not necessary represent text in the ComboBox as an item. For example, if you typed some arbitrary text in your ComboBox and selected it, that would be the SelectedText. If you only want choices available to the user that are in your DataTable, then you should set ComboBox.DropDownStyle to ComboBoxStyle.DropDownList.

Microsoft MVP, Visual C#
My Articles

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.