1
hai all...,
i used to store my mp3 file into database by
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
<%@ import Namespace="System.IO" %>
<%@ import Namespace="System.Data.SqlClient" %>
<%@ import Namespace="System.Drawing.Imaging" %>
<%@ import Namespace="System.Drawing" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Web.UI.WebControls" %>
<script runat="server">
void upload(Object s, EventArgs e)
{
// create a byte[] from the input file
int imagelen = songUpload.PostedFile.ContentLength;
byte[] pic = new byte[imagelen];
songUpload.PostedFile.InputStream.Read (pic, 0, imagelen);
//select * from SongDetails
//string connectionString = "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.Text);
cmd.Parameters.Add("@SongArtist", txtSongArtist.Text);
cmd.Parameters.Add("@Song",pic);
cmd.ExecuteNonQuery();
Label1.Text =("updated record");
dataConnection.Close();
txtSongTitle.Text = "";
txtSongArtist.Text = "";
}
}
}
</script>
<html>
<head>
<title>HurdLeg.com :: Administrator - Upload</title>
</head>
<body>
<form id="Form1" enctype="multipart/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="txtSongTitle" runat="server"></asp:TextBox>
</p>
<p>
<font size="3">Artist:</font>
<asp:TextBox id="txtSongArtist" runat="server"></asp:TextBox>
</p>
<p>
<font size="3">File:</font>
<asp:FileUpload 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
