如何在没有datagridview的前端asp.net页面中从数据库获取数据 [英] how to get data from database in frontend asp.net pages without datagridview

问题描述

你好，



如何在没有datagridview的前端asp.net页面中从数据库获取数据



，如果有可能给我java脚本代码我在我的web项目中使用内联JS。



这段代码正常工作从数据库中获取数据但不是很好的形状。



如果你有最好的代码plz给我。

谢谢

< h3 class =color_love font_heading left-1>我们的新闻< / h3>

< div class =tabs>



< asp：SqlDataSource

ID =SqlDataSource1

runat =server

ConnectionString =<％$ ConnectionStrings：dbJmblissConnectionString％>

SelectCommand =SELECT [title]，[news ]，[PostDate] FROM [tblNews]>

< / asp：SqlDataSource>

< marquee onmou seover =stop（）önmouseout=start（）margin-left =15pxdirection =upscrollamount =2width =300height =270<％ - behavior =alternate - ％GT; text-align =justify>

< div style =width：300px; font-size：17px;>



< asp：FormView ID =FormView1

runat =server

DataSourceID =SqlDataSource1

AllowPaging =True margin-left =14pxtext-align =justify>

< EditItemTemplate>

标题：

< asp ：TextBox ID =TitleTextBoxrunat =serverText ='<％＃Bind（title）％>'/>

< br />< br / >

新闻：

< asp：TextBox ID =NewsTextBoxrunat =serverText ='<％＃Bind（news）％> ;'/>

< br />< br />

PostDate：

< asp：TextBox ID = PostDateTextBoxrunat =server

Text ='<％＃Bind（PostDate）％>'/>

< br />

< asp：LinkBut​​ton ID =UpdateButtonrunat =serverCausesValidation =True

CommandName =UpdateText =更新/>

& nbsp;< asp：LinkBut​​ton ID =UpdateCancelButtonrunat =server

CausesValidation =FalseCommandName =Cancel Text =Cancel/>

< / EditItemTemplate>



< InsertItemTemplate>

Title ：

< asp：TextBox ID =TitleTextBoxrunat =serverText ='<％＃Bind（title）％>'/>

< br />< br />

新闻：

< asp：TextBox ID =NewsTextBoxrunat =serverText =' <％＃Bind（news）％>'/>

< br />< br />

PostDate：

< asp：TextBox ID =PostD ateTextBoxrunat =server

Text ='<％＃Bind（PostDate）％>'/>

< br />

< asp：LinkBut​​ton ID =InsertButtonrunat =serverCausesValidation =True

CommandName =InsertText =Insert/>

& nbsp;< asp：LinkBut​​ton ID =InsertCancelButtonrunat =server

CausesValidation =FalseCommandName =CancelText =Cancel/> ;

< / InsertItemTemplate>

< ItemTemplate>

标题：

< asp：标签ID =TitleLabelrunat =serverText ='<％＃Bind（title）％>'/>

< br /> < br />

新闻：

< asp：Label ID =NewsLabelrunat =serverText ='<％＃Bind（news ）％>'/>

< br /> < br />

PostDate：

< asp：Label ID =PostDateLabelrunat =serverText ='<％＃Bind（PostDate ）％>'/>

< br />

< / ItemTemplate>

< PagerSettings Mode =数字/>



< / asp：FormView>

< / div>< / marquee>

解决方案

ConnectionStrings：dbJmblissConnectionString％>

SelectCommand =SELECT [title]，[news]，[PostDate] FROM [tblNews ]>

< / asp：SqlDataSource>

< marquee onmouseover =stop（）önmouseout=start（）margin-left =15px direction =upscrollamount =2width =300height =270<％ - behavior =alternate - ％> text-align =justify>

< div style =width：300px; font-size：17px;>



< asp：FormView ID =表格View1

runat =server

DataSourceID =SqlDataSource1

AllowPaging =Truemargin-left =14pxtext- align =justify>

< EditItemTemplate>

标题：

< asp：TextBox ID =TitleTextBoxrunat =服务器Text ='<％＃Bind（title）％>'/>

< br />< br />

新闻：

< asp：TextBox ID =NewsTextBoxrunat =serverText ='<％＃Bind（news）％>'/>

< br />< br />

PostDate：

< asp：TextBox ID =PostDateTextBoxrunat =server

Text ='<％＃Bind（PostDate）％>'/>

< br />

< asp：LinkBut​​ton ID =UpdateButtonrunat =serverCausesValidation =True

CommandName =UpdateText =Update/>

& nbsp;< asp：LinkBut​​ton ID =UpdateCancelButtonrunat =server

CausesValidation = FalseCommandName =CancelText =Cancel/>

< / EditItemTemplate>



< InsertItemTemplate>

标题：

< asp：TextBox ID =TitleTextBoxrunat =serverText ='<％＃Bind（title）％>'/ >

< br />< br />

新闻：

< asp：TextBox ID =NewsTextBox runat =serverText ='<％＃Bind（news）％>'/>

< br />< br />

PostDate：

< asp：TextBox ID =PostDateTextBoxrunat =server

Text ='<％＃Bind（PostDate）％ >'/>

< br />

< asp：LinkBut​​ton ID =InsertButtonrunat =serverCausesValidation =True

CommandName =InsertText =Insert/>

& nbsp;< asp：LinkBut​​ton ID =InsertCancelButtonrunat =server

CausesValidation =FalseCommandName =CancelText =Cancel/>

< / InsertItemTemplate>

< ItemTemplate>

标题：

< asp：Label ID = TitleLabelrunat =serverText ='<％＃Bind（title）％>'/>

< br /> < br />

新闻：

< asp：Label ID =NewsLabelrunat =serverText ='<％＃Bind（news ）％>'/>

< br /> < br />

PostDate：

< asp：Label ID =PostDateLabelrunat =serverText ='<％＃Bind（PostDate ）％>'/>

< br />

< / ItemTemplate>

< PagerSettings Mode =数字/>



< / asp：FormView>

< / div>< / marquee>

hello,

how to get data from database in frontend asp.net pages without datagridview

and if may be possible give me java-script code i use inline JS in my web project.

this code working properly get data from database but not lucking good shape.

if you have best code plz give me.
thanks

<h3 class="color_love font_heading left-1">Our News</h3>
<div class="tabs">

<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:dbJmblissConnectionString %>"
SelectCommand="SELECT [title], [news], [PostDate] FROM [tblNews]">
</asp:SqlDataSource>
<marquee onmouseover="stop()" önmouseout="start()" margin-left="15px" direction="up" scrollamount="2" width="300" height="270" <%--behavior="alternate"--%> text-align="justify">
<div style="width:300px;font-size:17px;">

<asp:FormView ID="FormView1"
runat="server"
DataSourceID="SqlDataSource1"
AllowPaging="True" margin-left="14px" text-align="justify" >
<EditItemTemplate>
Title:
<asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("title") %>' />
<br /><br />
News:
<asp:TextBox ID="NewsTextBox" runat="server" Text='<%# Bind("news") %>' />
<br /><br />
PostDate:
<asp:TextBox ID="PostDateTextBox" runat="server"
Text='<%# Bind("PostDate") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="Update" />
&nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>

<InsertItemTemplate>
Title:
<asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("title") %>' />
<br /><br />
News:
<asp:TextBox ID="NewsTextBox" runat="server" Text='<%# Bind("news") %>' />
<br /><br />
PostDate:
<asp:TextBox ID="PostDateTextBox" runat="server"
Text='<%# Bind("PostDate") %>' />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="Insert" />
&nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</InsertItemTemplate>
<ItemTemplate>
Title:
<asp:Label ID="TitleLabel" runat="server" Text='<%# Bind("title") %>' />
<br /> <br />
News:
<asp:Label ID="NewsLabel" runat="server" Text='<%# Bind("news") %>' />
<br /> <br />
PostDate:
<asp:Label ID="PostDateLabel" runat="server" Text='<%# Bind("PostDate") %>' />
<br />
</ItemTemplate>
<PagerSettings Mode="Numeric"/>

</asp:FormView>
</div></marquee>

解决方案

ConnectionStrings:dbJmblissConnectionString %>"
SelectCommand="SELECT [title], [news], [PostDate] FROM [tblNews]">
</asp:SqlDataSource>
<marquee onmouseover="stop()" önmouseout="start()" margin-left="15px" direction="up" scrollamount="2" width="300" height="270" <%--behavior="alternate"--%> text-align="justify">
<div style="width:300px;font-size:17px;">

<asp:FormView ID="FormView1"
runat="server"
DataSourceID="SqlDataSource1"
AllowPaging="True" margin-left="14px" text-align="justify" >
<EditItemTemplate>
Title:
<asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("title") %>' />
<br /><br />
News:
<asp:TextBox ID="NewsTextBox" runat="server" Text='<%# Bind("news") %>' />
<br /><br />
PostDate:
<asp:TextBox ID="PostDateTextBox" runat="server"
Text='<%# Bind("PostDate") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="Update" />
&nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>

<InsertItemTemplate>
Title:
<asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("title") %>' />
<br /><br />
News:
<asp:TextBox ID="NewsTextBox" runat="server" Text='<%# Bind("news") %>' />
<br /><br />
PostDate:
<asp:TextBox ID="PostDateTextBox" runat="server"
Text='<%# Bind("PostDate") %>' />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="Insert" />
&nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</InsertItemTemplate>
<ItemTemplate>
Title:
<asp:Label ID="TitleLabel" runat="server" Text='<%# Bind("title") %>' />
<br /> <br />
News:
<asp:Label ID="NewsLabel" runat="server" Text='<%# Bind("news") %>' />
<br /> <br />
PostDate:
<asp:Label ID="PostDateLabel" runat="server" Text='<%# Bind("PostDate") %>' />
<br />
</ItemTemplate>
<PagerSettings Mode="Numeric"/>

</asp:FormView>
</div></marquee>

这篇关于如何在没有datagridview的前端asp.net页面中从数据库获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！