|
DateTime.AddXXX creates a new DateTime object with the added value.
Use this:
DateTime myDateTime = new DateTime(2007, 1, 1, 1, 1, 1);
MessageBox.Show("before:" + myDateTime.ToString());
myDateTime = myDateTime.AddDays(6);
myDateTime = myDateTime.AddYears(1);
myDateTime = myDateTime.AddMonths(4);
MessageBox.Show("after:" + myDateTime.ToString());
|
|
|
|
|
Hey.
I've been searching relentlessly via the web for a solution to converting pcl files to pdf, but every SDK I've found requires payment and at no cheap cost so I now beg assistance via this forum.
I'm writing a Sharepoint activity that will convert pcl files to pdf.
Any assistance as to a solution would be greatly appreciated.
A dll or an sdk would be of great help.
Thanks in advance, Marco
|
|
|
|
|
Dear,
i have 10 questions in a form each question have 4 option.
i made 10 group box for each question and putted 4 radio button into each.
finally i have to calculate score of this test using a answer key.
what is the process for this .
(i am checking 40 radio button individually)
but it is not good if we have 100 question.
is there any solution ?....
thanks 
|
|
|
|
|
Create a custom control to service a question. It needs to receive a question object, bind the controls to the object and bind the response to the answer in the object. When completed the object should write the result back to the database.
Then you just create one CC for each question and put it on the form. I would use a flowcontrol in winforms.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yes sure. As Mr. Holmes said, you can have a CC for your questions but not a CC for each one. You can have a CC for all your questions. If I were you, my CC would have a Label and 4 RadioButtons in it and I would set their values with my CC constructor, something like this:
public myCC (string LabelValue, string[4] questions)
{
labelQuestion.Text = LabelValue;
radiobuttonQuestions.Texts = questions;
}
And everytime user clicks on Next button (or something similar) store the result in an array, create a new CC, set its values, show on your form and dispose the previous one. Your memory can breathe in this way 
I hope I could help 
I learned something new today
|
|
|
|
|
Hi,
I am using ODBC connection to execute a Stored procedure inside my C# project (visual studio 2008). I am passing a parameter and it is working fine except fewer parameter values. I tried to replace the SP by the exact query (used inside the SP) and it is working fine for all the parameter values. I dont understand why. Any one came across this problem? i cant find any forums relatd to this particular situation.
I got stuck here for more than 4 days now. Any help is highly appreciated.
Thanks a lot
Renu
|
|
|
|
|
Renukapadhamanaban wrote: I am passing a parameter and it is working fine except fewer parameter values.
What does that mean?  Do you see fewer results than expected?
Also, how about posting the relevant code snippet?
|
|
|
|
|
You should explain your problem with SQL Query and what is the error message is show.
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
Hi Vikram and Anubhav,
Thanks a lot for the quick reply. Sorry for not explaining the problem clearly. here it is..
I have the Stored procedure written in sybase called PatientDetails
CREATE PROCEDURE PatientDetails2
(
@local_id VARCHAR (8)
, @facility VARCHAR (5) = 'RMH'
)
AS
SELECT lname = per.last_name, fname = per.first_name, mname = per.middle_name, per.title, dob = CONVERT(VARCHAR(10),per.dob,103)
, per.sex, per.mstatus, per.ssn, per.race, per.ethnic, per.religion, per.language, per.pob_country
, loc.facility, UR = loc.local_id
, pv1.visit_no, pv1.alternate_visit_id, pv1.admission_type, unit = pv1.hospital_service, ward = pv1.nurse_unit, pv1.room, pv1.bed
, admitted = pv1.admit_date_time, discharged = pv1.discharge_date_time, fin_class = pv1.financial_class
, admitting_dr = pv1.admitting_doctor, attending_dr = pv1.attending_doctor, consulting_dr = pv1.consulting_doctor, referring_dr = pv1.referring_doctor
, raddress1 = radr.address1, raddress2 = radr.address2, rcity = radr.city, rpostcode = radr.postal_code --residential
, maddress1 = madr.address1, maddress2 = madr.address2, mcity = madr.city, mpostcode = madr.postal_code --mailing
, hphone = hpho.phone --home
, bphone = bpho.phone --business
INTO #patients FROM ui_person per JOIN (ui_local_id loc
LEFT JOIN ui_pv1_segment pv1 ON (loc.local_id = pv1.local_id)
AND (loc.facility = pv1.facility))ON (per.u_id = loc.u_id)
LEFT JOIN ui_address radr ON per.u_id = radr.u_id
AND (radr.address_type = 'R')LEFT JOIN ui_address madr ON (per.u_id = madr.u_id AND madr.address_type = 'M')LEFT JOIN ui_phone hpho ON (per.u_id = hpho.u_id AND hpho.phone_type = '1') LEFT JOIN ui_phone bpho ON (per.u_id = bpho.u_id AND bpho.phone_type = '2')
WHERE loc.local_id = @local_id
AND loc.facility = @facility
RETURN
This works very fine for all the combination of the parameter values. I tested this in the AQL Advantage window.
Inside .NEt application i have written code to call this SP like this:
private DataTable PatientInformationRow(string ur, string facility, string procString) //procString=PatientDeatails2
{
OdbcConnection conn = new OdbcConnection(m_connString);
conn.Open();
OdbcCommand commDemo = new OdbcCommand();
commDemo.Connection=conn;
commDemo.CommandText="{call " + procString + "(?,?)}";
OdbcParameter urParam =commDemo.Parameters.Add("@local_id", OdbcType.VarChar);
urParam.Value= ur;
OdbcParameter facParam = commDemo.Parameters.Add("@facility", OdbcType.VarChar);
facParam.Value= facility;
OdbcDataAdapter daDemo = new OdbcDataAdapter(commDemo);
DataTable dtDemo = new DataTable();
try
{
daDemo.Fill(dtDemo);
}
catch(Exception e)
{
throw new Exception(e.Message);
}
conn.Close();
return dtDemo;
}
For example, If I pass the @local_id parameter value '123456', the SP works fine and returns the right patient record if I execute in the SQL advantage window and as well as through the .NET code. IF i pass '131534' it brings the right patient record if I execute in the sql advantage window but bringing no records through the .NET code. (this is what i specified as not working for fewer parameter values..) it is very weird..
I think i explained well... hoping for some help.
THanks in advance.
Renu
|
|
|
|
|
I am developing this tool specifically for our product. The product is called Process Expert. There are different blocks in which industrial process values are stored which in turn stores in mdb. A set of blocks is called a worksheet. In some blocks VB code is written to stablize the industrial process. I need to compare two different worksheets. I am able compare all the values, but I need to compare the VB code. If any body can help how to go about it, it will be helpful for me.
Regards
Surya
|
|
|
|
|
So... you are doing SCADA by embedding VBA into Access databases? I'm concerned.
|
|
|
|
|
Mark Churchill wrote: I'm concerned
Other than the choice of the toolset - why?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
It seems like part of the supervisory routines are going to be somehow embedded in the database. I had the horrible thought of live process data being pumped thru embedded VB which affects more than just setpoints. Usually I find these kind of decisions embedded in a supervisory PLC. Or maybe I'm just paranoid...
|
|
|
|
|
This is a tool for the commisioners to check if the installed software is different from the standard. I don't understand "I'm concerned" ????.
|
|
|
|
|
A simple string comparison would be easy but I assume you want to compare the logic/tokens in the code, in which case you will need to build and interpreter of some sort.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
how i create no. of pictures boxes during runtime. The no. of picture boxes is equal to the no. of images in a folder.
Thanks
|
|
|
|
|
use IO namespace to get the folder and file info
loop through the files in the folder counting/creating a picturebox for each one
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
do following steps :
1. list files in your selected directory using System.IO.Directory.GetFiles(PathToYourImageDirectory);
2. iterate along list of files in step no 1
3. Create a PictureBox ie : PictureBox pb = new PictureBox();
4. Set your picture box property in step no 3, like Top, Left, Widht and Height.
5. Add your picture box to your form or other container control you use, with yourParentControl.Controls.Add(pb)
6. Load your image to picture box using pb.Image = Image.FromFile(TheFileFromList)
7. Repeat step no 3 until all files processed.
hope this 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
|
|
|
|
|
Thanx A lot.......
|
|
|
|
|
i have had problems refreshing the datagrid when deleting an item or when adding data; when i run my program. However when i step into the code line by line the datagrid works as expected by clearing or adding the data and updating the result on the datagride, why is that?
D.Arnold
dave1816
|
|
|
|
|
How about showing some code? Nobody can divine the solution from your question.
|
|
|
|
|
a
dave1816
modified on Wednesday, April 15, 2009 8:16 AM
|
|
|
|
|
Hi,
i getting started with ado and how been sucessful so far, however im now trying to update the data when editing a record, however i can only find how to do this with one set of data involving one column not mulitple.
e.g.
update Patient set Lastname = '" + textBox2.Text + "' where patientunitno = '" + textBox1.Text + "'";
my question is probley rather simple to solve but i cant find anything on google. I must be trying the wrong type of key words in.
I did find however one article linked below
http://www.xtremedotnettalk.com/showthread.php?t=95074[^]
however im not sure if this is the most practical way? any help to point me in the right direction would be great
Many Thanxs
D.Arnold
dave1816
|
|
|
|
|
Just write your sql command text like this:
"update patient set lastname = '" + textbox2.Text + "', firstname = '" + textbox3.Text + "' where patientunitno = '" + textBox1.Text + "'";
and so on if you want to update more columns.
but this suggestion is not recommended because it vulnerable against sql injections, use parameters instead.
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
|
|
|
|
|
Clearly, I type too slowly
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
