如何在ASP.net中实现视频推荐 [英] how to implement Video Testimonial in ASP.net

问题描述

hi

我想使用C#在ASP.NET中创建视频库.
如何在链接存储在数据库中的网页上显示视频.
为此使用哪个控件.
我正在使用MS-SQL2005.
请帮助我...................

hi

I want to create Video gallary in ASP.NET using C#.
how to display video on web page whose link is stored in database.
Which control is used for that.
i m using MS-SQL 2005.
Plz help me out...................

推荐答案

亲爱的朋友，

对于YouTube Vedios Iam发布示例代码，请执行以下操作.

设计代码:
< table>
< tr>
< td align ="left" class ="links2">
标题:</td>
< td align ="left" class ="links2">
< asp:TextBox ID ="txtTitle" runat ="server"></asp:TextBox>< asp:RequiredFieldValidator
ID ="rfvName" runat ="server" ControlToValidate ="txtTitle" Display =动态" ErrorMessage =输入标题"
SetFocusOnError ="True" ValidationGroup ="add"> *</asp:RequiredFieldValidator></td>
</tr>
< tr>
< td align ="left" class ="links2" valign ="top">
链接:</td>
< td class ="links2" align ="left">
< asp:TextBox ID ="txtLink" runat ="server"></asp:TextBox>
< asp:RequiredFieldValidator ID ="rfvDesc" runat ="server" ControlToValidate ="txtLink"
Display ="Dynamic" ErrorMessage ="Enter Link" SetFocusOnError ="True" ValidationGroup ="add"> *</asp:RequiredFieldValidator></td>
</tr>
< tr>
< td>
</td>
< td>
</td>
</tr>
< tr>
< td colspan ="2">
& nbsp;</td>
</tr>
< tr>
< td colspan ="2">
< asp:按钮ID ="txtdelete" runat =服务器" Text =删除"
onclick ="txtdelete_Click1"/>
< asp:按钮ID ="btnSubmit" runat =服务器" Text ="Submit" ValidationGroup ="add" OnClick ="btnSubmit_Click"/>< asp:ValidationSummary
ID ="vsAdd" runat ="server" ShowMessageBox ="True" ShowSummary ="False" ValidationGroup ="add"/>
< asp:Repeater ID ="Repeater1" runat ="server" DataSourceID ="SqlDataSource1">
< ItemTemplate>
< object width ="480" height ="385">< param name ="movie" value =''<％#DataBinder.Eval(Container.DataItem，"url")％>''> </param>
< param name ="allowFullScreen" value ="true"></param>
< param name ="allowscriptaccess" value ="always"></param>
< embed src =''<％#DataBinder.Eval(Container.DataItem，"url")％>''type ="application/x-shockwave-flash" allowscriptaccess ="always" allowfullscreen ="true"宽度="480" height ="385">
</embed>
</object>
< br/>
</ItemTemplate>
</asp:Repeater>
< asp:SqlDataSource ID ="SqlDataSource1" runat =服务器"
ConnectionString =<％

Dear Friend,

For YouTube Vedios Iam Posting Sample Code Follow that.

Design Code:
<table>
<tr>
<td align="left" class="links2">
Title :</td>
<td align="left" class="links2">
<asp:TextBox ID="txtTitle" runat="server"></asp:TextBox><asp:RequiredFieldValidator
ID="rfvName" runat="server" ControlToValidate="txtTitle" Display="Dynamic" ErrorMessage="Enter Title"
SetFocusOnError="True" ValidationGroup="add">*</asp:RequiredFieldValidator></td>
</tr>
<tr>
<td align="left" class="links2" valign="top">
Link :</td>
<td class="links2" align="left">
<asp:TextBox ID="txtLink" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvDesc" runat="server" ControlToValidate="txtLink"
Display="Dynamic" ErrorMessage="Enter Link" SetFocusOnError="True" ValidationGroup="add">*</asp:RequiredFieldValidator></td>
</tr>
<tr>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td colspan="2">
&nbsp;</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="txtdelete" runat="server" Text="Delete"
onclick="txtdelete_Click1" />
<asp:Button ID="btnSubmit" runat="server" Text="Submit" ValidationGroup="add" OnClick="btnSubmit_Click" /><asp:ValidationSummary
ID="vsAdd" runat="server" ShowMessageBox="True" ShowSummary="False" ValidationGroup="add" />
<asp:Repeater ID="Repeater1" runat="server" DataSourceID ="SqlDataSource1">
<ItemTemplate>
<object width="480" height="385"><param name="movie" value=''<%#DataBinder.Eval(Container.DataItem, "url") %>''></param>
<param name="allowFullScreen" value="true"></param>
<param name="allowscriptaccess" value="always"></param>
<embed src=''<%#DataBinder.Eval(Container.DataItem, "url") %>'' type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="385">
</embed>
</object>
<br />
</ItemTemplate>
</asp:Repeater>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%

ConnectionStrings:sqlCon％>"
SelectCommand ="SELECT [url]，[description]，[id]来自[YouTubeVideos]">
</asp:SqlDataSource>
</td>
</tr>
</table>

C#代码:


私有字符串GetYouTubeID(string youTubeUrl)
{
//RegEx查找YouTube ID
匹配regexMatch = Regex.Match(youTubeUrl，"^ [^ v] + v =(.{11}).*"，
RegexOptions.IgnoreCase);
如果(regexMatch.Success)
{
返回"http://www.youtube.com/v/" + regexMatch.Groups [1] .Value +
& hl = zh-CN& fs = 1";
}
返回youTubeUrl;
}


在提交按钮事件中:


受保护的无效btnSubmit_Click(对象发送者，EventArgs e)
{

SqlConnection con =新的SqlConnection(ConfigurationManager.ConnectionStrings ["sqlCon"].ToString());
字符串url = txtLink .Text;
如果(url.Contains("youtube.com"))
{
字符串ytFormattedUrl = GetYouTubeID(url);

如果(！CheckDuplicate(ytFormattedUrl))
{
DataSet ds = new DataSet();
SqlDataAdapter ad =新的SqlDataAdapter("select * from YouTubeVideos"，con);
ad.Fill(ds);
如果(ds.Tables [0] .Rows.Count == 0)
{
SqlCommand cmd =新的SqlCommand("INSERT INTO YouTubeVideos([url])VALUES(""+ ytFormattedUrl +")"，con);
使用(con)
{
con.Open();
int结果= cmd.ExecuteNonQuery();
如果(结果！= -1)
{
Repeater1.DataBind();
}
其他
{Response.Write(插入新网址出错！"); }
con.Close();

}
}
其他
{
Response.Write(已经上传了视频");
}
}
否则{Response.Write(该视频已经存在于我们的数据库中！"); }
}
其他
{
Response.Write(此网址不是有效的YOUTUBE视频链接，因为其中不包含youtube.com")；
}
}

公共布尔CheckDuplicate(string youTubeUrl)
{
布尔存在=假;
//con = new SqlConnection();
//con.ConnectionString =数据源= SH-3 \\ SQLEXPRESS;初始目录= VarenyaCollege;集成安全性= True";
SqlConnection con =新的SqlConnection(ConfigurationManager.ConnectionStrings ["sqlCon"].ToString());
SqlCommand cmd =新的SqlCommand(String.Format(从YouTubeVideos中选择*，其中url =''{0}''"，youTubeUrl)，con);

使用(con)
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
存在=(dr.HasRows)吗? true:false;
}

返回存在；
}

分析并执行

问候

Anilkumar.D

ConnectionStrings:sqlCon%>"
SelectCommand="SELECT [url], [description], [id] FROM [YouTubeVideos]">
</asp:SqlDataSource>
</td>
</tr>
</table>

C# Code:


private string GetYouTubeID(string youTubeUrl)
{
//RegEx to Find YouTube ID
Match regexMatch = Regex.Match(youTubeUrl, "^[^v]+v=(.{11}).*",
RegexOptions.IgnoreCase);
if (regexMatch.Success)
{
return "http://www.youtube.com/v/" + regexMatch.Groups[1].Value +
"&hl=en&fs=1";
}
return youTubeUrl;
}


in submit button event:


protected void btnSubmit_Click(object sender, EventArgs e)
{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlCon"].ToString());
string url = txtLink .Text;
if (url.Contains("youtube.com"))
{
string ytFormattedUrl = GetYouTubeID(url);

if (!CheckDuplicate(ytFormattedUrl))
{
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter("select * from YouTubeVideos", con);
ad.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
SqlCommand cmd = new SqlCommand("INSERT INTO YouTubeVideos ([url]) VALUES (''" + ytFormattedUrl + "'')", con);
using (con)
{
con.Open();
int result = cmd.ExecuteNonQuery();
if (result != -1)
{
Repeater1.DataBind();
}
else
{ Response.Write("Error inserting new url!"); }
con.Close();

}
}
else
{
Response.Write("already you uploaded the video");
}
}
else { Response.Write("This video already exists in our database!"); }
}
else
{
Response.Write("This URL is not a valid YOUTUBE video link because it does not contain youtube.com in it");
}
}

public bool CheckDuplicate(string youTubeUrl)
{
bool exists = false;
//con=new SqlConnection ();
//con.ConnectionString = "Data Source=SH-3\\SQLEXPRESS;Initial Catalog=VarenyaCollege;Integrated Security=True";
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlCon"].ToString());
SqlCommand cmd = new SqlCommand(String.Format("select * from YouTubeVideos where url=''{0}''", youTubeUrl), con);

using (con)
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
exists = (dr.HasRows) ? true : false;
}

return exists;
}

Analize and Execute

Regards

Anilkumar.D

您能说清楚一点吗?您可以发布存储在数据库中的视频的示例链接吗?

Can you be a bit clear. Can you post a sample link of your video which is stored in database?

这篇关于如何在ASP.net中实现视频推荐的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！