How to return application id using database in c#

 private string GetApplicationNo(string ApplicationID)
        {
            string returnval = string.Empty;
            try
            {
                query = @"select ApplicationNo from ApplicationMSt where ApplicationID=@ApplicationID";

                using (SqlCommand cmd = new SqlCommand(query, ObjCon))
                {
                    cmd.Parameters.AddWithValue("@ApplicationID", ApplicationID);

                    if (ObjCon.State != ConnectionState.Open)
                        ObjCon.Open();

                    object obj = cmd.ExecuteScalar();

                    if (obj != null)
                    {
                        returnval = obj.ToString();
                    }

                    if (ObjCon.State != ConnectionState.Closed)
                        ObjCon.Close();
                }
            }
            catch (Exception ex)
            {
                lblApplDocError.Text = cnclss.SendExcepToDB(pageName, MethodBase.GetCurrentMethod().Name.ToString(), HttpContext.Current.Request.Url.ToString(), ex);
            }
            finally
            {
                if (ObjCon.State != ConnectionState.Closed)
                    ObjCon.Close();
            }
            return returnval;
        }

Comments

Post a Comment

Popular posts from this blog

String Program in C#

using System; using System.Linq; 1)Reverse Name String  in C# String Name="Sudam"; int Len=Name.Length-1; while(Len>=0) { Console.Write(Name[Len]); Len--; } ----------------------------------------- Output --madus ----------------------------------------- 2)Reverse Words of a String in C# string s = "I Name Is Sudam"; string[] a = s.Split(' '); int temp= a.Length - 1; while (temp >= 0) {     Console.Write(a[temp] + ' ');     temp--; } ------------------------------------------ Output --Sudam Is Name I ---------------------------------------- 3) How to Fine count how many double letters are in a string? int doubleLetters = 0; string characters = "Hello"; for (int i = 0; i < characters.Length - 1; i++) {     if (characters[i] == characters[i + 1])     {         doubleLetters++;         i++;     }     Console.WriteLine(doubleLetters); } -----------------------------------------...
Read more

CSV using XmlNode

 To create a CSV from an XmlNode in C#, you can follow these steps: 1. Parse the XML structure using XmlNode. 2. Extract the data you need from child nodes. 3. Write the CSV content using a StringBuilder or directly with StreamWriter. Here's a sample code snippet: using System; using System.IO; using System.Text; using System.Xml; public class XmlToCsvConverter {     public static void ConvertXmlNodeToCsv(XmlNode rootNode, string csvFilePath)     {         StringBuilder csvContent = new StringBuilder();         // Assuming all child nodes have the same structure         // Add header         if (rootNode.HasChildNodes)         {             XmlNode firstRow = rootNode.FirstChild;             for (int i = 0; i < firstRow.ChildNodes.Count; i++)             {     ...
Read more

Controller_Model. cs

Controller using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using NZWalks.API.Helper; using NZWalks.API.Models; using System.Net; namespace NZWalks.API.Controllers {     [ApiController]     [Route("api/[controller]")]     public class ConnectionController : ControllerBase     {         private readonly IConfiguration _configuration;         public ConnectionController(IConfiguration configuration)         {             _configuration = configuration;         }         [HttpGet("validate")]         public IActionResult ValidateAllConnections()         {             var hostname = Dns.GetHostName();             var connectionStrings = new List<ConnectionItem>();           ...
Read more