|
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
|
|
|
|
|
That is because you are splitting on pattern that matches the entire string.
Let's go for a simple example: If you have a pattern like "(ell)" and split the string "hello" using that pattern, you will get three strings; "h", "ell" and "o". If you have a pattern like "(hello)" and split the string "hello", you will also get three strings; "", "hello" and "".
Make the pattern match only the "(C987)" part of the string, and you get only three strings in the result.
---
b { font-weight: normal; }
|
|
|
|
|
Guffa, thank you very much! ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Cheers,
Vikram.
I don't know and you don't either.
Militant Agnostic
|
|
|
|
|
It really doesn't look like you actually want to be splitting the string at all.
if you try this:-
Regex regex = new Regex(@"^(.*)(\([V,C]\d+\))(.*)");
Match m = regex.Match(entityName);
if (m.IsMatch)
Console.WriteLine( m.Groups[2].Value);
Furthermore, your regular expression could be optimised a little - many of the brackets are unnecessary:-
^.*(\([VC]\d+\)).* should work also. Note the the submatch group number as used in my above code will be 1 for this pattern.
And if you move your submatch brackets a bit, like this,
^.*\(([VC]\d+)\).* then your submatch for the string "120 PP (C987) ERT" will contain "C987". I am of course making a wild assumption here that you don't want the brackets in the output.
Incidentally, I didn't test the above code or patterns, but they're good in substance even if they have minor errors in.
using System.Beer;
|
|
|
|
|
Hello all!
I need to know that can I write rtf text in word document. Actually I have a Richtextbox on my form. Now i need the rtf of that control to be in a word file. Is it possible. If yes............How?
Please help me in this regard
Thanx in Advance
Mubashir
|
|
|
|
|
Hi!
The only way I've found for this so far is to use the clipboard.
Paste your RTF to the clipboard (probably saving the clipboard contents before doing so) and then call Paste on the Selection object you want your RTF to appear in.
Afterwards restore the clipboard contents.
If anyone has a better solution, I'd be interested in that, too.
Regards,
mav
--
Black holes are the places where god divided by 0...
|
|
|
|
|
My advice would have been to go into "Customize Toolbox" and look for "Microsoft Word" component under the "COM Components tab. But looking there, I see that Word has not been included. Apparently, Microsoft does not want us to have this feature?
Roy.
|
|
|
|
|
Hello,
Right now I am using the following code to open a directory for exploring.
I do believe there must be some one line code available to do the same task. If it is true, then would you please let me know.
The code I am using.
Process openFolder = new Process();
openFolder.StartInfo.FileName = Application.StartupPath + @"\User Files\Email Attachments";
openFolder.StartInfo.CreateNoWindow = false;
openFolder.StartInfo.WindowStyle = ProcessWindowStyle.Normal;
openFolder.StartInfo.UseShellExecute = true;
openFolder.Start();
|
|
|
|
|
I'm not sure exactly what you are wanting to do here...however if all you want to do is enumerate the names of the files inside a directory you just need to do this:
string path = Application.StartupPath+@"file path";
.
.
.
string[] files = System.IO.Directory.GetFiles(path);
foreach ( string file in files )
{
... your code ...
}
|
|
|
|
|
Hi,
thanks a lot for your reply. No, Actually I was looking for a solution to use Windows Explorer to open a directory. I found the soltion as
System.Diagnostics.Process.Start("explorer.exe", "\"C:\\Temp\"");
Thanks again.
|
|
|
|
|
Try this:
System.Diagnostics.Process.Start("explorer.exe", "\"C:\\Temp\"");<br />
this code exploring folder C:\Temp
Best regards, Alexey.
|
|
|
|
|
Thank u very much. Exactly thats the VERY solution i was looking for.
|
|
|
|
|
Hello
In my code I am resizing the image. the following is my code:
public void resizeImage(int width, int height, Bitmap bmp){
System.Drawing.Size imgSize = new Size(width, height);
this.image_bmp = new Bitmap(bmp, imgSize);
}
the image gets distorted or I mean that the picyure quality is not
good.
what other things can we do to get good quality pictures
Deepak Anish
Maxumise Fiji Ltd
Suva, Fiji
|
|
|
|
|
Create a Bitmap with the desired size, create a Graphics object for it and use that to draw the bitmap onto it. Set the SmoothingMode property of the graphics object to SmoothingMode.HighQuality to get the best drawing quality.
If you are enlarging the image, you can't expect a very good result. Even if the image is larger, it doesn't contain more image information than the original image.
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
I made my Windows C# program with SQL Server 2005 Express. Now when i will ship this software to my client's pc, and if he has SQL Server professional or developer edition, will my Software work or He must install SQL Server Express edition to run my software ?
Thanks
|
|
|
|
|
emran834 wrote: will my Software work or He must install SQL Server Express edition to run my software ?
Your software ought to work and your client should not have to install SQL Server Express. I hope your software works for your client
Paul
|
|
|
|
|
As long as you have externalized your connection string from your program, then you will not have any problems accessing any form of Sql Server.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
