|
hi
As i penetrate deeper into the "Secrets" of Web Development, i am somewhat confused about the Database backend of my web applications.
I suppose I am looking for a tutorial that will combine the three Elements i posted in the Subject.
Maybe i am just blind, but i have done quite a lot of searches, and can not seem to find a tutorial that will cover the basics of SQL, DAL, BLL, and the idea behind them.
Maybe someone could summ up in this topic, or better jet post a link to an exsisting tutorial that will cover the follwing aspects:
-Database Design (What Datatype for wich field an why, relationships of tables, views, storedprocedures, complex Select statements (select within another select?)
- Data Access Layer - why do i need it, what are the pros/cons, how do i do it? are there Industry Standards? what are they?
- Buissness Logic Layer - (same idea as the DAL) why do i need it - how else could i do it...
i am sure this would not only help me, but also very many other people out. The tutorials i have found so far, seems to go into detail on the individual subjects quite quickly and dont seem to just give an overview of the entier idea behind the system.
~Skyruner2
|
|
|
|
|
|
|
I have html control on my page. It's property position set in "relative". Can I get it's absolute position from Javascript? And it what way can I do this?
Thank's
|
|
|
|
|
The "simple" answer is not always...
You need recursive program asking for the parent's left, top, width, height, border and so...
But the thing is unsolvable if you use percentile measures (IE: style="width: 100%") because this measures depends on the screen resolution.
I've tried... And I can't solve certain aspects.
I'm on a Fuzzy State: Between 0 an 1
|
|
|
|
|
Hi,
I am facing a problem in my web application while i am trying to print an html page, whose url is specified in a textbox, using axWebBrowser component. I am getting an error "Exception of type InvalidActiveXStateException was thrown", at axW.Navigate statement. Please help me to rectify this problem.
private void Button1_Click(object sender, System.EventArgs e)<br />
{<br />
try<br />
{<br />
object empty= null;<br />
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(WebForm1));<br />
AxWebBrowser axW=new AxWebBrowser();<br />
axW.Enabled=true;<br />
axW.Visible=false;<br />
axW.OcxState = (System.Windows.Forms.AxHost.State)(resources.GetObject("axW.OcxState"));<br />
axW.Navigate(TextBox1.Text,ref empty,ref empty,ref empty,ref empty);<br />
axW.ExecWB(SHDocVw.OLECMDID.OLECMDID_PRINT,SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER ,ref empty,ref empty);<br />
}<br />
catch(Exception Ex)<br />
{<br />
Response.Write(Ex.Message.ToString());<br />
} <br />
}
This application is a web application and I want the print at the server end since the server is the user in our case.
If it is not possible to print with this control in a web application, Is there any other way to print an html page without loading it and not to show any print dialog at the user end.
Please help me with this case.
Thanks in advance,
Sai.
|
|
|
|
|
Please don't cross post.
---
b { font-weight: normal; }
|
|
|
|
|
is it possible that i use microsoft access as my databse for my website on customer infomation???
i'm not sure is it save to do that or not..
any suggestion? i heard alot more website using asp or PHP but i not really familir which those language, any website to guide on how to have a secure databse?
Wat is the database file extension for asp? i only know access is .mdb
|
|
|
|
|
Yes, you can use MSAccess as your database, however it is NOT recommended aside from using it for student assignment. It is better for you to use the free MSDE, SQL 2005 Express, or MySql.
ASP and PHP are not databases, they are web programming languages (to create a web page) similar to ASP.Net.
File extension for ASP files are .asp, and php are .php (I believe both can be changed if you feel like it).
"You are special, but so is everybody else."
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
but will it be safe? casue i'm going to implement a business site store on customer information...
|
|
|
|
|
Obviously if you're going to develop a business site store you're better off with MSDE/SQL Express 2005, or MySql than Access.
"You are special, but so is everybody else."
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
Yes you can use the access database for the web application i.e. asp or asp.net
Mahi
|
|
|
|
|
Hello!
I can type in the value in one text box, then it'll go to the code behind of another page and do the correct functionality....which will tell the user if the number is distinct or not.
The only problem is when I post back the page via the button_click event, I get an IE error, iexplore.exe error, The instruction at "0x4a594476" referenced memory at "0x00000004". The memory could not be "read".
HTML code is:
<HTML>
<HEAD>
<title>WebForm1</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="Visual Basic .NET 7.1" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
<!-- Start script -->
<script language="javascript">
var xmlHttp = createXmlHttpRequestObject();
function createXmlHttpRequestObject()
{
var xmlHttp;
if(window.ActiveXObject)
{
try
{
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
catch (e)
{
xmlHttp = false;
}
}
else
{
try
{
xmlHttp = new XMLHttpRequest();
}
catch (e)
{
xmlHttp = false;
}
}
if (!xmlHttp)
{
alert("Error creating the XMLHttpRequest object.");
}
else
{
return xmlHttp;
}
}
function process()
{
varWBS = encodeURIComponent(document.getElementById("TextBox1").value);
xmlHttp.open("GET", "test.aspx?WBS=" + varWBS);
xmlHttp.onreadystatechange = handleServerResponse;
xmlHttp.send(null);
}
function handleServerResponse()
{
//if (xmlHttp.readyState == 4 && xmlHttp.status == 200)
//{
// document.getElementById("show").innerHTML = xmlHttp.responseText;
//}
//}
//New code
if (xmlHttp.readyState == 4)
{
if(xmlHttp.status == 200)
{
var parentElement = document.getElementById('show');
var wrappingDiv = document.createElement('div');
wrappingDiv.innerHTML = document.getElementById("TextBox1").value+' '+xmlHttp.responseText;
parentElement.appendChild(wrappingDiv);
//document.getElementById("show").innerHTML = xmlHttp.responseText;
//document.all[show].innerHTML = xmlHttp.responseText;
}
else
{
alert("hmmmm");
}
}
}
//End code
</script>
<!-- End script -->
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<table id="maintbl" border="1" style="WIDTH: 952px; HEIGHT: 59px">
<tr>
<td style="WIDTH: 327px"><asp:textbox id="TextBox1" onblur="process()" style="Z-INDEX: 101" runat="server" Width="100%"></asp:textbox></td>
<td><asp:textbox id="TextBox2" style="Z-INDEX: 101" runat="server"></asp:textbox></td>
</tr>
<tr>
<td colspan="2">
<div id="show" style="FONT-SIZE: smaller; COLOR: red" runat="server"></div>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button id="Button1" runat="server" Text="Button"></asp:Button>
<asp:Label id="Label1" runat="server">Label</asp:Label>
</td>
</tr>
</table>
</form>
</body>
</HTML>
The code behind for the test.aspx page is:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
sCon1.Open()
Dim strSQL As String = "Select count(*) from Table where [Number] = '" & Server.HtmlEncode(Request.QueryString("WBS")).ToString() & "'"
Dim cmd As New SqlCommand(strSQL, sCon1)
Dim intCnt As Integer = cmd.ExecuteScalar()
sCon1.Close()
If intCnt = 0 Then
Response.Write("is unique, and able to be added!")
Else
Response.Write("is already used. Please select another Number!")
End If
Catch ex As Exception
Response.Write(ex.ToString())
Finally
sCon1.Close()
End Try
|
|
|
|
|
The error may have been caused by this part of your code:
var parentElement = document.getElementById('show');
var wrappingDiv = document.createElement('div');
wrappingDiv.innerHTML = document.getElementById("TextBox1").value+' '+xmlHttp.responseText;
parentElement.appendChild(wrappingDiv);
Try appending the div to the parent element first before setting the value, and you may want to use innerText instead of innerHTML.
Also, is your xmlHttp.responseText a HTML script? If yes, that might be the cause of the problem.
You're better off writing your html via javascript than setting it via innerHTML property.
"You are special, but so is everybody else."
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
First of all, please have a look the belowed html code
--------------------
--------------------
the doAction() function should post hidden field to http://www.servername.com and the response data will be represented in a new open window for setting "_blank" to target. Actually, "userid=1" will post to destination howerver I wanna post custom data , for instance, a piece of xml to destination url and the data should not always with the format "xxx=xxxxxx". How to do this??
As you know, httpXml should post custom data you want to destination url with response data in httpXml.ResponseText, but how to simulate the feature of target="_blank" in form, which responds to new window and user can continue to communicate with destination server via the new window.
Thanks in advanced
Benjamin Li
|
|
|
|
|
Since you're going to open a new window, why do you need to use XmlHttpRequest to post it?
Just modify the action attribute of the form to submit the page to another page of your liking, and submit the form.
If you keep the form's target as "_blank" then it will open in another window and you can continue from there.
"You are special, but so is everybody else."
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
As mentioned in my post, form always post data like "xxx=xxxxx" to destination url but I just wanna post customized data, for instance, a xml stream to destination url. So I have no idea how can form do that. If you have any suggestion, could you give a sample?
Regards,
Benjamin Li
|
|
|
|
|
Sorry, I didn't get any e-mail notification so I didn't get back to you earlier.
There are plenty of samples in using XmlHttpRequest to post customised data to another page, you can either Google it or search CodeProject.
You can also have a look at Anthem.Net[^] to see if it fits the bill, or even to peek at how it uses XmlHttpRequest to post data.
I prefer using whatever is available out there in order to not reinvent the wheel.
"You are special, but so is everybody else."
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
I am looking for any good comparisons (features & functionality) between WebFOCUS and Microsoft SQL Server Reporting Services?
Thanks, Mike
"Yes I know the voices are not real. But they have some pretty good ideas."
|
|
|
|
|
we have one word template in that i want to read the content and i want change some text words and finally i want save the word.If any know this code.pls help me.
Thanks in advance.
by
sriguru
|
|
|
|
|
This[^] page from Microsoft website can explain to use the basic of Word Automation.
You will need to read more on Word Object Model to understand how things work, and here is a helpful list[^] containing code snippets on how to do things in Word.
"You are special, but so is everybody else."
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
I have a bit of a problem... I have a need for a tree control that will do all the nice expand / collapse stuff with child nodes indented etc., but that will also have a set of columns at the right had side of each node that remain in line with each other as children are expanded/collapsed, e.g.:
<pre>
+ Node 1 col1 col2
+ Node 2 col1 col2
</pre>
We decided to 'hack' a third party control from a suite that we already use, so that when we bind the text to each node, it contains the html string to create the columns. All well and good up to this point
An example of the output html for two nodes is given below:
<DIV>
<NOBR>
<DIV id="m" align="left">
<DIV id="1t">
<SPAN class="soxProcess" style="DISPLAY: inline-block; VERTICAL-ALIGN: top; WIDTH: 50%">
<!-- Within each of these divs, i am able to add text from here -->
A long name owner test. </SPAN><SPAN style="DISPLAY: inline-block; RIGHT: 0px; VERTICAL-ALIGN: top; WIDTH: 40%; POSITION: relative">
<TABLE id="Table1" cellSpacing="0" cellPadding="0" width="100%">
<TR style="VERTICAL-ALIGN: top">
<TD style="WIDTH: 35%"><SPAN class="bodyText" style="PADDING-LEFT: 3px">A very very very very very very very very very vey long bit of text.</SPAN></TD>
<TD style="WIDTH: 35%"><SPAN class="bodyText" style="PADDING-LEFT: 3px"></SPAN></TD>
<TD style="WIDTH: 30%"><SPAN class="bodyText" style="PADDING-LEFT: 3px">INC</SPAN></TD>
</TR>
</TABLE>
</SPAN>
<!-- to here -->
</DIV>
<DIV id="m1">
<DIV id="ucDetailucTreeuwtSOXTree_1_1" igTag="PR4">
<img src="" width="25px" />
<SPAN class="soxProcess" style="DISPLAY: inline-block; VERTICAL-ALIGN: top; WIDTH: 50%"
gtxt="1">
<!-- Within each of these divs, i am able to add text from here -->
A test child for PD2 </SPAN><SPAN style="DISPLAY: inline-block; RIGHT: 0px; VERTICAL-ALIGN: top; WIDTH: 40%; POSITION: relative">
<TABLE id="Table2" cellSpacing="0" cellPadding="0" width="100%">
<TR style="VERTICAL-ALIGN: top">
<TD style="WIDTH: 35%"><SPAN style="PADDING-LEFT: 3px">PD2</SPAN></TD>
<TD style="WIDTH: 35%"><SPAN style="PADDING-LEFT: 3px"></SPAN></TD>
<TD style="WIDTH: 30%"><SPAN style="PADDING-LEFT: 3px">INC</SPAN></TD>
</TR>
</TABLE>
</SPAN>
<!-- to here -->
</DIV>
</DIV>
</DIV>
</NOBR>
</DIV>
Pretty, isn't it. My problems start to arise when i have very long text in one of the columns (as in the example). As the span containing the table is positioned absolutely, it has been taken out of the flow of the containing div, and this div does not expand to take the height of my column span into account... Any magic CSS help advice here would be much appreciated.
|
|
|
|
|
From copying and pasting your HTML script I got the 'A very very...long text' wrapping on its cell.
You don't seem to specify the position:absolute in your code either.
Can you please clarify how you want the result to be?
"You are special, but so is everybody else."
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
Sorry, copied the code after several hours of staring at it yesterday...
The problem is not so much that it doesn't wrap (because it does), but that it pushed the text below it downwards. However, i've also come up with a dirty hack that'll do what i need, so...
anyway, here's the code i meant to post yesterday...
<DIV>
<NOBR>
<DIV id="m" align="left">
<DIV id="1t">
<SPAN class="soxProcess" style="DISPLAY: inline-block; VERTICAL-ALIGN: top; WIDTH: 50%">
<!-- Within each of these divs, i am able to add text from here -->
A long name owner test. </SPAN><SPAN style="DISPLAY: inline-block; RIGHT: 0px; VERTICAL-ALIGN: top; WIDTH: 40%; POSITION: absolute">
<TABLE id="Table1" cellSpacing="0" cellPadding="0" width="100%">
<TR style="VERTICAL-ALIGN: top">
<TD style="WIDTH: 35%"><SPAN class="bodyText" style="PADDING-LEFT: 3px">A very very very very very very very very very vey long bit of text.</SPAN></TD>
<TD style="WIDTH: 35%"><SPAN class="bodyText" style="PADDING-LEFT: 3px"></SPAN></TD>
<TD style="WIDTH: 30%"><SPAN class="bodyText" style="PADDING-LEFT: 3px">INC</SPAN></TD>
</TR>
</TABLE>
</SPAN>
<!-- to here -->
</DIV>
<DIV id="m1">
<DIV id="ucDetailucTreeuwtSOXTree_1_1" igTag="PR4">
<img src="" width="25px" />
<SPAN class="soxProcess" style="DISPLAY: inline-block; VERTICAL-ALIGN: top; WIDTH: 50%"
gtxt="1">
<!-- Within each of these divs, i am able to add text from here -->
A test child for PD2 </SPAN><SPAN style="DISPLAY: inline-block; RIGHT: 0px; VERTICAL-ALIGN: top; WIDTH: 40%; POSITION: absolute">
<TABLE id="Table2" cellSpacing="0" cellPadding="0" width="100%">
<TR style="VERTICAL-ALIGN: top">
<TD style="WIDTH: 35%"><SPAN style="PADDING-LEFT: 3px">PD2</SPAN></TD>
<TD style="WIDTH: 35%"><SPAN style="PADDING-LEFT: 3px"></SPAN></TD>
<TD style="WIDTH: 30%"><SPAN style="PADDING-LEFT: 3px">INC</SPAN></TD>
</TR>
</TABLE>
</SPAN>
<!-- to here -->
</DIV>
</DIV>
</DIV>
</NOBR>
</DIV>
|
|
|
|
|
Hi
Is there any way through which i can import my yahoo and hotmail email in my java based application? Any API or something like that?
Thank you
We Believe in Excellence
www.aqueelmirza.cjb.net
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
