从sql server中检索数据 [英] retrive data from the sql server

问题描述

嗨frnds ...

i在asp.net中创建一个网站并从sql server 2005中检索数据，它以页表格式表示如何完成请重放

谢谢...

hi frnds...
i make a web site in a asp.net and retrive data from the sql server 2005 and it's represent in page table format how it is done please replay
thanks...

推荐答案

您好

请尝试此链接

http://lmgtfy.com/?q=how + to + store +和+ retrieve + vedio + file + in + sql + server + 2005 +％3F [ ^ ]





只需将一些视频保存在一个文件夹中并根据sql中的文件名获取相同的视频文件格式文件夹并播放它不是一个好主意，尝试保存视频文件sql server itslef。有时文件是从该文件夹中删除的，所以最好的方法是在sql server中存储视频文件的详细信息，所以只有你可以检索带有视频文件名的数据，并转换为vedio并播放它，如果用户在网格视图中单击文件名（表格格式）

Hi
pls try this link
http://lmgtfy.com/?q=how+to+store+and+retrieve+vedio+file+in+sql+server+2005+%3F[^]


Simply save some video in one folder and based on file name from sql and get that same video file form folder and play it is not good idea,Try to save video file sql server itslef.Sometime files is delete from that folder,so best way is store video file in sql server with detail,so only u can retrieve data with video file name ,and convert to vedio and play it ,if user click file name in grid view (table format)

试试这个.. :)



如何从sql server中检索数据？ [ ^ ]



在gridview中绑定数据，如表格

try this.. :)

how to retrive data from sql server ?[^]

Bind data in gridview like table

string str = " select filename from tblFiles  ";

        //con.Ins_Upd_Del("insert into tblnews(title,description,date) values('"+txtTitle .Text +"','"+txtDescription .Text+"','"+txtDate .Text .Trim ()+"')");

        SqlConnection sqn = new SqlConnection(@"Data Source=MEHUL-PC\SQLEXPRESS;Initial Catalog=dbFiles;Integrated Security=True");
        sqn.Open();

        SqlCommand cmd = new SqlCommand(str, sqn);
       SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
gvUserInfo.DataSource = ds;
gvUserInfo.DataBind();

这篇关于从sql server中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！