|
MySQLString = "INSERT INTO Bank_Details(Bank_Code,Bank_Name,Acc_No)" +
"VALUES('"+ txtBankCode.Text +"','"+ txtBankName.Text +"','"+ txtAccNo.Text +"')";
SqlConnection MySqlConn = new SqlConnection(MyConnectionString);
SqlCommand MySqlComm = new SqlCommand(MySQLString, MySqlConn);
MySqlComm.Connection.Open();
MySqlComm.ExecuteNonQuery();
MySqlComm.Connection.Close();
mwith wrote: And can anybody explain me, what are the good/bad coding practices with this?
When working with DB try your best to keep it simple.
Also, check the SQL statement if Bank_Code and Acc_No are 'int' data types then you need to convert the textboxes from string to int. i.e. Convert.ToInt32(txtBankCode.Text)
Good Luck,
Jason
-- modified at 12:01 Thursday 11th January, 2007
Programmer: A biological machine designed to convert caffeine into code. * Developer: A person who develops working systems by writing and using software.
[ ^]
|
|
|
|
|
Hello,
I am using the TreeView control in form application of C#.
I am having my own classes which are derived from TreeNode and i am adding the object of these classes to treeview as a node.
I want to serialize and deserialize the TreeView and i am doing it with BinaryFormatter object.
It get serialized properly but when i am loading it back it flashes an error "The constructor to deserialize an object of type 'MyTreeNode' was not found".
What else i need to add to get this done.
Thanks in advance
Gajesh
Pune(India)
-- modified at 2:17 Thursday 11th January, 2007
|
|
|
|
|
hi
friends i have an windows exe file
i want to knwo whether i can run exe without .netframework installed on the system or not
if it can be done how can i embeed the required dll's to my project....
thanking u ./.
byebye
|
|
|
|
|
This gets asked so often, and the answer is no. You can buy expensive frameworks that do it, but for the rest of us, we need to install .NET, that's a keo component of how it works.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Sure, don't develop it in .NET Winforms. Winforms are a joke.
|
|
|
|
|
Hi, Iam trying to parse XMLdata in c#.
please see the XMl data:
<response>1000 <message><mbit version="2"><share><id>29<title>up<description>up<file><id>26<name>up5454.bmp<type>allfiles<size>8910<checksum>9839B8107FF
3D117BDD67139D8318D29<chunks><chunk><id>45<checksum>9839B8107FF3D117BDD67139D8318D29
Iam using code:
XmlTextReader reader = new XmlTextReader(new StringReader(xmldata));
Exception coming while parsing due to xml declaration line.How to omit that line?Any idea?
Thanks
|
|
|
|
|
<?xml version="1.0" encoding="UTF-8"?>
<response>
<code>1000</code>
<message>
<mbit version="2">
<share>
<id>29</id>
<title>up</title>
<description>up</description>
<file>
<id>26</id>
<name>up5454.bmp</name>
<type>allfiles</type>
<size>8910</size>
<checksum>9839B8107FF3D117BDD67139D8318D29</checksum>
<chunks>
<chunk>
<id>45</id>
<checksum>9839B8107FF3D117BDD67139D8318D29</checksum>
</chunk>
</chunks>
</file>
</share>
</mbit>
</message>
</response>
Looks like your XML is valid. I wouldn't expect an exception because of the top item, not at all. What's the error ?
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Hi All
I Am interfacing a microcontroller from C3 the protocol i choose is modbus Do any one have an idea or code about the modbus in C#
SAs
|
|
|
|
|
So I have the current date in a string by doing this:
string date=DateTime.Now.ToShortDateString();
So on a single digit day/month it will show up without a leading zero. Like today for example:
1/10/2007
I was messing around with the format specifiers of toString but I cant figure out a way to get a leading zeros on single digit days. How can I do this short of some string spitting.
/\ |_ E X E GG
|
|
|
|
|
Using the ToShortDateString is causing your problem. This call uses the Short date format specified in the "Regional and Language Options" control panel.
To have complete control over how the string is formatted, you would want to use the ToString method and pass in the format string. For your example, the call would look like this:
string date = DateTime.Now.ToString("MM'/'dd'/'yyyy");
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
OK, thanks I didn't know it was that flexable!
/\ |_ E X E GG
|
|
|
|
|
No problem. Most of the ToString methods, particulary on the DateTime and native numeric data types (int, short, etc.), take some sort of format string.
Here is the MSDN page that will give you information on all of the different formatting options available for the different data types:
http://msdn2.microsoft.com/en-us/library/fbxft59x.aspx[^]
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
This is a repost as I didn't get a reponse to my last one and I still can't get this thing to run through. Well I lie. It ran through fine once, but since then I've been getting this contextSwitchDeadlock issue, but I haven't modified the code!
Anyone have any ideas?
/TH
<br />
Hi All,<br />
<br />
I'm slowing finding my way around C#.<br />
<br />
I have written an application that takes a directory, take each file in that directory and also each file in each subdirectory, and then trys to find any files with the same name<br />
<br />
(Trying to clear up all my duplicate photos )<br />
<br />
SO I have written the code, and checked it and checked it again, it does not get caught in an infinite loop.<br />
<br />
But when I F6 the app it comes up with a ContextSwitchDeadlock MDA issue.<br />
|
|
|
|
|
My friend...
Even though I've never faced a contextSwitchDeadlock, but I think that googling[^] is a very healthy practice.
Regards
|
|
|
|
|
Hi Nader,
I tried that. found something about setting it to "Full Trusted" which i tried, but that did not resolve it.
Thanks for the help though!
|
|
|
|
|
|
Though I don't like that solution, but here is a link to something that may help. Click here[^].
PS.
If you are mulithreading, then getting this exceptions means that you've done something wrong, and ifnoring it isn't quite the best thing to do.
Regards
|
|
|
|
|
LOL Great minds think a like
Its not threading its quite procedural, so this should suffice.
I'll see if it blows up when I get it into production. Then it might be back to the drawing board.
/TH
|
|
|
|
|
There is a program calling a C++ dll named "ffisamp.dll".
The C++ code is as follows:
*****
//Simple C function that just puts something in a string
// and returns the length of that string both as the RC and as a param
// Keeping the C interface as simple as possible.
__declspec( dllexport ) int PopulateString ( char *FormsBuffer, int *BuffLen)
{
int LocalLength;
strcpy(FormsBuffer,"A Fixed string from within the C program");
*BuffLen = strlen(FormsBuffer);
LocalLength = strlen(FormsBuffer);
return LocalLength;
}
*****
I need C# code that will compile to a dll that mimics the sample dll such that no modifications will need to be made to the calling program. I need to be able to just replace the old dll with the new one.
I am most perplexed that the C++ method is not in a class. That might be that the source code is just a snippet of the whole dll's source code... since it comes from a sample, but I have the impression from the documentation that is all of it. Here is a link to the article I am working with. I am trying to communicate with an Oracle 10g form using methods to call C functions.
http://www.oracle.com/technology/products/forms/htdocs/webutil/howto_ffi.html[^]
I've tried a few things, but so far the calling application doesn't even find the function.
I am not familiar with C++, MFC etc... so I am sure I am missing some fundamentals.
|
|
|
|
|
AFAIK that's not possible.
C# is managed code, while C++ is unmanaged code. Data and object marshaling in both is very different -not to mention the structure of the dll file, and the method of function exporting-.
Regards
|
|
|
|
|
While I don't know much about C# I am aware that MS went to some effort to make managed code and native code interoperate. I’d be willing to bet it is possible.
Steve
|
|
|
|
|
Stephen Hewitt wrote: I’d be willing to bet it is possible.
If you do, then why didn't you tell us how to do it!
Yes, it's possible somehow, but not in his scenario. You may mean the COM wrapper of DotNet that enables you to make your objects COM visible. He wants to make a C# dll for a program that references a C++ dll without COM, and my bet is that the program doesn't expect a managed code either. Also note that the function doesn't belong to a class which is not allowed in C#.
Regards
|
|
|
|
|
Here's what I said:
Stephen Hewitt wrote: While I don't know much about C# I am aware that MS went to some effort to make managed code and native code interoperate. I’d be willing to bet it is possible.
Nader Elshehabi wrote: If you do, then why didn't you tell us how to do it!
Isn't the answer to this question obvious? "I don't know much about C#". I don't know how, it's just my opinion that it’s possible. What’s more, I’d wager it’s not that complex.
Steve
|
|
|
|
|
As already explained by others, C# can only produce managed code, while your sample is an unmanaged DLL. There are several ways to implement managed-unmanaged interoperability, but there is no simple solution for what you want to do.
One idea that come to my mind requires the creation of two DLLs:
One unmanaged C++ DLL that exports your required method and transforms it into a COM method call. And a COM server DLL that provides the method consumed by the first DLL. The second DLL can be written in C# as managed DLLs can be designed to be callable by COM clients (CCW).
Regards,
Tim
|
|
|
|
|
Well, I actually expected it was the case that I could not fully duplicate the external behavior of a C++ dll, but I wanted to make sure.
The C++ wrapper dll occurred to me and would be possible since we have C++ developers, but it is not a good solution.
Ultimately the problem was solve in another manner. We are communicating through he standard output stream and it works great.
Thanks for everyones comments.
|
|
|
|