Posts

Photoshop Tips: 1.To resize Image -->. ctrl + + -->. shift & Adjust through mosue -->. once adjust it press enter.
Language Translation Editor http://www.quillpad.in/editor.html
Code to add background color or background image:- Frontend:- <html> <head> <title></title> </head> <body id="bgBody" runat="server"> </body> </html> C# apply in any method:- // Background color code  bgBody.Attributes["bgcolor"] = "#cc0000"; //background image code bgBody.Attributes.Add("background", "images/fullbg.jpg");
Get IPAddress of PC in c#: HttpRequest currentRequest = HttpContext.Current.Request; string ipAddress = currentRequest.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (ipAddress == null || ipAddress.ToLower() == "unknown") ipAddress = currentRequest.ServerVariables["REMOTE_ADDR"];
How to insert multiple rows from c# table to sql database table:- Frontend:   <asp:Button ID="Button2" runat="server" Text="Create Table"             onclick="Button2_Click" /> <asp:GridView ID="gveg" runat="server">         </asp:GridView> Backend C#:  protected void Button2_Click(object sender, EventArgs e)     {         //         // Here we create a DataTable with four columns.         //                 DataTable temptable = new DataTable();         temptable.Columns.Add("ProductID", typeof(string));         temptable.Columns.Add("RelatedProductID", typeof(string));       ...
Text in Proper Case or say Title Case ;-  lnk_1.Text = CultureInfo.CurrentCulture.TextInfo.ToTitleCase("Find a goal");  //TextInfo UsaTextInfo = new CultureInfo("en-US", false).TextInfo; Ouput: Find A Goal
Comparing a value in between two columns I have a table TblControl. Data type of both field is int. StartRange End Range BMIClassification Table startval endvalue 0 100 200 300 500 600 900 950 SELECT StartRange, EndRange FROM Control WHERE 225 BETWEEN StartRange AND EndRange eg:- Declare @BMIValue int set @BMIValue=34 SELECT * FROM BMIClassification WHERE @BMIValue between startval and endvalue