Posted by: Vinit on: June 27, 2011
Hi, First Create the database in Sql. After that create web service in asp.net with c#. the code is like below. public class LoginDetails : System.Web.Services.WebService { SqlConnection con = new SqlConnection(“Data Source=SourceName;Initial Catalog=DBName;User id=UserName;Password=Password”); public LoginDetails() { //Uncomment the following line if using designed components //InitializeComponent(); } // Method to get login records from [...]
Posted by: Vinit on: June 15, 2011
Hi, The below code is for replace the specified attribute from the html. protected override void Render(HtmlTextWriter writer) { using (System.IO.MemoryStream msOur = new System.IO.MemoryStream()) { using (System.IO.StreamWriter swOur = new System.IO.StreamWriter(msOur)) { HtmlTextWriter ourWriter = new HtmlTextWriter(swOur); base.Render(ourWriter); ourWriter.Flush(); msOur.Position = 0; using (System.IO.StreamReader oReader = new System.IO.StreamReader(msOur)) { string sTxt = oReader.ReadToEnd(); [...]
Posted by: Vinit on: June 3, 2011
Hi, If you have the Data in Sql table like Value 15 17 Now, If you want to print the values like $15 and $17. So you will have to do like this… SELECT LEFT(‘$’ + CONVERT(VARCHAR, CAST(’15.00′ AS MONEY), 1), LEN(‘$’+ CONVERT(VARCHAR, CAST(’15.00′ AS MONEY), 1)) – 3)
Comments