Thursday, December 22, 2011

Call JavaScript function Server Side button_onclick

You can easily call any javascript anywhere on page by this code simply....

ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Key", "script language='javascript'>alert("msg");script", false);

Monday, December 19, 2011

Sending sms from Asp.Net

I use the following two functions in my application to send sms from my asp.net application.
I use c# as programming language.
I provide some credential which I got from the sms API provider. we use www.smscountry.com API in application.
I call the setupSMS function to send sms from my application which requires mobileNumber and message as input parameter and returns the response of the message sent.


private string setupSMS(string mobileNumber, string message)
{
string strPostBody;
String strPostResponse;


//'Give The Respective Variable Values
string userName = "UserId"; //'Enter Your User Name provided by API Provider
string password = "Password";//'Enter Your Password provided by API Provider
string senderid = "senderId";//' Enter Your Senderid provided by API Provider


string messageType = "N";//' Enter Your Message Type As N for Normal Message, O for Other Laungauge Sms
Char deliveryReports = 'Y';//' if U want To Know Delivery Reports Enter Y it Gives JOBID Otherwise N


//'****If U R Behind The Proxy Server Uncomment And Give Below Details *****
//'objProxy = New WebProxy("Proxy Ip Adress", PortNumber)


//'Call sendSMS Method For Sending The Sms's

message = Server.UrlEncode(message);
strPostBody = "User=" + userName + "&passwd=" + password + "&mobilenumber=" + mobileNumber + "&message=" + message + "&sid=" + senderid + "&mtype=" + messageType + "&DR=" + deliveryReports;
strPostResponse = sendSMS(strPostBody);
return strPostResponse;
}


private string sendSMS(string stringPost)
{

HttpWebRequest objWebRequest = null;
HttpWebResponse objWebResponse;
StreamWriter objStreamWriter = null;
StreamReader objStreamReader = null;
try
{

string stringResult;

objWebRequest = (HttpWebRequest)(WebRequest.Create("http://www.smscountry.com/smscwebservice.asp"));

objWebRequest.Method = "POST";

if (objProxy != null)
{
objWebRequest.Proxy = objProxy;
}
objWebRequest.ContentLength = stringPost.Length;
objWebRequest.ContentType = "application/x-www-form-urlencoded";
objStreamWriter = new StreamWriter(objWebRequest.GetRequestStream());
objStreamWriter.Write(stringPost);
objStreamWriter.Flush();
objStreamWriter.Close();

objWebResponse = (HttpWebResponse)(objWebRequest.GetResponse());
objStreamReader = new StreamReader(objWebResponse.GetResponseStream());
stringResult = objStreamReader.ReadToEnd();
objStreamReader.Close();
return stringResult; //'jobid

}
catch (Exception ex)
{
return ex.ToString();
}
finally
{
if (objStreamWriter != null)
{
objStreamWriter.Close();
}
if (objStreamReader != null)
{
objStreamReader.Close();
}
objWebRequest = null;
objWebResponse = null;
objProxy = null;
}
}

Wednesday, November 30, 2011

Export datagrid to Excel in asp.net (Revised)

How to export datagrid data into excel
Utility Code: It is self explanatory

protected void btnExportToExcel_Click(object sender, EventArgs e)
{
DataTable dtOriginal = new DataTable();
dtOriginal = ReturnTable(); //Return Table consisting data

//Create Tempory Table
DataTable dtTemp = new DataTable();

//Creating Header Row
dtTemp.Columns.Add("Employee Name");
dtTemp.Columns.Add("Email");
dtTemp.Columns.Add("Join Date");
dtTemp.Columns.Add("Salary");
double dSalary;
DateTime dtDate;
DataRow drAddItem;
for (int i = 0; i < dtOriginal.Rows.Count; i++)
{
drAddItem = dtTemp.NewRow();
drAddItem[0] = dtOriginal.Rows[i][0].ToString();//Name
drAddItem[1] = dtOriginal.Rows[i][1].ToString();//Email

//Join Date
dtDate = Convert.ToDateTime(dtOriginal.Rows[i][2].ToString());
drAddItem[2] = dtDate.ToShortDateString();

//Salary
dSalary = Convert.ToDouble(dtOriginal.Rows[i][3].ToString());
drAddItem[3] = dSalary.ToString("C");

dtTemp.Rows.Add(drAddItem);
}

//Temp Grid
DataGrid dg = new DataGrid();
dg.DataSource = dtTemp;
dg.DataBind();
ExportToExcel("BudgeReport.xls", dg);
dg = null;
dg.Dispose();
}

private void ExportToExcel(string strFileName, DataGrid dg)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + strFileName);
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}

Thursday, November 3, 2011

Find All trigger Information in our Database In Sql

This is the Query by which one u can get the whole information about the trigger which are in our database or particular database.

SELECT Tables.Name TableName,
Triggers.name TriggerName,
Triggers.crdate TriggerCreatedDate,
Comments.Text TriggerText
FROM sysobjects Triggers
Inner Join sysobjects Tables On Triggers.parent_obj = Tables.id
Inner Join syscomments Comments On Triggers.id = Comments.id
WHERE Triggers.xtype = 'TR'
And Tables.xtype = 'U'
ORDER BY Tables.Name, Triggers.name

Monday, October 24, 2011

Rupee foridian font Applied on Repeater control

This is a new font of Indian rupees I found and Apply it on the Repeater control as like this.

asp:Label ID="lblFees" runat="server" Text='<%#Eval("SemFees","`{0}") %>' Font-Names="Rupee Foradian" asp:Label

Also check the link for how to apply and download rupee foridian font.
http://www.indianweb2.com/2010/07/how-to-type-indian-rupee-symbol-download-indian-rupee-font/

http://www.codeproject.com/KB/silverlight/NewIndianRupeeSymbolDemo.aspx

Thursday, October 13, 2011

Validate Number by Javascript function

by this function simply call this function on onkeypress event and get mast functionality.
function isNumberKey(e) {
var charCode = (e.which) ? e.which : event.keyCode
if ((charCode > 31) && (charCode < 48 || charCode > 57)) {
return false;
}
}

//call on onkeypress event in textbox

asp:TextBox ID="txtbox1" runat="server" CssClass="input_big" MaxLength="15"
onkeypress="return isNumberKey(event)"/asp:TextBox

Wednesday, October 12, 2011

Find any Control in Repeater using Javascript

I used Javascript function to check count of checkboxes into repeater which are checked.And on that count I performed some action on it on my client side perfomance.
function checkAll(cb)
{
var ctrls = document.getElementsByTagName('input');
var count=0;
for (var i = 0; i < ctrls.length; i++)
{
var cbox = ctrls[i];
if (cbox.type == "checkbox")
{

if(cbox.checked)
{
count++;

}
//cbox.checked = cb.checked;
}
}
}

Call this function on aspx contol

asp:CheckBox ID="chkPaper" runat="server" onclick="return checkAll(this)"
enjoy coding...

Tuesday, September 27, 2011

Find control in header template in repeater or any container

We can search any type of control in header templete through item_databound event of repeater like this.

protected void rptElective_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Header)
{
Label lblSelect = (Label)e.Item.FindControl("lblSelect");
if (SpecFlag == false)
lblSelect.Visible = true;
else
lblSelect.Visible = false;
}

}

And also you can Hide Control without Item_dataBound like this enjoy coding...

Label lblSelect = rptElective.Controls[j].Controls[j].FindControl("lblSelect") as Label;

Wednesday, September 21, 2011

Convert string to datetime exactly not normal datetime.

The unexpected error was come once in front of me.string was not in a valid datetime format.Then i searched for this conversion and it works properly now.

DateTime dt = DateTime.ParseExact(txtdob.Text, "dd/MM/yyyy", null); ;

Tuesday, September 20, 2011

Select checkboxlist according to db get values

This is very simple example for splitting and selecting checkbox list according to the values get by database field.
string[] value = DocValues.Split(',');

foreach (string st in value)
{
if (chkdocument.Items.FindByText(st).Text != string.Empty)
{
chkdocument.Items.FindByText(st).Selected = true;
}
}

Friday, September 16, 2011

format datetime in any container

//We can format our date time string into our desired format in any container like this:-

asp:Label ID="lblDOB" runat="server" Text='<%#Eval("DOB","{0 :MM/dd/yyyy}") %>'asp:Label

format datetime in any container

//We can format our date time string into our desired format in any container like this:-

asp:Label ID="lblDOB" runat="server" Text='<%#Eval("DOB","{0 :MM/dd/yyyy}") %>'asp:Label

Friday, July 15, 2011

Write Image from server on page without image control

Writing an Image on a page without using Image control from other url as like url rewiring we write that image or content to our Location page url.



Using image As New Bitmap(Context.Server.MapPath("~/img/gsa_logo3.gif"))
Using ms As New MemoryStream()
image.Save(ms, System.Drawing.Imaging.ImageFormat.Gif)
ms.WriteTo(Context.Response.OutputStream)
Response.ContentType = "image/gif"
Response.Flush()
End Using
End Using

Monday, May 30, 2011

Retrieval Password from asp Membership tables

//web.config
machineKey validationKey="10B00B531A175EFE53065651BC315DDDDED9C1A6626D0996B1E18F6BEAC58153ACF7AC5306937C6C6C823C00BB8DB07F4D1CF4F4CF2CAC7EBEBB9463DC801B31" decryptionKey="4BCD239B9946A067517A3DBC503DAAE28BFE5C860A7037D25C547D85C4F55973" validation="SHA1" decryption="AES"

"add connectionStringName="UserManagement" minRequiredPasswordLength="6" enablePasswordRetrieval="true" passwordFormat="Encrypted" enablePasswordReset="true" requiresUniqueEmail="true" minRequiredNonalphanumericCharacters="0" requiresQuestionAndAnswer="false" applicationName="/InkyDB" name="AspNetSqlProvider" type="System.Web.Security.SqlMembershipProvider" "


on .aspx page

MembershipUser user = Membership.GetUser("piyush");

string password = user.GetPassword();

Friday, May 27, 2011

Paging in Datalist or repeater + using hashtable

// I have a search Module in a project in which data is coming and populated by //datalist for more than 1 pages I have need for integrated paging in this datalist //and also I used hashtable on the basis of unique key and datasource of datalist .
PagedDataSource pg = new PagedDataSource();
string searchstring; int catid;
DataView dvData = new DataView(dt);
dvData.Sort = "PublishDate Desc";
ListDictionary myHashTable = new ListDictionary();
for (int j = 0; j < dvData.Count; j++)
{
if (dvData[j]["ArticleID"] != null)
{
//StringBuilder str = new StringBuilder(150);5+6
string str = dvData[j]["CategoryID"] + "~^`" + dvData[j]["ArticleID"] + "~^`" + dvData[j]["Title"] + "~^`" + dvData[j]["ListThumbnail"].ToString() + "~^`" + dvData[j]["GetPrintOrDay"].ToString() + "~^`" + dvData[j]["ShortStory"].ToString() + "~^`" + dvData[j]["PublishDate"].ToString();
myHashTable.Add(dvData[j]["ArticleID"].ToString(), str.Split("~^`".ToCharArray()));
}

}

pg.DataSource = myHashTable;
//pg.AllowCustomPaging = true;
pg.AllowPaging = true;
pg.PageSize = 20;
// Move to the appropriate page based on the query string.
try
{
pg.CurrentPageIndex = Int32.Parse(Request.QueryString["Page"].ToString());
}
catch (Exception ex)
{
pg.CurrentPageIndex = 0;
}
// Enable and/or disable the previous and next buttons
btnPrev.Enabled = !pg.IsFirstPage;
btnNext.Enabled = !pg.IsLastPage;
// Display which is the current page being displayed
lblCurrentPage.Text = "Page: " + (pg.CurrentPageIndex + 1).ToString();
lbltotalpages.Text = (dt.Rows.Count / 20).ToString();
if (dt.Rows.Count % 20 != 0)
{
lbltotalpages.Text = ((dt.Rows.Count / 20) + 1).ToString();
}
// Attach data source to the datalist
if (dt.Rows.Count > 20)
divNav.Visible = true;
rptDepartmentCate.DataSource = pg;
rptDepartmentCate.DataBind();
lblmessage.Text = "" + dt.Rows.Count.ToString() + "" + " " + "Results found for" + " '" + searchstring + "'";
for (int l = 0; l < pg.Count; l++)
{
rptDepartmentCate.Controls[l].Controls[3].Visible = true;
}
}
else
{
lblmessage.Text = "Your search '" + searchstring + "' did not match any article.";
}
}
else
{
lblmessage.Text = "Your search '" + searchstring + "' did not match any article.";
}
}
public void Prev_Click(Object sender, EventArgs e)
{
int pagenumber = 0;
if (!string.IsNullOrEmpty(Request.QueryString["Page"]))
pagenumber = Convert.ToInt32(Request.QueryString["Page"]) - 1;
if (Request.CurrentExecutionFilePath == "/EditorAndPublisher/SearchResult.aspx")
Response.Redirect(Request.CurrentExecutionFilePath + "?Page=" + pagenumber);

}

// Move to next page
public void Next_Click(Object sender, EventArgs e)
{
int pagenumber=1;
if(!string.IsNullOrEmpty(Request.QueryString["Page"]))
pagenumber=Convert.ToInt32(Request.QueryString["Page"])+1;
if (Request.CurrentExecutionFilePath == "/EditorAndPublisher/SearchResult.aspx")
Response.Redirect(Request.CurrentExecutionFilePath + "?Page=" + pagenumber);

}

Thursday, May 19, 2011

Search according to date and time

private void Search()
{
// Get start date and end date of Current Week//
DayOfWeek day = DateTime.Now.DayOfWeek;
int days = day - DayOfWeek.Monday;
DateTime startD = DateTime.Now.AddDays(-days);
DateTime endD = startD.AddDays(6);

// Get start date and end date of Current month //
DateTime startM = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DateTime endM = startM.AddMonths(1).AddDays(-1);


DateTime? OrderDate = null, StartOrderDate = null, EndOrderDate = null;


ViewState["sContent"] = null;
//string Title = txtTitle.Text;
if (ddlPeriod.SelectedItem.Value != "Select")
{
if (ddlPeriod.SelectedValue == "Today")
OrderDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
else if (ddlPeriod.SelectedValue == "Yesterday")
OrderDate = Convert.ToDateTime(DateTime.Now.AddDays(-1).ToShortDateString());
else if (ddlPeriod.SelectedValue == "This Week")
{
StartOrderDate = startD;
EndOrderDate = endD;
}
else if (ddlPeriod.SelectedValue == "This Month")
{
StartOrderDate = startM;
EndOrderDate = endM;
}
else if (ddlPeriod.SelectedValue == "Date Range")
{

if (!string.IsNullOrEmpty(txtDateRange1.Text))
StartOrderDate = Convert.ToDateTime(txtDateRange1.Text);
if (!string.IsNullOrEmpty(txtdaterange2.Text))
EndOrderDate = Convert.ToDateTime(txtdaterange2.Text);
}
}
//int CatId = 0;
//if (Request.QueryString["CategoryID"] != null)
// CatId = Convert.ToInt32(Request.QueryString["CategoryID"]);
//if (Title != null)
// Title = Title.Replace("'", "''");
int onumber = 0;
if (!string.IsNullOrWhiteSpace(txtorderno.Text))
onumber=Convert.ToInt32(txtorderno.Text);

GetOrders(onumber, txtcustname.Text, txtemail.Text, OrderDate.ToString(), StartOrderDate.ToString(), EndOrderDate.ToString(), chkDisable.Checked);
//GetOrders((Convert.ToInt32(txtorderno.Text)));
}

Monday, May 16, 2011

Credit card date expire validations

script type="text/javascript"
function ValidateCardNumber(sender, args) {
if ((args.Value.length < 13) || (args.Value.length > 16)) {
args.IsValid = false;
}
else {
args.IsValid = true;
}
}
function IsValidDate(Mn, Yr) {
if (Mn == 12)
Yr++;

var dt = new Date();
dt.setMonth(Mn);
dt.setDate(1);
dt.setFullYear(Yr);
var today = new Date();

if (today >= dt) {
return false;
}
return true;
}

function CallDateFun(sender, args) {
var m = document.getElementById('<%= mddlMM.ClientID %>').value
var y = document.getElementById('<%= mddlYY.ClientID %>').value;
//year=2000+parseInt(y);
if (m != 0 && y != 0) {
args.IsValid = IsValidDate(m, y);
}
}
/script

Tuesday, May 10, 2011

What is Delegates ?

A delegate is a type-safe object that can point to another method (or possibly multiple methods) in the application, which can be invoked at later time.

Delegates also can invoke methods Asynchronously.

A delegate type maintains three important pices of information :

The name of the method on which it make calls.
Any argument (if any) of this method.
The return value (if any) of this method.
Defining a Delegate in C#

when you want to create a delegate in C# you make use of delegate keyword.

The name of your delegate can be whatever you desire. However, you must define the delegate to match the signature of the method it will point to. fo example the following delegate can point to any method taking two integers and returning an integer.

public delegate int DelegateName(int x, int y);

A Delegate Usage Example

namespace MyFirstDelegate
{
//This delegate can point to any method,
//taking two integers and returning an
//integer.
public delegate int MyDelegate(int x, int y);
//This class contains methods that MyDelegate will point to.
public class MyClass
{
public static int Add(int x, int y)
{
return x + y;
}
public static int Multiply(int x, int y)
{
return x * y;
}
}
class Program
{
static void Main(string[] args)
{
//Create an Instance of MyDelegate
//that points to MyClass.Add().
MyDelegate del1 = new MyDelegate(MyClass.Add);
//Invoke Add() method using the delegate.
int addResult = del1(5, 5);
Console.WriteLine("5 + 5 = {0}\n", addResult);
//Create an Instance of MyDelegate
//that points to MyClass.Multiply().
MyDelegate del2 = new MyDelegate(MyClass.Multiply);
//Invoke Multiply() method using the delegate.
int multiplyResult = del2(5, 5);
Console.WriteLine("5 X 5 = {0}", multiplyResult);
Console.ReadLine();
}
}
}

Tuesday, April 26, 2011

Copy tables from one database to another in sql

SELECT *
INTO Destinationtdb.dbo.MyTable
FROM Source.dbo.MyTablejavascript:void(0)

Select one field of many

function selectone(objSource, objArgs) {

var fldvalid;
var first = document.getElementById('<%= flImage.ClientID %>')
var second = document.getElementById('<%=txtembed.ClientID %>')
var third = document.getElementById('<%=FileUpload2.ClientID %>')
if (first.value == "" && second.value == "" && third.value == "") {
fldvalid = false;
}
else if (first.value != "" && second.value != "" && third.value != "") {
fldvalid = false;
}
else if (first.value != "" && second.value != "")
fldvalid = false;
else if (first.value != "" && third.value != "")
fldvalid = false;
else if (second.value != "" && third.value != "")
fldvalid = false;
else {
fldvalid = true;
}
objArgs.IsValid = fldvalid;
return;
}


asp:CustomValidator ID="CustomValidator2" ValidationGroup="News" runat="server"
ClientValidationFunction="selectone" Display="None"
ValidateEmptyText="true" ErrorMessage="Required One video path or embed or image." asp:CustomValidator

check file extension through javascript

.aspx
function checkFileExtension(objSource, objArgs) {
var blnValid;
var file = objArgs.Value.split(".");
var extn = file[file.length - 1].toUpperCase();

if (extn == "MOV" || extn== "WMV") {
blnValid = true;

}
else {
blnValid = false;
}
objArgs.IsValid = blnValid;
return;
}

asp:CustomValidator ID="CustomValidator1" ValidationGroup="News" runat="server"
ClientValidationFunction="checkFileExtension" ControlToValidate="flImage" Display="None"
ValidateEmptyText="false" ErrorMessage="Only .mov,.wmv video files are allowed." asp:CustomValidator

Check date format in textbox by compare validator

asp:CompareValidator ID="CompareValidator1" runat="server" Display="None"
ControlToValidate="txtDate" ErrorMessage="Invalid Date" ValidationGroup="News"
Operator="DataTypeCheck" Type="Date"
asp:CompareValidator

select max value of field by linq

int clientid;
var max_Query = (from c in abc.Table where (c.id== clientid)
select c.SortOrder
).Max();

Add To Cart funtionality

private void GetCartData()
{

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ProductId", typeof(int)));
dt.Columns.Add(new DataColumn("ProductName", typeof(string)));
dt.Columns.Add(new DataColumn("ProductOption3Value", typeof(string)));
dt.Columns.Add(new DataColumn("ProductOption2Value", typeof(string)));
dt.Columns.Add(new DataColumn("ProductOption1Value", typeof(string)));
dt.Columns.Add(new DataColumn("SalePrice", typeof(int)));
dt.Columns.Add(new DataColumn("TotalPrice", typeof(int)));
dt.Columns.Add(new DataColumn("Quantity", typeof(int)));
dt.Columns.Add(new DataColumn("Thumbnail", typeof(string)));

DataRow dr;
if (ViewState["ProductId"] != null)
productid = Convert.ToInt32(ViewState["ProductId"]);

if (Session["CartData"] == null)
{
dr = dt.NewRow();
//add the row to DataTable
var Pl = mse.ProductDesc.Where(c => c.ProductId == productid).FirstOrDefault();
if (Pl != null)
{
//add values to each rows
dr["Productid"] = Pl.ProductId;
dr["ProductName"] = Pl.ProductName;
dr["SalePrice"] = Pl.Saleprice;
dr["TotalPrice"] = Pl.Saleprice * 1; //Convert.ToInt32(ddlqty.SelectedItem.Value);
dr["Quantity"] = 1;// ddlqty.SelectedItem.Value;
dr["Thumbnail"] = Pl.Thumbnail;
dt.Rows.Add(dr);
}
}
else
{
var Pl = mse.ProductDesc.Where(c => c.ProductId == productid).FirstOrDefault();
if (Pl != null)
{
dt = (DataTable)Session["CartData"];

dr = dt.NewRow();
dr["Productid"] = Pl.ProductId;
dr["ProductName"] = Pl.ProductName;
//dr["ProductOption3Value"] = ddlsize.SelectedItem.Text;
//dr["ProductOption2Value"] = Pl.ProductOption2Value;
//dr["ProductOption1Value"] = Pl.ProductOption1Value;
dr["SalePrice"] = Pl.Saleprice;
dr["TotalPrice"] = Pl.Saleprice * 1;// Convert.ToInt32(ddlqty.SelectedItem.Value);
dr["Quantity"] = 1;// ddlqty.SelectedItem.Value;
dr["Thumbnail"] = Pl.Thumbnail;
dt.Rows.Add(dr);
}
}
Session["CartData"] = dt;
Response.Redirect("~/viewcart.aspx");

}


//second page
protected DataTable GetCartData()
{
DataTable dt;
dt = (DataTable)Session["CartData"];
for (int intC = 0; intC < dt.Rows.Count; intC++)
{
if (mgvBasket.Rows[intC].RowType == DataControlRowType.DataRow)
{
if (((CheckBox)mgvBasket.Rows[intC].FindControl("mchkRemove")).Checked)
{
dt.Rows[intC].Delete();

}
else if (((CheckBox)mgvBasket.Rows[intC].FindControl("mchkRemove")).Checked || ((TextBox)mgvBasket.Rows[intC].FindControl("mtxtQty")).Text != "")
{
string strqty = ((TextBox)mgvBasket.Rows[intC].FindControl("mtxtQty")).Text;
if (!string.IsNullOrEmpty(strqty))
{
int qty = Convert.ToInt32(strqty);
int saleprice = Convert.ToInt32(dt.Rows[intC]["SalePrice"]);
dt.Rows[intC]["Quantity"] = qty;
dt.Rows[intC]["TotalPrice"] = qty * saleprice;
}
}
else { }

}
else { }
}
dt.AcceptChanges();
GetTotal();
Session["CartData"] = dt;
return dt;
}
public void GetTotal()
{

double Rate = 0;
if (Session["ship"] != null)
{
ShippingInfo ship = (ShippingInfo)Session["Ship"];
// Rate = RateServices.GetRate(ship, 15);
}
DataTable dt = new DataTable();
if (Session["CartData"] != null)
{
dt = (DataTable)Session["CartData"];
int count = 0;

if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
count += Convert.ToInt32(dt.Rows[i]["Quantity"]);

TotalAmt = TotalAmt + Convert.ToInt32(dt.Rows[i]["Quantity"]) * Convert.ToInt32(dt.Rows[i]["SalePrice"]);


}
Session["Items"] = count;
subtotal = TotalAmt;
lblsubtotal.Text = subtotal.ToString("c");
Session["SubTotal"] = subtotal;
Rate = 0;
Session["Rate"] = Rate;
lblshiprate.Text = Rate.ToString("c");
TotalAmt = TotalAmt + Rate;
Session["Total"] = TotalAmt;
//lblrate.Text = Rate.ToString("c");
lblTotal.Text = Convert.ToDouble(TotalAmt).ToString("c");
Session["Total"] =TotalAmt;
}
else
{
Session["CartData"] = null;
Session.Clear();
Response.Redirect("~/index.aspx");
}
}
}

sorting in gridview

protected void BindProductsGrid()
{
DataTable dt =GetAllProducts();
if (dt.Rows.Count > 0)
{
if (ViewState["Sort"] == null)
dt.DefaultView.Sort = "ProductName Asc";
else
dt.DefaultView.Sort = ViewState["Sort"].ToString();

gvProducts.AllowSorting = true;
gvProducts.DataSource = dt.DefaultView;
gvProducts.DataBind();
}
else
{
gvProducts.AllowSorting = false;
DataSetLinqOperators.ShowNoResultFound(dt, gvProducts, "There is no Product Types.");
}
}
public static DataTable GetAllProducts()
{
bhscEntities ese = new bhscEntities();
var pt = (from c in ese.Products
join d in ese.ProductImages on c.ProductId equals d.ProductId
where c.Deleted == false
orderby c.ProductName ascending
select new
{
c.ProductId,
d.Thumbnail,
c.ProductName,
c.ProductOption1Value,
c.ProductOption2Value,
c.ProductOption3Value,
c.SKU,
c.Saleprice
});

DataTable dt = DataSetLinqOperators.CopyToDataTable(pt);
return dt;
}

protected void gvProducts_Sorting(object sender, GridViewSortEventArgs e)
{
if (ViewState["Sort"] != null)
{
if (ViewState["Sort"].ToString().Substring(ViewState["Sort"].ToString().Length - 4, 4).Trim() == "ASC")
ViewState["Sort"] = e.SortExpression + " DESC";
else
ViewState["Sort"] = e.SortExpression + " ASC";
}
else
ViewState["Sort"] = e.SortExpression.ToString() + " Desc";

BindProductsGrid();
}

show and hide buttons or link while printout page

javascript funtion
function ShowHelp(id) {
document.getElementById(id).style.display = "block";
}
function HideHelp(id) {
document.getElementById(id).style.display = "none";
window.print();
setTimeout("ShowHelp('aprint')", 3000);


}
function HideHelp1(id) {
document.getElementById(id).style.display = "none";

setTimeout("ShowHelp('imgbtdelorder')", 3000);


}


calling on button click

a id="aprint" onclick="javascript:HideHelp1('imgbtdelorder');javascript:HideHelp('aprint');" href="JavaScript:window.print();">Print this page a

Saturday, April 23, 2011

2 querysting on postback event of linkbuton

asp:LinkButton ID="lbtprname" runat="server" PostBackUrl='<%# "Description.aspx?Productid="+Eval("ProductId")+"&ProductTypeID="+protypeid %>'

Sunday, February 27, 2011

On Mouse Over show image

function ShowHelp(id) {
document.getElementById(id).style.display = "block";
}
function HideHelp(id) {
document.getElementById(id).style.display = "none";
}


on .aspx page

onmouseover="javascript:ShowHelp('dvthumimage');" onmouseout="javascript:HideHelp('dvthumimage');"

On Mouse over show different image in javascript

function Bind(cControl, imgsrc) {
// t2_ovr.jpg.jpg

cControl.childNodes[0].src = imgsrc;
}
function Clear(cControl, imgsrc) {

cControl.childNodes[0].src = imgsrc;
}



on .aspx page

onmouseover='javascript:Bind(this,"<%# GetAppImagePath(Eval("Thumbnail_Rollover")) %>");' onmouseout='javascript:Clear(this,"<%# GetAppImagePath(Eval("Thumbnail"))

Saturday, February 26, 2011

Asp dotnet 2 yr. exp Interview Questions

Please visit this link for 2 yr. exp. interview questions.

http://www.dotnetcurry.com/ShowArticle.aspx?ID=63

http://dotnetprojectninterviewquestions.blogspot.com/

Wednesday, February 16, 2011

Friday, January 14, 2011

How to backup and restore database in mysql

Backup and restore database from mysql:
From Dos Command Prompt(First Go Inside-C:\Program Files\MySQL\MySQL Server 5.0\bin)
Then Fire command as like--
mysqldump -u root -psa1234 databasename > c:/databasename.sql

REstore:
mysql -u [uname] -p[pass] [db_to_restore] < c:/databasename.sql
mysql -u root -pSa1234 -D photochat < c:/photochat.sql