tag:blogger.com,1999:blog-74421815434493303862024-03-05T20:36:06.988-08:00Learn Advanced ASP.NET And Its FeaturesRohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-7442181543449330386.post-10314695859040569402014-07-26T10:59:00.001-07:002018-09-11T11:06:36.721-07:00Find Column Name,Text from Tables In A Sql Server Database<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Below Stored Procedure is used "To Find Column Name,Text from Tables In A Sql Server Database" : </b>Just copy Paste the below query in query window of Sql Server Database, execute it and then pass the text , execute it the search result will shown :<br />
<br />
<br />
<div style="text-align: left;">
Create PROC [dbo].[SearchAllTables] </div>
<div style="text-align: left;">
(</div>
<div style="text-align: left;">
@SearchStr nvarchar(100)</div>
<div style="text-align: left;">
)</div>
<div style="text-align: left;">
AS</div>
<div style="text-align: left;">
BEGIN</div>
<div style="text-align: left;">
<br />
CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))</div>
<div style="text-align: left;">
<br />
SET NOCOUNT ON</div>
<div style="text-align: left;">
<br />
DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)</div>
<div style="text-align: left;">
SET @TableName = ''</div>
<div style="text-align: left;">
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')</div>
<div style="text-align: left;">
<br />
WHILE @TableName IS NOT NULL</div>
<div style="text-align: left;">
<br />
BEGIN</div>
<div style="text-align: left;">
SET @ColumnName = ''</div>
<div style="text-align: left;">
SET @TableName = </div>
<div style="text-align: left;">
(</div>
<div style="text-align: left;">
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))</div>
<div style="text-align: left;">
FROM INFORMATION_SCHEMA.TABLES</div>
<div style="text-align: left;">
WHERE TABLE_TYPE = 'BASE TABLE'</div>
<div style="text-align: left;">
AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName</div>
<div style="text-align: left;">
AND OBJECTPROPERTY(</div>
<div style="text-align: left;">
OBJECT_ID(</div>
<div style="text-align: left;">
QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)</div>
<div style="text-align: left;">
), 'IsMSShipped'</div>
<div style="text-align: left;">
) = 0</div>
<div style="text-align: left;">
)</div>
<div style="text-align: left;">
<br />
WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)</div>
<div style="text-align: left;">
<br />
BEGIN</div>
<div style="text-align: left;">
SET @ColumnName =</div>
<div style="text-align: left;">
(</div>
<div style="text-align: left;">
SELECT MIN(QUOTENAME(COLUMN_NAME))</div>
<div style="text-align: left;">
FROM INFORMATION_SCHEMA.COLUMNS</div>
<div style="text-align: left;">
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)</div>
<div style="text-align: left;">
AND TABLE_NAME = PARSENAME(@TableName, 1)</div>
<div style="text-align: left;">
AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'int', 'decimal')</div>
<div style="text-align: left;">
AND QUOTENAME(COLUMN_NAME) > @ColumnName</div>
<div style="text-align: left;">
)</div>
<div style="text-align: left;">
<br />
IF @ColumnName IS NOT NULL</div>
<div style="text-align: left;">
<br />
BEGIN</div>
<div style="text-align: left;">
INSERT INTO #Results</div>
<div style="text-align: left;">
EXEC</div>
<div style="text-align: left;">
(</div>
<div style="text-align: left;">
'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630) </div>
<div style="text-align: left;">
FROM ' + @TableName + 'WITH (NOLOCK) ' +</div>
<div style="text-align: left;">
' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2</div>
<div style="text-align: left;">
)</div>
<div style="text-align: left;">
END</div>
<div style="text-align: left;">
END </div>
<div style="text-align: left;">
END</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
SELECT ColumnName, ColumnValue FROM #Results</div>
<div style="text-align: left;">
END</div>
<div style="text-align: left;">
</div>
</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-32283387732589385452014-05-12T09:27:00.000-07:002014-05-12T09:31:04.949-07:00Apple Push Notification On IOS,IPhone Using C#<div dir="ltr" style="text-align: left;" trbidi="on">
<b> Working Example Push Notification On IOS Uing C# </b><br />
<br />
<b>using JdSoft.Apple.Apns.Notifications;<br />using Newtonsoft.Json.Linq; </b><br />
<br />
<b>public void Ios_Push_Notification(String SenderName, Int32 SenderID, Int32 ReceiverID, String TextMessage)</b><br />
{<br />
bool sandbox = true;<br />
<br />
//Put your device token in here<br />
<br />
string testDeviceToken = "3b717cfe826825daa6ee3d8756de8a101ba5f46d5de35d3730748dbac976d2uy";<br />
<br />
//Put your PKCS12 .p12 or .pfx filename here.<br />
// Assumes it is in the same directory as your app<br />
string p12File = Server.MapPath("~/Key.p12");<br />
<br />
//This is the password that you protected your p12File<br />
// If you did not use a password, set it as null or an empty string<br />
string p12FilePassword = "123";<br />
<br />
//Number of notifications to send<br />
int count = 1;<br />
<br />
//Number of milliseconds to wait in between sending notifications in the loop<br />
// This is just to demonstrate that the APNS connection stays alive between messages<br />
int sleepBetweenNotifications = 3000;<br />
<br />
string p12Filename = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, p12File);<br />
<br />
NotificationService service = new NotificationService(sandbox, p12Filename, p12FilePassword, 1);<br />
<br />
service.SendRetries = 5; //5 retries before generating notificationfailed event<br />
service.ReconnectDelay = 5000; //5 seconds<br />
<br />
service.Error += new NotificationService.OnError(service_Error);<br />
service.NotificationTooLong += new NotificationService.OnNotificationTooLong(service_NotificationTooLong);<br />
<br />
service.BadDeviceToken += new NotificationService.OnBadDeviceToken(service_BadDeviceToken);<br />
service.NotificationFailed += new NotificationService.OnNotificationFailed(service_NotificationFailed);<br />
service.NotificationSuccess += new NotificationService.OnNotificationSuccess(service_NotificationSuccess);<br />
service.Connecting += new NotificationService.OnConnecting(service_Connecting);<br />
service.Connected += new NotificationService.OnConnected(service_Connected);<br />
service.Disconnected += new NotificationService.OnDisconnected(service_Disconnected);<br />
<br />
<br />
Dictionary<string, object> rows = new Dictionary<string, object>();<br />
JavaScriptSerializer objSerializable = new JavaScriptSerializer();<br />
List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();<br />
Dictionary<string, object> row = new Dictionary<string, object>();<br />
<br />
<br />
rows.Add("Result", "Success");<br />
rows.Add("SenderName", SenderName);<br />
rows.Add("SenderID", SenderID);<br />
rows.Add("ReceiverID", ReceiverID);<br />
rows.Add("TextMessage", TextMessage);<br />
<br />
String postDatas = objSerializable.Serialize(rows);<br />
<br />
for (int i = 0; i < count; i++)<br />
{<br />
//Create a new notification to send<br />
Notification alertNotification = new Notification(testDeviceToken);<br />
<br />
alertNotification.Payload.Alert.Body = postDatas;<br />
alertNotification.Payload.Sound = "default";<br />
//Queue the notification to be sent<br />
if (service.QueueNotification(alertNotification))<br />
Console.WriteLine("Notification Queued!");<br />
else<br />
Console.WriteLine("Notification Failed to be Queued!");<br />
<br />
//Sleep in between each message<br />
if (i < count)<br />
{<br />
Console.WriteLine("Sleeping " + sleepBetweenNotifications + " milliseconds before next Notification...");<br />
System.Threading.Thread.Sleep(sleepBetweenNotifications);<br />
}<br />
}<br />
<br />
Console.WriteLine("Cleaning Up...");<br />
<br />
//First, close the service.<br />
//This ensures any queued notifications get sent befor the connections are closed<br />
service.Close();<br />
<br />
//Clean up<br />
service.Dispose();<br />
<br />
Console.WriteLine("Done!");<br />
Console.WriteLine("Press enter to exit...");<br />
Console.ReadLine();<br />
}<br />
<br />
static void service_BadDeviceToken(object sender, BadDeviceTokenException ex)<br />
{<br />
Console.WriteLine("Bad Device Token: {0}", ex.Message);<br />
}<br />
<br />
static void service_Disconnected(object sender)<br />
{<br />
Console.WriteLine("Disconnected...");<br />
}<br />
<br />
static void service_Connected(object sender)<br />
{<br />
Console.WriteLine("Connected...");<br />
}<br />
<br />
static void service_Connecting(object sender)<br />
{<br />
Console.WriteLine("Connecting...");<br />
}<br />
<br />
static void service_NotificationTooLong(object sender, NotificationLengthException ex)<br />
{<br />
Console.WriteLine(string.Format("Notification Too Long: {0}", ex.Notification.ToString()));<br />
}<br />
<br />
static void service_NotificationSuccess(object sender, Notification notification)<br />
{<br />
Console.WriteLine(string.Format("Notification Success: {0}", notification.ToString()));<br />
}<br />
<br />
static void service_NotificationFailed(object sender, Notification notification)<br />
{<br />
Console.WriteLine(string.Format("Notification Failed: {0}", notification.ToString()));<br />
}<br />
<br />
static void service_Error(object sender, Exception ex)<br />
{<br />
Console.WriteLine(string.Format("Error: {0}", ex.Message));<br />
}</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-29249808176092403412014-05-12T09:22:00.002-07:002014-05-12T09:28:02.417-07:00Push Notification On Android Using C#<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Working Example to push notification on Android using C#</b> <br />
<br />
using JdSoft.Apple.Apns.Notifications;<br />using Newtonsoft.Json.Linq;<br />
<br />
string regId = "APA91bEFbLOkP56DfLtUeXD1xiap54BDxQa1iP321W_- QnRSYEenap8uz8lk8hkieEHRMH4rr6cAN-XE14IO2rx4IEZiN0xQ4Yf39aTw63zHM6swbp8zfwB_MEF6fTPTKEwxhtcpUfdc1Xhik6u6gQZIz6pULifQ";<br />
<br />
var applicationID = "AIzaSyDK7e2fDNymJCl8toInDPmPTlUsSKE1wz0";<br />
var SENDER_ID = "572165304164";<br />
var value = "TextMessage";<br />
WebRequest tRequest;<br />
tRequest = WebRequest.Create("https://android.googleapis.com/gcm/send");<br />
tRequest.Method = "post";<br />
tRequest.ContentType = " application/x-www-form-urlencoded;charset=UTF-8";<br />
tRequest.Headers.Add(string.Format("Authorization: key={0}", applicationID));<br />
<br />
tRequest.Headers.Add(string.Format("Sender: id={0}", SENDER_ID));<br />
<br />
Dictionary<string, object> rows = new Dictionary<string, object>();<br />
JavaScriptSerializer objSerializable = new JavaScriptSerializer();<br />
List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();<br />
Dictionary<string, object> row = new Dictionary<string, object>();<br />
<br />
<br />
rows.Add("Result", "Success");<br />
rows.Add("SenderName", SenderName);<br />
rows.Add("SenderID", SenderID);<br />
rows.Add("ReceiverID", ReceiverID);<br />
rows.Add("TextMessage", TextMessage);<br />
<br />
<br />
<br />
//Context.Response.Write(objSerializable.Serialize(rows));<br />
<br />
String postDatas = objSerializable.Serialize(rows);<br />
<br />
<br />
<br />
//Data_Post Format<br />
//string postDatas = "{'data': {'SenderName':'" + SenderName + "','SenderID': '" + SenderID + "','ReceiverID':'" + ReceiverID + "','TextMessage':'" + TextMessage + "'}}";<br />
//string postDatas = "{" + "data:" + "{" + "SenderName:" + SenderName + "','SenderID': '" + SenderID + "','ReceiverID':'" + ReceiverID + "','TextMessage':'" + TextMessage + "'}}";<br />
<br />
<br />
string postData = "collapse_key=score_update&time_to_live=108&delay_while_idle=1&data.message="<br />
+ postDatas + "&data.time=" + System.DateTime.Now.ToString() + "&registration_id=" + regId + "";<br />
<br />
<br />
Console.WriteLine(postData);<br />
Byte[] byteArray = Encoding.UTF8.GetBytes(postData);<br />
tRequest.ContentLength = byteArray.Length;<br />
<br />
Stream dataStream = tRequest.GetRequestStream();<br />
dataStream.Write(byteArray, 0, byteArray.Length);<br />
dataStream.Close();<br />
<br />
WebResponse tResponse = tRequest.GetResponse();<br />
<br />
dataStream = tResponse.GetResponseStream();<br />
<br />
StreamReader tReader = new StreamReader(dataStream);<br />
<br />
String sResponseFromServer = tReader.ReadToEnd();<br />
<br />
// Label3.Text = sResponseFromServer; //printing response from GCM server.<br />
tReader.Close();<br />
dataStream.Close();<br />
tResponse.Close();</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-44249033368365023792014-03-07T21:35:00.001-08:002014-06-22T00:55:53.307-07:00Query to generate comma-separated list from one individual column data from database table in sql server using COALESCE()<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Table Name ></b> tbmap<br />
<b> Fields ></b> Place<br />
<b> Data ></b> Amritsar<br />
Bhutan<br />
Kerala<br />
<br />
<br />
<b>Query to generate comma-separated list from one individual column data <br />from database table in sql server using COALESCE()</b><br />
<br />
<b>Query ></b><br />
<br />
DECLARE @List VARCHAR(8000)<br />
<br />
SELECT @List = COALESCE(@List + ',', '') + CAST(Place AS VARCHAR)<br />
FROM tbmap<br />
where Place='PLACENAME'<br />
SELECT @List as Place<br />
<br />
<b>Output :</b><br />
Amritsar,Bhutan,Kerala</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-28137832693485193872014-03-07T21:27:00.003-08:002014-03-07T21:39:43.115-08:00Query to generate comma-separated list from one individual column data from database table in sql server<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Table Name ></b> EmployeeDetails<br />
<b>Fields ></b> EmployeeName<br />
<b> Data ></b> Rohin<br />
Rajat<br />
Rahul<br />
Ishan<br />
<br />
<b>Query to generate comma-separated list from one individual column data from database table in sql server</b><br />
<b><br />Query ></b> SELECT STUFF((SELECT ',' + [EmployeeName]<br />
FROM @EmployeeDetails<br />
ORDER BY [EmployeeName]<br />
FOR XML PATH('')), 1, 1, '') AS [EmployeeName]<br />
<br />
<b>Output</b><br />
Ishan,Rahul,Rajat,Rohin</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-15176384027555255982013-07-16T10:01:00.002-07:002013-07-16T10:01:37.526-07:00How to Set Default Page in Asp.net<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="color: orange;"> Set Default Page in Asp.net :</span></b><br />
<br />
Go to web.config file and then write the following below code inside <System.WebServer></System.WebServer><br />
<br />
<b>For Example : </b><br />
<br />
<System.webserver><br />
<defaultdocument><br />
<files><br />
<clear/><br />
<add value="Hello.aspx"> <br />
</files><br />
<br />
</defaultdocument><br />
</System.webserver><br />
<br /></div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-34690632096193843452013-07-13T09:02:00.001-07:002013-07-13T22:45:25.129-07:00Godaddy 500 Internal Server Errors<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<br />
<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: orange;"><b> Godaddy 500 Internal Server Error-:</b></span> When your Website code working properly in your local system and when i'll upload the same website code over the server hosting then some times it gives 500 Internal Server Error.<br />
So you will do that as paste and replace the following your code in your web.confing that exists on your live server :<br />
<br />
<?xml version="1.0" encoding="UTF8"?><br />
<configuration><br />
<system.web><br />
<customErrors mode="Off" /><br />
</system.web><br />
<connectionStrings><br />
<remove name="LocalSqlServer" /><br />
<remove name="LocalMySqlServer" /><br />
<br />
<br />
</connectionStrings><br />
</configuration><br />
<br /></div>
</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-13816989395953096782013-07-08T21:56:00.003-07:002014-06-22T00:57:36.095-07:00GoogleVerification<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://plus.google.com/111511552857979281177" or="" rel="publisher"></a>
<br />
<div dir="ltr" style="text-align: left;" trbidi="on">
google-site-verification: googlea893cd627662978f.html</div>
</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-76041401014331418212013-07-07T00:04:00.000-07:002013-07-13T22:47:55.519-07:00State Management<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
State Management : It is used to manage the state of stateless pages.<br />
<br />
Types of State Management : There are two types of State Management are as shown below :<br />
<br />
1. Client Side State Management.<br />
2. Server Side State Management.<br />
<br />
1. Client Side State Management : a) To use the Client resources means that information is stored on client hard-disk and client memory.<br />
<br />
b) Secure : It is not secure means anyone can modify on client hard disk.<br />
<br />
Types of Client Side State Management :<br />
<br />
a. Cookies.<br />
b. Query String.<br />
c. View State.<br />
d. Hidden State.<br />
e Control State.<br />
<br />
a) Cookies : Data stored in different types and this information stores and go to the next page, for this action we will used cookies.<br />
<br />
=> To stored data in text file and that text file resides or store on client machine.<br />
=> We can stores only string values but not object i.e Data Set not store.<br />
=> Scope : Multiple pages means Make cookie in one page and access in any other pages.<br />
=> By default Cookies are temporary and temporary cookies store on the browser memory.<br />
If we can off the browser then the cookie will destroy.<br />
=> But we can also create Permanent Cookies and we can specify Expiry time for cookie. If System off then there is no effect on cookie.<br />
<br />
<br />
b) Query String : It is also used for data storage.<br />
<br />
=> Data concatenated with URL in query string.<br />
=> Not stored in Text file.<br />
=> We can store string value but didn't store objects.<br />
=> Scope : Its scope is to the next page means one page to another page but cookie scope is more.<br />
=> Maximum length of URL is 2086 characters.<br />
=> Client side not secure means we can manipulate data in URL.<br />
<br />
<br />
c) View State : Information is stored in view state in Hashed(#), Compressed, Encoded form.<br />
Hash key generated for data retrieve and it is fast.<br />
<br />
=> We can stores string value as well as objects like data set store.<br />
=> We can store only serialisable object but we can't store Non-Serializable objects.<br />
=> Scope : To manage the state of current page.<br />
<br />
For example : Information stored and goes to server and information retrieve when page comes from server.<br />
If we go to the next page and then come back to the previous page then Information is lost.<br />
<br />
=> We can specify Encryption Mode for a View State like Always, Never , On Request.<br />
=> We can specify maximum page size for a view state. By default -1 means unlimited, but we can also apply limitation over there.<br />
<br />
Drawbacks :<br />
<br />
=> In large volume of data, Pagr slow and information or performance also slow down.<br />
<br />
<br />
d) Hidden : Data display in URL but with the help of hidden we can hide the data.<br />
<br />
=> We can also store string values but not objects.<br />
<br />
=> Scope of hidden value is to the next page.<br />
<br />
=> It is not display in URL.<br />
<br />
e) Control State : Control State is used to manage the state of Custom Controls we used Control State.<br />
<br />
<br />
2. Server Side State Management : Server Side State Management is used to used the Server Resources.<br />
<br />
=> No login on Server if they donot know the Username and password.<br />
=> It is Secure.<br />
=> It is slower as compared to Client side because Information comes from Server to Client then it takes time.<br />
<br />
Types of Server Side State Management :<br />
<br />
a) Application.<br />
b) Sessions.<br />
c) Profile.<br />
d) Cache.<br />
<br />
a) Application : It is a Global variable when run on server ( Ms Server, Framework, IIS).<br />
<br />
When firstly user opens the site the Application_Start() Event fired and then Run and if other user opens, then Http Application class creates their instances and if all users log-out including last one and then App_End() event fired and then all instances closed or removed.<br />
<br />
Application Variable : In the application variable we can store String value as well as objects.<br />
<br />
=>Scope : Throughout the application means we used in whole project.<br />
<br />
=> Hit Counter : Number of Viewer visit in our personal website with the help of an application variable.<br />
<br />
b) Session: Session generates Unique ID for all users provides like 50 people opens and generates 50 unique Ids. It creates two session copies i.e One is stored on Server Memory and other is stored on Client Memory.<br />
And it is stored in special type cookie i.e Session Cookie.<br />
<br />
=> Size of Session Id is 128 bit.<br />
<br />
In ASP.Net we can create cookieless application means if session cookie is disabled and then it pass from querystring.<br />
<br />
=> Session Variable : In session variable we can store String value as well as Objects.<br />
<br />
=> Scope: Throughout the session.<br />
<br />
=> Session Expired Forcefully by using Session.Abondoned() Method in c#.<br />
<br />
=> Expiry Time : Session Expiry Time is by default 20 minutes but we can Increase or Decrease Session Expiry time.<br />
<br />
Types of sessions:<br />
<br />
a) In-Process.<br />
b) Out-Process.<br />
<br />
a) In-Process: To store session on same process where the application is running.<br />
<br />
Drawback :<br />
<br />
=> If you reset the webserver i.e IIS then Session destroy. We have single Mode in IN-PROCESS i.e INPROC and it is by default.<br />
<br />
b) OUT-PROCESS : To store session on different process means application is on one server and session is on other server.<br />
<br />
Different process may be on different server. Different process may be Sql Server Database. If application close then Session not close for example, ATM Transaction Rectify.<br />
<br />
Two types of modes :<br />
<br />
a) State Server.<br />
b) Sql Server.<br />
<br />
a) State Server : To store session on different server. First you must start the ASP.NET STATE SERVICES to implement the STATE SERVER TECHNIQUE.<br />
<br />
Drawback: If you Reset the ASP.NET State Services then session will be destroy.<br />
<br />
b) Sql Server : We can store Session in Sql Server Database.<br />
<br />
Two types of Database :<br />
<br />
(A) Temporary Database.<br />
(B) ASP State.<br />
<br />
(A) Temporary Database: We can store Session Temporary and it is inbuilt Sql Server.<br />
<br />
Drawback : If we Reset the Sql Server Service then Data loss from temporary database.<br />
<br />
(B) ASP State: Session stores permanently in ASP State. If either application close or session close then there is no effect.<br />
<br />
** SESSION_END() EVENT NOT FIRE IN OUT-PROCESS means SESSION EXPIRE BUT EVENT DIDNOT FIRE.<br />
<br /></div>
<!-- Begin BidVertiser code -->
<script language="JavaScript1.1" src="http://bdv.bidvertiser.com/BidVertiser.dbm?pid=542729&bid=1357192" type="text/javascript"></script>
<noscript><a href="http://www.bidvertiser.com/bdv/BidVertiser/bdv_advertiser.dbm">pay per click</a></noscript>
<!-- End BidVertiser code --> </div>
</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-65776100113472325672013-07-06T10:50:00.000-07:002013-07-13T22:42:18.955-07:00Sql Data Reader<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://plus.google.com/111511552857979281177" or="" rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
Sql Data Reader :<br />
<br />
1. It is used to display data.<br />
2. Read only but not manipulate.<br />
3. It is a FORWARD only means go to only one direction i.e going to to the NEXT STEP means ONE by ONE go to 5th record and not directly jump from 1 t0 5th record and not vice-versa.<br />
4. It is pne and only fastest way to retrieve data from database is called Data Reader.</div>
</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-85727140948816563992013-07-06T09:07:00.002-07:002013-07-13T22:42:34.645-07:00Introduction to DotNet<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://plus.google.com/111511552857979281177" or="" rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
DotNet : .Net was introduced by Microsoft. Ms.net is a software component that runs on the windows operating system.<br />
It provides tools and libraries that enable developers to create windows software much faster and easier. The .net must be installed on a Users System to run .Net applications.<br />
<br />
.Net Framework : It is a collection of all tools and utilities required to execute the .net applications on a particular platform like Web and Mobile Development.<br />
<br />
The Microsoft.Net includes the standard compilers i.e c#, Vb.net,J# etc., runtime environment,Garbage Collector, Security Manager, Thread Manager, Assembly Loader, Just In Time Compilers and the standard framework or Base Class Libraries.<br />
<br />
The .Net is made up of two parts as shown below :<br />
<br />
1. Common Language Runtime.<br />
2. Base Class Libraries.<br />
<br />
1. Common Language Runtime: It is the execution engine for .Net applications and serves as the interface between .Net applications and the operating System.<br />
<br />
or<br />
<br />
It is an environment which manages the execution of coding.<br />
<br />
Forexample : Memory Management, Garbage Collection,To support multiple Language.<br />
<br />
The CLR provides many services such as :<br />
<br />
a. Loads and Executes Code.<br />
b. Convert Intermediate Language to Native Machine Language.<br />
c. Separate Processes and Memory.<br />
4. Handle Exceptions.<br />
<br />
Code that is compiled and targeted to the CLR is known as Managed Code.<br />
<br />
Managed Code provides metadata that is needed for the CLR to provide the services of multilanguage support, code security, object lifetime management and memory management.<br />
<br />
2. Base Class Library -: It is a standard library available to all languages using .Net framework.Dotnet includes the BCL to encapsulate a large number of common funstions such as file reading and writing, graphic rendering, database interaction and XML document manipulation which makes the programmer job easier.<br />
<br />
The BCL is sometimes incorrectly referred to as the Framework Class Library which is a superset including the Microsoft.* namespace.<br />
<br />
<br /></div>
</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-54572194339636396452013-07-05T22:17:00.001-07:002013-07-13T22:47:58.476-07:00Checked All checkbox during Grid View Load while Page Load using Javascript Code<a href="https://plus.google.com/111511552857979281177" or="" rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: orange;">Checked All checkbox during Grid View Load while Page Load using Javascript Code with the following code :</span><br />
<br />
<HeaderTemplate><br />
<input id="chkAll" onclick="javascript:SelectAllChkboxes(this);" runat="server" type="checkbox" /><br />
</HeaderTemplate><br />
<script type="text/javascript"><br />
<br />
function SelectAllChkboxes(spanChks) {<br />
<br />
var oItem = spanChks.children;<br />
var theBox = (spanChks.type == "checkbox") ? spanChks : spanChks.children.item[0];<br />
xState = theBox.checked;<br />
elme = theBox.form.elements;<br />
for (i = 0; i < elme.length; i++)<br />
if (elme[i].type == "checkbox" && elme[i].id != theBox.id) {<br />
if (elme[i].checked != xState)<br />
elme[i].click();<br />
}<br />
<br />
}<br />
</script></div>
<!-- Begin BidVertiser code -->
<script language="JavaScript1.1" src="http://bdv.bidvertiser.com/BidVertiser.dbm?pid=542729&bid=1357192" type="text/javascript"></script>
<noscript><a href="http://www.bidvertiser.com/bdv/BidVertiser/bdv_advertiser.dbm">pay per click</a></noscript>
<!-- End BidVertiser code --> </div>
</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-58046853179533150132013-07-05T22:14:00.001-07:002013-07-13T22:48:23.654-07:00Upload Image File according to Dimensions choice i.e. Height and Width :<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: orange;">Upload Image File according to Dimensions choice i.e. Height and Width : In which whenever you will upload a image then you can set it with any dimensions with the following C# code as shown below :</span><br />
<br />
protected void btnSave_Click(object sender, EventArgs e)<br />
{<br />
if (imageUpload.HasFile)<br />
{<br />
string extension = Path.GetExtension(imageUpload.PostedFile.FileName);<br />
Boolean flag = checkext(extension);<br />
if (flag == true)<br />
{<br />
String imagepath = uploadImagess(imageUpload.PostedFile, Convert.ToInt32(356), Convert.ToInt32(1600));<br />
Initialize();<br />
obj.InsertBannerLinks(imagepath, "True");<br />
lblmsz.Text = "Image Saved Successfully.";<br />
}<br />
else<br />
{<br />
<br />
lblmsz.Text = "Invalid file extension.";<br />
}<br />
}<br />
else<br />
{<br />
lblmsz.Text = "Please Upload Image";<br />
}<br />
}<br />
<br />
<br />
public Boolean checkext(String ext)<br />
{<br />
String[] exts = {".bmp", ".jpg", ".jpeg", ".gif", ".tif", ".png"};<br />
if (exts.Contains(ext.ToLower()))<br />
{<br />
return true;<br />
}<br />
else<br />
{<br />
return false;<br />
}<br />
}<br />
private String uploadImagess(HttpPostedFile fil, int height, int width)<br />
{<br />
string now = DateTime.Now.ToString("MM-dd-yyyy");<br />
string DateFormat = now.Replace('-', '_');<br />
string now2 = DateTime.Now.ToString("HH:mm");<br />
string DateFormat2 = now2.Replace(':', '_');<br />
String fulldate = DateFormat + DateFormat2;<br />
<br />
String Name = fulldate + fil.FileName;<br />
Byte[] fileBinary = GetPictureBitss(fil.InputStream, fil.ContentLength);<br />
MemoryStream stream = new MemoryStream(fileBinary);<br />
Bitmap b = new Bitmap(stream);<br />
Bitmap s = new Bitmap(stream);<br />
Size newsize = new Size();<br />
newsize.Height = height;<br />
newsize.Width = width;<br />
Bitmap newBitMap = new Bitmap(newsize.Width, newsize.Height);<br />
Graphics g = Graphics.FromImage(newBitMap);<br />
g.DrawImage(b, 0, 0, newsize.Width, newsize.Height);<br />
newBitMap.Save(Server.MapPath("~/BannerImage/") + Name, ImageFormat.Jpeg);<br />
newsize.Height = 56;<br />
newsize.Width = 56;<br />
newBitMap.Dispose();<br />
s.Dispose();<br />
b.Dispose();<br />
return Name;<br />
}<br />
<br />
private Byte[] GetPictureBitss(Stream fs, int size)<br />
{<br />
Byte[] img = new Byte[size];<br />
fs.Read(img, 0, size);<br />
return img;<br />
}</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-59499656012740130132013-07-05T22:07:00.001-07:002013-07-13T22:48:36.457-07:00Set focus of textbox while loading of Page using Javascript code as shown below :<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: orange;">Set focus of textbox while loading of Page using Javascript code as shown below : When someone open Login Page then first focus is set to Username textbox i.e txtUserName</span><br />
<br />
<script type="text/javascript"><br />
$(function() {<br />
setTimeout(function() {<br />
$("[id*=txUserName]").focus();<br />
}, 10);<br />
});<br />
</script></div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-2111501297718596962013-07-04T09:16:00.003-07:002013-07-13T22:53:07.879-07:00Port Number with description<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="color: orange;">Port Number with description -: </span></b><br />
<br />
<span style="color: blue;">Port Number <span class="Apple-tab-span" style="white-space: pre;"> </span>Description</span><br />
<br />
1 <span class="Apple-tab-span" style="white-space: pre;"> </span>TCP Port Service Multiplexer (TCPMUX)<br />
5 <span class="Apple-tab-span" style="white-space: pre;"> </span>Remote Job Entry (RJE)<br />
7 <span class="Apple-tab-span" style="white-space: pre;"> </span>ECHO<br />
18 <span class="Apple-tab-span" style="white-space: pre;"> </span>Message Send Protocol (MSP)<br />
20 <span class="Apple-tab-span" style="white-space: pre;"> </span>FTP -- Data<br />
21 <span class="Apple-tab-span" style="white-space: pre;"> </span>FTP -- Control<br />
22 <span class="Apple-tab-span" style="white-space: pre;"> </span>SSH Remote Login Protocol<br />
23 <span class="Apple-tab-span" style="white-space: pre;"> </span>Telnet<br />
25 <span class="Apple-tab-span" style="white-space: pre;"> </span>Simple Mail Transfer Protocol (SMTP)<br />
29 <span class="Apple-tab-span" style="white-space: pre;"> </span>MSG ICP<br />
37 <span class="Apple-tab-span" style="white-space: pre;"> </span>Time<br />
42 <span class="Apple-tab-span" style="white-space: pre;"> </span>Host Name Server (Nameserv)<br />
43 <span class="Apple-tab-span" style="white-space: pre;"> </span>WhoIs<br />
49 <span class="Apple-tab-span" style="white-space: pre;"> </span>Login Host Protocol (Login)<br />
53 <span class="Apple-tab-span" style="white-space: pre;"> </span>Domain Name System (DNS)<br />
69 <span class="Apple-tab-span" style="white-space: pre;"> </span>Trivial File Transfer Protocol (TFTP)<br />
70 <span class="Apple-tab-span" style="white-space: pre;"> </span>Gopher Services<br />
79 <span class="Apple-tab-span" style="white-space: pre;"> </span>Finger<br />
80 <span class="Apple-tab-span" style="white-space: pre;"> </span>HTTP<br />
103 <span class="Apple-tab-span" style="white-space: pre;"> </span>X.400 Standard<br />
108 <span class="Apple-tab-span" style="white-space: pre;"> </span>SNA Gateway Access Server<br />
109 <span class="Apple-tab-span" style="white-space: pre;"> </span>POP2<br />
110 <span class="Apple-tab-span" style="white-space: pre;"> </span>POP3<br />
115 <span class="Apple-tab-span" style="white-space: pre;"> </span>Simple File Transfer Protocol (SFTP)<br />
118 <span class="Apple-tab-span" style="white-space: pre;"> </span>SQL Services<br />
119 <span class="Apple-tab-span" style="white-space: pre;"> </span>Newsgroup (NNTP)<br />
137 <span class="Apple-tab-span" style="white-space: pre;"> </span>NetBIOS Name Service<br />
139 <span class="Apple-tab-span" style="white-space: pre;"> </span>NetBIOS Datagram Service<br />
143 <span class="Apple-tab-span" style="white-space: pre;"> </span>Interim Mail Access Protocol (IMAP)<br />
150 <span class="Apple-tab-span" style="white-space: pre;"> </span>NetBIOS Session Service<br />
156 <span class="Apple-tab-span" style="white-space: pre;"> </span>SQL Server<br />
161 <span class="Apple-tab-span" style="white-space: pre;"> </span>SNMP<br />
179 <span class="Apple-tab-span" style="white-space: pre;"> </span>Border Gateway Protocol (BGP)<br />
190 <span class="Apple-tab-span" style="white-space: pre;"> </span>Gateway Access Control Protocol (GACP)<br />
194 <span class="Apple-tab-span" style="white-space: pre;"> </span>Internet Relay Chat (IRC)<br />
197 <span class="Apple-tab-span" style="white-space: pre;"> </span>Directory Location Service (DLS)<br />
389 <span class="Apple-tab-span" style="white-space: pre;"> </span>Lightweight Directory Access Protocol (LDAP)<br />
396 <span class="Apple-tab-span" style="white-space: pre;"> </span>Novell Netware over IP<br />
443 <span class="Apple-tab-span" style="white-space: pre;"> </span>HTTPS<br />
444 <span class="Apple-tab-span" style="white-space: pre;"> </span>Simple Network Paging Protocol (SNPP)<br />
445 <span class="Apple-tab-span" style="white-space: pre;"> </span>Microsoft-DS<br />
458 <span class="Apple-tab-span" style="white-space: pre;"> </span>Apple QuickTime<br />
546 <span class="Apple-tab-span" style="white-space: pre;"> </span>DHCP Client<br />
547 <span class="Apple-tab-span" style="white-space: pre;"> </span>DHCP Server<br />
563 <span class="Apple-tab-span" style="white-space: pre;"> </span>SNEWS<br />
569 <span class="Apple-tab-span" style="white-space: pre;"> </span>MSN<br />
1080 Socks</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-9153938598456049742013-07-04T09:14:00.005-07:002013-07-13T22:52:48.108-07:00Find IP address of web site visitor<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="color: orange;">To find IP address of web site visitor -:</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
string VisitorIPAddress = Request.UserHostAddress.ToString();</div>
<div style="text-align: left;">
string VisitorIPAddress = Request.ServerVariables["REMOTE_ADDR"];</div>
</div>
</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-37734711246755284492013-07-04T09:12:00.002-07:002013-07-13T22:51:21.813-07:00Forgot Password Recovery via email<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: orange;">Forgot Password Recovery via email -:</span><br />
<br />
MailMessage mes = new MailMessage();<br />
<br />
mes.To.Add(username.text+"@gmail.com");<br />
mes.From = new MailAddress("admin email id");<br />
<br />
mes.Body = "Your Password is: " + Label2.Text;<br />
<br />
SmtpClient client = new SmtpClient();<br />
client.Host = "smtp.gmail.com";<br />
client.Port = 587;<br />
<br />
client.DeliveryMethod = SmtpDeliveryMethod.Network;<br />
NetworkCredential credentials = new NetworkCredential("admin email id","admin email password");<br />
client.Credentials = credentials;<br />
client.EnableSsl = true;<br />
<br />
client.Send(mes);<br />
Label1.Text = "EMail Sent Successful:";<br />
<br /></div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-88447494884494347422013-07-04T09:05:00.001-07:002013-07-13T23:01:51.340-07:00Encrypt and Decrypt Password during Login Authentication in Asp.net<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="color: orange;">Encryption Method For Password :-</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
static String KeyEncryption = "PU$y*P*@$";</div>
<div style="text-align: left;">
public static string Encrypt(string stringToEncrypt)</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
String sEncryptionKey = KeyEncryption;</div>
<div style="text-align: left;">
byte[] key = { };</div>
<div style="text-align: left;">
byte[] IV = { 0x12, 0x34, 0x56, 0x78, 0x90, 0xab, 0xcd, 0xef };</div>
<div style="text-align: left;">
byte[] inputByteArray; //Convert.ToByte(stringToEncrypt.Length)</div>
<div style="text-align: left;">
try</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
key = System.Text.Encoding.UTF8.GetBytes(sEncryptionKey.Substring(0, 8));</div>
<div style="text-align: left;">
DESCryptoServiceProvider des = new DESCryptoServiceProvider();</div>
<div style="text-align: left;">
inputByteArray = System.Text.Encoding.UTF8.GetBytes(stringToEncrypt);</div>
<div style="text-align: left;">
MemoryStream ms = new MemoryStream();</div>
<div style="text-align: left;">
CryptoStream cs = new CryptoStream(ms, des.CreateEncryptor(key, IV), CryptoStreamMode.Write);</div>
<div style="text-align: left;">
cs.Write(inputByteArray, 0, inputByteArray.Length);</div>
<div style="text-align: left;">
cs.FlushFinalBlock();</div>
<div style="text-align: left;">
return Convert.ToBase64String(ms.ToArray());</div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
catch (System.Exception ex)</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
throw ex;</div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="color: orange;">Decryption Method For Password :-</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
public static string Decrypt(string stringToEncrypt)</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
String sEncryptionKey = KeyEncryption;</div>
<div style="text-align: left;">
byte[] key = { };</div>
<div style="text-align: left;">
byte[] IV = { 0x12, 0x34, 0x56, 0x78, 0x90, 0xab, 0xcd, 0xef };</div>
<div style="text-align: left;">
byte[] inputByteArray;//= Convert.ToByte(Convert.ToDouble((stringToEncrypt.Length));</div>
<div style="text-align: left;">
try</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
key = System.Text.Encoding.UTF8.GetBytes(sEncryptionKey.Substring(0, 8));</div>
<div style="text-align: left;">
DESCryptoServiceProvider des = new DESCryptoServiceProvider();</div>
<div style="text-align: left;">
inputByteArray = Convert.FromBase64String(stringToEncrypt);</div>
<div style="text-align: left;">
MemoryStream ms = new MemoryStream();</div>
<div style="text-align: left;">
CryptoStream cs = new CryptoStream(ms, des.CreateDecryptor(key, IV), CryptoStreamMode.Write);</div>
<div style="text-align: left;">
cs.Write(inputByteArray, 0, inputByteArray.Length);</div>
<div style="text-align: left;">
cs.FlushFinalBlock();</div>
<div style="text-align: left;">
System.Text.Encoding encoding = System.Text.Encoding.UTF8;</div>
<div style="text-align: left;">
String retval = encoding.GetString(ms.ToArray());</div>
<div style="text-align: left;">
return retval;</div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
catch (System.Exception ex)</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
throw ex;</div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
}</div>
</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-88684648717013270732013-07-04T08:45:00.005-07:002013-07-13T22:54:02.166-07:00Login form with c# in asp.net<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="color: orange;">Create two textboxes with following name and Login Button i.e</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
User Name : txtusername</div>
<div style="text-align: left;">
Password :txtpassword</div>
<div style="text-align: left;">
Login Button :btnlogin</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="color: orange;">Paste below code in your ASP page</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<table style="width:100%" ></div>
<div style="text-align: left;">
<tr></div>
<div style="text-align: left;">
<td align="center" colspan="3"></div>
<div style="text-align: left;">
<asp:Label ID="lblMsg" runat="server" FontBold="True" ForeColor="#FF3300"></asp:Label></div>
<div style="text-align: left;">
</td></div>
<div style="text-align: left;">
</tr></div>
<div style="text-align: left;">
<tr></div>
<div style="text-align: left;">
<td align="left" colspan="3" style="fontweight: 700"></div>
<div style="text-align: left;">
<h3> </div>
<div style="text-align: left;">
<asp:Label ID="Label1" runat="server" ForeColor="White" </div>
<div style="text-align: left;">
Text="Admin Login Panel"></asp:Label></div>
<div style="text-align: left;">
</h3><hr /></td></div>
<div style="text-align: left;">
</tr></div>
<div style="text-align: left;">
<tr></div>
<div style="text-align: left;">
<td class="style1"></div>
<div style="text-align: left;">
&nbsp;<asp:Label ID="Label2" runat="server" FontBold="True" ForeColor="White" </div>
<div style="text-align: left;">
Text="User Name :"></asp:Label></div>
<div style="text-align: left;">
</td></div>
<div style="text-align: left;">
<td class="style1"></div>
<div style="text-align: left;">
<asp:TextBox ID="txtusername" runat="server"></asp:TextBox></div>
<div style="text-align: left;">
<asp:RequiredFieldValidator ID="requsername" runat="server" </div>
<div style="text-align: left;">
ControlToValidate="txtusername" ErrorMessage="*"></asp:RequiredFieldValidator></div>
<div style="text-align: left;">
</td></div>
<div style="text-align: left;">
<td class="style1"></div>
<div style="text-align: left;">
</td></div>
<div style="text-align: left;">
</tr></div>
<div style="text-align: left;">
<tr></div>
<div style="text-align: left;">
<td></div>
<div style="text-align: left;">
&nbsp;<asp:Label ID="Label3" runat="server" FontBold="True" ForeColor="White" </div>
<div style="text-align: left;">
Text="Password :"></asp:Label></div>
<div style="text-align: left;">
</td></div>
<div style="text-align: left;">
<td></div>
<div style="text-align: left;">
<asp:TextBox ID="txtpassword" runat="server" TextMode="Password"></asp:TextBox></div>
<div style="text-align: left;">
<asp:RequiredFieldValidator ID="reqpassowrd" runat="server" </div>
<div style="text-align: left;">
ControlToValidate="txtpassword" ErrorMessage="*"></asp:RequiredFieldValidator></div>
<div style="text-align: left;">
</td></div>
<div style="text-align: left;">
<td></div>
<div style="text-align: left;">
&nbsp;</td></div>
<div style="text-align: left;">
</tr></div>
<div style="text-align: left;">
<tr></div>
<div style="text-align: left;">
<td></div>
<div style="text-align: left;">
&nbsp;</td></div>
<div style="text-align: left;">
<td></div>
<div style="text-align: left;">
<asp:Button ID="btnlogin" runat="server" Text="Admin Login" Width="93px" </div>
<div style="text-align: left;">
onclick="btnlogin_Click" /></div>
<div style="text-align: left;">
</td></div>
<div style="text-align: left;">
<td></div>
<div style="text-align: left;">
&nbsp;</td></div>
<div style="text-align: left;">
</tr></div>
<div style="text-align: left;">
</table></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="color: orange;">On Button Click, Paste the following c# code in aspx.cs code file</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
int AdminStatus = obj.AdminAuthenticate(txtusername.Text, txtpassword.Text);</div>
<div style="text-align: left;">
if (AdminStatus != 1)</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
lblMsg.Text = "Invalid Login";</div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
else</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Response.Redirect("Admin.aspx");</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="color: orange;">Create a class file with the following below code:</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
public int AdminAuthenticate(string username, string passowrd)</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);</div>
<div style="text-align: left;">
SqlCommand cmd = new SqlCommand("sp_AdminAuthenticate", con);</div>
<div style="text-align: left;">
cmd.CommandType = CommandType.StoredProcedure;</div>
<div style="text-align: left;">
cmd.Parameters.AddWithValue("@username", username);</div>
<div style="text-align: left;">
cmd.Parameters.AddWithValue("@password", passowrd);</div>
<div style="text-align: left;">
if (con.State == ConnectionState.Closed)</div>
<div style="text-align: left;">
{</div>
<div style="text-align: left;">
con.Open();</div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
int retValue = Convert.ToInt32(cmd.ExecuteScalar());</div>
<div style="text-align: left;">
return retValue;</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
}</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="color: orange;">Also create a stored procedure</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
CreatePROCEDURE [dbo].[sp_AdminAuthenticate] </div>
<div style="text-align: left;">
(</div>
<div style="text-align: left;">
@username nvarchar(20),</div>
<div style="text-align: left;">
@password nvarchar(20)</div>
<div style="text-align: left;">
)</div>
<div style="text-align: left;">
AS</div>
<div style="text-align: left;">
BEGIN</div>
<div style="text-align: left;">
IF EXISTS (select * from tbllogin where username=@username AND password = @password AND status=1 )</div>
<div style="text-align: left;">
BEGIN</div>
<div style="text-align: left;">
select 1 as retValue</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
END</div>
<div style="text-align: left;">
ELSE</div>
<div style="text-align: left;">
BEGIN</div>
<div style="text-align: left;">
select 1 as retValue</div>
<div style="text-align: left;">
END</div>
<div style="text-align: left;">
END</div>
<div style="text-align: left;">
<br /></div>
</div>
</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-69919011944443389492013-07-04T05:54:00.003-07:002013-07-13T22:54:36.602-07:00Show Tweets of Twitter in Twitter Widget in your Website<a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
Firstly create a Twitter Account and then after successful login , go to the following Url i.e https://twitter.com/settings/widgets<br />
<br />
And then create a New Widget by click on Create New button as shown below :<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHl-m-IGGx2lkidFEysGJ28johhWnLYmZFpX3As0CciOiQZYSBx748972bpnAf1ApGhICy7oiVnNOnU1G5L9VEKwp8JkZS_8s_mStSzFanrxVExvPh7PvRv4sbrG3g03S_HAXn353v18Cx/s531/createnew.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="48" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHl-m-IGGx2lkidFEysGJ28johhWnLYmZFpX3As0CciOiQZYSBx748972bpnAf1ApGhICy7oiVnNOnU1G5L9VEKwp8JkZS_8s_mStSzFanrxVExvPh7PvRv4sbrG3g03S_HAXn353v18Cx/s400/createnew.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
After click on Create new the following window will appear :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj57fgqC0xCpCLYkcZ4icHsSoNGqNJoF79_joaHFtFodrwgoY5huUVZPZcY0VmdesEYvr4Au9qcsLf_ApGdH4Y9sil1dsGSO5Mx0ogBvBUECBAFtaU-daaUk1dwBI7UYk96qA8bbafUQlue/s911/WidgetSuccessfull.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj57fgqC0xCpCLYkcZ4icHsSoNGqNJoF79_joaHFtFodrwgoY5huUVZPZcY0VmdesEYvr4Au9qcsLf_ApGdH4Y9sil1dsGSO5Mx0ogBvBUECBAFtaU-daaUk1dwBI7UYk96qA8bbafUQlue/s1600/WidgetSuccessfull.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Then click on Create widget and then Copy the code as shown in below box then paste it your website in aspx page as shown below :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglTXXCI-ZEYifQFzCJLPJlBHed5_fleruSYs7RO8NyvQvuHcFk6qx2bq92tzo07fU7E3YKc3seToHPC1ULSrMH9zutMbNU5ynafmDjZbvUGJXq85sntYxRaw-KXs-7QQIZamoc9a9M_l8Q/s764/CopyCode.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglTXXCI-ZEYifQFzCJLPJlBHed5_fleruSYs7RO8NyvQvuHcFk6qx2bq92tzo07fU7E3YKc3seToHPC1ULSrMH9zutMbNU5ynafmDjZbvUGJXq85sntYxRaw-KXs-7QQIZamoc9a9M_l8Q/s1600/CopyCode.png" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br />
<br />
<br /></div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-58489670472408076762013-07-04T05:05:00.002-07:002013-07-13T22:54:53.169-07:00Delete All Stored Procedure's and Tables from Database at a time instead of one by one in Sql Server <a href="https://plus.google.com/111511552857979281177" rel="author" or rel="publisher"></a>
<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="color: orange;">Query to delete all Stored Procedure at a time from database in Sql Server Query Execution Window :</span></b><br />
<div>
<br /></div>
<div>
<div>
declare @procName sysname</div>
<div>
declare someCursor cursor for</div>
<div>
select name from sysobjects where type = 'P' and objectproperty(id, 'IsMSShipped') = 0</div>
<div>
open someCursor</div>
<div>
fetch next from someCursor into @procName</div>
<div>
while @@FETCH_STATUS = 0</div>
<div>
begin</div>
<div>
exec('drop proc ' + @procName)</div>
<div>
fetch next from someCursor into @procName</div>
<div>
end</div>
<div>
close someCursor</div>
<div>
deallocate someCursor</div>
<div>
go</div>
</div>
<div>
<br /></div>
<div>
<b><span style="color: orange;">Query to delete all Tables at a time from database in Sql Server Query Execution Window :</span></b></div>
<div>
<b><span style="color: blue;"><br /></span></b></div>
<div>
<div>
DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR</div>
<div>
SET @Cursor = CURSOR FAST_FORWARD FOR</div>
<div>
SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'</div>
<div>
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1</div>
<div>
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME</div>
<div>
OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql</div>
<div>
WHILE (@@FETCH_STATUS = 0)</div>
<div>
BEGIN</div>
<div>
Exec SP_EXECUTESQL @Sql</div>
<div>
FETCH NEXT FROM @Cursor INTO @Sql</div>
<div>
END</div>
<div>
CLOSE @Cursor DEALLOCATE @Cursor</div>
<div>
GO</div>
<div>
EXEC sp_MSForEachTable 'DROP TABLE ?'</div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
</div>Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0tag:blogger.com,1999:blog-7442181543449330386.post-10137870515900869402013-07-03T22:44:00.000-07:002014-05-24T08:39:43.836-07:00Upload Video on Youtube using Asp.Net (c#) and play the url within your website.<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://plus.google.com/111511552857979281177" or="" rel="publisher"></a><br />
<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: blue;"><i><b></b></i></span><br />
<br />
First you need to download the following dlls from Internet via Google Search Engine :<br />
<br />
<span style="color: orange;">1. Google.GData.Client.DLL<br />2. Google.GData.Extensions.dll<br />3. Google.GData.YouTube.dll<br />4. Newtonsoft.Json.dll</span><br />
<br />
<span style="color: blue;"><i><b>Following c# code is usable to upload video on You Tube and play it in on your website :</b></i></span><br />
<br />
<span style="color: red;"><b>C# Code :</b></span><br />
<br />
using System;<br />
using System.Configuration;<br />
using System.Data;<br />
using System.Linq;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.HtmlControls;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Xml.Linq;<br />
using Google.YouTube;<br />
using Google.GData.YouTube;<br />
using Google.GData.Client;<br />
using Google.GData.Extensions;<br />
using Google.GData.Extensions.MediaRss;<br />
using System.IO;<br />
using Google.GData.Extensions.Location;<br />
using System.Threading;<br />
using System.Collections.Generic;<br />
<br />
public partial class _Default : System.Web.UI.Page<br />
{<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
<br />
}<br />
<div style="text-align: left;">
<span style="color: orange;"> string developerKey = "AI39si7ETkiMUFrMQtfkuYcOoaxs1H8QMso8R0YTzApg-alwA9XebuWKUCm4e_tbUHWvU9Of5Iwr6gXPQOwFwTa5D7gn3oecRg";</span></div>
<div style="text-align: left;">
<span style="color: blue;"> <span style="color: orange;">string username = "abc@gmail.com";</span> <span style="color: magenta;">// Gmail username</span></span></div>
<div style="text-align: left;">
<span style="color: blue;"> <span style="color: orange;">string password = "123456";</span> <span style="color: magenta;">// Gmail Password</span></span></div>
<div style="text-align: left;">
<span style="color: blue;"> <span style="color: black;"> <span style="color: orange;">public string youtubeurl;</span></span></span></div>
<div style="text-align: left;">
</div>
protected void Button3_Click(object sender, EventArgs e)<br />
{<br />
<span style="color: magenta;"> <span style="color: yellow;"> <span style="color: orange;">string FileName = FileUpload1.FileName;<br /> string fillPath = FileUpload1.PostedFile.FileName;<br /> var newp = Server.MapPath("download/" + FileName);<br /> FileUpload1.SaveAs(Server.MapPath("download/" + FileName));<br /> YouTubeRequestSettings settings = new YouTubeRequestSettings("applicationName", developerKey, username, password);</span></span></span><br />
<span style="color: magenta;"><span style="color: yellow;"><span style="color: orange;"> settings.Timeout = int.MaxValue;<br /> YouTubeRequest request = new YouTubeRequest(settings);<br /> Video newVideo = new Video();<br /> newVideo.Title = "Test";<br /> newVideo.Tags.Add(new MediaCategory("Animals", YouTubeNameTable.CategorySchema));<br /> newVideo.Description = "Testing Testing Testing";<br /> newVideo.YouTubeEntry.Private = false;<br /> newVideo.YouTubeEntry.MediaSource = new MediaFileSource(newp, "video/mpeg");<br /> Video A = request.Upload(newVideo);<br /> youtubeurl = "http://www.youtube.com/v/" + A.VideoId + "&hl=en_US&fs=1&rel=0";<br /> System.IO.File.Delete(Request.PhysicalApplicationPath + "download/" + FileName);</span></span></span><br />
<br />
}<br />
}<br />
<br />
<span style="color: blue;">Output Shown as below :</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEgvOG7v43wlIc-28HbBJFSEPykygOmrq8_hVRSSUFeCQBU_S0qhsbSL_q7MI4KUV7lL772DKmzghsDdA03YVu2AceR_THsn2DzlYpgkuL1iXx4gUsWdXROUfC02DhDRP3hduxwGMsACx4/s509/Video+Upload.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEgvOG7v43wlIc-28HbBJFSEPykygOmrq8_hVRSSUFeCQBU_S0qhsbSL_q7MI4KUV7lL772DKmzghsDdA03YVu2AceR_THsn2DzlYpgkuL1iXx4gUsWdXROUfC02DhDRP3hduxwGMsACx4/s320/Video+Upload.jpg" height="295" width="320" /></a></div>
<br />
<br />
<br /></div>
</div>
Rohin Sharmahttp://www.blogger.com/profile/11174626377247886440noreply@blogger.com0