kerek2

Hi Sir, I'm trying to use oracle Stored Produce with my login form as below :- package cms is -- 1 => OK, 0 => ERROR function validateUser( username in cms_user.cu_username%TYPE, passwd in varchar2, errmsg out varchar2 ) return number; END; For info , my password is encrypted , so …

Hi All's, I in a project to write some value into Mifare 1K using ACR122U with VB.Net. The value is Student ID like ' MA091221'....already read the API / SDK but not understand to do it. Can anyone giude me?..Tq

Hi All's, i'm stuck in create the Chart from my Access Database. My DB got Date with Datetime format , CLICK with Integer Format. Axis X must display a Date with Click Value , but the Date is not align correct like this picture : Please help me to arrange …

Hi All's, really need your's help regarding this issues. I have one Access Database where the Table = ST , Column =DATE(Datetime),CLICK(Integer). I want to get the total value form CLICK column by Month.I'm already tried with this but cannot : Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM …

Hi All's, Really need your help, i'm trying to update existing data in MDB database by date.today but cannot update . Here my coding Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source= PTGDB.mdb") Dim cmd As OleDbCommand = New OleDbCommand("SELECT …

Hi, Tq for ur support before.... I got some stuck here regarding how to make my text file write a new line for each input from textbox.. E.g :- I have a one textbox1 , when i insert any value in textbox it will save into my textfile. .. but …

Hi Alls, I'm need your help regarding this issues. What i'm try to do is when updating or insert command done,the color will follow. like below :- if dr.true then fcmd.executenonquery listbox1.items.add ("Good") Listbox1.forecolor = color.green else gcmd.executenonquery listbox1.items.add("Bad") Listbox1.forecolor = color.red end if but unfortunately when the color cahnge …

Hi all... I'm new in vb.net and just create a listview project . I wan to display item from database(.mdb) into listview.how to make the next item going below and not auto sorting by id?...please help me...thank in advance Do While IBSSDR.Read() If IBSSDR.Item("USERDEFINED10").Equals("Y") Then ListView1.Items.Add(IBSSDR.Item("CARDHOLDERID")).ToString() ListView1.Items(ListView1.Items.Count - 1).SubItems.Add(IBSSDR.Item("NAME")).ToString() If …

Hi, I'm already using ORacle 11G . The problem is when i'm using System.Data.Oracleclient to pull blob into picturebox it's ok, but when i'm using OracleDataaccess.Client / Types.....there no image appear n comeout error " Parameter is not valid" in this coding :- > Quoted Text Here Dim bmp As …

Hi All, I'm stuck regarding to grab connection from app.config file...i'm surf many type and kind to do it..but still can',t.....i need to connect into two database (oracle n firebird).....how to do this..hope u all can help me....tq

I got same problem to for this ACR120....plz help us

Hi Alls, Really need your help. I'm trying to list all text file in Application Startup path folder in combobox but cannot...can anyone help?.....In Application Startup Path folder i got more than 3 .txt file. So i want to list out in combobox...please help me..thank you

Hi All's, I'm currently doing my project to check my server status with ping option. but i got problem to check either the network is plugged or unplugged...I need this checking automaticly using timer...here what i have done....to ping the server is success but when pulgged back the network...error come …

Hi alls, since 2 week i'm stuck to do this thing. Actually i need to display image from oracle database into the picturebox. My oracle database got table name "STAFF_PHOTO" and the column of photo is "PICTURE". The image already converted into ByteArray. I'm already make a connection and success …

Hi all's... I'm need your help regarding how to make advance setup program with setup wizard.I manage to to create normal setup file....but i need to have the config page that i desgin in form2..to create the shortcut menu?..pleaswe

Hi guys... Can anyone help me to do log file for my apllication?...actually i'm doing console application where it will pull the data from database and insert to another database...i need to have log etheir it working or error..thanks for your help

Hi all...need help from u all...i already develop system using VB.net with Microsoft Access 2003 as my database. when i running in Windows XP it's working great but when running in Windows 7, i can't insert into it...can anyone help me plz

Hi all... i need to do some study regarding how to count the multiple int that keep in by user like this :- "Please enter the integer : 1 3 5 66 88 (1+3=4+5=9+66=75+88=163 - the program will terminted cause exceed than 100) how to do ?...i stuck very long …

Hi, I need ur help regarding to do this program in java....i need to do program where user can input any number n this program will count until reach 100...if reach then the program will print out :---bla bla bla.....if not user can keep input the integer..how to to?...i'm dizzy …

I'm already build this program but get error...anyone can check for me?..tq [CODE] public class Clock { private int hour; private int minute; private int second; public Clock (int hour, int minute, int second) { this.hour = hour; this.minute = minute; this.second = second; } public Clock (Int hour, int …

Hi... I have one problem regarding how to check whether the record already have or not then do insert or update...I'm using firebird database....i want to pull all record from one table to other database . Here my coding but i'm get stuck to do insert or update...hope anyone can …

Can anyone help me how to insert date into firebird?....i get the date value from other field then need to insert it into other database...but the problem is when the column is null the n it cannot insert it..anyone get idea?...tq

Hi all, I'm really need your help regarding how to insert image into blob field in Firebird/Interbase 6.0....I'm using connection trough ODBC ( "DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=c:\ibss\database\ibssdemo.gdb " I can manage to pull into SQL Server 2008..but not for Interbase....can anyone help me...here my code that giving error...(SQL -104) [CODE] If Not …

Hi all, Pls help me....i need to save picture from oracle database (blob type) into jpeg....i'm using vb 2005 with console application...After that i need to insert that picture into Other databasse...can anyone help me..tq

Hi All.... I need to detect when no moving of cursor or keyboard then my form will automatic closing...how to do that..tq

Hi all...need your help form this item....i need to get date from database table and compare it either it today or tomoe..after that need to compare time.... I got table where the format is 'datetime' contains like = 4/11/2010 12:00:00AM'....so i need to get the date only...how to do that?...when …

Hi all...i need your help regarding to change a new day and date after clock shown 00:00:00 AM......can anyone help me....i'm desprerated....tq

Hi everyone, I got prob with my proj that is reading data from Mifare Card using Contactless Card Reader (ACR120U). for the connection its successful but need to press cmdButton to grab a data from Mifare card. So if anyone got idea how to grab data automaticly such as flash/touch …

Hi, i need your help to get date of birth (DOB) from the Age that given...example AGE = 45...so how to get the DOB?...tq

Hi All's, I trying to develop new virtual keyboard for my on screen application using vb 2005. I can send a letter to cursor but just form one time only....how to send key to activewindows application at current cursor?...can anyone help me plz... This is my coding:[CODE] SetActiveWindow(8975651603260375040) If CheckBox1.Checked …

Hi All, Need your help regarding to get time from remote pc via Network (LAN)..plz...urgently need...tq

Hi Buddy's, I need your guide to done this item...how to set my pc time application sync with my remote time server?...my pc application is 192.1.2.1 and my time server is 192.20.10.1.... Can anyone help me.... Thank in advance

Hi buddy's, I need your guide regarding to pull data form other database to other database....I'm already pull the data into Dataset using this command :- [CODE] oracmd = New odbccommand ("Select id,name,dept from staff order by id",oracn) da = ds.fill [/CODE] then i need to insert to other database …

Hi Alls, I really need help from u all regarding how to update database using checkbox in datagridview.... i got 4 columns from my access database that is:- Columns1 = Id Coulmn2 = Name Columns3 = Status Columns4 checkbox = I need to update any data in column that have …

Hi, I'm already create connection to database with datagridview to view the data. I also create header unbound like this :- STUDENT ID,STUDENT NAME,REMARKS(CHECKBOX). I need to pull data from database with column SM_STUDENT_ID,SM_STUDENT_NAME then insert under this datagridview column.....how to do that..c.an anyone assist me.....so long to setle it..plzzzz

Hi Alls Buddy, I'm still stuck to check value in listbox either more than one or duplicate value when keep in in textbox.... i got one textbox as search box and one listbox.....when i keep in the value it will load into listbox with this coding "[CODE] if textbox1.text <> …

Hi All's, I need to read value from my mdb database into currency format in textbox...can anyone guide me please.tq in advance

Hi Alls, I got problem here to check whether the value in listbox more than one or already exist....I already do this code but it just check existing value only not count if it more than that,,,,anyone can show me the way plz...

Hi All my buddy, I'm trying to add my data to datagrid from mdb. I can do that but the problem is , i need to custom the header.....but it just display all selected item field from my database...can anyone show me how to display in datagrid with only selected …

Hi, I',\m already success to display value from mdb database into crystal report.....i got some problem that is ... how to display item with own format into crystal report..The situation is..in my database the field is like this = EPS0000000 with autonumber function. But when display in crsytal report it …

Hi Alls, I need your help regarding crystal report....i have access database, application form,crystal report.rpt......the application form i build it with VB.net..... Crystal Report already done...but i need to link data into it and print...Assume i keep in the data like student id , name into Application form..then i need …

Hi Alls, I'm really need your's help... I develop console application as a engine to pull data from oracle to SQL...the connection to both database is ok..but when to insert got problem....somebody help me plz.... [CODE] 'Connection To Sql Dim sqlcn As SqlConnection Dim sqldr As SqlDataReader Dim sqlda As …

Hi Alls, I try to write into .doc file and success...but i need to know how to write into form that i already make in microsoft word?...it's mean i got one form(document) in microsoft word format...then my input from textbox box ,will save into SQL database. I need to print …

Hi All, I try to ping my server with my application but cannot make it.....anyone can help me in VB.net 2003 , if use vb.net 2005 it already ok..plzzz

Hi, I already create connection to sql database and successfull. I need to know how to run two command together?...This is my problem:- [CODE] sqlcmd = New Sqlcommand ( "Select * from Staff_Main where Staff_id like '"&textbox1.text&"'",cn) dr = sqlcmd.executereader while dr.read() label1.text = dr.item(1) 'item 1 is name sqlcmd …

Hi Alls, I need help regarding to rename my event file by current date. It's mean my file will be rename by date automaticly.....i can write to the text but the name not replace with the current date....can u help me...plz

Hi, I have 1 textbox and button to insert value into sql server database 2008. But the problem is in database it not appear correctly when had zero front of value....example :- 00001.....in database just appear 1...i try to use nvarchar,varchar,nchar but still same...] Can anyone guide me...tq

Hi Alls, Can anyone guide me how to check either the data valid or not in database?.... I got one textbox..when enter the ID Number..then the message box will appear valid or not thar id...the inquiry from database.... Anyone can help me?

hi all, I got 3 form that is form1,form2,form3 I create a mainmenu to call form2 or form3 I got problem to getcenter the form2 or form3 in FORM 1.... Anyone have idea?...

Hi alls, I'm using console application to pull data between 2 different database and column name (from Oracle to Sql 2008). The connection already done..but i'm having problem to select and insert from oracle to sql... The details as below :- Oracle DB Table :- Event Column : ID , …