tag:blogger.com,1999:blog-8336464829980188702024-02-07T20:02:49.457-08:00Ajay INVINCIBLEAjay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-833646482998018870.post-69140779935114773812012-06-20T06:46:00.000-07:002012-06-20T06:46:27.883-07:00How to store and retrive json from localstorage.<div dir="ltr" style="text-align: left;" trbidi="on">localStorage only supports strings. Use JSON.stringify() and JSON.parse().<br />
<br />
--save json in localstorage<br />
<pre class="brush: js">var hash={};
localStorage['hash']=JSON.stringify(hash);</pre><br />
--retrive json from localstorage<br />
<pre class="brush: js">var jsonObj=JSON.parse(localStorage['hash']);</div></pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-31538890459578619112011-12-23T01:26:00.000-08:002011-12-23T01:34:39.740-08:00How to Enable Database and table For SQLCacheDependency<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on">Start Visual Studio Command Prompt and enter these commands for enable sqlcachedependency in your application</div>for enabling a database<br />
for enabling a database<br />
<pre class="brush: sql">aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -ed</pre><br />
for diUserNamebling a database<br />
<pre class="brush: sql">aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -dd</pre><br />
for enabling a table<br />
<pre class="brush: sql">aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -t Table -et</pre><br />
for diUserNamebling a table<br />
<pre class="brush: sql">aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -t Table-dt</pre><br />
for listing tables<br />
<pre class="brush: sql">aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -lt</pre></div>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-33065358570473270772011-07-08T05:48:00.000-07:002011-07-08T05:48:01.702-07:00How to generate proxy class from a web service in asp .net?open visual studio command prompt and go to root directory and write this command and press enter. MyProxyClass.cs will be created in your root directory.<br />
WseWsdl3 http://hostServer/WebServiceRoot/WebServiceName.asmx?WSDL /out:MyProxyClass.csAjay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-87514849145249440262011-07-08T05:44:00.000-07:002011-07-08T05:55:52.186-07:00How to show sum at footer in Gridview.Generally to show sum at footer in GridView we use. GridView's RowDataBound Event. We Create a variable(float/Int) outside of event.<br />
and in RowDataBound Event we check row type. if row type is DataRow than we find the Cell's Text convert it into int and Add it to variable created outside of RowDataBound Event. and When RowType change from DataRow to Footer Row than we put that variable's value in footer.<br />
But i want to tell you short and sweet method for it.<br />
as all of you know generally we use DataTable as datasource in gridview.<br />
than we should use it<br />
<pre class="brush: csharp">string str = dt.Compute("sum(sGrandTotal)", "").ToString();
</pre>now just find the Footer of gridview and put str variable in the cell. like this<br />
<pre class="brush: csharp">grdReport.FooterRow.Cells[7].Text = "Total" + float.Parse(str).ToString( "N2");
</pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-25136933542757866232011-07-08T05:30:00.000-07:002011-07-08T05:30:57.626-07:00How to delete duplicate records from a table ?<pre class="brush: sql">delete t1
from tblTable t1, tblTable t2
where t1.sName = t2.sName
and t1.uniqueField > t2.uniqueField
</pre>where t1.uniqueFiled should be intAjay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-62636542613206084372011-06-12T22:47:00.000-07:002011-06-12T22:49:35.599-07:00How to Enable Service Broker on SQL Server 2005 ?<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on">You can check to see whether the Service Broker is enabled on your server by executing the following SQL syntax:</div><pre class="brush: sql">SELECT name, is_broker_enabled FROM sys.databases where name='YourDBName'</pre>To enable the Service Broker on your database, you must execute the ALTER DATABASE command. The following SQL command will enable the Service Broker service on the your database:<br />
<pre class="brush: sql">ALTER DATABASE YourDBName SET ENABLE_BROKER
</pre></div>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-32972670677084457182011-06-07T05:55:00.000-07:002011-06-07T05:55:50.466-07:00Add Hindi or Phonetic Typing to your web pagehi friends generally we use google translate to type hindi or other language <br />
in textboxes or other text editor tool.<br />
by using this code we can directly type in engish which automatically converted to hindi or any language which we set in java script code.<br />
<pre class="brush: js"> <script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("elements", "1", { packages: "transliteration" });
function onLoad() {
var options = { sourceLanguage: google.elements.transliteration.LanguageCode.ENGLISH,
destinationLanguage: google.elements.transliteration.LanguageCode.HINDI,
transliterationEnabled: true
};
var control = new google.elements.transliteration.TransliterationControl(options);
var input = document.getElementById("input1");
control.makeTransliteratable([input]);
}
google.setOnLoadCallback(onLoad);
</script>
</pre><pre class="brush: html"><input type="text" id="input1" />
</pre>change destinationLanguage to google.elements.transliteration.LanguageCode.HINDI,<br />
google.elements.transliteration.LanguageCode.NEPALI,<br />
google.elements.transliteration.LanguageCode.BENGALI,<br />
google.elements.transliteration.LanguageCode.TELUGU,<br />
google.elements.transliteration.LanguageCode.TAMIL<br />
or other language which google support.Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-24238855691688044712011-04-26T02:39:00.000-07:002011-06-07T03:20:50.332-07:00Sql Function to Split a string and return a table<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Courier New",Courier,monospace;"><pre class="brush: sql">create ALTER FUNCTION [dbo].[Split]
(
@RowData nvarchar(2000),
@SplitOn nvarchar(5)
)
RETURNS @RtnValue table
(
Id int identity(1,1),
Data nvarchar(100)
)
AS
BEGIN
Declare @Cnt int
Set @Cnt = 1
While (Charindex(@SplitOn,@RowData)>0)
Begin
Insert Into @RtnValue (data)
Select
Data = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1)))
Set @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
Set @Cnt = @Cnt + 1
End
Insert Into @RtnValue (data)
Select Data = ltrim(rtrim(@RowData))
Return
END
</pre></div><div style="font-family: "Courier New",Courier,monospace;"><br />
</div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-family: Arial,Helvetica,sans-serif;">use it like this:</span></div><div style="font-family: "Courier New",Courier,monospace;"><span style="font-family: Arial,Helvetica,sans-serif;">select * from dbo.Split('a,b,c,d,e,f,g',',') </span></div></div>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-60348324260967084152010-11-02T22:45:00.000-07:002010-11-02T22:55:16.234-07:00how to select records of particular date from a sql table if time is also there?query for select all records.<br />
<pre class="brush: sql">select * from tbltable</pre><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP05ZuHWDrJE5ihNdLg0MtlDJPhZqdk00D5GstOxVW3tiz3wDf6hd9evxDoIvu5LM9kDMKkn6v2idgrZ1XfUTde4QzxRZBon3N4jF2d5LvxlCAOfKd2tgkgYPfwXS2ncnFCMcUkiz_Txhz/s1600/table.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP05ZuHWDrJE5ihNdLg0MtlDJPhZqdk00D5GstOxVW3tiz3wDf6hd9evxDoIvu5LM9kDMKkn6v2idgrZ1XfUTde4QzxRZBon3N4jF2d5LvxlCAOfKd2tgkgYPfwXS2ncnFCMcUkiz_Txhz/s1600/table.JPG" /></a></div><br />
<pre class="brush: sql"> </pre><br />
<br />
query for select record for particular date<br />
<pre class="brush: sql">select * from tblTable where dDate='10/29/2010'</pre><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRFLN5tBuR0IGzGiApzVYBrkhc1Uvl1rOz3Z6LSKYSzkKD5bvaovbYYw2lEz3cJExyrS-j2W_R81LnKdODAg1qNatOq-kopzkcVUUlL_52hmdr4sIaCgccBiT0tLz30oEZurxX1EuTVjj7/s1600/table1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRFLN5tBuR0IGzGiApzVYBrkhc1Uvl1rOz3Z6LSKYSzkKD5bvaovbYYw2lEz3cJExyrS-j2W_R81LnKdODAg1qNatOq-kopzkcVUUlL_52hmdr4sIaCgccBiT0tLz30oEZurxX1EuTVjj7/s1600/table1.JPG" /></a></div>but because of time there is no record retrieved in result<br />
now if you want to record from a particular date not including time use this query<br />
<pre class="brush: sql">select * from tbltable
where DateAdd(day, datediff(day,0, dDate), 0)=DateAdd(day, datediff(day,0, '10-29-2010'), 0)</pre><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt6-Cg_BZN-KfcW4GSeIxD-eVwKeQM3doYETNgf-MWu5qRayFzWXPnGyQLuRKUjh4hWyj3QnC7hs75vPgjt2nOCdRBnHis_zlWNZTNWHy6tnGq737MEL1jLwt6tQB_PWCN93ticGeGQ2W9/s1600/table2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt6-Cg_BZN-KfcW4GSeIxD-eVwKeQM3doYETNgf-MWu5qRayFzWXPnGyQLuRKUjh4hWyj3QnC7hs75vPgjt2nOCdRBnHis_zlWNZTNWHy6tnGq737MEL1jLwt6tQB_PWCN93ticGeGQ2W9/s1600/table2.JPG" /></a></div>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-77464251351557181362010-10-12T22:29:00.000-07:002010-10-12T22:29:15.283-07:00case statement in sql query.<pre class="brush: sql">SELECT col1,col2,col3,
case col4 when 0
then 'Approve'
else 'Un-Approve'
end as Approved as 'Colum4',
col5
FROM tblTest
</pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-59328124418232628342010-09-07T05:03:00.000-07:002010-09-07T05:03:29.054-07:00How to Set Dynamically order by Clause in sql Query ?<pre class="brush: sql">DECLARE @iSort int
SET @iSort = 3
SELECT * FROM tableName
order by
case when @iSort = 1 then Column1 end asc,
case when @iSort = 2 then Column2 end desc,
case when @iSort = 3 then Column3 end asc,
case when @iSort = 4 then Column4 end desc
</pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-81627731874138556472010-08-28T04:51:00.000-07:002010-08-28T04:57:13.487-07:00How to Show and Hide Div Using JavaScript?Java Script Code<br />
<pre class="brush: csharp"><script language="javascript" type="text/javascript">
function ShowPanel(flag) {
if(flag==1) {
document.getElementById("pnl1").style.display='block';
document.getElementById("pnl2").style.display='none';
}
else {
document.getElementById("pnl1").style.display='none';
document.getElementById("pnl2").style.display='block';
}
return false;
}
</script>
</pre>html Code<br />
<pre class="brush: html"><a href="#" onclick="ShowPanel(1)">Step First</a> <a href="#" onclick="ShowPanel(2)">
Step Second</a>
<div id="pnl1" style="display: none;">This Is Step First Panel
</div><div id="pnl2">This is Step Two Panel
</div></pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-12665448080217928722010-08-28T01:48:00.000-07:002010-08-28T04:58:00.086-07:00How to Convert Number in Indian Currency format(like lakh and crore format)?A method to convert any number in indian curreny format in words.<br />
<pre class="brush: csharp">public string NumberToText(int number)
{
if (number == 0) return "Zero";
if (number == -2147483648) return "Minus Two Hundred and Fourteen Crore Seventy Four Lakh Eighty Three Thousand Six Hundred and Forty Eight";
int[] num = new int[4];
int first = 0;
int u, h, t;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (number < 0)
{
sb.Append("Minus ");
number = -number;
}
string[] words0 = {"" ,"One ", "Two ", "Three ", "Four ",
"Five " ,"Six ", "Seven ", "Eight ", "Nine "};
string[] words1 = {"Ten ", "Eleven ", "Twelve ", "Thirteen ", "Fourteen ",
"Fifteen ","Sixteen ","Seventeen ","Eighteen ", "Nineteen "};
string[] words2 = {"Twenty ", "Thirty ", "Forty ", "Fifty ", "Sixty ",
"Seventy ","Eighty ", "Ninety "};
string[] words3 = { "Thousand ", "Lakh ", "Crore " };
num[0] = number % 1000; // units
num[1] = number / 1000;
num[2] = number / 100000;
num[1] = num[1] - 100 * num[2]; // thousands
num[3] = number / 10000000; // crores
num[2] = num[2] - 100 * num[3]; // lakhs
for (int i = 3; i > 0; i--)
{
if (num[i] != 0)
{
first = i;
break;
}
}
for (int i = first; i >= 0; i--)
{
if (num[i] == 0) continue;
u = num[i] % 10; // ones
t = num[i] / 10;
h = num[i] / 100; // hundreds
t = t - 10 * h; // tens
if (h > 0) sb.Append(words0[h] + "Hundred ");
if (u > 0 || t > 0)
{
if (h > 0 || i == 0) sb.Append("and ");
if (t == 0)
sb.Append(words0[u]);
else if (t == 1)
sb.Append(words1[u]);
else
sb.Append(words2[t - 2] + words0[u]);
}
if (i != 0) sb.Append(words3[i - 1]);
}
return sb.ToString().TrimEnd();
}
</pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-26641822537154501962010-08-23T05:10:00.000-07:002010-08-28T04:58:38.588-07:00Auto Generated Serial Number in a SQL Query<pre class="brush: sql">select ROW_NUMBER() over (order by ID) as RowNumber from tableName
</pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com2tag:blogger.com,1999:blog-833646482998018870.post-36973077722095717782010-08-23T05:09:00.000-07:002010-08-28T04:59:25.986-07:00How to Convert Date in dd-MM-yyyy format in Sql ?<pre class="brush: sql">select convert(varchar(50),getdate(),105)
</pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-85060324461265304882010-08-23T05:06:00.000-07:002010-08-28T05:00:00.669-07:00What is partial Class in ASP .NET C-Sharp ?Instead of defining an entire class, you can split the definition into multiple classes by using the partial keyword. When the application is complied, the C# complier will group all the partial classes together and treat them as a single class. There are a couple of good reasons to use partial classes. Programmers can work on different parts of a class without needing to share the same physical file. Also you can separate your application business logic from the designer-generated codeAjay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-41976888654790909422010-08-23T05:03:00.000-07:002010-08-28T05:00:37.432-07:00How to access server control in javascript in asp .net ?This is your Server Control<br />
<pre class="brush: csharp"><asp:TextBox ID="txtBox" runat="server" Enabled="false"></asp:TextBox>
</pre>and this is JavaScript code to access asp .net server control in javascript<br />
<pre class="brush: js"><script language="javascript" type="text/javascript">
var txtBox=document.getElementById('<%=txtBox.ClientID%>');
</script>
</pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0tag:blogger.com,1999:blog-833646482998018870.post-90576368813704619502010-08-23T02:04:00.000-07:002010-08-28T05:01:00.359-07:00How to Create Dynamic Datatable ?<pre class="brush: csharp">public Datatable DynamicDataTable
{
DataTable dt = new DataTable();
dt.Columns.Add("year", typeof(string));
DataRow dr = null;
for (int i = 2005; i <= DateTime.Now.Year; i++)
{
dr = dt.NewRow();
dr["year"] = i.ToString() + "-" + (i+1).ToString().Substring(2);
dt.Rows.Add(dr);
}
return dt;
}
</pre>Ajay Rathorehttp://www.blogger.com/profile/02714259074986457337noreply@blogger.com0