Lowyat.NET: Latest topics by bzai123

Format Excel cell

bzai123 — Thu, 23 Jul 2009 16:30:41 +0800

Hi,
How can i format the cell of excell sheet using c#?

Eg:

value=0123456789

i would like to export this value into excel file with "0123456789" instead of "123456789"

i had tried

CODE

worksheet.cell.NumberFormat="##########"

but it seems not realistic since the value will be growing larger....

Any suggesstion?

Currently using VS2008 Team Stream + MS Excel 2007

Thank you in advance.....

Export from xml and write to excel

bzai123 — Wed, 22 Jul 2009 14:35:49 +0800

hi,

Is there anyone know how to read data from a xml file and then write to excel fil without using dataset?
What i want is read the data into memory insteat of retriving from database.

Currently using VS2008 web service with c#.....

Thank you in advance.....

[addedon]July 22, 2009, 5:59 pm[/addedon]Really no one could help?

Message box in Web Application

bzai123 — Tue, 09 Jun 2009 15:04:08 +0800

Hi,

currently i'm working on a small web project. I would like to display a confirmation message box when user clicking on a delete button by using the following method:

CODE

Button1.Attributes.Add("onclick", "return confirm('Are you sure you want to delete?')");

As the result, it prompted me a message box. The problem i'm having now is how can i get the response from the user whether he is clicking on OK or CANCEL as DialogResult doesnt' work in web application like window application.

Currently using VS2005 Web Application with C#

Hope to hear from somebody soon.......

Thank you in advance.

Power Builder

bzai123 — Wed, 29 Apr 2009 13:06:36 +0800

Is there anyone familiar with Power Builder??
Can I have the web site with can learn this programming language?

Thank you in advance

Theory Question

bzai123 — Sun, 29 Mar 2009 09:15:15 +0800

hi,
I'm newbie to MS2008......
So can anyone help me to answer the following questions??

1. What is ASP.net?

2. What is VB.net?

3. Does C#.net exist? If so then what is the differences between C#.net. VB.net and ASP.net?

how to generate System Year for Crystal report?

bzai123 — Wed, 18 Feb 2009 21:31:37 +0800

i'm currently using VS2005 window application with C#

does anyone know how can i display the value of "1/1/2009" and "12/1/2009" if i generated the report for year 2009
EG: Report XXXX
from 1/1/2009 to 12/1/2009

and "1/1/2008" and "12/1/2008" if i generate the report for 2008
EG: Report XXXX
from 1/1/2008 to 12/1/2008

i wish to have it by not setting the the values manually instead it will be change according to the current year......
thank you in advance......

Crystal Report

bzai123 — Sat, 31 Jan 2009 02:59:52 +0800

CODE

ReportPD rePD = ReportPD(value1, value2);
DataSet ds = rePD.suReceipt();

CrystalReport1 crSuR = new CrystalReport1();
crSuR.SetDataSource(ds.Tables["suReceipts"].DefaultView);

crystalReportViewer1.ReportSource = crSuR;

the above codes are used to retrive data from database and display the data into crytal report. the problem is whenever the retrieved data involve 2 table or more, it will display nothing in the report viewer but hen i only retrieve data from only 1 table then it can be done. So.... could anyone tell me that what is happening?

thank you in advance......

Unknown errors

bzai123 — Tue, 30 Dec 2008 19:08:43 +0800

CODE

import java.util.concurrent.*;
import java.util.concurrent.locks.*;
/***********************************************/
/** A semaphore producer/consumer **/
/***********************************************/
public class Producer_Consumer implements Runnable
{
private static Semaphore mutex = new Semaphore(1);
private static Semaphore full = new Semaphore(0);
private static Semaphore empty = new Semaphore(20);
private static int COUNT=0;
private String thread_name;
static int buffer[] = new int[20];
private static int current=0;

public static void main (String args [])
{
// initialise buffer with some dud values
for(int i=0;i<20;i++) buffer[i]=-1;

// create two producer/consumer threads
Thread T1 = new Thread(new Producer_Consumer("T1"));
Thread T2 = new Thread(new Producer_Consumer("T2"));

// and start them off
T1.start();
T2.start();
}

public Producer_Consumer (String name)
{
thread_name=name;
}

public void run ()
{
do
{
// am I a producer or a consumer?
int randy = (int)(Math.random() * 100);
if (((randy%2)==0) & (current>0)) // CONSUMER
{
[COLOR=red]full.wait();
mutex.wait(); [/COLOR]
// start of critical section
COUNT++;
current--;
System.out.println(thread_name +" removing buffer["+current +"]="+buffer[current] );
buffer[current]=-1;
// end of critical section
mutex.notify();
empty.notify();

}
else //PRODUCER
{
[COLOR=red]empty.wait();
mutex.wait(); [/COLOR]
// start of critical section
COUNT++;
buffer[current]=randy;
System.out.println(thread_name +" adding buffer["+current +"]="+buffer[current] );
current++;
// end of critical section
mutex.notify();
full.notify();

}
} while (COUNT<20);
}
}

When the above codes being compiled there are 4 same errors occurred with the same error description......
unreported exception java.lang.InterruptedException; must be caught or declared to be thrown

i need helps in urgen...... hw to solve it?
thank you in advance.......

diferences of 2 date time

bzai123 — Sun, 28 Dec 2008 02:28:05 +0800

i'm currently using MS2005 with C# (window application)

how can i calculate the diferences of 2 different dae time value?

let's say the 1st date is 01/31/2008 and the second date is 02/01/2008

and the foolowing method is applied:

label1.text = Convert.tostring(date2.value.date-date1.value.date);

as the result the text that pronted in the label would e like 2.00.00.00 instead of 2.

is the method wrong? could anyone can help me to resolve?

Generate Crystal Report

bzai123 — Fri, 12 Dec 2008 19:49:32 +0800

I've already create a CryatalReport but how can i display it during run time?
NOTE: the report is linked to a database.

CODE

CrystalReport1 CR1 = new CrystalReport1();
CR1.XXX;

is the above code correct? if do so then what should be the XXX?

Application Environment: VS2005 with C#.

Thank you in advance......

Random number by using prolog

bzai123 — Mon, 08 Dec 2008 23:51:41 +0800

Does anyone know how to generate a random number within 2 number by using prolog language?

Wait() and Signal()

bzai123 — Thu, 04 Dec 2008 07:15:39 +0800

Are the Wait() and Signal() below a built-in function in java?
Thank you in advance.

CODE

int randy = (int)(Math.random() * 100);
if (((randy%2)==0) & (current>0)) // CONSUMER
{
full.WAIT();
mutex.WAIT();
// start of critical section
COUNT++;
current--;
System.out.println(thread_name +" removing buffer["+current +"]="+buffer[current] );
buffer[current]=-1;
// end of critical section
mutex.SIGNAL();
empty.SIGNAL();
try {
Thread.currentThread().sleep((int)(Math.random() * 100));}
catch
(InterruptedException e){}

}

error C3861: 'malloc': identifier not found

bzai123 — Wed, 19 Nov 2008 23:33:59 +0800

QUOTE

#include "malloc.h"
#include "stdlib.h"
#include "stdafx.h"
#include "dos.h"
#include "stdio.h"
#include "process.h"
#include "windows.h"
#include "conio.h"
#include "omp.h"

#define N_THREADS 6
#define M 3
#define K 2
#define N 3

int main(int argc, char *argv[])
{
DWORD ThreadId[N_THREADS];
HANDLE ThreadHandle[N_THREADS];
LPSECURITY_ATTRIBUTES lpThreadAttributes = NULL;
DWORD stackSize = 0;
DWORD dwCreationFlag = 0;
int thread_num = 0;
//create the thread
for(int numRow=0;numRow < K; numRow++)
{
for(int numColumn=0; numColumn < N; numColumn++ )
{
struct dataPassingToThread *data = (struct dataPassingToThread *) malloc(sizeof(struct dataPassingToThread)); data->numRow = numRow;
data->numColumn = numColumn;
data->thread_no = thread_num+1;
.
.
.
.

don't know why is the error occurred.......
could anyone help?
NOTE: currently using VS2005 with c++
thank you in advance......

Function run over a certain period

bzai123 — Mon, 29 Sep 2008 20:57:20 +0800

hi......
how would I make a function run for a certain amount of time?
i would like to run an alert function every 3 minutes.....
but i do not have any idea to do so......

Can u guys pls help?

Thank you in advance.

Environment: Microsoft Visual Studio 2005 Window Application with C#

sql problem

bzai123 — Tue, 23 Sep 2008 22:30:38 +0800

QUOTE

SqlConnection conSaInv = new SqlConnection("Data Source=MY-LAPTOP;Initial Catalog=Wai_Tat_db;Persist Security Info=True;User ID=sa;PWD=project");
SqlCommand cmdSaInv = new SqlCommand("select sum(PAYMENT_AMOUNT) from SALOON_RECEIPTS where SALOON_INV_NO=@no", conSaInv);

try
{
conSaInv.Open();

cmdSaInv.Parameters.AddWithValue("@no", no);

dtrInv = cmdSaInv.ExecuteReader();

if (dtrInv.Read())
{
paid_amt = System.Double.Parse(dtrInv.GetSqlMoney(0).ToString());
amt_balance = ttl - paid_amt;
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}

when i try to run the statement, error occurred at the highlighted part.

error message : Input string was not in a correct format

currently using Microsoft Visual Studio 2005 Window Application with C#

Thank you in advance.....

method to get system path

bzai123 — Tue, 23 Sep 2008 11:55:11 +0800

i would like to backup my application database to a certain location and it is able to allow user to choose where to store the backup file. So how can i get the system path?

i should use OpenDialog or SaveDialog?
i'd tried both but it could not be done.....
it is because both of the above methods are forcing me to choose a file then only i got the system path.

Can u guys provide some solutions?

Thank you in advance......

Fail to backup database

bzai123 — Wed, 17 Sep 2008 20:54:27 +0800

CODE

SqlConnection conBackUp = new SqlConnection("Data Source=MY-LAPTOP;Initial Catalog=Wai_Tat_db;Persist Security Info=True;Asynchronous Processing=true;User ID=sa;PWD=project");
SqlCommand cmdBackUp = new SqlCommand("backup database Wai_Tat_db to disk= 'C:\\Wai_Tat_db.bak' with init", conBackUp);

try
{
conBackUp.Open();

cmdBackUp.ExecuteNonQuery();

MessageBox.Show("Database is backup to C:\\", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conBackUp.Close();
}

When the above function is called, an errro is prompted:
"Cannot open backup device 'C:\Wai_Tat_db.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally."

So what is the problem actually?
Thank you in advance.....

sql statement problem

bzai123 — Tue, 09 Sep 2008 14:29:16 +0800

CODE

int sum1,sum2;
SqlDataReader dtr;

SqlConnection con = new SqlConnection("Data Source=.......");
SqlCommand cmd = new SqlCommand("select sum(item1), sum(item2) from ItemTable",con);

con.Open();

dtr = cmd.ExecuteReader();

sum1=?????
sum2=?????

con.Close();
dtr.Close();

What should i write in the ????? in order to assign the sum of item1 and item2 to sum1 and sum2 respectively?

Currently using Microsoft Visual Studio 2005, Window Application with C#.

Thank you in advance.

Change Drop Down List property during run time

bzai123 — Sun, 31 Aug 2008 21:32:52 +0800

how could i change the property of the Drop Down List during run time?

i'd tried this before but it does't working......

public void New_button Click(.....)
{
DropDownList1.DropDownStyle=DropDownList;
}

is there anything i've missed out?

currently using Microsoft Visual Studio 2005, Window Application with C#

prevent editing in a drop down list

bzai123 — Thu, 28 Aug 2008 10:42:38 +0800

could anyone tell how to disable the edit mode of a drop down list?

I mean I would like to force the end user to choose only the data inside the drop down list instead of adding themselve.

I've tried all of the properties in the properties window of drop down list but it doesn't has any property which refers to that function.

Is there any way to do so???

currently using Microsoft Visual Studio 2005, Window Application with C#.

Thank you in advance.