Reply to thread

Message

<blockquote data-quote="Snowl" data-source="post: 11191783" data-attributes="member: 374230">මේක Firefox වලට වැඩ කරනවා අනෙක් ඒවාට කොහොමද දන්නේ නෑනමුත් Basic ක්‍රමය මේකයි පොඩ්ඩක් Edit කරලන්න අනෙක් Browser වලට වැඩ කරන්නේ නැත්නම්.මේක use කරන්නේ Windows Media Player එක.නමුත් Windows Media player plugin එක installකරන්න ඕනේ.[code]using System;using System.Collections.Generic;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Text.RegularExpressions;public partial class sound : System.Web.UI.Page{&nbsp; &nbsp; String connectionStr = &quot;&quot;;&nbsp; &nbsp; protected void Page_Load(object sender, EventArgs e)&nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; //############&nbsp; EVENTS&nbsp; &nbsp; ###################################################################&nbsp; &nbsp; protected void Retrieve(object sender, EventArgs e)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; loadAllSoundFiles();&nbsp; &nbsp; }&nbsp; &nbsp; protected void createDatabase(object sender, EventArgs e)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; proCreateTheDatabase();&nbsp; &nbsp; }&nbsp; &nbsp; protected void saveFile(object sender, EventArgs e)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; proUpdateDatabase();&nbsp; &nbsp; }&nbsp; &nbsp; protected void audioSelect_Click(object sender, EventArgs e)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; string getSoundFile = allAudioFiles.SelectedValue;&nbsp; &nbsp; &nbsp; &nbsp; makeMp3Player(getSoundFile);&nbsp; &nbsp; }&nbsp; &nbsp; //############################################################################################&nbsp; &nbsp; //################## PROCEDURES ##############################################################&nbsp; &nbsp; //&lt;---------- Create The Database ------&gt;&nbsp; &nbsp; public void proCreateTheDatabase()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionStr);&nbsp; &nbsp; &nbsp; &nbsp; String sqlCommand = &quot;CREATE TABLE sound(soundID INT NOT NULL,soundPath VARCHAR(200) NOT NULL,PRIMARY KEY(soundID))&quot;;&nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(sqlCommand, con);&nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.ExecuteNonQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Write(&quot;&lt;script type='text/javascript'&gt;alert('Database is created by Snowl.!');&lt;/script&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Write(&quot;&lt;script type='text/javascript'&gt;alert('There is an error, perhaps you already made it mister.!');&lt;/script&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; /*//&lt;---------- Upload The File to the Server ------&gt;&nbsp; &nbsp; public void proUploadFile()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; String filePath = soundUpload.PostedFile.FileName;&nbsp; &nbsp; &nbsp; &nbsp; if (!filePath.Equals(&quot;&quot;) &amp;&amp; !filePath.Equals(null))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String serverPath = Server.MapPath(&quot;~/&quot; + filePath.ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; proUpdateDatabase(serverPath);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; soundUpload.PostedFile.SaveAs(serverPath);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Write(&quot;&lt;script type='text/javascript'&gt;alert('You must first select a file to upload.! :P');&lt;/script&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; */&nbsp; &nbsp; //&lt;---------- Update The Database&nbsp; ------&gt;&nbsp; &nbsp; public void proUpdateDatabase()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; string filePath = txtFilePath.Text;&nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionStr);&nbsp; &nbsp; &nbsp; &nbsp; String sqlCommand = &quot;INSERT INTO sound(soundID,soundPath) VALUES(@soundID,@soundPath)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(sqlCommand, con);&nbsp; &nbsp; &nbsp; &nbsp; int previousID = proGetPreviousId();&nbsp; &nbsp; &nbsp; &nbsp; int newId = previousID + 1;&nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@soundID&quot;,newId);&nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.AddWithValue(&quot;@soundPath&quot;, filePath);&nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.ExecuteNonQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Write(&quot;&lt;script type='text/javascript'&gt;alert('Record is created by Snowl.!');&lt;/script&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Write(&quot;&lt;script type='text/javascript'&gt;alert('There is an error in updating the database.');&lt;/script&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; //&lt;------------ Get previous id's number ---------&gt;&nbsp; &nbsp; public int proGetPreviousId()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; int takeId = 0;&nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionStr);&nbsp; &nbsp; &nbsp; &nbsp; String sqlCommand = &quot;SELECT soundID FROM sound&quot;;&nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(sqlCommand,con);&nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDataReader read = cmd.ExecuteReader();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while(read.Read())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; takeId = int.Parse(read[&quot;soundID&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int lastId = takeId;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return lastId;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 0; //This means there is NO value so start from the beginning&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; // &lt;---------- Retrieve the Sound file and put it with the mp3 player ----------&gt;&nbsp; &nbsp; public void makeMp3Player(string soundFileServerPath)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; string fileToBePlayed = soundFileServerPath;&nbsp; &nbsp; &nbsp; &nbsp; string mp3PlayerCommands = &quot;&lt;embed type='application/x-mplayer2'&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &quot; width='420' height='45'&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &quot; src='&quot; + fileToBePlayed + &quot;' autostart='true'&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &quot; loop='false'&gt;&quot;+&nbsp; &nbsp; &nbsp; &nbsp; &quot;&lt;/embed&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; mediaDIV.InnerHtml = mp3PlayerCommands;&nbsp; &nbsp; }&nbsp; &nbsp; //&lt;--------- Load All sound files to the Listbox ----------------&gt;&nbsp; &nbsp; public void loadAllSoundFiles()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; allAudioFiles.Items.Clear();//Clear All Previous items from the item List&nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = new SqlConnection(connectionStr);&nbsp; &nbsp; &nbsp; &nbsp; String sqlCommand = &quot;SELECT soundPath FROM sound&quot;;&nbsp; &nbsp; &nbsp; &nbsp; SqlCommand cmd = new SqlCommand(sqlCommand, con);&nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDataReader read = cmd.ExecuteReader();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (read.Read())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; allAudioFiles.Items.Add(read[&quot;soundPath&quot;].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Close();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; catch (Exception error)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Write(&quot;&lt;script type='text/javascript'&gt;alert('There is an error in searching in the database.');&lt;/script&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; //#############################################################################################}[/code]</blockquote>

[QUOTE="Snowl, post: 11191783, member: 374230"] මේක Firefox වලට වැඩ කරනවා අනෙක් ඒවාට කොහොමද දන්නේ නෑ නමුත් Basic ක්‍රමය මේකයි පොඩ්ඩක් Edit කරලන්න අනෙක් Browser වලට වැඩ කරන්නේ නැත්නම්. මේක use කරන්නේ Windows Media Player එක.නමුත් Windows Media player plugin එක install කරන්න ඕනේ. [code]using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Text.RegularExpressions; public partial class sound : System.Web.UI.Page { String connectionStr = ""; protected void Page_Load(object sender, EventArgs e) { } //############ EVENTS ################################################################### protected void Retrieve(object sender, EventArgs e) { loadAllSoundFiles(); } protected void createDatabase(object sender, EventArgs e) { proCreateTheDatabase(); } protected void saveFile(object sender, EventArgs e) { proUpdateDatabase(); } protected void audioSelect_Click(object sender, EventArgs e) { string getSoundFile = allAudioFiles.SelectedValue; makeMp3Player(getSoundFile); } //############################################################################################ //################## PROCEDURES ############################################################## //<---------- Create The Database ------> public void proCreateTheDatabase() { SqlConnection con = new SqlConnection(connectionStr); String sqlCommand = "CREATE TABLE sound(soundID INT NOT NULL,soundPath VARCHAR(200) NOT NULL,PRIMARY KEY(soundID))"; SqlCommand cmd = new SqlCommand(sqlCommand, con); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); Response.Write("<script type='text/javascript'>alert('Database is created by Snowl.!');</script>"); } catch (Exception error) { Response.Write("<script type='text/javascript'>alert('There is an error, perhaps you already made it mister.!');</script>"); } } /*//<---------- Upload The File to the Server ------> public void proUploadFile() { String filePath = soundUpload.PostedFile.FileName; if (!filePath.Equals("") && !filePath.Equals(null)) { String serverPath = Server.MapPath("~/" + filePath.ToString()); proUpdateDatabase(serverPath); soundUpload.PostedFile.SaveAs(serverPath); } else { Response.Write("<script type='text/javascript'>alert('You must first select a file to upload.! :P');</script>"); } } */ //<---------- Update The Database ------> public void proUpdateDatabase() { string filePath = txtFilePath.Text; SqlConnection con = new SqlConnection(connectionStr); String sqlCommand = "INSERT INTO sound(soundID,soundPath) VALUES(@soundID,@soundPath)"; SqlCommand cmd = new SqlCommand(sqlCommand, con); int previousID = proGetPreviousId(); int newId = previousID + 1; cmd.Parameters.AddWithValue("@soundID",newId); cmd.Parameters.AddWithValue("@soundPath", filePath); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); Response.Write("<script type='text/javascript'>alert('Record is created by Snowl.!');</script>"); } catch (Exception error) { Response.Write("<script type='text/javascript'>alert('There is an error in updating the database.');</script>"); } } //<------------ Get previous id's number ---------> public int proGetPreviousId() { int takeId = 0; SqlConnection con = new SqlConnection(connectionStr); String sqlCommand = "SELECT soundID FROM sound"; SqlCommand cmd = new SqlCommand(sqlCommand,con); try { con.Open(); SqlDataReader read = cmd.ExecuteReader(); while(read.Read()) { takeId = int.Parse(read["soundID"].ToString()); } con.Close(); int lastId = takeId; return lastId; } catch (Exception error) { return 0; //This means there is NO value so start from the beginning } } // <---------- Retrieve the Sound file and put it with the mp3 player ----------> public void makeMp3Player(string soundFileServerPath) { string fileToBePlayed = soundFileServerPath; string mp3PlayerCommands = "<embed type='application/x-mplayer2'"+ " width='420' height='45'"+ " src='" + fileToBePlayed + "' autostart='true'"+ " loop='false'>"+ "</embed>"; mediaDIV.InnerHtml = mp3PlayerCommands; } //<--------- Load All sound files to the Listbox ----------------> public void loadAllSoundFiles() { allAudioFiles.Items.Clear();//Clear All Previous items from the item List SqlConnection con = new SqlConnection(connectionStr); String sqlCommand = "SELECT soundPath FROM sound"; SqlCommand cmd = new SqlCommand(sqlCommand, con); try { con.Open(); SqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { allAudioFiles.Items.Add(read["soundPath"].ToString()); } con.Close(); } catch (Exception error) { Response.Write("<script type='text/javascript'>alert('There is an error in searching in the database.');</script>"); } } //############################################################################################# }[/code] [/QUOTE]

Verification

Dahaya deken beduwama keeyada?

Search

Latest ads

Reply to thread