Monday, April 28, 2025

Saturday, April 26, 2025

How to create unique key in SQL server management studio

 >First Open Visual Studio

>Right Click on table and click on Design

>Right Click on column name left side

>Click on Indexes/Key

>Select Unique key in 'Type' Filed


Note:- Sometime unique key option is not visible

Saturday, April 19, 2025

asp.net button pass value to url in grid view

    <asp:Button ID="Button1" runat="server"

            PostBackUrl='<%# Eval("Id","~/Employee/Update/{0}") %>'

            Text="Save" Width="75px" />

Friday, April 18, 2025

how to use webclient class uploadstring - For webapi, webservice, handler - For post and for get

webclient in asp.net 


for get

 string handlerUrl = String.Format(Request.Url.Scheme+"://" +Request.Url.Authority+"{0}","/api/values");

        string response = (new WebClient()).DownloadString(handlerUrl);


for post

   using (var client = new WebClient())

        {

            string handlerUrl = String.Format(Request.Url.Scheme + "://" + Request.Url.Authority + "{0}", "/api/values");

            client.Headers[HttpRequestHeader.ContentType] =  "application/x-www-form-urlencoded";

            var data = "=Short test...";

            string result = client.UploadString(handlerUrl, "POST", data);

            

            Response.Write(result);

        }


 https://www.aspsnippets.com/Articles/2149/Call-Consume-Web-API-using-WebClient-in-ASPNet-C/

How to use object as list of object - Array of object - How to create object in C#

   object input = new { Name ="yash"};

        input = 6;

        List<object> a = new List<object>();

        a.Add(5);

        a.Add( "ere");


object[] jji=new object[2]{ new {s = "df"}, new {s= "df"}};

some times we can use 

dr.ItemArray = new Object[] {new {    AgentName = "dfdf"}, new {AgentName = "df"} };