.NET Logo
Welcome Guest Search | Active Topics | Members | Log In | Register

CodeToday.NET » Microsoft .NET Developer Forum » ASP.NET & Expression Web » ดึงข้อมูลจากAccess

ดึงข้อมูลจากAccess Options · View
Previous Topic · Next Topic
ucifer
Posted: Wednesday, October 01, 2008 9:18:42 PM
Rank: มือฝึกหัด
Groups: Member

Joined: 9/10/2008
Posts: 8

ผมอยากดึงข้อมูลจาก Access แล้วให้มาโชว์ใน Textbox

เช่นดึงข้อมูล ชื่อ ที่อยู่ มาโชว์ใน Textbox1 กับ Textbox2

ต้องเขียนโค๊ดยังไงครับช่วยหน่อย ประมาณนี้อ่ะครับ

 

<

html xmlns="http://www.w3.org/1999/xhtml" >head runat="server">

 

</

<

<title>Untitled Page</title>head>body>

 

<form id="form1" runat="server">

 

<div>

 

&nbsp;&nbsp;

 

<asp:TextBox ID="txthn" runat="server"></asp:TextBox>

 

<asp:Button ID="Button1" runat="server" Text="Button" />&nbsp;<br />

 

<br />

 

<br />

ชื่อ

&nbsp; &nbsp;

 

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />

 

 

&nbsp;ที่อยู่<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />

 

<br />

 

&nbsp;</div>

 

</

</

<

Dim

(

 

 

myda.Fill(ds,

 

</form>body>html>script runat=server> myconn As New OleDbConnection _"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" & Server.MapPath("a.mdb"))Dim myda As New OleDbDataAdapter("Select * From Register WHERE HN='" & txthn.Text & "'", myconn)Dim ds As New DataSet"Table1")</script>

<
Back to top
 
zerozaaa
Posted: Thursday, October 02, 2008 10:29:33 AM
Rank: มือพระกาฬ
Groups: Member

Joined: 6/13/2008
Posts: 79

 

Webconfig  Connect Database Access
 
<connectionStrings>
            <addname="ConnectionString"connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\dbschool.mdb;Persist Security Info=True"providerName="System.Data.OleDb"/>
      </connectionStrings>
 
 
using System.Data.OleDb;
 
 
string sqlProducts;
 
            string conStrDB;
            conStrDB = WebConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
            OleDbConnection Conn = new OleDbConnection(conStrDB);
            Conn.Open();
 
            sqlProducts = "SELECT name,id_pic,topic_pic,name_pic FROM picture";
            OleDbDataAdapter oda = new OleDbDataAdapter(sqlProducts, Conn);
            DataSet ds = new DataSet();
            oda.Fill(ds, "picture");
 
          TextBox1.Text = ds_see.Tables[0].Rows[0][0].ToString();
          TextBox2.Text = ds_see.Tables[0].Rows[0][1].ToString();
 
Picture เป็นชื่อ Table คับ dbschool.mdb เป็น Database คับ
Back to top
 
Users browsing this topic
Guest

CodeToday.NET » Microsoft .NET Developer Forum » ASP.NET & Expression Web » ดึงข้อมูลจากAccess


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFVision Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.

Sponsored by