retrive data from the sql server

Question

0.00/5 (No votes)

See more:

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...

Posted 9-Apr-14 3:37am

Mehul Tank

Add a Solution

Comments

[no name] 9-Apr-14 9:40am

How is what done?

Mehul Tank 15-Apr-14 22:56pm

i want to create website like you tube store video and retrive video from that...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aravindba · Accepted Answer · 2014-04-10T17:08:00

Solution 2

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)

Posted 10-Apr-14 17:08pm

Aravindba

Comments

Mehul Tank 13-Apr-14 23:44pm

thank you
i will try this but pls tell me how much maximum size of video store in sql server ??
i tried also that you are said i can storw only 2 mb video in the server no more than 2 mb size store
how to store 1/2 gb video file store in the db ???

Aravindba 14-Apr-14 11:20am

hi sorry for late reply,pls try this link
https://www.google.co.in/?gws_rd=cr&ei=evtLU5vRN86Hrgfdk4CYCQ#q=how+to+store+3gb+video+in+sql+server+2005

Mehul Tank 15-Apr-14 22:54pm

thx i will check it

**Nirav Prabtani** · Accepted Answer · 2014-04-09T03:53:00

Solution 1

try this.. :)

how to retrive data from sql server ?[^]

Bind data in gridview like table

C#

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();

Posted 9-Apr-14 3:53am

Nirav Prabtani

Updated 9-Apr-14 19:52pm

v2

Comments

Mehul Tank 9-Apr-14 9:58am

i am trying to this and retrive but how to display table format ????

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);
cmd.ExecuteNonQuery();

cmd.Dispose();
sqn.Close();

Nirav Prabtani 10-Apr-14 1:53am

see updated solution and try to bind data in gridview, If you are not satisfied with that then try to search in google "How to Binf data in gridview c#"

PIEBALDconsult 9-Apr-14 10:11am

I'm guessing some sort of Control that displays Data in a Grid for Viewing.

Mehul Tank 9-Apr-14 10:31am

you are right
but i want to do retrive data from the table and again retrive data from the folder as data appropriate retriving database
i.e data retrive from the table is give in the input in the other query that query is such as retrive data from the folder

PIEBALDconsult 9-Apr-14 11:01am

What's a folder?

Mehul Tank 10-Apr-14 7:14am

your question is not clear,u ask like how to retrive data form sql server and show in page as table format,using dataview or gridview can show like table format,but what u say now need to retrieve form folder ,what is it folder ? r u going to get any file or image form folder based on file name in sql server ? first u try and post ur code upto what u did,simply u ask retrieve form sql server then again ask also retrieve form folder.

Aravindba 10-Apr-14 2:42am

your question is not clear,u ask like how to retrive data form sql server and show in page as table format,using dataview or gridview can show like table format,but what u say now need to retrieve form folder ,what is it folder ? r u going to get any file or image form folder based on file name in sql server ? first u try and post ur code upto what u did,simply u ask retrieve form sql server then again ask also retrieve form folder.

Mehul Tank 10-Apr-14 7:13am

ya i completed retrive data from sql .
i have one video folder and this folder all video file that all video file i want display on the web page such as a u tube unser stand or not ???

Aravindba 10-Apr-14 22:55pm

u r design for website right ? ur folder is inside root folder (i mean in iis inside ur website folder correct ?) if u retrieve form local drive its working in development machine,so better to convert ur video files into binary and save in sql server itself,i mean in which table retrieve data in that table,so it easy to retrieve data and video according with detail that one u ask in ur first question. In grid view if u click name of video then get binay from sql and convert into video and play it.
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.