Lowyat.NET: Latest topics by alex84

Boxing or Muay Thai Equipment where can buy in kl?

alex84 — Sat, 28 Mar 2009 18:17:08 +0800

Hei i looking for Muay Thai or Boxing equipment like the gloves and the bandage things... where can buy all this things around KL.

change application document to web..

alex84 — Fri, 16 Jan 2009 12:01:47 +0800

expert may i ask how to change a document file IE into http:

i creating a website after finish all the design i dont know how to change html to Http; localhost

any expert can help me??

where can get L-men products?

alex84 — Tue, 13 Jan 2009 14:28:45 +0800

i wan to ask where can buy the L-men products... it look like suitable for teenager use

but i cant found it at my place

[addedon]January 13, 2009, 4:31 pm[/addedon]look like no one know where can get this product

sorting datagrid MySql C#

alex84 — Tue, 30 Dec 2008 10:28:49 +0800

haii

i got problem to solve the sorting datagrid MySql database in C#. i dont know wat problem in my code and how to solve it.

protected void SortData(Object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
BindDataGrid(e.SortExpression.ToString());
}

protected void BindDataGrid(string sortfield)
{
MySqlDataAdapter adapter = new MySqlDataAdapter
("SELECT trxRnID, trxRnDt, trxQsID, trxQsDt, trxQsCn,"
+ "trxTelA, trxTelN, trxTelC, trxTelD, trxAmts, trxBaln,"
+ "trxDvID, trxCmds, trxFlag, trxStat, trxRwRq, trxRwRp FROM rmbrawtrx",
"server=127.0.0.1;database=relmobile;UID=root");
DataSet ds = new DataSet();
DataView dv = ds.Tables["rmbrawtrx"].DefaultView;
dv.Sort = sortfield;
StaffDetailsDtGrid.DataSource = dv;
StaffDetailsDtGrid.DataBind();
}

hope u all can help me....

brazilian wax for guys? anyone here try before?

alex84 — Mon, 22 Dec 2008 15:36:09 +0800

now days brazillian wax look like very popular....

they say can keep clean and gals more like it that way for guys??

izzit true?? and any guys here try before??

running speed... 8.30 pace?

alex84 — Fri, 19 Dec 2008 09:39:30 +0800

hi i just started running marathon training

i read some acticle about the marathon.. i dont really understand what it mean 8.30 pace..
can someone explain it to me...

seach data from tables C#

alex84 — Wed, 10 Dec 2008 15:10:52 +0800

Hi

now i writing a website that full with data from my database MySQL.

the information is too much so i need a search function to simplifier i find the data i wan

if anyone got a example source code or code i suppose to use?

C# insert delete and update problem...

alex84 — Fri, 05 Dec 2008 11:19:08 +0800

i have a hard time to figure what wrong with my program. i need to make a detailview that can insert the data. i can run it with database stored produces. but now i need to empty the stored produces and write in C# only. i have edit but it cant run. pls help me look at this code and tell me wat wrong and how to solve it.

THIS IS INSERT
[DataObjectMethod(DataObjectMethodType.Insert)]
public static void InsertStaff(cnpstaffmain cnpstaffmain)
{
string MyConString = "SERVER=127.0.0.1;" + "DATABASE=relmobile;" + "UID=root;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();

/* MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand cmd = new MySqlCommand("InsertStaff",
new MySqlConnection(MyConString));
cmd.CommandType = CommandType.StoredProcedure;*/
command.Connection = connection;
/* command.Connection.Open();*/
command.CommandType = CommandType.Text;
String InsertStaff = "INSERT INTO cnpstaff(usrUsID, usrPswd, usrName, usrFlag) VALUES (@usrUsID, @usrPswd, @usrName, @usrFlag)";
/* command.CommandText = "INSERT INTO cnpstaff(usrUsID, usrPswd, usrName, usrFlag) VALUES (@usrUsID, @usrPswd, @usrName, @usrFlag)";*/
/*command.Connection = connection;*/
MySqlCommand cmd = new MySqlCommand(InsertStaff,
new MySqlConnection(MyConString));
cmd.Connection.Open();
cmd.Parameters.Add(new MySqlParameter("@usrUsID", cnpstaffmain.usrUsID));
cmd.Parameters.Add(new MySqlParameter("@usrPswd", cnpstaffmain.usrPswd));
cmd.Parameters.Add(new MySqlParameter("@usrName", cnpstaffmain.usrName));
cmd.Parameters.Add(new MySqlParameter("@usrFlag", cnpstaffmain.usrFlag));

cmd.ExecuteNonQuery();
cmd.Connection.Close();
}

THIS IS UPDATE

[DataObjectMethod(DataObjectMethodType.Update)]
public static int UpdateStaff(cnpstaffmain cnpstaffmain)
{
string MyConString = "SERVER=127.0.0.1;" + "DATABASE=relmobile;" + "UID=root;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();

MySqlDataAdapter adapter = new MySqlDataAdapter();
String UpdateStaff ="UPDATE cnpstaff SET usrUsID = @usrUsID, usrPswd = @usrPswd, usrName = @usrName, usrFlag = @usrFlag WHERE usrUsID = @usrUsID_param)";
MySqlCommand cmd = new MySqlCommand(UpdateStaff,
new MySqlConnection(MyConString));
cmd.Connection.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new MySqlParameter("@usrUsID", cnpstaffmain.usrUsID));
cmd.Parameters.Add(new MySqlParameter("@usrPswd", cnpstaffmain.usrPswd));
cmd.Parameters.Add(new MySqlParameter("@usrName", cnpstaffmain.usrName));
cmd.Parameters.Add(new MySqlParameter("@usrFlag", cnpstaffmain.usrFlag));
int i = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return i;
}

THIS IS DELETE CODE

[DataObjectMethod(DataObjectMethodType.Delete)]
public static int DeleteStaff(cnpstaffmain cnpstaffmain)
{
string MyConString = "SERVER=127.0.0.1;" + "DATABASE=relmobile;" + "UID=root;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();

MySqlDataAdapter adapter = new MySqlDataAdapter();
String DeleteStaff = "DELETE FROM cnpstaff WHERE usrUsID = @usrUsID";
MySqlCommand cmd = new MySqlCommand(DeleteStaff,
new MySqlConnection(MyConString));
cmd.Connection.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new MySqlParameter("@usrUsID", cnpstaffmain.usrUsID));

int i = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return i;
}

MySQL Create grid view in C# ?

alex84 — Wed, 26 Nov 2008 12:13:07 +0800

i have a problem here. i connected MySql server in my c# but i dont know how to created datalist or view in my C# program. anyone can let me have a look wat the source code like and the way to do it.....

how to created a grid view database MySQL in C# web application?

NEED help! ODBC connect with VB database problem

alex84 — Thu, 20 Nov 2008 18:01:42 +0800

helo i need help at here.

i connect MySQL database into MySQL ODBC connector it test run find.

after that i try to connect the ODBC into VB database , it successful connected when i test run.

the problem here is all my table and data i created in MySQL database dissappear. it only got one view and no table inside the database VB database explorer. My database suppose have 11 tables that have created.

I read some forum say u need to covert the folder to full control folder and i did it but still my database .sql only got one view. may i know how wat the problem and how to solve it.

online streamxy problem

alex84 — Mon, 07 Jan 2008 18:29:46 +0800

i actually just apply streamxy. i using the modem that tmnet give us.

i can online at the beginning but suddenly it will pop up win32 things and then my connection become down

wat the problem and how i can fix it.

hope u all help me pls

Create database using VB

alex84 — Mon, 07 Jan 2008 18:07:32 +0800

how to create a database using VB?

my advisor need me create it using VB.... i have not much idea about it and i dont know where i can found the information

anyone here got a idea or website about this topic, pls give some advice

Receive and sending sms from pc using phone

alex84 — Mon, 26 Nov 2007 12:29:58 +0800

HI i need a bit help here

i doing a project need to use the sms application

i need a code that can receive sms from phone and immediately send the sms to pc

So anyone here done this before can help me out