ASP.NET

CREATE TABLE MyMp3s<br />
(<br />
Mp3Image image<br />
)<br />
GO<br />
<br />
CREATE PROC InsertMp3Image<br />
@Mp3Image image<br />
AS<br />
INSERT INTO MyMp3s VALUES(@Mp3Image)<br />
GO<br />
<br />
// C# code snippet<br />
<br />
Int32 m_MaxFileSize = 10240000;<br />
<br />
SqlCommand storedProcedure =<br />
new SqlCommand("InsertMp3Image" , SqlConnection);<br />
storedProcedure.CommandTimeout = 30;<br />
storedProcedure.CommandType = CommandType.StoredProcedure;<br />
<br />
System.IO.BinaryReader binaryReader =<br />
new BinaryReader(<br />
new FileStream (@"C:\Mp3\MyMp3.mp3",<br />
FileMode.Open,<br />
FileAccess.Read));<br />
<br />
byte[] buffer = binaryReader.ReadBytes(m_MaxFileSize);<br />
<br />
binaryReader.Close();<br />
<br />
storedProcedure.Parameters.Add( "@Mp3Image", buffer );<br />
<br />
storedProcedure.ExecuteNonQuery();

suri83 wrote:

When we enter a word and do a search on that, we should get all the sound files containing that word.

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
       If Not IsPostBack Then BindIt()
End Sub


Sub BindIt()
        Dim ds As New DataSet
        ds = data.GetEverything

        If ds.Tables.Count > 0 AndAlso ds.Tables(0).Rows.Count > 0 Then
            gdv.DataSource = ds
            gdv.DataBind()
        End If
End Sub


Protected Sub btnSearchSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearchSubmit.Click
        Dim ds As New DataSet
        ds = data.GetData(parmaterfromsearchform, another, another)

        If ds.Tables.Count > 0 AndAlso ds.Tables(0).Rows.Count > 0 Then
            gdv.DataSource = Nothing
            gdv.DataSource = ds
            gdv.DataBind()
        Else
            gdv.DataSource = Nothing
            gdv.DataBind()
        End If
    End Sub

Dim data As New Data