Hi lucy,
This thread might help:
http://asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=171587
:)
Regards,
Colt
--- In AspNetWebMatrix@yahoogroups.com, "lucy_indra"
<lucy_indra@y...> wrote:
> Hi .. All
>
> I want to Ask :
> How Webmatrix connect to db Oracle ?
Hello Group ,
I am glad I found this group. I have just started working on
webmatrix. Could you please let me know how to bring he contents of
Table in Drop Down Menu.
For example I want to bring the name of all the employees from
employee table.
Thanks
Hi puja,
You can use at least 2 approaches to do so :)
1. Use the MSAccessDataSource control
<%@ Page Language="VB" %>
<%@ Register TagPrefix="wmx"
Namespace="Microsoft.Matrix.Framework.Web.UI"
Assembly="Microsoft.Matrix.Framework, Version=0.6.0.0,
Culture=neutral, PublicKeyToken=6f763c9966660626" %>
<script runat="server">
' Insert page code here
'
Sub DropDownList1_Load(sender As Object, e As EventArgs)
If Not IsPostBack Then
DropDownList1.DataBind()
End If
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<wmx:AccessDataSourceControl
id="AccessDataSourceControl1" runat="server" SelectCommand="SELECT *
FROM [Employee]" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Ole DB Services=-4; Data
Source=C:\db2.mdb"></wmx:AccessDataSourceControl>
</p>
<p>
<asp:DropDownList id="DropDownList1" runat="server"
DataMember="Table" DataSource="<%# AccessDataSourceControl1 %>"
DataTextField="EmployeeName" DataValueField="EmployeeID"
OnLoad="DropDownList1_Load"></asp:DropDownList>
</p>
<!-- Insert content here -->
</form>
</body>
</html>
2. Use the OleDb namespace and code it manually:
http://aspalliance.com/Colt/articles/article2.aspx
Regards,
Colt
Microsoft MVP
http://WebLogs.asp.net/ColtK
--- In AspNetWebMatrix@yahoogroups.com, "puja_jain" <pjain1@g...>
wrote:
> Hello Group ,
> I am glad I found this group. I have just started working on
> webmatrix. Could you please let me know how to bring he contents of
> Table in Drop Down Menu.
> For example I want to bring the name of all the employees from
> employee table.
>
> Thanks
Hi!
I'm new to web matrix and I'm trying to get Crystal Reports
components to work with Web Matrix.
Any ideas and suggestions would be of great help.
Thank you
Hi all,
[Source: http://weblogs.asp.net/coltk/posts/35155.aspx]
One of the ˇ§bugˇ¨ or problem that Web Matrix developers face is
that whenever you try to start the Web Matrix IDE, it will shut down
automatically without displaying any error message nor notice.
That's really weird as it happen occasionally and no error message
for us to trace what's going wrong.
I have no clue about the cause or solution as I never face this
problem (luckily) but I understand the frustration of the victims. :(
Later, I notice that this problem normally occured in a machine with
a regional setting in ˇ§Turkishˇ¨ and a member tried to debug the
WebMatrix.exe and managed to see and exception in
Microsoft.Matrix.dll. The exception is
System.Configuration.ConfigurationException with a message 'Invalid
template document type'.
In short, once you face this problem and you can open the
WebMatrix.exe.config file and modify the content:
FROM: <templateDocumentType extension="config"
templateCategory="Security"
TO: <templateDocumentType extension="confIg"
templateCategory="Security"
(the letter ˇ§Iˇ¨s are different)
Regards,
Colt
My ASP.NET site (DNN version 1.09) is linked to from a site that
uses FRAMES.
I need to bust out of the frames. I have been able to bust out of
frames on NON-ASP.NET sites using javascript in the HEAD of the html
page.
How do I do the same in ASP.NET page? Can I use Web Matrix to do
that? Where do I put the javascript code.
Thanks so much
Thanks for a quick reply
ron
Hi. I am a newbie in Webmatrix. Right now I am developing a webpage
with a datagrid, and I want that when someone clicks in an item of
the list, a new page with info is opened. Where and how should I use
the linkcolumn property? Thanks in advance.
Rodrigo Mendizabal
Hi Ron,
I believe you've already found the solution at
http://asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=408518
Similar to IBuySpy/PortalStarterKit, DotNetNuke make use of a common
(mother) web form - DesktopDefault.aspx for itself. It load
different "module" based on the QueryString values. Therefore,
the "heading" was separate as a User Control and visible and apply in
different "pages".
Regards,
Colt
--- In AspNetWebMatrix@yahoogroups.com, "bear4asian"
<bear4asian@y...> wrote:
> My ASP.NET site (DNN version 1.09) is linked to from a site that
> uses FRAMES.
>
> I need to bust out of the frames. I have been able to bust out of
> frames on NON-ASP.NET sites using javascript in the HEAD of the
html
> page.
>
> How do I do the same in ASP.NET page? Can I use Web Matrix to do
> that? Where do I put the javascript code.
>
> Thanks so much
>
> Thanks for a quick reply
> ron
Hi Rodrigo,
You can use the "_blank" property of the HyperLinkColumn, or you can
use Javascript:window.open method to do so.
FYI:
http://www.datawebcontrols.com/faqs/Hyperlinks/HyperlinkThatOpensInANe
wWindow.shtml
http://www.datawebcontrols.com/faqs/Hyperlinks/HyperlinkWithMultipleQu
erystringValues.shtml
Regards,
Colt
--- In AspNetWebMatrix@yahoogroups.com, "sintegua" <sintegua@y...>
wrote:
> Hi. I am a newbie in Webmatrix. Right now I am developing a webpage
> with a datagrid, and I want that when someone clicks in an item of
> the list, a new page with info is opened. Where and how should I
use
> the linkcolumn property? Thanks in advance.
>
> Rodrigo Mendizabal
From: sintegua
[mailto:sintegua@...] Sent: Monday, December 08, 2003
1:25 PM To:
AspNetWebMatrix@yahoogroups.com Subject: [AspNetWebMatrix] Image
Path from a database
Hi! I am trying to point the src of an image to a path
stored in a database. How should I do this? Thanks in advance.
Rodrigo Mendizabal
To unsubscribe from this
group, send an email to: AspNetWebMatrix-unsubscribe@yahoogroups.com
I have always developed asp pages using FrontPage in conjuction with IIS.
The webs are all in wwwroot and I would like to be able to see these in WM
and develop more 'projects' located there.
WM doesn't even show the wwwroot folder in the Workspace, although it shows
other folders in the IIS parent folder.
I can browse for and open pages in wwwroot using 'File Open' but have to
manually specify the IIS server alias if I want to preview pages in WM.
The wwwroot folder permissions are set correctly.
Is there any way to have IIS and WM work more closely together in the way
the FP does?
Any help appreciated.
Ian Haynes
Data Insite UK
www.data-insite.co.uk
hello my friends.. i'm beginner with asp.net n now using web matrix
to know more about asp.net
i use the guided tour but have problem with DataList and Templates
where actually at this page
http://www.asp.net/webmatrix/guidedtour/section4/thedatalist.aspx
the problem is i don't understand what is means by this walkthrough
at number 21...
anybody know about it..please help me..
Hi,
The line #21 on the Guided Tour is talking about customize the
appearance of the DataList control.
As you can see in the screen shot at line #25, the DataList have a
border in black (bold), it is because the attributes were hardcoded
as in line #21: BorderColor="Black" BorderStyle="Solid"
BorderWidth="2"
Regards,
Colt
--- In AspNetWebMatrix@yahoogroups.com, "asp111z" <asp111z@y...>
wrote:
> hello my friends.. i'm beginner with asp.net n now using web matrix
> to know more about asp.net
> i use the guided tour but have problem with DataList and Templates
> where actually at this page
> http://www.asp.net/webmatrix/guidedtour/section4/thedatalist.aspx
>
> the problem is i don't understand what is means by this walkthrough
> at number 21...
> anybody know about it..please help me..
thank you for your information,but i have stuck at this guided tour
because when i press f5 , it will error :.
the error seems like this:
Server Error in '/' Application.
----------------------------------------------------------------------
----------
Compilation Error
Description: An error occurred during the compilation of a resource
required to service this request. Please review the following
specific error details and modify your source code appropriately.
Compiler Error Message: BC30456: 'DataItem' is not a member
of 'System.Web.UI.Control'.
Source Error:
Line 45: BorderColor="Black" BorderStyle="Solid"
BorderWidth="2"> </asp:datalist>
Line 46: <ItemTemplate>
Line 47: ProductName:<asp:Label id="Label1"
runat="server" text='<%# DataBinder.Eval
(Container.DataItem, "ProductName") %>'></asp:Label>
Line 48: </ItemTemplate>
Line 49: </asp:DataList>
Source File: C:\Documents and Settings\Administrator\My
Documents\Izhar\ASP.NET\myFirstDataPage.aspx Line: 47
it looks like that the (Container.DataItem has error
do you know about it..plese help if u know
bye
I am working with an sql database. One of the fields is a money
field, but when I insert it into a grid, the output displays with 4
decimal places. How can I use a mask to display just 2 digits.
Thanks in Advance,
Rodrigo Mendizabal
Hi Rodrigo,
This article might help:
http://aspalliance.com/31 >> Helper Function <<
5. Format and display currency with 2 decimal points in a BoundColumn
DataFormatString="${0:N2}"
Regards,
Colt
---------- Original Message ----------------------------------
From: "sintegua" <sintegua@...>
Reply-To: AspNetWebMatrix@yahoogroups.com
Date: Mon, 05 Jan 2004 23:19:10 -0000
><html><body>
>
>
><tt>
>I am working with an sql database. One of the fields is a money <BR>
>field, but when I insert it into a grid, the output displays with 4 <BR>
>decimal places. How can I use a mask to display just 2 digits.<BR>
><BR>
>Thanks in Advance,<BR>
><BR>
>Rodrigo Mendizabal<BR>
><BR>
></tt>
>
>
><br>
>
><!-- |**|begin egp html banner|**| -->
>
><table border=0 cellspacing=0 cellpadding=2>
><tr bgcolor=#FFFFCC>
><td align=center><font size="-1" color=#003399><b>Yahoo! Groups
Sponsor</b></font></td>
></tr>
><tr bgcolor=#FFFFFF>
><td align=center width=470><table border=0 cellpadding=0 cellspacing=0> <tr>
<td align=center><font face=arial size=-2>ADVERTISEMENT</font><br><a
href="http://rd.yahoo.com/SIG=12cuc0pmr/M=267637.4116732.5333197.1261774/D=egrou\
pweb/S=1705007181:HM/EXP=1073431160/A=1853619/R=0/*http://www.netflix.com/Defaul\
t?mqso=60178356&partid=4116732" alt=""><img
src="http://us.a1.yimg.com/us.yimg.com/a/ne/netflix/yhoo1103_b_300250A.gif"
alt="click here" width="300" height="250" border="0"></a></td></tr></table>
</td>
></tr>
><tr><td><img alt="" width=1 height=1
src="http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmai\
l/S=:HM/A=1853619/rand=485187034"></td></tr>
></table>
>
><!-- |**|end egp html banner|**| -->
>
>
><br>
><tt><hr width="500">
><b>Yahoo! Groups Links</b><br>
><ul>
><li>To visit your group on the web, go to:<br><a
href="http://groups.yahoo.com/group/AspNetWebMatrix/">http://groups.yahoo.com/gr\
oup/AspNetWebMatrix/</a><br>
><li>To unsubscribe from this group, send an email to:<br><a
href="mailto:AspNetWebMatrix-unsubscribe@yahoogroups.com?subject=Unsubscribe">As\
pNetWebMatrix-unsubscribe@yahoogroups.com</a><br>
><li>Your use of Yahoo! Groups is subject to the <a
href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</a>.
></ul>
></tt>
></br>
>
></body></html>
>
>---
>[This E-mail scanned for viruses by Declude Virus]
>
>
---
[This E-mail scanned for viruses by Declude Virus]
Thanks for all the responses that I have got from the last messages I
post.
Right now I am working with a Drop Down List, whatever it is
selected, I have a field in the table that will be the "filter" of
the Select command applied to a grid that I have in the same page.
How should I do this.
I mean I have in the same page a drop down with some countries, but,
in the center of the page I have the information in a grid with all
the data displayed. When a selection is made in the drop down, I
think I have to use a button to apply a command to do the select and
refresh the query of the grid.
Also I have another question, I have a grid with a link column, this
should open another page in another window and a grid with a "special
select command" based on the parameter I passed from the firs page.
Help on this please !!!
For some reason I am unable to see inetpub/wwwroot in the Workspace window.
I've asked the question here before, and elsewhere, without finding a
solution.
The other folders in inetpub are visible but not wwwroot. It may be
something to do with an IIS setting but I cant see what. (Platform is
Win2kP, with Fat32 FS, Net Framework v1.1).
I recently installed the demo version of VS.Net and that saw wwwroot
automatically, as does MS FrontPage.
Any suggestions gratefully received.
Ian Haynes
Data Insite UK
Ian,
My solution to this is quite simple. In the workspace I
click on the New Project icon which brings up a wizard. I then
select Folder Shortcut which brings you to a Browse for Folder.
Browse till you find your wwwroot and then click ok. Now you should
have your wwwroot folder in your workspace window.
Hope that helps.
MacJason
--- In AspNetWebMatrix@yahoogroups.com, "Ian Haynes" <ihaynes@d...>
wrote:
> For some reason I am unable to see inetpub/wwwroot in the
Workspace window.
> I've asked the question here before, and elsewhere, without
finding a
> solution.
>
> The other folders in inetpub are visible but not wwwroot. It may be
> something to do with an IIS setting but I cant see what. (Platform
is
> Win2kP, with Fat32 FS, Net Framework v1.1).
>
> I recently installed the demo version of VS.Net and that saw
wwwroot
> automatically, as does MS FrontPage.
>
> Any suggestions gratefully received.
>
> Ian Haynes
> Data Insite UK
Some pages that worked last week gave errors when viewed today. I eventually found that WM was adding <%@ language = VB %> and <html>, <head> and <body> tags to include pages where I hadn't added any myself and didn't want them.
Thanks to Colt for the valuable information.
I just have another question related to the topic:
Right now I can send succesfully the id of the item I want to
display, so, in the second page (the new one) how can I tell the
Select statement to filter just the item I want. Also, can I use a
grid but the columns positioned like if they were rows.
Thanks in advance.
Rodrigo Mendizabal
Hi ,
CAn antbody send me a sample working code of .net file with Oracle
and Webmatrix . Something like a small form that updates , deletes
and views records from Oracle. Also let me know how to configure
Oracle with Webmatrix. Like what steps do I need to follow to make
the form working. Preferably with Oracle 8 or 8i.
Thank
DJ
Hi DJ,
This article introduce "Using the .NET Framework Data Provider for
Oracle ":
http://www.4guysfromrolla.com/webtech/tips/t080902-1.shtml
Moreover, you can take a look at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dndotnet/html/manprooracperf.asp
where you can find the sample of "Nile3.0" for reference.
Regards,
Colt
--- In AspNetWebMatrix@yahoogroups.com, "finchonline"
<finchonline@y...> wrote:
> Hi ,
> CAn antbody send me a sample working code of .net file with Oracle
> and Webmatrix . Something like a small form that updates , deletes
> and views records from Oracle. Also let me know how to configure
> Oracle with Webmatrix. Like what steps do I need to follow to make
> the form working. Preferably with Oracle 8 or 8i.
> Thank
>
> DJ
Hi Rodrigo,
You can , for example, use the DataTable.Select() method to filter
out data with specific ID and then re-bind to the DataGrid.
Moreover, you can see this article: http://www.c-
sharpcorner.com/Code/2003/May/DisplayVerticalData.asp about how to
display data horizontally.
Regards,
Colt
--- In AspNetWebMatrix@yahoogroups.com, "sintegua" <sintegua@y...>
wrote:
> Thanks to Colt for the valuable information.
> I just have another question related to the topic:
>
> Right now I can send succesfully the id of the item I want to
> display, so, in the second page (the new one) how can I tell the
> Select statement to filter just the item I want. Also, can I use a
> grid but the columns positioned like if they were rows.
>
>
> Thanks in advance.
>
> Rodrigo Mendizabal
Hi Ian,
"Undesire" code modification is annoying... but it's unavoidable in
the current version of Web Matrix (and VS.NET) ...
FYI: http://weblogs.asp.net/coltk/archive/2003/08/28/25623.aspx
Regards,
Colt
--- In AspNetWebMatrix@yahoogroups.com, "Ian Haynes" <ihaynes@d...>
wrote:
> Some pages that worked last week gave errors when viewed today. I
eventually
> found that WM was adding <%@ language = VB %> and <html>, <head>
and <body>
> tags to include pages where I hadn't added any myself and didn't
want them.
>
> Is there any way of stopping this default action?
>
> Ian Haynes
> Data Insite UK
> w <http://www.data-insite.co.uk> ww.data-insite.co.uk
When debugging SQL statements in asp I've been used to 'response.writing'
out the statement without executing it. Is there a way to do this with the
parameterised SQL that WebMatrix uses? I can't see how to show the populated
SQL statement, ie, with the parameters entered in it.
Any help appreciated.
Ian Haynes
Data Insite UK
www.data-insite.co.uk
Hi !
I am interested in display pictures that I have the path saved in a
field in a microsoft sql database. Which is the best way to display
them. I have 2 fields in the table. One is the id of the picture, and
the otherone is the path.
Any advice will be helpfull.
Thanks in advance,
Rodrigo Mendizabal