|
i create a s/w , by C# (visual studio) , at backend mySql. i create exe file which i create in visual studio.
so my Question is-
a)if i install the exe file in other computer then i have to install Mysql workbrench on that computer ?
b)if yes then how can i install it?
|
|
|
|
|
Don't post this in multiple places - it wastes time and annoys people.
You have it posted in QA, leave it there.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
No, you shouldn't have to. Presumably your exe is using MySQL 'driver' assemblies, so as long as they are distributed with your .exe you should be fine.
Regards,
Rob Philpott.
|
|
|
|
|
Hi
I need to populate a datatable with two fields from an xml file.<partnum> and <actualqtynum>
The file was obtained from a report that opens in a web browser, and the file saved from there.
DataTabel.ReadXml(XMLFilename) fails (complains about the ':' character in Line 2 of the xml file.)
I thought about using something like below, since I do have a complete list of the <partnum> in another table, but the <actualqtynum> is not a child node of <partnum> , and this also fails (complains about the ':' character in Line 2 of the xml file.)
public string GetKeyValue(string key)
{
System.Xml.XmlDocument xd = new System.Xml.XmlDocument();
xd.Load(_XMLFileName);
System.Xml.XmlNode Node = xd.DocumentElement.SelectSingleNode("/REPORTTABLE/REPORTTABLEDETAILS/PARTNUM add[@key=\"" + key + "\"]");
if ((Node != null))
{
return Node.Attributes.GetNamedItem("value").Value;
}
else
{
return null;
}
}
Any idea how I can get a list of PARTNUM with the corresponding ACTUALQTYNUM?
="1.0"="Shift_JIS"
="text/xsl"="../Bin/KITSCHREPFLEXA.xsl"
<DOCUMENT>
<REPORTHEADER>
<REPORTTIME>2014/07/11 13:36:44</REPORTTIME>
<CREATEBY>Fujiuser</CREATEBY>
<SCHEDULENAME>Week_23_2014</SCHEDULENAME>
</REPORTHEADER>
<REPORTTABLE>
<REPORTTABLEDETAILS>
<JOBNAMES><JOBNAME>260-C536000-PACE - Top_TLine 1 / Line 1 / Top / 1</JOBNAME></JOBNAMES>
<JOBNAMES><JOBNAME>260-C536000-PACE - Top_BLine 2 / VEK Line 2 / Bottom / 1</JOBNAME></JOBNAMES>
<DATANUM>38</DATANUM>
<PARTBARCODE>938-1030507</PARTBARCODE><ORIGINALPARTBARCODE>938-1030507</ORIGINALPARTBARCODE><PARTNUM>938-1030507</PARTNUM>
<SUPPLYNUM>2</SUPPLYNUM>
<ACTUALNUM>2</ACTUALNUM>
<REMAINSNUM>0</REMAINSNUM>
<QTYSUPPLYNUM>4</QTYSUPPLYNUM>
<QTYACTUALNUM>6249</QTYACTUALNUM>
<QTYREMAINSNUM>6245</QTYREMAINSNUM>
</REPORTTABLEDETAILS>
<REPORTTABLEDETAILS>
<DATANUM></DATANUM>
<PARTBARCODE>948-1025627</PARTBARCODE><ORIGINALPARTBARCODE>948-1025627</ORIGINALPARTBARCODE><PARTNUM>948-1025627</PARTNUM>
<SUPPLYNUM>2</SUPPLYNUM>
<ACTUALNUM>1</ACTUALNUM>
<REMAINSNUM>-1</REMAINSNUM>
<QTYSUPPLYNUM>40</QTYSUPPLYNUM>
<QTYACTUALNUM>6720</QTYACTUALNUM>
<QTYREMAINSNUM>6680</QTYREMAINSNUM>
</REPORTTABLEDETAILS>
|
|
|
|
|
|
Thanks for your reply Richard.
From W3.org it seems the file is possibly not 100% compliant
xml:stylesheet should be
xml-stylesheet
But even so, I eventually got hold of the stylesheet which did not have any Schema info.
Also tried DataSet.ReadXml as many posts on the net suggested where a schema was not available with no luck.
Ended up reading the file with StreamReader.ReadLine and picking out the values I needed with SubString(...)
|
|
|
|
|
Having to deal with defective XML files is always fun... My 5 for seeing that little difference.
Alternatively to your solution, write the file back line by line, just omitting the "bad" line. With that file, some tools could generate classes for its content, and thus making the access to the properties easier.
The Japanese encoding could cause some more fun later on, be prepared for that.
|
|
|
|
|
C# Code
using System;
using System.Collections;
namespace Loop_Test
{
public class ForLoopTest
{
static void Main()
{
int Ticks = 0;
int Bit = 0;
int Ask = 0;
int Bar1 = 22;
for(int i = 0; i < 22 ( Bit + Ask) ; i++)
Console.WriteLine("Bar1");
}
}
}
This is one of bar from 22 Ticks ,Stock bar chart (Bid,Ask,Open,High,Low, Close).
When bar close must have Variable (Bit&Ask) Total= 22;
Can somebody help me with this loop.
David.
|
|
|
|
|
A few things:
1) Do you want to loop until (Bit + Ask) = 22?
2) The value of Bit,Ask and Bar1 are not changing from 0
3) If you want to display the value of Bar1 then you should put Console.WriteLine(Bar1.ToString());
(Console.WriteLine("Bar1") will display 'Bar1' and not the value of the variable Bar1)
for (int i = 0; (Bit + Ask) < 22; i++)
{
Console.WriteLine(Bar1.ToString());
}
|
|
|
|
|
|
Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ?
I have face this problem many times. why sql server don't accept any format like C# datetime ?
|
|
|
|
|
I guess I am a little confused, I use MySQL and do not have to change the DateTime. are you just looking to place the Date in there?
|
|
|
|
|
SQL uses DateTime types which do not have a format; you should convert date strings to DateTimes before storing in the database.
|
|
|
|
|
Converting strings to dates in SQL Server depends on the current DATEFORMAT option[^]. This option will be one of mdy, dmy, ymd, ydm, myd, or dym; the default is mdy.
You should try to avoid converting strings to dates (or vice-versa) in SQL; that sort of code belongs in the user-interface code. However, if you absolutely have to specify a date as a string, you should use an unambiguous format - namely yyyyMMdd. Don't add any separators, as dates with separators are still liable to change based on the culture and settings.
MSDN has a list of the supported string literal formats for dates:
http://msdn.microsoft.com/en-gb/library/ms187819.aspx#sectionToggle1[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
The major problem is that SQL doesn't have a clue where the date is coming from: it is nearly always running on a different computer from the code that sent the date to the DB, and probably the user entered it on a third computer!
So what is is supposed to do with:
12/11/10 SQL doesn't have any access to cultural information about how the user is likely to have intended that, so it doesn't know if the year is 1912, 2012, 1911, 2011, 1910, or 2010 - or some other date system altogether, given that in the Iranian calendar (also known as Persian calendar or the Jalaali Calendar) this year is 1389, but it's year starts around 21st March in the Gregorian calender which complicates thinges even further.
Since is can't get it right - or even make an educated guess - it doesn't try. It expects you to do teh work for it, and either present it with a date in DateTime format already from your external code, or in ISO format: yyyy-MM-dd HH:mm:ss
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
When you insert / update data on the SQL Server, do not use a "simple" query which contains all values as strings. Use a parameterized query, and then add the parameter's value (as a C# DateTime value of course, not as a string!); the parameterized query will handle all those formatting quirks for you automagically!
|
|
|
|
|
I want to illustrate a set of linear 3D coordinates (x,y,z) using IlNumerics. I want to draw only the points. Is there any example?
Coordinates are stored in an Array like:
float[,] G = new float[,] { { 1f, 2f, 3f }, { 4f, 5f, 7f }, { 7f, 8f, 8f }, { 10f, 11f, 12f } };
#ilnumerics
modified 11-Jul-14 9:53am.
|
|
|
|
|
Ask the people who created it! They will know more than we will...
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
I'm trying to deploy the Crystal report engine to my installation package and I need to run the crystal report runtime package in silent no interface mode so does any one knows the commmand line to do that
|
|
|
|
|
Depends on the installer that the CR-engine uses to install. Which installer are you using? There's info on the merge-modules on MSDN[^] 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi!
I'm not sure if I try something which is impossible. I just want to pass any of the TryParse() methods (byte.tryParse(), int.TryParse(), ulong.tryParse() etc...) as parameter to a function. So a function receives what TryParse() method it should run.
Here is what I have in mind:
delegate bool TryParseHandler(string text, out object result);
static void Main(string[] args)
{
bool b = Check(byte.TryParse, "12");
bool i = Check(int.TryParse, "345");
}
static bool Check(TryParseHandler method, string text)
{
object result;
bool ok = method(text, out object result);
}
If it's possible to make a generic solution, it would be really nice! Maybe something like this:
delegate bool TryParseHandler<T>(string text, out T result);
static void Main(string[] args)
{
bool l = Check<long>(long.TryParse, "12345678912")
}
static bool Check<T>(TryParseHandler method, string text)
{
T result;
bool ok = method(text, out T result);
}
Any suggestions?
/Steffe
|
|
|
|
|
Your second code block is nearly there:
delegate bool TryParseHandler<T>(string text, out T result);
static bool Check<T>(TryParseHandler<T> method, string text)
{
T result;
return method(text, out result);
}
static void Main(string[] args)
{
bool l = Check<long>(long.TryParse, "12345678912");
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks!!!
Funny I managed to almost solve it by pure logic thinking and miss just one thing O_o
/Steffe
|
|
|
|
|
foreach (TabItem ti in MainWindow.mw.tcMain.Items)
{
if (Convert.ToInt16(ti.Tag) == r.id)
{
MainWindow.mw.tcMain.SelectedItem = ti;
return;
}
}
modified 11-Jul-14 3:44am.
|
|
|
|
|
Who write this code ask to him...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
