Here query show how to select record between two dates in sql server.
select * from ContentMst
where c_date> = '2012-06-01' and c_date <= '2012-07-01'
order by c_date de...
Friday, August 17, 2012
How to insert record from one database to other database server
Here example show i am retrieving record from one server(DBServer2) and inserting in other server(DBServer1).
insert into Category(DBServer1)
select * from [DBServer2].[DatabaeName].[dbo].Category
Note: Both database server should be linq server otherwise it will give erro...
Wednesday, July 4, 2012
How to create a hyperlink or any other control dynamically and add to this in panel control
Here i am show how can you create hyperlink dynamically and add to it in panel control.
Here we can also create line break dynamically.
Take a asp.net panel in your .aspx page as given below:
<asp:Panel ID="Panel2" runat="server" CssClass="applycss">
</asp:Panel>
.cs code to create HyperLink dynamically and add...
Thursday, April 12, 2012
How to create or implement Remember me Login Page asp.net and c#
Login page source code in asp.net and c#
Hi,as you have seen various example above,please see one other example for login page using
Here i have implement Remember me on Login Page using checkbox. now i am going to explain
how to use Remember Me checkbox and login page code using asp.net and c# net.When you checked Remember me
checkbox...
Wednesday, March 7, 2012
How to improve asp.net Web application performance
For application performance you need to some r & d on your query mean stored procedure
see their retrieval cost and find where it is taking too much time to retriev the data
and do some action on that table.
For eg.
1.You should be use index whereever required
2.Use joining if required otherwise remove unnesseary join.
3.Select...
Tuesday, March 6, 2012
How to get label or textbox control from .aspx page in .ascx user control page
How to access controls from .aspx in .ascx user control page
Here i am showing a simple example how can we access controls from aspx in .ascx page
First i have created a WebUserControl.ascx user control page which contain a button.
WebUserControl.ascx page
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="WebUserControl.ascx.cs"...
Monday, February 27, 2012
How to detect MSISDN from browser headers
How to detect MSISDN from browser headers
Things to note be remember that:
1.If the user has come to wap portal on WiFi then you will not receive msisdn.
2.User mobile operator has to support the passing of the msisdn in the HTTP headers.
Below is simple code to find msisdn from...
Wednesday, February 22, 2012
Create HTTP request and receive response using asp.net C#
Create HTTP request and receive response using asp.net C#
1.Simple http request
Uri objurl = new Uri(url);
WebRequest objWebRequest = WebRequest.Create(objurl);
WebResponse objWebResponse = objWebRequest.GetResponse();
Stream objstream = objWebResponse.GetResponseStream();
StreamReader objStreamReader...
Tuesday, February 21, 2012
How to use stored Procedure with output parameters with ASP.NET,c#
How to retrieve store procedure output parameter value?I have given a simple code example.
I have created a store procedure with output parameter. After that I get it from code behind page of
asp.net and stored it a variable.
private void GetInfo()
{
DALUtility objDALUtility = null;
SqlConnection con = null;
SqlCommand...
