Reply to thread

Message

<blockquote data-quote="Snowl" data-source="post: 11189989" data-attributes="member: 374230">මේක වැඩ කරනවා මම developed කරේ ,ඒ වගේම test කරලා බැලුවා කිහිප සැරයක්මහොදට වැඩ කරනවා. <img src="/styles/default/xenforo/smilies/default/happy.gif"&nbsp; class="smilie" loading="lazy" alt=":)" title="Happy&nbsp; &nbsp; :)" data-shortname=":)" />නමුත් පිළිවෙලට යන්න මොකද Validation System එක ඒ තරම් හොද මදි.ඔයාට ප්‍රශ්ණයක් තියෙනවා නම් කියන්න මම බලන්නම් මොකද කරන්න පුලුවන් කියලා.මුලින්ම Database එකක් හදාගන්න මේක තියෙන්නේ SQL වලින්Access කරන්න ඕන නම් SQL -&gt; OleDb කරන්න එකේ connection string එක මෙතනට දාන්නconnectionStr = &quot;&quot;එච්චරයි තියෙන්නේ ඒ වගේම මේක වැඩ කරන්නේ Online තියෙනවා නම් විතරයිමොකද ActiveX player එක Firefox,Opera,Safari වල වැඩ කරන්නේ නැති නිසා වෙනම flashplayer එකක් use කරන්න වුනා මට.මේ file 2ක් විතරයි ඕන වෙන්නේ. ඒ වගේම මේකේ database එකේcolumns හදනවා Automatically ඒකේ තියෙන්නේ id එක සහා path එකවිතරයි. මුලින්ම යන්න මේ විදියට Create database එක ඔබන්න එතනින් database එක හදනවා Application එකෙන්මඊට පස්සේ Browse කියන button එක මගින් අදාළ file එක select කරලාඊට එහා පැත්තේ තියෙන Save button එකෙන් upload කරගන්න මේකෙන් වැඩදෙකක් වෙනවා එකක් තමයි file එක upload වෙන එක අනෙක database එකටඅදාළ file එකේ server path එක යන එක.ඊට පස්සේ සෑහෙන තරම් records database එකේ තියෙන කොට Retrieve buttonඑක ඔබලා අදාළ files වල path ටික ගන්න පුලුවන්. දැන් මේ file එකක්play කරගන්න ඕන නම් කෙළවරේම තියෙන listbox එකේ ඕන file එකselect කරලා Select කියන button එක ඔබන්න ඒකෙන් mp3 player එකdraw කරනවා HTML එක මත දැන් play කියන button එක ඔබලා music එකඅහන්න. sound.aspx.cs[CODE]using System;using System.Collections.Generic;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;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; proUploadFile();&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; //&lt;---------- Update The Database&nbsp; ------&gt;&nbsp; &nbsp; public void proUpdateDatabase(String filePath)&nbsp; &nbsp; {&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 = &quot;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; if (soundFileServerPath.Contains(&quot;http://&quot;))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int start = soundFileServerPath.LastIndexOf(&quot;//&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fileToBePlayed = soundFileServerPath.Substring(start+1);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int start = soundFileServerPath.LastIndexOf(&quot;\\&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fileToBePlayed = soundFileServerPath.Substring(start+1);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Example of Local URL c:\file\mpfile.mp3&nbsp; &nbsp; &nbsp; &nbsp; String mp3PlayerCommands = &quot;&lt;object type='application/x-shockwave-flash' data='http://flash-mp3-player.net/medias/player_mp3.swf' width='200' height='20'&gt;&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &quot;&lt;param name='movie' value='http://flash-mp3-player.net/medias/player_mp3.swf' /&gt;&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &quot;&lt;param name='bgcolor' value='#ffffff' /&gt;&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &quot;&lt;param name='FlashVars' value='mp3=&quot; + fileToBePlayed + &quot;' /&gt;&quot; +&nbsp; &nbsp; &nbsp; &nbsp; &quot;&lt;/object&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; mp3PlayerDrawHere.InnerHtml = mp3PlayerCommands;&nbsp; &nbsp; }&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]sound.aspx[CODE]&lt;%@ Page Language=&quot;C#&quot; AutoEventWireup=&quot;true&quot; CodeFile=&quot;sound.aspx.cs&quot; Inherits=&quot;sound&quot; %&gt;&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt;&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;&lt;head runat=&quot;server&quot;&gt;&nbsp; &nbsp; &lt;title&gt;&lt;/title&gt;&nbsp; &nbsp; &lt;script language=&quot;javascript&quot; type=&quot;text/javascript&quot;&gt;&nbsp; &nbsp; &lt;/script&gt;&lt;/head&gt;&lt;body&gt;&nbsp; &nbsp; &lt;form id=&quot;form1&quot; runat=&quot;server&quot;&gt;&nbsp; &nbsp; &lt;div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;asp:Button ID=&quot;btnRetrieve&quot; runat=&quot;server&quot; onclick=&quot;Retrieve&quot; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text=&quot;Retrieve&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;asp:FileUpload ID=&quot;soundUpload&quot; runat=&quot;server&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;asp:Button ID=&quot;btncreateDatabase&quot; runat=&quot;server&quot; onclick=&quot;createDatabase&quot; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text=&quot;Create The Database&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;asp:Button ID=&quot;btnsaveFile&quot; runat=&quot;server&quot; onclick=&quot;saveFile&quot; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text=&quot;Save File&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;asp:DropDownList ID=&quot;allAudioFiles&quot; runat=&quot;server&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/asp:DropDownList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;asp:Button ID=&quot;audioSelect&quot; runat=&quot;server&quot; onclick=&quot;audioSelect_Click&quot; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Text=&quot;Select File&quot; /&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/form&gt;&nbsp; &nbsp; &lt;div id=&quot;mp3PlayerDrawHere&quot; runat=&quot;server&quot;&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/body&gt;&lt;/html&gt;[/CODE]//Snowl//</blockquote>

[QUOTE="Snowl, post: 11189989, member: 374230"] මේක වැඩ කරනවා මම developed කරේ ,ඒ වගේම test කරලා බැලුවා කිහිප සැරයක්ම හොදට වැඩ කරනවා. :) නමුත් පිළිවෙලට යන්න මොකද Validation System එක ඒ තරම් හොද මදි. ඔයාට ප්‍රශ්ණයක් තියෙනවා නම් කියන්න මම බලන්නම් මොකද කරන්න පුලුවන් කියලා. මුලින්ම Database එකක් හදාගන්න මේක තියෙන්නේ SQL වලින් Access කරන්න ඕන නම් SQL -> OleDb කරන්න එකේ connection string එක මෙතනට දාන්න connectionStr = "" එච්චරයි තියෙන්නේ ඒ වගේම මේක වැඩ කරන්නේ Online තියෙනවා නම් විතරයි මොකද ActiveX player එක Firefox,Opera,Safari වල වැඩ කරන්නේ නැති නිසා වෙනම flashplayer එකක් use කරන්න වුනා මට. මේ file 2ක් විතරයි ඕන වෙන්නේ. ඒ වගේම මේකේ database එකේ columns හදනවා Automatically ඒකේ තියෙන්නේ id එක සහා path එක විතරයි. මුලින්ම යන්න මේ විදියට Create database එක ඔබන්න එතනින් database එක හදනවා Application එකෙන්ම ඊට පස්සේ Browse කියන button එක මගින් අදාළ file එක select කරලා ඊට එහා පැත්තේ තියෙන Save button එකෙන් upload කරගන්න මේකෙන් වැඩ දෙකක් වෙනවා එකක් තමයි file එක upload වෙන එක අනෙක database එකට අදාළ file එකේ server path එක යන එක. ඊට පස්සේ සෑහෙන තරම් records database එකේ තියෙන කොට Retrieve button එක ඔබලා අදාළ files වල path ටික ගන්න පුලුවන්. දැන් මේ file එකක් play කරගන්න ඕන නම් කෙළවරේම තියෙන listbox එකේ ඕන file එක select කරලා Select කියන button එක ඔබන්න ඒකෙන් mp3 player එක draw කරනවා HTML එක මත දැන් play කියන button එක ඔබලා music එක අහන්න. [B]sound.aspx.cs[/B] [CODE] using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; 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) { proUploadFile(); } 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) { 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 = ""; if (soundFileServerPath.Contains("http://")) { int start = soundFileServerPath.LastIndexOf("//"); fileToBePlayed = soundFileServerPath.Substring(start+1); } else { int start = soundFileServerPath.LastIndexOf("\\"); fileToBePlayed = soundFileServerPath.Substring(start+1); } //Example of Local URL c:\file\mpfile.mp3 String mp3PlayerCommands = "<object type='application/x-shockwave-flash' data='http://flash-mp3-player.net/medias/player_mp3.swf' width='200' height='20'>" + "<param name='movie' value='http://flash-mp3-player.net/medias/player_mp3.swf' />" + "<param name='bgcolor' value='#ffffff' />" + "<param name='FlashVars' value='mp3=" + fileToBePlayed + "' />" + "</object>"; mp3PlayerDrawHere.InnerHtml = mp3PlayerCommands; } 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] [B]sound.aspx[/B] [CODE] <%@ Page Language="C#" AutoEventWireup="true" CodeFile="sound.aspx.cs" Inherits="sound" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <script language="javascript" type="text/javascript"> </script> </head> <body> <form id="form1" runat="server"> <div> <asp:Button ID="btnRetrieve" runat="server" onclick="Retrieve" Text="Retrieve" /> <asp:FileUpload ID="soundUpload" runat="server" /> <asp:Button ID="btncreateDatabase" runat="server" onclick="createDatabase" Text="Create The Database" /> <asp:Button ID="btnsaveFile" runat="server" onclick="saveFile" Text="Save File" /> <asp:DropDownList ID="allAudioFiles" runat="server"> </asp:DropDownList> <asp:Button ID="audioSelect" runat="server" onclick="audioSelect_Click" Text="Select File" /> </div> </form> <div id="mp3PlayerDrawHere" runat="server"> </div> </body> </html> [/CODE] [B]//Snowl//[/B] [/QUOTE]

Verification

Hata thunen beduwama keeyada? (60 bedeema thuna)

Search

Latest ads

Reply to thread