KaMbEnG KeR 0 Report post Posted May 2, 2008 (edited) assalamualaikum..ni coding pnuh form ke2:Imports System.Object Imports System.Data Imports System.Data.OleDb Partial Class Carian2a Inherits System.Web.UI.Page Dim str As String = "Provider=Microsoft.Jet.oledb.4.0;Data Source='C:\Sistem.mdb'" Dim Conn As New Data.OleDb.OleDbConnection(str) Dim UserID As String Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim txtCarian As String UserID = Request.QueryString("UserID") Conn.Open() Dim obj As String = " " Dim objcommand As New Data.OleDb.OleDbCommand(obj, Conn) txtCarian = Session("txt") If Session("pilih") = "A" Then obj = "select * from Pelajar where Nama like '%" & txtCarian & "%' order by Nama " Response.Write(obj) gvNama.DataBind() 'Else 'lblMsg.Text = "Maaf.. Anda memasukkan kata kunci yang tidak mengikut kriteria pilihan yang diberi." End If Conn.Close() End Sub form1 de txtbox ngan radio button.. ni coding carian 1: If radNamaCari.Checked = True Then 'txtCarian.Text = "@Nama" Session("pilih") = "A" Session("txt") = txtCarian.Text Response.Redirect("Carian2a.aspx?UserID=" & txtCarian.Text)sebelum coding form ke2 tu..user plih radio button pastu taip kt txtbox ikut kriteria so dia akn ke form2,,form 2 tu ade gridview..cam ne nk set gridview tu supaya gridview tu paparkan data yang pengguna cari jer..sbb skrg dia paparkan sume skali.. Edited May 2, 2008 by kAmBeNg KeR Quote Share this post Link to post Share on other sites
Uwais Al-Qarani 0 Report post Posted May 2, 2008 err ini masalah ker contoh untuk nak buat grid tu? Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 err ini masalah ker contoh untuk nak buat grid tu?ni masalah...jap ek.. Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 ermmm... kenapa tak kuar eikcuba ubah gini lak...If Session("pilih") = "A" Then obj = "select * from Pelajar where Nama like '%" & txtCarian & "%' order by Nama " Conn.Open() Dim sCmd As New OleDbCommand(obj , Conn) Dim rd As OleDbDataReader = sCmd.ExecuteReader() gvNama.DataSource = rd gvNama.DataBind() End If Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 ermmm... kenapa tak kuar eikcuba ubah gini lak...If Session("pilih") = "A" Then obj = "select * from Pelajar where Nama like '%" & txtCarian & "%' order by Nama " Conn.Open() Dim sCmd As New OleDbCommand(obj , Conn) Dim rd As OleDbDataReader = sCmd.ExecuteReader() gvNama.DataSource = rd gvNama.DataBind() End Ifda ubah tapi ade error..Both DataSource and DataSourceID are defined on 'gvNama'. Remove one definition. Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 hang dah define datasource ker kat gridview tu? sy wat ok jer...kalo dah define, buang yg dah define tu, guna kod yg dibagi tu.. sebab kat situ kita bg datasource utk gridview tu.. Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 hang dah define datasource ker kat gridview tu? sy wat ok jer...kalo dah define, buang yg dah define tu, guna kod yg dibagi tu.. sebab kat situ kita bg datasource utk gridview tu..yg ini ye?ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Sistem.mdb" Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 yerla kot. sy taktau full code awak. takleh nk komen mana. tu dok tang mana? coba buang, leh run tak? kalo takleh, buang gridview wak tu, drag gridview baru, tukar nama GridView1 jadi gvNama, then run... Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 (edited) da ok..trime kasih..tapi mcm mane nak hubungkan dgn form3..ni coding utk form3: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim obj As String On Error Resume Next UserId = Request.QueryString("UserID") obj = "SELECT * FROM Pelajar WHERE PelajarID = " & UserId If Conn.State = ConnectionState.Closed Then Conn.Open() End If Dim objcommand As New OleDbCommand(obj, Conn) Dim dr As OleDbDataReader dr = objcommand.ExecuteReader dr.Read() Me.lblNoID.Text = CStr(Trim(dr.Item("PelajarID"))) Me.lblNamaCarian.Text = CStr(Trim(dr.Item("Nama"))) Me.lblNoTelCarian.Text = CStr(Trim(dr.Item("NoTel"))) Me.lblNoMatrikCarian.Text = CStr(Trim(dr.Item("NoMatrik"))) Me.lblProgramCarian.Text = CStr(Trim(dr.Item("Program"))) Me.lblPenyeliaCarian.Text = CStr(Trim(dr.Item("Penyelia"))) Me.lblKemudahanCarian.Text = CStr(Trim(dr.Item("Kemudahan"))) Me.lblEmelCarian.Text = CStr(Trim(dr.Item("Emel"))) Me.lblStatus.Text = CStr(Trim(dr.Item("StatusPelajar"))) Me.lblNoBilikCarian.Text = CStr(Trim(dr.Item("NoBilik"))) dr.Close() Conn.Close() End Sub coding ni papar data kalau kte da tentukan pelajarID dia.. tp klau set awal2 nnt bile user klik yang lain pn akan kuar yg set tu jugak.. ni coding kt button form2.. Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim CheckBox1 As New CheckBox If CheckBox1.Checked = True Then Response.Redirect("Carian3.aspx?UserID") End If End Sub Edited May 2, 2008 by kAmBeNg KeR Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 apa maksud awak nak hubung dengan form3? tak paham....yg ni Response.Redirect("Carian3.aspx?UserID") betul ker? apa nilai UserID? Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 utk coding source diafunction check_uncheck (Val) { var ValChecked = Val.checked; var ValId =Val.id; var frm = document.forms[0]; for (i=0; i<frm.length; i++) { if (ValId.indexOf ('CheckBox1') != -1) { if(ValChecked) frm.elements[i].checked = true; else frm.elements[i].checked = false; } else if (ValId.indexOf ('CheckBox1') != -1) tp code button ni tak pegi kat form3 tu.. apa maksud awak nak hubung dengan form3? tak paham.... yg ni Response.Redirect("Carian3.aspx?UserID") betul ker? apa nilai UserID?mksudnye bile user klik checkbox pastu klik button1 tu dia akan pegi ke form3 dan paparkan sume skali maklumat pasal carian sebelum ni..userid tu ikut user yg login.. Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 mmg dia akan ikut user yg login, tapi kat sini Response.Redirect("Carian3.aspx?UserID") dia tatau apa userID sebab takder nilai.... nampak tak??? patutnya .....?UserID=***something kat sini*** Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 mmg dia akan ikut user yg login, tapi kat sini Response.Redirect("Carian3.aspx?UserID") dia tatau apa userID sebab takder nilai.... nampak tak??? patutnya .....?UserID=***something kat sini***ermm...mcm mane nk set?maap yer tak taw.. Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 ermmm coba tgk sini Response.Redirect("Carian2a.aspx?UserID=" & txtCarian.Text) kat situ kan nilai UserID=txtcarian kan? so utk ke form3 tu takder nilai dibagi untuk userID. perasan tak? so kena bagi nilai arrr.... errrr dpt ke tak? Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 ermmm coba tgk sini Response.Redirect("Carian2a.aspx?UserID=" & txtCarian.Text) kat situ kan nilai UserID=txtcarian kan? so utk ke form3 tu takder nilai dibagi untuk userID. perasan tak? so kena bagi nilai arrr.... errrr dpt ke tak? mksudnya sy kne ltk nilai checkbox ke? mcm ni Response.Redirect("Carian3.aspx?UserID=" & CheckBox1.Checked) Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 bukan ler dik oiii... wak ckp useriD tu ikut userid yg user login kan? so, kat situ UserID sepatutnya nilai userid yg user login tu arrr... paham ker? Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 bukan ler dik oiii... wak ckp useriD tu ikut userid yg user login kan? so, kat situ UserID sepatutnya nilai userid yg user login tu arrr... paham ker?mksudnya ikut yg kat database la?mcm niResponse.Redirect("Carian3.aspx?UserID=" & UserID)alamak xbrape fhm.. Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 ermm.. caner nak bgtau eikk.. bila user login, dia login ngan userid and password dia kan. so nilai userid dia tu arr... kalo UserID kat situ dia punya userid, so betul arr kat atas tu. coba wat, test,test.. Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 ermm.. caner nak bgtau eikk.. bila user login, dia login ngan userid and password dia kan. so nilai userid dia tu arr... kalo UserID kat situ dia punya userid, so betul arr kat atas tu. coba wat, test,test..da try da..tak de error tapi tak jadi pape..kt database UserID tu type dia number.. Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 2, 2008 apa maksud tak jadi paper? dia kuar apa? masa login tu, apa nilai userid? masa load page utk carian tu, ada bawak skali ker tidak dia punya userid? Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 2, 2008 apa maksud tak jadi paper? dia kuar apa? masa login tu, apa nilai userid? masa load page utk carian tu, ada bawak skali ker tidak dia punya userid?dia paparkan form gridview tu jugak dia tak beralih ke form ke3 tu..sy da run dr login sblm test form carian tu.. Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 5, 2008 (edited) salam..ni sy tunjukkan design carian yang sy wat..mcm tu lah yang sy maksudkan..mule2 dia akan pilih 1 radio button pastu msukkan kata kunci pastu klik button untuk cari tu dia akan ke form ke2 yang ade gridview tu.. kat situ dia akan pilih checkbox(tak boleh check all) dan klik button untuk pegi ke form yang ke3 lak.. kat form ke3 tu dia akan paparkan data2 dari carian sebelum tu..sy tak dapat nak wat aturcara untuk hubungkan form ke2 kat form ke3 tu untuk papar data..yang len2 dapat da mslh dia kat checkbox dan button yang ptut bawak dia kat form3 tu..sesape boleh bantu sy tak... Edited May 5, 2008 by kAmBeNg KeR Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 5, 2008 ni ada satu idea. kenapa nak pakai checkbox tu? apa kata, tukar, bila klik carian kat form cari tu, paparkan dlm table dia punya senarai carian. setiap nama yg dicari tu buat hyperlink.. so bila nk tengok detail dia, just klik kat nama jer... bleh ka? hehehehe... Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted May 5, 2008 ni ada satu idea. kenapa nak pakai checkbox tu? apa kata, tukar, bila klik carian kat form cari tu, paparkan dlm table dia punya senarai carian. setiap nama yg dicari tu buat hyperlink.. so bila nk tengok detail dia, just klik kat nama jer... bleh ka? hehehehe...macam mane?kire dia still dalam gridview tapi tak de checkbox ke? Quote Share this post Link to post Share on other sites
DrASAG 0 Report post Posted May 5, 2008 yer. cuma buat senarai nama yg dicari tu dlm hyperlink. so user just click that name... Quote Share this post Link to post Share on other sites