|
Please Post it in MySql Discussion Forums
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
Windows error code 10048 is a Windows Sockets error code, WSAEADDRINUSE. This error means that the IP address/port combination selected is already in use. Normally, client code does not explicitly select a port, so this would indicate that the number of dynamic ports available has been exhausted. This, in turn, would suggest that connections are being leaked, either by your web site or some other application.
Assuming that the MySql data provider follows the pattern of the Microsoft-supplied providers, I would ensure that you call Dispose on your connection objects when you've finished with them. To make this happen automatically, use a using block; the compiler will generate a call to Dispose at the end of the block for you. You should also call Dispose on any other objects that have a Dispose method, or implement the IDisposable interface, when you've finished using them. The SQL Server Data Provider classes SqlCommand, SqlTransaction and SqlDataReader also implement IDisposable; you may find that the MySql equivalents also do.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
hi, i have a program which i always try to execute it in another windows.
that win has not crystall report,i affect with an error : "windows could not find many file such as crystall engin and etc", i have added this files but for a file as call as keycodev2.dll windows show a message : (file is invalid).
what is the matter? i copy it from visual studio cd why it is invalid?
|
|
|
|
|
Possibilities:
You don't have crystal installed in your system.
if it is installed then you have to add refrences of crystal program in your application.
Go to 'project'->refrences->com
First select Crystal Reports Library
if the programs runs succesfully. Then do your work. Other wise add all crystal refrences in the refrences dialog box.
|
|
|
|
|
I’m about to start a new project on an application that fore sure will be under development for about 3-4 years. I will start with an C# 2.0 WinApplication and I will try to make it pligin-based so I easy can meet my customer needs with new plugins.
I won’t go in detail on what my program should do but my problem is how can I make an application an then develop plug-ins for that application. My solution will bee 100% .NET based…
All tips on how to do plug-in-based development are welcomed!!
_____________________________
...and justice for all
APe
|
|
|
|
|
read up on System.Reflection . This namespace contains a lot of stuff which allows you to interogate, and dynamically load assemblies, and dynamically instantiate objects from those assemblies.
Your plugins should be custom class(es) which implement interfaces that you know about. You can then use reflection to instantiate your new plugged in objects, and you can call their functionality through interfaces. Design your interfaces carefully, you can't change them easily in the future.
using System.Beer;
|
|
|
|
|
Thanks. Looks like a good start for me!!
_____________________________
...and justice for all
APe
|
|
|
|
|
I have a dll file written by C++ MFC. I want to use it in C#, but I can't know how to use it. Who can show me how to use it?
Thanks a lot!
|
|
|
|
|
using System.InteropServices;
[dllImport("yourDll")]
public static extern type function(params);
Aaron
|
|
|
|
|
Hi,
I'm writing an application in c#.net and i'm completely new to it.
Please refer to the following code in which i'm getting an exception...
//.....................................................................
String classStartTime;
conn.Open();
String myQuery = "Select starttime from tblecture";
OdbcCommand myCommand = new System.Data.Odbc.OdbcCommand(myQuery, conn);
OdbcDataReader dataReader = myCommand.ExecuteReader();
try
{
while (dataReader.Read()) //exception
classStartTime = dataReader.GetTime(0).ToString();
}
finally
{
dataReader.Close();
conn.Close();
}
//.....................................................................
I'm getting this exception for only column named "starttime"; for other fields this code works fine.
Is there any other way to read a field of type time from database?
Thanks,
Kranti
-- modified at 4:13 Wednesday 19th April, 2006
|
|
|
|
|
There is a very obvious mistake that you are making here. The query myQuery is returning you only one column per row. You are using dataReader.GetTime(1) , which is trying to get the second column (indexes are zero based, not 1 based) and hence generating an index out of range exception, because there is nothing at the "1" ordinal.
Solution:
Change the line
classStartTime = dataReader.GetTime(1).ToString();
to
classStartTime = dataReader.GetTime(0).ToString();
|
|
|
|
|
In addition to the above, if your variable "classStartTime" is of type DateTime (as it should be) then you do not need the .ToString() call - it will cause an invalid cast exception.
if classStartTime is a string:
classStartTime = dataReader.GetString(0);
if classStartTime is DateTime:
classStartTime = dataReader.GetTime(0);
|
|
|
|
|
The first field has index 0, not 1.
---
b { font-weight: normal; }
|
|
|
|
|
even when i make it as ...
//...................................................
while (dataReader.Read()) //exception
classStartTime = dataReader.GetTime(0).ToString();
//...................................................
it generates the exception at the previous line i.e. the line containing "while", before going for this statement
Thanks,
Kranti
|
|
|
|
|
What is the exception generated?
|
|
|
|
|
the exception generated is "Array index out of bounds"
|
|
|
|
|
Array Index out of bounds was when you were trying to read element 1, that exception is unlikely to be being generated by the call to while(reader.Read()).
try posting the complete code, that is the relevant bit that is opening connection, creating command etc.
|
|
|
|
|
the complete code is as follows ...
//..................................
String connectionString = "Dsn=pgTEducation;database=teducation;server=192.168.0.135;port=5432;uid=divinet;readonly=0;protocol=6.4;fakeoidindex=0;showoidcolumn=0;rowversioning=0;showsystemtables=0;fetch=100;socket=4096;unknownsizes=0;maxvarcharsize=254;maxlongvarcharsize=8190;debug=0;commlog=0;optimizer=1;ksqo=1;usedeclarefetch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boolsaschar=1;parse=0;cancelasfreestmt=0;extrasystableprefixes=dd_;lfconversion=1;updatablecursors=1;disallowpremature=0;trueisminus1=0;bi=0;byteaaslongvarbinary=0;useserversideprepare=0";
OdbcConnection conn = new System.Data.Odbc.OdbcConnection(connectionString);
String classStartTime;
conn.Open();
String myQuery = "Select starttime from tblecture";
OdbcCommand myCommand = new System.Data.Odbc.OdbcCommand(myQuery, conn);
OdbcDataReader dataReader = myCommand.ExecuteReader();
try
{
while (dataReader.Read())
classStartTime = dataReader.GetTime(0).ToString();
}
finally
{
dataReader.Close();
conn.Close();
}
//..................................
thanks,
Kranti
|
|
|
|
|
The problem may be to do with your use of GetTime(int). The documentation of this states "Gets the value of the specified column as a System.TimeSpan object". Im thinking what you actually want is GetDateTime(int).
However, as with my post above, if all you need is a string, then use GetString(int)
|
|
|
|
|
hey hi, The question i want to ask you is that I want to add items in a Combo Box. First of all how would I add items in it? . and Secondly, with every selection of the combo box item, my program should perform following actions:
1) When user selects option "2" from the combo box then the two "Text Boxes" should appear, Similarly if user selects option "3" then three "Text Boxes" should appear.
2) At the bottom of the page is the "Browse" button, which should upload the picture and display it at the "Picture Box" which is displayed just infront of that button.
regards,
noman
|
|
|
|
|
|
how to use google earth api's in my c# code
|
|
|
|
|
How we transfer a table from dbf to sql server 2000 through programming in c# with table schema plz send me at soni_linux@yahoo.co.in
Vinod Soni
|
|
|
|
|
Hi all,
Would like to know how to export the contents of a datagrid to a SQL 2000 db...(with the code as well , if u plz).......
Thx.
-- modified at 6:09 Wednesday 19th April, 2006
|
|
|
|
|
I'm a bit new to Regex, and almost got this working, except for a small glitch. I have a string called entityName which looks like "120 PP (V987) XYZ", from which I have to strip out the entity code which in this case is (V987). The entity code is V or C followed by any number of digits, all of which is enclosed in ().
My code looks like this:
string[] entityNameString;
Regex regex = new Regex(@"^(.*)(\([V,C]\d+\))(.*)");
entityNameString = regex.Split(entityName);
Console.WriteLine(entityName);
foreach(string s in entityNameString)
{
Console.WriteLine("\t" + s + "\t\t" + s.Length);
}
Unfortunately, when I run it, the output produced is
120 PP (C987) ERT
0
120 PP 7
(C987) 6
ERT 4
0
It produces an extra null string at the beginning and the end. I'm guessing my Regex pattern is incomplete. How should I correct this?
Thanks in advance. 
Cheers,
Vikram.
I don't know and you don't either.
Militant Agnostic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
