1
hai all...,
i used to store my mp3 file into database by
<%@ Page Language="C#" AutoEventWireup ="true" CodeFile="Defau lt3.aspx.cs" Inherits="Defau lt3" %>
<%@ import Namespace="Syst em.IO" %>
<%@ import Namespace="Syst em.Data.SqlClie nt" %>
<%@ import Namespace="Syst em.Drawing.Imag ing" %>
<%@ import Namespace="Syst em.Drawing" %>
<%@ import Namespace="Syst em.Data" %>
<%@ import Namespace="Syst em.Web.UI.WebCo ntrols" %>
<script runat="server">
void upload(Object s, EventArgs e)
{
// create a byte[] from the input file
int imagelen = songUpload.Post edFile.ContentL ength;
byte[] pic = new byte[imagelen];
songUpload.Post edFile.InputStr eam.Read (pic, 0, imagelen);
//select * from SongDetails
//string connectionStrin g = "connection string";
using (SqlConnection dataConnection = new SqlConnection(" Data Source=192.168. 0.100;Initial Catalog=master; User ID=sa;Password= ;"))
{
using (SqlCommand dataCommand = dataConnection. CreateCommand() )
{
dataConnection. Open();
SqlCommand cmd = new SqlCommand ("INSERT INTO SongDetails" + "(SongTitle , SongArtist, Song) VALUES (@SongTitle, @SongArtist, @Song)", dataConnection) ;
cmd.Parameters. Add("@SongTitle ", txtSongTitle.Te xt);
cmd.Parameters. Add("@SongArtis t", txtSongArtist.T ext);
cmd.Parameters. Add("@Song",pic );
cmd.ExecuteNonQ uery();
Label1.Text =("updated record");
dataConnection. Close();
txtSongTitle.Te xt = "";
txtSongArtist.T ext = "";
}
}
}
</script>
<html>
<head>
<title>HurdLeg. com :: Administrator - Upload</title>
</head>
<body>
<form id="Form1" enctype="multip art/form-data" runat="server">
<p align="Left">
<font size="5"><i>mp3 file into Database</i></font>
</p>
<p><font size="3"></font></p>
<p><font size="3"></font></p>
<p><font size="3"></font></p>
<p>
<font size="3">Title: </font>
<asp:TextBox id="txtSongTitl e" runat="server"> </asp:TextBox>
</p>
<p>
<font size="3">Artist :</font>
<asp:TextBox id="txtSongArti st" runat="server"> </asp:TextBox>
</p>
<p>
<font size="3">File:</font> &nbs p;
<asp:FileUplo ad id="songUpload " runat="server"> </asp:FileUpload>
</p>
<p>
<input id="btnUpload" type="button" value="upload" runat="server" onserverclick=" upload" />
<asp:Label ID="Label1" runat="server" Style="z-index: 100; left: 15px; position: absolute;
top: 260px" Width="205px"></asp:Label>
</p>
</form>
</body>
</html>
but iam not able to retrive my mp3 file from database. so please any body can help me
by
varaprasad
