Database

shriku24 wrote:

i have problem to store audio file in database

byte[] audioData = SomeMethodForGettingTheAudioData();<br />
SqlCommand cmd = new SqlCommand();<br />
cmd.CommandText = "INSERT INTO SomeTable(AudioDataColumn) VALUES (@audioData)";<br />
cmd.Parameters.Add("@audioData", audioData);<br />
cmd.ExecuteNonQuery();

SqlCommand cmd = new SqlCommand();<br />
cmd.CommandText = "SELECT AudioDataColumn FROM SomeTable WHERE ID = @id";<br />
cmd.Parameters.Add("@id", someIdValue);<br />
byte[] audioData = (byte[])cmd.ExecuteScalar();

Colin Angus Mackay wrote:

byte[] audioData = SomeMethodForGettingTheAudioData();

Kunal P wrote:

well.. i wanted it for images.. though ia m sure the procedure wud be same..

Kunal P wrote:

now the somemethodforinputimages.. how do i go bout it..

Kunal P wrote:

i`l have a fileupload control to browse to the file..

Colin Angus Mackay wrote:

I've not used the file upload contro

Colin Angus Mackay wrote:

Get your image file and return it as a byte array

insert into table1(col1, col2) values(@col1, @col2)

insert into table1(col2, col1) values(@col2, @col1)

where text_data like '%some query with multiple words%'

where text_data like '%some%' or text_data like '%query%' or text_data 
like '%with%' or text_data like '%multiple%' or text_data like '%words%'

where text_data like '%some query with multiple words%' or text_data 
like '%some%' or text_data like '%query%' or text_data like '%with%' or 
text_data like '%multiple%' or text_data like '%words%'

BEGIN TRAN<br />
<br />
SELECT *<br />
FROM authors<br />
WITH (HOLDLOCK, ROWLOCK)<br />
WHERE au_id = '274-80-9391'<br />
<br />
/* Do all your stuff here while the record is locked */<br />
<br />
COMMIT TRAN

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}