thx dude..its working now..

now the code already working.but the location of the output is not the same as the input.let say the input=101000,the output would look like this"001010=...".its changes place from last place to 1st place.actually i set it to read pair by pair.If Mid(sData, iChar, 2) = "00" Thenit doest read odd num input.

this is the decoding function,its working Public Function sHexDecode(ByVal sData As String) As String Dim iChar As Integer Dim sOutString As String Dim sTmpChar As String For iChar = 1 To Len(sData) Step 2 If Mid(sData, iChar, 2) = "00" Then 'sTmpChar = vbNullString oCP.Write(Chr("&H" & (1 - 1))) GoTo skipDecode End If sTmpChar = Chr("&H" & Mid(sData, iChar, 2)) skipDecode: sOutString = sOutString & sTmpChar Next iChar sHexDecode = sOutString 'Mod By TC Kua TextBox1.Text = "" TextBox1.Text = sHexDecode End Function this is the part to display the output Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try 'Mod by TC Kua 21st Feb 2008 Call sHexDecode(txtHex.Text) oCP.Write(Encoding.ASCII.GetBytes(Me.TextBox1.Text))))) oCP.Write(Chr("&H" & (1))) Catch ex As Exception ' Warn the user. MessageBox.Show("Unable to write to comm port") Finally End Try End Sub

im doin a convertion from hex to ascii.the formula is working fine.but the is one problem whereby if the input is 00.its cant be display in the output..eg input="101010" the output="..." but for 1001 the output only ".".how could is resolve this?

Compiler Error Message: BC30455: Argument not specified for parameter 'strBiaya' of 'Public Function DBAuthenticate(strUsername As String, strPassword As String, strTajuk As String, strObjektif As String, strSokong1 As String, strSokong2 As String, strBiaya As String) As Boolean'. Source Error: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As Handles Button1.Click If IsValid Then If DBAuthenticate(txtnama.Text, txttajuk.Text, txtobjektif.Text, txtsokong1.Text, txtsokong2.Text, txtbiaya.Text) = True Then FormsAuthentication.RedirectFromLoginPage(txtnama.Text, False) Response.Redirect("homelec2.aspx") anybody can help?

there is a data in the db.can u show me the write stored proc?My stored proc look like this : dbo.sp_getUser ( @noPekerja varchar(50) ) AS SELECT lec.* FROM lec WHERE (lec.noPekerja = @noPekerja) Is it rite?

the name field is correct.it return nuthing.one thing how should the stored proc look?

the line is: txtnama.Text = CStr(dr("nama")). how to make sure that the datareader has row?did't if check it with: If dr.HasRows = False Then ' error mesej Else txtnama.Text = CStr(dr("nama"))

the error is : Invalid attempt to read when no data is present.

im trying to retreave an information from a database after the person have logged in.but i can insert the data to a specific place that im intent to put it.Im using session to do that by passing the parameter to campare it. this is the code i used: Dim MyConn As SqlConnection Dim cmdSelect As SqlCommand userName = Session("userName") If userName <> "" Then MyConn = New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString")) cmdSelect = New SqlCommand("sp_GetUser", MyConn) cmdSelect.CommandType = CommandType.StoredProcedure Dim parameternoPekerja As New SqlParameter("@noPekerja", SqlDbType.VarChar) parameternoPekerja.Value = userName cmdSelect.Parameters.Add(parameternoPekerja) MyConn.Open() Dim dr As SqlDataReader = cmdSelect.ExecuteReader(CommandBehavior.CloseConnection) If dr.HasRows = False Then ' error mesej Else txtnama.Text = CInt(dr("nama")) txtjawatan.Text = CInt(dr("jawatan")) txtjabatan.Text = CInt(dr("jabatan")) txtbidang.Text = CInt(dr("jabatan")) txtjabatan.Text = CInt(dr("jabatan")) End If Else 'error Is it wrong

im trying to retreave an information from a database after the person have logged in.but i can insert the data to a specific place that im intent to put it.Im using session to do that by passing the parameter to campare it. this is the code i used: Dim MyConn As SqlConnection Dim cmdSelect As SqlCommand userName = Session("userName") If userName <> "" Then MyConn = New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString")) cmdSelect = New SqlCommand("sp_GetUser", MyConn) cmdSelect.CommandType = CommandType.StoredProcedure Dim parameternoPekerja As New SqlParameter("@noPekerja", SqlDbType.VarChar) parameternoPekerja.Value = userName cmdSelect.Parameters.Add(parameternoPekerja) MyConn.Open() Dim dr As SqlDataReader = cmdSelect.ExecuteReader(CommandBehavior.CloseConnection) If dr.HasRows = False Then ' error mesej Else txtnama.Text = CInt(dr("nama")) txtjawatan.Text = CInt(dr("jawatan")) txtjabatan.Text = CInt(dr("jabatan")) txtbidang.Text = CInt(dr("jabatan")) txtjabatan.Text = CInt(dr("jabatan")) End If Else 'error Is it wrong?

the error is : Value of type 'System.Configuration.ConnectionStringSettingsCollection' cannot be converted to 'System.Data.SqlClient.SqlConnection'. so?

how could i do that?

when i was trying to connect to the database there is an error occured. the erro r is: The ConnectionString property has not been initialized. i check it with the local window below it,the connection to database is null. what can i do?

where did u specified ur connection string?

i cant understand what did u mean?could u show my what ur web config look like.

there is an error: Unrecognized attribute 'keyword'. Note that attribute names are case-sensitive. the code is: add keyword="name=psmConnectionString2" keyword1="connectionString=Data Source=HAPPYFAM-B614E1\SQLEXPRESS;Initial Catalog=psm;Integrated Security=True" providerName="System.Data.SqlClient" -- modified at 4:06 Wednesday 1st March, 2006

where should i change.is it in the web config?

could u show me one of ur example?

it return nuthing.the page when blank.whats wrong?