Comments by loai_maane (Top 66 by date)

did you get any solution for you issue dear ?

thanks a lot dave for your information

thanks a lot dear Dave for your replay ,
so i think it is better to forget .net and do the job using win application . what is your opinion ?
and dear last question , how can i print the Temp PDF after rendering process.

guys actually, it is program to print medical form include 5 copies for each form ,the end user enter some data like employee id, doctor code ..... then press on print button 5 copies of the form will printed using printer connected to client PC .

thanks Dave I will try , but how can I print the temp PDF and I want to print it 5 copies

thanks guys , but dear Dave as Richard told render will set the value . any options guys please ?

dear if i rendering as PDF,is my code should create PDF physically in Program file to print the generated PDF?

hi dear ,
i am using asp.net.
i tried to print the report from the print button on report viewer it is OK the printed page was A4.but using the code the printed page was huge and printed on 4 papers

Dear,
sorry today i try your solution it give error Cannot find table 0, i already create data table with name retired

first line, i already create data table with same name retired

OriginalGriff,
I have one webapplication which works fine on my PC,currently i publish to server which has the database on SQL server 2012(i move the database also).now i face problem in the date format
on my PC the date format was dd/MM/yyyy but in server MM/dd/yyyy, so i got error in many places.i can not change the language for the sql server becuase it is include another database.I change Regional setting and set date Format to dd/MM/yyyy but still there is no solution, any sugestions??

thank you OriginalGriff

Hello Sergey,
I have printed form, actually it is a medical form . now we fill it manually .
I want to fill this form programmatically using c#.net, there are a lot of ideas in my mind .
now I designed page to enter the data by the user then pass that data to a report I created like that form using report viewer . because there are two types of that form one A3 size and the other one A4 size , I created two reports ,so when print the reports we should use two paper trays one A3 and the other one A4.now if you print the first report the first tray while work dirctly ,the second report second tray should work ,how can i do it in c#?

please any idea!!

for that reason i change the showupdown property for datetimepiker to true

i think the problem in the event it self , because when i change the day then the month just and add the data to the data base by pressing a button , then again come back to the datetimepiker the courser move to the year because i did not change the year before.
now i want way to change the focus on the day when i come back to the dtetimepiker.

dear i am creating program for user to enter data about employees.
my code very long ,but the important code about this issue is :

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
SendKeys.Send("{RIGHT}");

}

Dear,
i have oracle database already on my PC,I downloaded ODAC1020221.exe
from oracle website its Oracle Data Access Components (ODAC) support widows XP and
the download includes:
Oracle Data Provider for .NET 1.x 10.2.0.2.20
Oracle Data Provider for .NET 2.0 10.2.0.2.20
up till now I installed the provider on my pc in folder on c drive.
actually, i found this subject
http://www.codeproject.com/Tips/436023/Setting-up-Oracle-Database-for-NET-development#xx4565693xx
but i am afraid from removing Oracle database PATH from environment variable
because i use oracle also here.

hello dear,
yes i created table and i want to add columns .

Unclosed quotation mark after the character string 'td['0'] varchar(50) default 0 NOT NULL'.
Incorrect syntax near 'td['0'] varchar(50) default 0 NOT NULL'.
this is the error

i find the answer thnx Kornfeld, just put $otn_days into single quote
mysqli_query($connection,"INSERT INTO otn(e_no,grade,ccn_code,otn_days,otn_hrs) values($e_no,$grade,$ccn_code,'$otn_days',$otn_hrs) ");

actually, i did not understand you now.but after debug one row inserted in the database

dear Kornfeld, i use $result2 to check if the query insert row in the database or no, we can remove it no problem and the insert code is correct because one row added in my database when i press on submit but the date filed is 0000-00-00.
so the code is :
mysqli_query($connection,"INSERT INTO otn (e_no,grade,ccn_code,otn_days,otn_hrs) values($e_no,$grade,$ccn_code,$otn_days,$otn_hrs) ");

and also i used date('Y-m-d', strtotime($_POST['date'])), but same thing the date filed
0000-00-00

i know in mysql Date field is of format yyyy-mm-dd,but i checked the code separately and gave me correct format date like 2013-10-01.

this is example :

e_no grade ccn_code otn_days otn_hrs
2393 07 270 0000-00-00 5

there is any code to do this

i finish my C# project but i want to run my project in specific time (such as 22:00:00)and close it in 23:00:00

if i use sql server what i should to do if i want to use my database from any PC ??

thnx prasad ,
if i use sql server what i should to do if i want to use my database from any PC ??

thnx very much Ron

no work no problem in any time

for your second part how can i do it ?? you have any examples please.

sometimes work no problem ,so what do you mean of not match???

the interval 100
sometimes work no problem ,but sometimes do not work

ok the model is AC100

PROCESSOR : 400 MHz microprocessor
MEMORY : 4MB flash memory
-STORAGE:
• Fingerprint templates:1500
• Transaction :100000
-ENROLLMENT & VERIFICATION:
• Methods :Fingerprint (1:1, 1:N), Password
• Recommended fingerprint per user ID: 2
• Fingerprint placement :Any angle

there are two ports for the device :
1.RS232/485 Port (serial communication)
2.TCP/IP Port

it has The FingerTec BioBridge SDK 2.0.

there are two port for the device :
1.RS232/485 Port (serial communication)
2.TCP/IP Port

hello zoltan ,
i connect the finger print device to my PC using network cable so i choose TCP/IP as a way for connection
now i want to write code sing C# to take the finger print image of that device and store it in access database.at the same time that code compare between finger prints .

you are right OriginalGriff. thanx a lot i will use your idea

string zipfile="E:\\"+t+".accdb.gz";

yes it is work thnx a lot

sorry, another problem i try your way it is good
but when i Extract the file and open it,no data in that file (my tables not available )

open any winrar file you while see something called CRC ,The problem in this CRC

! E:\1-7-2013.accdb.gz: Unexpected end of archive
! E:\1-7-2013.accdb.gz: CRC failed in 1-7-2013.accdb. The file is corrupt

this error come when i try to do Extract file here , the file extension well .

no

because when i finish my project, i want to print a report include that data in the access database

i mean ... in my database when i add data the id simply is 1,2,3....right??
but when i remove one row such as row number 2 the id be wrong so i try to write a code to make the id filed again 1,2,3...
i do not know how can explain, but i hope you understand me.

Ron you know in access database, the id field i want to sort it again .
this the code .
OleDbConnection h5 = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\\IJC Database.accdb");
OleDbConnection h6 = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\\users\\IJC Database.accdb");
OleDbCommand cmd5;
OleDbCommand cmd6;
h5.Open();
cmd5 = new OleDbCommand("select count(ID) from ijc"+";",h5);
int countID = (int)cmd5.ExecuteScalar();
h5.Close();
h6.Open();
for (int i = 1; i <= countID; i++)
{
cmd6 = new OleDbCommand("update ijc set ID='"+i+"';",h6);
cmd6.ExecuteNonQuery();

}
h6.Close();

but how can i move to the next id... you understand me ??

thnx:))

thnx Ron :))

use data from my database

no i use c#

thnx:))

thnx :))

thnx

physical device
thnx

???????

this project not for Master Degree :)

hardware has numbers from 0-9