|
HI Tamer,
Thanks for the reply.
But my intention is i just want to access remote system from my Window application.as its password protected,is there any way to send User name and password and then access system
Have a Nice Day Dudes
|
|
|
|
|
please read this and tell me my mistake.
cn.Open();
cmd.CommandText = "Select ATT_DATE,DEP_ID,to_char(timein,'HH:MI'),to_char(timeout,'HH:MI'),EMP_NAME from attandance where emp_id = '" + id.Text + "' and shift = '" + shift.SelectedItem + "'";
odr = cmd.ExecuteReader();
while (odr.Read())
{
ename.Text = odr["emp_name"].ToString();
dept.Text = odr["dep_id"].ToString();
timein.Text = odr["timein"].ToString();
timeout.Text = odr["timeout"].ToString();
Dte.Text = odr["att_date"].ToString();
}
|
|
|
|
|
That depends. what is going wrong ? Is there an error message ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Error Message is
INDEX OUT OF RANGE EXCEPTION WAS UNHANDLED
|
|
|
|
|
that because you dont specify return field name for time in
try change your query in "to_char('timein',...) as timein"
hope it helps
dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support
|
|
|
|
|
I change my query like;
"to_char('timein','HH:MI')as timein"
now Error Message Change
ERROR [22018] [Microsoft][ODBC driver for Oracle][Oracle]ORA-01722: invalid number
|
|
|
|
|
then try to follow this link
ORA-01722: invalid number[^]
hope it helps
dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support
|
|
|
|
|
mjawadkhatri wrote: tell me my mistake.
Not telling us what the error message says and which line it occurs on?
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
Error Message is
INDEX OUT OF RANGE EXCEPTION WAS UNHANDLED
line of Error is
timein.Text = odr["timein"].ToString();
|
|
|
|
|
So, there is no column called 'timein'. I suspect you need to read a few basic books before doing any more work, the error message is pretty self documenting, and googling it would have got you a ton of info
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
In your select statement set "to_char(timein,'HH:MI')" to "to_char(timein,'HH:MI') AS 'timein'"
same with "to_char(timeout,'HH:MI')"
|
|
|
|
|
In addition to your missing columns, your code is vulnerable to SQL injection. You might want to look into stored procedures
Between the idea
And the reality
Between the motion
And the act
Falls the Shadow
|
|
|
|
|
"You might want to look into stored procedures parameterized statements."
(Regardless of whether or not the statement executes a stored procedure.)
|
|
|
|
|
Whoops. I thought that stored procedures and parametrized statements were the same thing. Thanks for the tip - research time methinks
Between the idea
And the reality
Between the motion
And the act
Falls the Shadow
|
|
|
|
|
I am developing window application in C#.NET. My form has a many images. If I run the project, images on the form are appearing one by one and form is vibrating. So plz give me any solution for this.
Thanks in advance..
|
|
|
|
|
I'm not sure what you'd like to hear. I mean, what do you expect us to do here ? You have not told us how you show the images. You have not even told us if you want to show lots of images at once, or one at a time. I have no idea what 'form is vibrating' means. At the end of the day, if you can't provide some details, and some code for us to try to correct for you, I don't see how you expect to get any help
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
please read my sig below and act accordingly.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Hello,
Does anyone know how to update the web.config of .aspx project in windows form of C#?
thanks in advance
|
|
|
|
|
Member 1439234 wrote: Does anyone know how to update the web.config of .aspx project in windows form of C#?
Do you want to open the web.config file of a web application from a C# windows forms application? web.config is just an XML file. You should be able to read it using the classes provided under System.XML[^] namespace.
|
|
|
|
|
I want to modify it in runtime but not in web application but in windows form application of c#
|
|
|
|
|
i have a problem with my character creation program.. i have different pictureboxes for the different parts of the character's features.. the eyes, nose, mouth head.. etc.. the problem is how can i merge the combination i made as a single picture.. just imagine the avatar/character creators in the internet,that's what i'm trying to do.. the difference is their doing it in flash and i'm doing it in C# so it makes it harder for me.. i appreciate your help guys.. thanks..
|
|
|
|
|
your overall approach is broken. Don't use picture boxes, just draw the images onto your form in your paint event. Then create a new bitmap to hold the end result and use the same code to draw the bitmaps into that new image.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i'm using templates for each parts of the body(eyes,nose..etc).. that's why i used a picture box to insert my ready made images on the form..
is it also possible to insert my ready made images using the paint events?? i'm really not familiar on this, this is my first time to make an application with image manipulation so i'm really confused..
|
|
|
|
|
If I have this:
IDictionary<int, string> dict = new SortedDictionary<int, string>();
then add a bunch of stuff to it...
and want to retrieve the last value (sorted, not inserted) and do this:
string val = dict.Values.Last();
Will this have the expected behavior of giving the the value that corresponds with the last sorted key?
|
|
|
|
|
Did you try it to see ? It doesn't seem likely to me, given that it's a SORTED dictionary.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|