Re: Double seperator disappears upon insert in DB - C# Discussion Boards

Double seperator disappears upon insert in DB

7-Jun-07 5:02

That is quiet hard to achieve. This basically means that you have to override the Windows execute functions. When you click on a program binary ( exe ) Windows initiates the execution of the program and executes the code in that binary. There is no function that can neither interrupt the execution nor interrupt the executed code in the binary.

A possible way around it , is to disable all binaries, or set the permission of the binaries ( eg. winword.exe ) so that only a particular user is allowed to execute it. Then write yourself a little wrapper that is allowed to execute the binaries after you prompted for a password.

Cheers,

Re: Password Permission

Dan Neely7-Jun-07 7:29

Dan Neely

7-Jun-07 7:29

the site appears down at the moment, but the secure process utility from Stardock's Thinkdesk Suite[^] might be able to do what you want.

--
You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer

Rick van Woudenberg7-Jun-07 3:37

7-Jun-07 3:37

Dear all,

I'm trying to insert a double value in a database. To my understanding a double value can exist of eg. 23.45
When I insert a double value ( 23.45 ) into my postgres database, the seperator dissapears and the value in the table becomes 2345. The table in the database is of type Double Precision.

I have to use Double, instead of decimal since a library is demanding a double value as input.

Can anyone point me in the right direction ? How can I store the value so that the dot is there as well. ( 23.45 )

Kind regards,

Ian Shlasko7-Jun-07 4:38

Ian Shlasko

7-Jun-07 4:38

Without seeing some actual code, it's hard to diagnose your problem. The only thing I can think of is that maybe there are localization settings coming into play, which would require you to use a comma (,) instead of a decimal point (.)

I would suggest that to avoid this, you use parameterized queries instead of just using string parsing to insert the value.

Rick van Woudenberg7-Jun-07 5:26

7-Jun-07 5:26

Hi Ian,

Thank you even giving it a go Smile | :)

This is basically what I am doing :

private void btnRunwaySet_Click(object sender, EventArgs e)<br />
        {<br />
            <br />
          //grab some stuff from the registry as value for my query<br />
<br />
          RegistryKey key = Registry.CurrentUser.OpenSubKey("Software\\TestApp\\DBSettings", false);<br />
            if (key == null)<br />
            {<br />
                key = Registry.CurrentUser.CreateSubKey("Software\\TestApp\\DBSettings");<br />
            }<br />
            else<br />
            {<br />
                object db;<br />
                db = key.GetValue("name");<br />
                lbl.Text = db.ToString();<br />
            }<br />
            <br />
            //convert the textbox input to Double ( for insertion in DB )<br />
            <br />
            Double a = Convert.ToDouble(textbox.Text);<br />
<br />
            //Chuck it all in the database<br />
<br />
            NpgsqlConnection conn = new NpgsqlConnection("Server=" + txtDBip.Text + ";" + "Port=" + txtDBPort.Text + ";" + "User Id=" + txtDBuname.Text + ";" + "Password=" + txtDBPasswd.Text + ";" + "Database=jordan;");<br />
            conn.Open();<br />
            NpgsqlCommand command = new NpgsqlCommand("INSERT INTO (table(column)) VALUES (" + a + ") WHERE (anothercolumn) = '" + lbl.Text"'", conn);<br />
            command.ExecuteNonQuery();<br />
            conn.Close();

The column of the table is of type double precision to avoid an invalid cast exception. Now, any value given in textbox will be converted to Double and then inserted in the database. I suspect something is going wrong during the conversion from String to Double.

If I insert the Double value eg. 887.23 into the textbox, the string value 887.23 is converted to Double. The funny thing is, that when I covert it right back to string :

anothertextbox.Text = a.ToString();

or

anothertextbox.Text = Covert.ToString(a);

the values that shows up in anothertextbox is 88723. So I assume this is more of a math thing then a database error. The database is simply accepting and inserting the presented Double value.

I'm quiet puzzled actually.

Ian Shlasko7-Jun-07 12:01

Ian Shlasko

7-Jun-07 12:01

Ahhh, ok, I see. Simple problem. Convert.ToDouble is meant to be used to convert from other numeric types, or from a number boxed in an object. It's not a string parser.

What you're looking for is double.TryParse()

Double a;
if (!double.TryParse(textbox.Text, out a))
  throw new ArgumentException("Type a number");

If you check the API for TryParse, you'll see it tries to convert a string to a double, placing the result in the second argument. It returns true if it succeeds, so if it comes back as false, the person typed something non-numeric.

Convert.ToDouble was probably just grabbing every digit character and stuffing them together.

Rick van Woudenberg8-Jun-07 13:07

Check Box inside a datagrid in VS2003

8-Jun-07 13:07

Ian,

Thank you for your reply. it works. I implemented your solution and it all runs smooth now. Thanks a lot !!

However, your comment about Convert.ToDouble not being a string parser pursueded me to go down a different path. I tricked the database by presenting it with a string value for insertion into a double column. I was expecting a Cast Exception, but it went in happily, as long as the string value is in the double form, eg. 88,543. Any other form will be rejected. I'm just wondering if this a bug in Postgres or that the database is unable to distinguish a string value ( written as double ) from a true double value.

After I grabbed the string value back from the database, I converted it into a double :

Double aa;<br />
aa = (Double)cmd1.ExecuteScalar();

And the value was in the correct format ( 88,543 ).
However, I prefer your solution, and I'm using it.

[Message Deleted]

Ankit Aneja7-Jun-07 3:07

Ankit Aneja

7-Jun-07 3:07

[Message Deleted]

Re: Filename.indexof

Sathesh Sakthivel7-Jun-07 3:12

Sathesh Sakthivel

7-Jun-07 3:12

Ankit Aneja wrote:
if(filename.indexof("FIX")!=-1)

if(filename.indexof("FIX")!=0)

Now it is Possible.

Regards,

Satips. Rose | [Rose]

Re: Filename.indexof

Anthony Surendran7-Jun-07 3:20

Anthony Surendran

7-Jun-07 3:20

Have to tried the possibility of small / caps change.?

Rate This Message.

Thank You,
A.Surenth.

Anthony Surendran7-Jun-07 2:38

Anthony Surendran

7-Jun-07 2:38

Hi,
I have a situation where I have to have a check box inside a Data grid.
And the datagrid will be filled by set of rows from a database. selecting a check box should enble me to find the exact row in the databse.

I tried a number of articles. But nothing could do what exactly I want.
Can any one help me out.

Environment: VS2003.
Thanks in advance

Rate This Message.

A.Surenth.

Re: Check Box inside a datagrid in VS2003

SimulationofSai7-Jun-07 3:26

SimulationofSai

7-Jun-07 3:26

Anthony Surendran wrote:
selecting a check box should enble me to find the exact row in the databse.

This is easiest when your table has a primary key defined.

Make sure the data that populates the grid also has the primary key returned. You can bind the primary key to a hidden column in the grid and use that as a future reference to find the corresponding row in the table.

.NET C# server and VC++ client

Kabirdas Jaunjare7-Jun-07 2:31

Kabirdas Jaunjare

7-Jun-07 2:31

hellow friends....
i have developed ASP.NET Services and i want to use this services in my VC++ client but i m not getting result although i m able call method correctly using SOAP .. but result is not proper.?
plz tell me where i m making mistake...

//ASP .NET services..
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;

[WebService(Namespace = "http:/www.WbService07Name.com/webServices/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class ClsService07 : System.Web.Services.WebService
{
public ClsService07()
{

//Uncomment the following line if using designed components
//InitializeComponent();
}

[WebMethod]
public double DoAdditon(double a, double b)
{
return (a + b);
}

}

///vc++ client
void DisplayAdd()

{
try
{
ISoapSerializerPtr Serializer;
ISoapReaderPtr Reader;
ISoapConnectorPtr Connector;

cout<<"test display:main\n";

// Connect to the service
Connector.CreateInstance(__uuidof(HttpConnector30));
Connector->Property["EndPointURL"] ="http://localhost:2014/WebService07/Service.asmx";
Connector->Connect();

Connector-> Property["SoapAction"] = "http:/www.WbService07Name.com/webServices/DoAdditon";

// Begin message
Connector->BeginMessage();

// Create the SoapSerializer
Serializer.CreateInstance(__uuidof(SoapSerializer30));

// Connect the serializer to the input stream of the connector
Serializer->Init(_variant_t((IUnknown*)Connector->InputStream));

// Build the SOAP Message
Serializer->StartEnvelope("","","");
Serializer->StartBody("");
Serializer->StartElement("DoAdditon",L"http://localhost:2014/WebService07/Service.asmx/","","");

//Serializer->startElement("Add","uri:Calc","","m");
Serializer->StartElement("a","","","");
Serializer->WriteString("5.9");
Serializer->EndElement();

Serializer->StartElement("b","","","");
Serializer->WriteString("10.8");
Serializer->EndElement();

Serializer->EndElement();
Serializer->EndBody();
Serializer->EndEnvelope();

// Send the message to the web service
Connector->EndMessage();

// Let us read the response
HRESULT hr = Reader.CreateInstance(__uuidof(SoapReader30));

// Connect the reader to the output stream of the connector
Reader->Load(_variant_t((IUnknown*)Connector->OutputStream), "");

printf("Answer: %s\n",(const char*)Reader->RpcResult->text);

BSTR br;
Reader->RpcResult->get_text(&br);

cout<

Help with config file error

ttohme7-Jun-07 2:27

ttohme

7-Jun-07 2:27

I have an app.config file that looks like this:

<configuration>
<appsettings file="ClassLibrary1.dll.config">
<appsettings file="ClassLibrary2.dll.config">

This use to work fine in VS 2003, when I migrated to VS 2005 I started getting this error :
" Configuration system failed to initialize"
"Sections must only appear once per config file"

Anyone knows how can I fix this???

Thanks in advance.

Sathesh Sakthivel7-Jun-07 2:33

Sathesh Sakthivel

7-Jun-07 2:33

ttohme wrote:
" Configuration system failed to initialize"

when I changed the settings available in My.Settings - what I found in my case was that one of the changes I had made had added a StringCollection and it needed a try-catch block to create a new instance the first time around if it didn't exist.

That, plus I had corrupted the user.config file.... when I deleted that it wrote a new one and started working fine.

ttohme wrote:
"Sections must only appear once per config file"

To get your code to compile without the warnings, you'll need to replace your call to
System.Configuration.ConfigurationSettings.GetConfig("systems")
with
System.Configuration.ConfigurationManager.GetSection("systems")

This new type lives in the System.Configuration.dll assembly so you'll also need to add a reference to this assembly to your project.

To migrate your v1.1 configuration section handler to v2.0, you'll need to re-write your sectionHandler using the new Configuration system base classes which live in the System.Configuration namespace in the System.Configuration.dll assembly. You'll need to use the following classes: ConfigurationSection, ConfigurationElement and ConfigurationElementCollection.

Here's a pretty good link that blogs how to create your own sectionHandler:
Get it[^]

Regards,

Satips. Rose | [Rose]

ttohme7-Jun-07 2:58

ttohme

7-Jun-07 2:58

I'm not getting compile errors, I did switch to using ConfigurationManager.

My problem, is that in the old config file I referenced multiple config file in the app.config which means I could access other projects config file setting in the main application, now VS 2005 is complaining the having multiple <appsettings> sections is not allowed.
I need to know how can I modify my config file so it can still reference multiple configuration files.

Thanks

Sathesh Sakthivel7-Jun-07 3:02

Sathesh Sakthivel

7-Jun-07 3:02

ttohme wrote:
now VS 2005 is complaining the having multiple sections is not allowed.

Yes.

ttohme wrote:
I need to know how can I modify my config file so it can still reference multiple configuration files.

Please modify the config file into a single config file and run your application.

Regards,

Satips. Rose | [Rose]