|
JavaScript - Working with Database
After reading this coding, you will know the following facts.
How to connect the database in JavaScript
How to use the ADODB.Recordset in JavaScript
As I already put the details comments in coding, I hope you will find it useful.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<script type="text/javascript">
<!–
var adOpenDynamic = 2;
var adLockOptimistic = 3;
/* Path of database.
If you put the database "Inventory.mdb" in different location,
you need to specify the correct path to this variable.
But When you are running the webpage from Browsers only,
you should use this keyword "window.location.pathname" for getting
the current location. But If you are using FrontPage,
you hav to specity the static path.
*/
var strDbPath = "C:\\JavaScript Database\\Inventory.mdb";
/*
Here is the ConnectionString for Microsoft Access.
If you wanna use SQL or other databases, you hav
to change the connection string..
eg: SQL => var conn_str = "Provider=sqloledb; Data Source=itdev;" +
"Initial Catalog=pubs; User ID=sa;Password=yourpassword";
*/
var conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strDbPath;
function getAdoDb(strAdoType){
if (window.ActiveXObject){
return new ActiveXObject(strAdoType);
}
else{
return new ActiveXObject(strAdoType);
}
}
function showReports(){
try{
var strHtml ="";
strHtml += "<table cellpadding=0 cellspacing=0 border=1 width=500px align=center>";
strHtml += "<tr ><td align=center colspan=4><b>Stock List</b></td></tr>";
//Database Connection
var conn = getAdoDb("ADODB.Connection");
conn.open(conn_str, "", "");
//Recordset
var rs = getAdoDb("ADODB.Recordset");
strQuery = "SELECT StockID,StockName,ReOrderLevel,IsActive FROM Stocks";
rs.open(strQuery, conn, adOpenDynamic, adLockOptimistic);
if(!rs.bof){
rs.MoveFirst();
while(!rs.eof) {
strHtml += "<tr>";
strHtml += " <td width=\"10px\">" + rs.fields(0).value + "</td>";
strHtml += " <td width=\"50px\">" + rs.fields(1).value + "</td>";
strHtml += " <td width=\"10px\">" + rs.fields(2).value + "</td>";
strHtml += " <td width=\"5px\">" + rs.fields(3).value + "</td>";
strHtml += "</tr>";
rs.MoveNext();
}
}
else{
//No Records.
strHtml += "<tr colspan=4><td align=center><font color=red>No Records.</font></td></tr>";
}
conn.close();
strHtml += "</table>";
document.write(strHtml);
}catch(ex){
alert(ex.message);
}
}
//–>
</script>
<title>Stock List</title>
</head>
<!–<body onload="show_menu()">
<div id="main" />–>
<body>
<script language="JavaScript">
showReports();
</script>
</body>
</html>
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
And if the user isn't running IE?
|
|
|
|
|
these are the objects you can use to connect database.
=====================================================
this supports both IE and NNav
DbPool Constructors
Name MSIE NNav Notes
DbPool() - -
DbPool Methods
Name MSIE NNav Notes
connect() - -
connected() - -
connection() - -
disconnect() - -
majorErrorCode() - -
majorErrorMessage() - -
minorErrorCode() - -
minorErrorMessage() - -
storedProcArgs() - -
toString() - -
DbPool Properties
Name MSIE NNav Notes
prototype - -
this link will help you
=======================
http://docs.sun.com/source/816-6410-10/dbpool.htm[^]
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
|
Thanks for adding my link. Scott.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Thank you. 
|
|
|
|
|
You're welcome. Just trying to be helpful. 
|
|
|
|
|
Hai to all,
I am using crystalreports Version7 in my VS2003(which supports crystalreports version9 ),But lower version can be used in the upper version.
Here i am getting problem when i am using report's Design part from the crystal report and the rest(like dataset and sqlquery for the report)are in .net/vbnet itself.
Here when i am debugging this,it si giving an error like "Logon Failed",I have checked the DBConnection also.
In my view there is no problem with the crystal report's Version. I am using SqlServer as backend.
Why it is giving error,For some reports it is working.
Can anybody give me the reason???
Thanks in advance
Regards,
kissy
kissy
|
|
|
|
|
Welcome to developing with Crystal Reports, the worst reporting application ever!
nothing
|
|
|
|
|
provide your database info
//set the database loggon information.
//**Note that the third parameter is the DSN name
// and not the Database or System name
reportDocument.SetDatabaseLogon("pchitriv", "Windows2000",
"TestDB_DSN", "testDB", false);
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
I need the help for printing the web page without clicking any button
|
|
|
|
|
you need an event to call the print function.
Thomas
|
|
|
|
|
|
You can call the Print() Function by declaring it, in the onLoad attribute of the Body Tag .
Regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Hi,
need help with the following code, the intention is for my server-side web app to open a doc held on the server's drive using a clients external native program (ie. notepad for a .text doc).
my code so far:
(previous page redirects to here after setting the file path as the session 'FullFilePath')
FileStream theFile = File.Open(Session["FullFilePath"].ToString(), FileMode.Open);
Response.AppendHeader("content-disposition", "attachment;filename="+Session["FullFilePath"].ToString());
Response.Write(Session["FullFilePath"].ToString());
long filesize = theFile.Length;
byte[] getContent = new byte[filesize];
Response.BinaryWrite(getContent);
Response.Flush();
Response.Close();
theFile.Close();
theFile.Dispose();
compiled my site which was all fine
but then get server error in my app when i browse to it after its set live.
'Specified argument was out of the range of valid values.
Paramater name: offset'?
but I can't see that anythings wrong?
any thoughts at all?
|
|
|
|
|
What line does the code on. The other response.write of the filename might also be giving you a problem...
|
|
|
|
|
it seems to be on the filestream line, which made me think that the file path was bad, but then i response.write displays the path as ok, though the system may think otherwise
|
|
|
|
|
ok, with lots of playing I've narrowed it down to the
'Response.BinaryWrite(getContent);'
It took me a while to get that bit to what I thought was right, and taking it out lets the page work, but it just tries to open a new IE window with the redirected page in it rather than the file that I'm trying to open, I'm a little stumped as this is al new to me.
|
|
|
|
|
HI all,
I need a help for printing the content of the page displayed in the webpage
using vb.net
Can anybody help
I will be very very pleased if i get answer
|
|
|
|
|
Printing on the client? You can just get them to hit the print button in the browser...
Also, you can set css styles with a media of 'print' that will control how your page is displaying the print preview.
|
|
|
|
|
I hope the following article may help u out
Ever wanted to print a DataGrid alone from an ASP.NET Web page? Put an <asp:DataGrid> tag inside the tag does the trick. Here are the steps involved:
1. Enclose the <asp:datagrid></asp:datagrid> tag inside the <div></div> tag.
2. Write a JavaScript function which takes care of printing the content from <div> tag.
Here's an example:
<script language=javascript>
function CallPrint(strid)
{
var prtContent = document.getElementById(strid);
var WinPrint = window.open('','','letf=0,top=0,width=1,height=1,toolbar=0,scrollbars=0,status=0');
WinPrint.document.write(prtContent.innerHTML);
WinPrint.document.close();
WinPrint.focus();
WinPrint.print();
WinPrint.close();
prtContent.innerHTML=strOldOne;
}
</script>
<div id="divPrint">
<asp:datagrid>
.....
.....
.....
</asp:datagrid>
</div>
<asp:button ID="btnPrint" onClick="javascript:CallPrint('divPrint');" Runat=Server />
Everything Is Possible!
|
|
|
|
|
I have a webform whereby i use a dropdown list to select fields like title,province etc. but the problem is that when i select a value from the dropdown and click save button,the field in the database becomes blank.
my code is as follows:
BUSINESS LAYER
Public Function GetTitle() As Data.DataSet
Dim strSQL As String
Dim obj As Datalayer.Database = New Datalayer.Database
'strSQL = "Select * from UserProfile with (nolock) where UserName='" & strUserName & "' and Status = 'A'"
strSQL = "Select TitleID, Title from Title1 with (nolock) "
GetTitle = obj.GetDataSet(strSQL)
obj.Close()
Exit Function
End Function
PRESENTATION LAYER
Private Sub LoadTitle()
Dim ds As New Data.DataSet
Dim objdata As Businesslayer.Contractors = New Businesslayer.Contractors
ds = objdata.GetTitle
cbotitle.DataSource = ds
cbotitle.DataBind()
cbotitle.Items.Add(New ListItem("Select...", ""))
cbotitle.Items.Item(cbotitle.Items.Count - 1).Selected = True
End Sub
BUTTON SAVE
Dim obj As Businesslayer.Contractors = New Businesslayer.Contractors
Dim ds As Data.DataSet
ds = obj.Getcontractor(txtfirstname.Text)
obj.AddContractor(txtID.Text, cbotitle.SelectedItem.Value, cbogender.SelectedItem.Value, txtfirstname.Text, txtlastname.Text, _
txtIDNumber.Text, txttel.Text, txtcell.Text, txtfax.Text, txtemail.Text, _
cbodepartment.SelectedItem.Value, txtlocation.Text, txtcity.Text, txtpostal.Text, txtoccupation.Text, cbomtype.SelectedItem.Value, _
cboprovince.SelectedItem.Value, txtpassport.Text)
UserMsgBox("Successfully add")
Karabo Mekgwe
|
|
|
|
|
the field in the database becomes blank.?
you mean. the selected value doesn't store in database.
some tips.
1. Set the breakpost in Button Save. Check the selected value of combobox.
2. Check whether you got any value (eg: paraProvince) in Businesslayer.Contractors.AddContractor() function. [Make ensure that all values of parameters has been passed from Presentation Layer to BusinessLayer.]
3. Check the SQL Statement.. [Make ensure that all values of parameters has been passed from BusinessLayer to DataLayer.]
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Thank you.
|
|
|
|
|
HI all,
I need a help for printing the content of the page displayed in the webpage
using vb.net
Can anybody help
I will be very very pleased if i get answer
|
|
|
|
|
You need a client side script like:
window.print()
you can check this link:
http://www.javascriptkit.com/howto/newtech2.shtml
|
|
|
|
|
Hi
I am having 2 html pages
a.html and b.html
In a.html I am having a tag
go
Then in b.html how can we retrieve the value of querystring in b.html
only in javascript(not in asp or .net)
Thanks
Karan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
