|
I developed my pages in dreamweaver, now I want to connect to my MS Access database.Anyone help with a HTLM code on how to connect.
This code shows what I want to do on this webpage.Please help with a code.I used vb.net & c# and they work but I want to use straight HTLM coding.
****************************************************************************
using System;
using System.Data;
using System.Data.ProviderBase;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
//**************************First Connection DropDownList Load******************
OleDbConnection connect = new OleDbConnection();
//string strng = @"Provider = Microsoft.Jet.Oledb.4.0; Data Source = C:\StoreKey.mdb";******uncomment this
string strng = @"Provider = Microsoft.Jet.Oledb.4.0; Data Source = C:\TelephoneList.mdb";
//OleDbDataReader datareader;
//*****************************Second Connection Datagrid population***************
//OleDbConnection connectin = new OleDbConnection();
//string strng2 = @"Provider = Microsoft.Jet.Oledb.4.0; Data Source = C:\TelephoneList.mdb";
//OleDbDataReader datareader2;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
// when a character is selected
// load the datagrid with values from that character
LabelMessage.Text = "";
connect.ConnectionString = strng;
//OleDbCommand command = new OleDbCommand("Select * from Extensions Where FilterByKey = '" + DropDownList1.SelectedItem + "'", connect);
OleDbDataAdapter oda = new OleDbDataAdapter("Select Name, Surname, Department, Xtension, [Alternative Extension] from Extensions Where FilterByKey = '" + DropDownList1.SelectedItem.ToString() + "'", connect);
connect.Open();
DataSet datas = new DataSet();
oda.Fill(datas, "MyTable1");
GridView1.DataSource = datas.Tables[0];
GridView1.DataBind();
}
}
:->
kagiso
|
|
|
|
|
I'm not shure what you mean but you can
Repeater2.DataSource = Repeater1.DataSource;
Repeater2.DataBind();
or
if (Repeater1.DataSource is <typeofdatasource>)
{
//do something...
}
|
|
|
|
|
Hi,
Can i connect from PHP to MS Access Without ODBC? If possible give me a sample.
Socheat
................
|
|
|
|
|
Try this: PHP Connect To Access
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
Sorry, the url go to another page, how connect fox pro with access without odbc, is possible connect php with access without odbc?
|
|
|
|
|
I want to write a program that draws some shape (for example line, circle, etc). This program should be executed on a website and it should be client side.
What do you offer me? (I should implement it by applet or js or ...)
|
|
|
|
|
|
What about action script (mm flash). Do you think it's a good way for implementing such this program?
Note that this program should read data from a file and draw shapes according to the data.
Js is a good way to do this but I want to research about another ways, to find the best.
Thanks for your guids.
GoOd LuCk
|
|
|
|
|
Whilst that is a pretty cood lib for drawing stuff in JS, have you looked at its performance when things get complicated....at one point, due to the way it works, I ended up with c1000 divs on my page......
"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)
|
|
|
|
|
how to bind repeater depend on another repeater in asp.net2
amr el sayed
|
|
|
|
|
Hi Guys,
How can I get the value from my tblEmployee.EmployeeID?
Please correct my code below?
.
.
.
IdentCurrent.CommandText = "Select EmployeeID from tblCustomers" IdentCurrent"
IdentCurrent.CommandType = Data.CommandType.Text
IdentCurrent.Connection = sqlConn
da = New Data.SqlClient.SqlDataAdapter(IdentCurrent)
da.Fill(ds)
iCurrentID = ds.Tables.Item(0).ToString()
MsgBox(iCurrentID) 'msgbox - it wont' display the value
Thanks in advance Guys
hifiger2004
|
|
|
|
|
How do you want to display it?
You can for example put a Label on the page, and assign the value to it's Text property:
SomeLabel.Text = ds.Tables.Item(0).ToString()
---
single minded; short sighted; long gone;
|
|
|
|
|
i use a custom control for logout"logout.ascx"
it has a buttom and coding is
protected void Button1_Click(object sender, EventArgs e)
{
Session.Clear();
Session.Abandon();
Response.Cookies.Clear();
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetAllowResponseInBrowserHistory(false);
FormsAuthentication.SignOut();
Response.Redirect("index.aspx");
}
it works well but when user goes to back from window menu it allowed
and page load event not taking effect.
pls help
|
|
|
|
|
When they go back they are seeing their browsers cache of the previous page, its not being requested again from server. If they try to refresh the page or click some action on the page it will fire a request and page_load will run.
|
|
|
|
|
I am trying to investigate into International language renderings using Unicode. Typically, if you observe this URL (http://ezilnila.com/tane/unicode_Writer.htm[^]), it facilitates rendering in Tamil. However, Internet Explorer works fine. But I see junk text in Mozilla FireFox.
I am encountering the same issue while generating Unicode Tamil in Indic IME Editor Helper for Microsoft Word.
Should I set some charset or similarly for Mozilla Firefox?
|
|
|
|
|
It looks fine to me in Firefox. (Well, Tamil looks like junk to me anyway  , but it looks the same as in IE.)
Do you have a recent version of Firefox? I have version 2.0.0.4.
---
single minded; short sighted; long gone;
|
|
|
|
|
It looks fine in FireFox.
Regards,
Arun Kumar.A
|
|
|
|
|
Arun,
I see Tamil characters are rendered but did you see that it is unintelliglble set of characters. I guess, some explicit charset setting for Unicode (in case of Mozilla FireFox) is required?
|
|
|
|
|
Hi Guys,
How can I show the value of textbox1.text and textbox2.text from the other aspx thru msgbox. Because, when I click the button there's no msbox will popup.
I hope you can send me a sample asp.net code vb coding on how to do it. Right now I am using session.
Thanks in advance Guys
hifiger2004
|
|
|
|
|
I think you are asking for code to show a message box.
Here is some code I have used for vb.net .net version 1.1
Private Sub ShowMessageBox(ByVal aMessage As String)
'This procedure will cause a dialog box to pop up with whatever message is passed in.
aMessage = aMessage.Replace(vbCrLf, "\n").Replace("""", "'")
Dim myScript As New StringBuilder
With myScript
.Append("<script>")
.Append(Environment.NewLine)
.Append("alert(""").Append(aMessage).Append(""");")
.Append(Environment.NewLine)
.Append("</script>")
Page.RegisterStartupScript("msg box", .ToString())
End With
End Sub
The code is a little different if you are using .net 2.0.
I think you would continue to need to save the text box data in session, if you need it on another page.
Hope that helps.
Ben
|
|
|
|
|
hifiger2004 wrote: How can I show the value of textbox1.text and textbox2.text from the other aspx thru msgbox. Because, when I click the button there's no msbox will popup.
You may be labouring under a misapprehension here - if you show a message box on the server side - i.e. in your codebehind - then it will be shown ON_THE_SERVER, not on the client. If you're working on localhost, then you'll see it, but any clients connecting from other machines won't - but you will!
If you're adamant you want to use a messagebox-type output, then Session is the way to go, followed by either registering some startup script, or by slapping the values into some hidden fields , then using javascript to get the values out and alert() them...
"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)
|
|
|
|
|
If the values are in the session, then all you need to do is write javascript code to show them in a message box when the form loads.
Posting your code would help us help you.
hifiger2004 wrote: Because, when I click the button there's no msbox will popup.
To make this work, you need to create a button on the client, which triggers the javascript on the client.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hello,
i m using mathod for uploading image:
int i=file.postedFile.ContentLength();
byte[] len=new byte[i];
sqlcommand.parameter.add("@image",len);
for retrieval:
SqlDataReader rd;
.......
byte[] barImage = (byte[])rd.GetValue(rd.GetOrdinal("image"));
Response.ContentType = "image/gif";
Response.BinaryWrite(barImage);
i m using SQl2005
and clumn is "image" type
but image shows unavailable image "cross mark"
what may be wrong pls help.
|
|
|
|
|
Are you sure it's a gif ? If you do a binary write of the data to the file system, do you get a GIF ? That's one way to break down the process, and work out which part is not working.
Response.End() is also good, to make sure nothing else gets sent. Also make sure your ASP.NET page is not writing debug info into the page.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Have you tried adding Response.Flush() at the end?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
