nokomoli

Hi Guys , i have faced a sql command problem. That is currently i have 2 different table [ICODE]a) Select ID, Name from Table1 where ID >=1 and ID ID <=3 ID | Name 1 | Alan 2 | Amy 3 | Andrew [/ICODE] [ICODE]b) Select ID,Sum(Points) as [Total] from …

Hi guys, i am facing problem when i need to create an excel file and insert some data inside. Can anyone help me? i am using vs 2005 and excel 2003.

Hi guys, currently i faced a problem that is i need to add some extra text into HTML Editor (AJAX) but i fail to get the text cursor location, have anyone can tell me how to solve it??

Hi guys, I am facing a weird problems which is i am fail to get cursor position at DIV at IE8 but work at IE7 or IE6. Can anyone tell me how to solve this problem.

Hi guys, i am facing a problem at Vb.net. There is i have a html editor created by myself. i also add a dlghelper but when i run at localhost, and click a button to show color dialog, java script runtime error occured and wrote "Microsoft JScript runtime error: 'dlgHelper' …

Hi guys, i am faced a problem here where is i need to select a query where the column name is dynamic: table a col1 | col2 ---------------- A | Ali B | Abu C | Kawan A | Bayu B | Cawam C | didik how i write a …

Hi guys, i am facing a problem which is i need to create a dynamic gridview control and i need to add eventhandler for this gridview. Therefore, how i add the event?

Hi, i am newbie of java script. i faced a problem in java script which is when i want to prompt a message box and enable to let user to type their own password. but i found that a problem is when the user type their own password in the …

Hello, i have face problem when i need to retrieve data from database (SQL 2000). Below my table : Column A | Column B 1 a 1 b 2 c 2 d i need the result is : Column A | Column B 1 a b 2 c d Can …

Hi guys, i am a problem when i doing my coding about format a number for normal number with 4 digit , i have idea which is e.g: Dim a As double a = 1/ 2946.33 ' its return is 0.00033940529 If i use format number function with 4digits, the …

Hi guy, i'm newbie of .net language. Last week i found a new method at the .net with vb.net language. That is in the Global.asax, you are enable to store a global variable. The common at below: [ICODE]Application("ABC")="CDE"[/ICODE] i doubt that this method with cookies or session. Besides this, i …

Hi Guys, i'm newbie in .net area. now i confuse one things is : i have a variabel is use at all pages in my web site. so how i set this variable in one page, so that every time when i need this variable, i can use this and …

hello guy, Recently i faced a problem that i have 2 sqldatasource where connect to different server. But the problem is how to combine 2 sqlcommand into one datagrid. eg: [ICODE]1) sql1 = Select ID, Name from Table1 sqldatasource1.selectcommand = sql1 datagrid1.datasource = sqldatasource1 datagrid1.databind[/ICODE] [ICODE]2) sql2 = Select ID, …

hello Guys, I facing a sql query problem which is i need to join many query into one query. That is : a) [code=sql]SELECT sum(Total) As [MONEY1] FROM ((SELECT SUM(T1.Amount+T2.Amount) AS Total FROM TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID) UNION ALL (SELECT SUM(T3.Amount+T4.Amount) AS Total FROM TABLE3 …

Hi Guys, I have some confusing part in the sql command the question is i have 2 different query : a)[code=sql] Select SUM(T1.Amount+T2.Amount) as Total From TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID[/code] b) [code=sql]Select Sum(Amount) as Total FROM TABLE3 [/code] the result if a) query is 100 …

Hello Friends, I'm facing a problem now that is i have some THAI language data in SQL Server 2000. The problem i don't know how to retrieve this data to variable and i don't noe the variable should be what data type? such as string or others? Have any one …