1
Answer

how to play audio files available in different server.

sri dev

sri dev

12y
1.1k
1
Hi,
 
I have to develop an application to play audio files available in different server.
suppose my application is hosted in Server A.and we have audio files to play available in Server B.
 
so how to connect to server B programatically using C# and ASP.NET and play that files.
 
please respond quickly 
Thank You very much
D Srinivas
Answers (1)
0
Sam Hobbs
NA 28.7k 1.3m 13y
The easiest and most reliable way is to create an auto-incrementing database field and then when you insert a new customer, get the number of the new customer record. The number will be only the number part; it would not include the "E" part. The E could be added whenever it is needed for formatting. Will the "E" part ever be something other than E? If so, then what is the meaning of it?
0
magesh manavalan
NA 244 423.5k 13y
Hi dear thanx for ur co operations and help ur codings.


Thanks&Regs

Magesh.A
0
Satyapriya Nayak
NA 53k 8m 13y
Hi Magesh,



 

Create table employee(empid varchar(50),empname varchar(50),sal int)

 
Default.aspx code

 

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

 

<!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>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

  

        <asp:Label ID="Label1" runat="server" Text="EmpId" Font-Bold="True"

            Width="100px"></asp:Label>

    <asp:TextBox ID="txt_empid" runat="server"></asp:TextBox><br />

    <asp:Label ID="Label2" runat="server" Text="EmpName" Font-Bold="True" Width="100px"></asp:Label>

    <asp:TextBox ID="txt_empname" runat="server"></asp:TextBox><br />

    <asp:Label ID="Label3" runat="server" Text="Salary" Font-Bold="True" Width="100px"></asp:Label>

    <asp:TextBox ID="txt_sal" runat="server"></asp:TextBox><br />

    </div>

  

    <asp:Button ID="btn_insert" runat="server" onclick="btn_insert_Click"

        Text="Insert Data" /><br />

    <asp:Label ID="Label4" runat="server"></asp:Label>

  

    </form>

</body>

</html>

 
Default.aspx.cs code

 

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

    string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    string str;

    SqlCommand com;

    int count;

    protected void Page_Load(object sender, EventArgs e)

    {

        SqlConnection con = new SqlConnection(strConnString);

        str = "select count(*) from employee";

        com = new SqlCommand(str, con);

        con.Open();

        count = Convert.ToInt16(com.ExecuteScalar()) + 1;

        txt_empid.Text = "E000" + count;

        con.Close();

    }

    protected void btn_insert_Click(object sender, EventArgs e)

    {

        SqlConnection con = new SqlConnection(strConnString);

        con.Open();

        str = "insert into employee values('" + txt_empid.Text.Trim() + "','" + txt_empname.Text.Trim() + "'," + txt_sal.Text.Trim() + ")";

        com = new SqlCommand(str, con);

        com.ExecuteNonQuery();

        con.Close();

        Label4.Text = "Records successfully Inserted";

    }

}

Thanks
If this post helps you mark it as answer