Wednesday, May 8, 2013
Sunday, April 21, 2013
Send email from asp.net page
using System.Net.Mail;
using System.Net;
public void SendEmail(string name, string email, string subjectemail, string message)
{
// Gmail Address from where you send the mail
var fromAddress = "emailid@gmail.com";
// any address where the email will be sending
var toAddress = "chetan0389@gmail.com";
//Password of your gmail address
const string fromPassword = "yourpassword";
// Passing the values and make a email format to display
string subject = subjectemail;
string body = "From: " + "" + "\n";
body += "Email: " + email + "\n";
body += "Subject: " + subject + "\n";
body += "Message: \n" + message + "\n";
// smtp settings
var smtp = new System.Net.Mail.SmtpClient();
{
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.EnableSsl = true;
smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
smtp.Credentials = new NetworkCredential(fromAddress, fromPassword);
smtp.Timeout = 20000;
}
// Passing values to smtp object
smtp.Send(fromAddress, toAddress, subject, body);
}
Add Rows in Temporary Table at runtime on button click (ASP.net C# Code)
*********************************************************************************
Step 2: Code.cs
on page load
if (!Page.IsPostBack)
{
Session["tmpTable"] = DisPhotoTable();
}
private DataTable DisPhotoTable()
{
dtTemp = new DataTable();
dtTemp.Columns.Add("Name");
dtTemp.Columns.Add("Age");
dtTemp.Columns.Add("Sex");
dtTemp.Columns.Add("ID Proof");
dtTemp.Columns.Add("ID No");
dtTemp.Columns.Add("Fare", typeof(decimal));
return dtTemp;
}
protected void btnadd_Click(object sender, EventArgs e)
{
DataRow dr;
dtTemp = (DataTable)Session["tmpTable"];
dr = dtTemp.NewRow();
if (txtname.Text != string.Empty)
dr[0] = txtname.Text.Trim();
else
dr[0] = "";
if (txtage.Text != string.Empty)
dr[1] = txtage.Text.Trim();
else
dr[1] = "";
if (ddlsex.SelectedValue != string.Empty)
dr[2] = ddlsex.SelectedValue;
else
dr[2] = "";
if (ddlidtype.SelectedValue != string.Empty)
{
dr[3] = ddlidtype.SelectedValue;
}
else
{
dr[3] = "";
}
if (txtidno.Text != string.Empty)
{
dr[4] = txtidno.Text.Trim();
}
else
{
dr[4] = "0";
}
dr[5] = Convert.ToDecimal(lbltotalfare.Text); // fare eg : 2400
dtTemp.Rows.Add(dr);
BindTempGrid(dtTemp);
decimal Total = Convert.ToDecimal(dtTemp.Compute("sum(Fare)", ""));
total1.Text = Total.ToString();
}
private void BindTempGrid(DataTable dt)
{
gvGrid.DataSource = dt;
gvGrid.DataBind();
tddiv.Visible = true;
}
protected void gvGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataTable dt = (DataTable)Session["tmpTable"];
DataRow dr = dt.Rows[e.RowIndex];
dt.Rows.Remove(dr);
gvGrid.EditIndex = -1;
BindTempGrid(dt);
string ToTAmt = dt.Compute("sum(Fare)", "").ToString();
total1.Text = ToTAmt.ToString();
}
protected void gvGrid_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "this.previous_color=this.style.backgroundColor;this.style.backgroundColor='#ffEECC'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=this.previous_color;");
}
}
Sunday, March 31, 2013
Ladies Sangeet (Mahila Sangeet) Script
Sample Ladies Sangeet Script
Anchor=Aaee sangeet ki ye saam
laai sapno ki baarath
Bhaiya aur bhabhi ka
rhe hamesha saath aai sangeet ki ye saam
Jaisa ki aap sabhi
jaante h ki kisi b shubh karya ki suruwaat hm apne jinendra dev ko yaad krke
krte h to Aaiye swagath kerte hai hamaare nanhe
kalakaroo ka jo aapke saamne present krne jaa rhe h namokaar mha mantra
………….
Anchor = Dekha aapne abhi nanhe bachcho KA DHAMAAL
Ab dekhiya hamare
mummy papa ka KAMAAL
Song1: Ye chand sa roshan
chehra julfon ka rang sunhara…. (by_mummypapa)
àNext Songs Present krne jo
aa rhe unke bare me aapko kuch btatae h.
Ye
h hamare dulhe k brother
Cricket
khelna inhe hai pasand
Nikle
h dhoondhne apne brother ki dulhen
Song2: Mere brother ki
dulhan …(brother)
Anchor :=
Shadi k liye sabne keh keh kar had kr di….
Finally dulhe ne dulhan pasand kar li.
Song3: Shadi
k liye rzamand kar li(Groom)
Anchor :=
Dulhe ko dulhan h bhaaie
Aaj h inki sagaai
Hum sab milkar dete h inhe badhai
Song4: wah wah ramji jodi
kya banai (by all bros and sis)
Anchor :=
Lo ab to ho gyi sagaai
Ab baat mulakat ki aayi
Ye hai dulhe ki pehli date
Jiska vo kar rhe the besabri se w8
Song5: chup chup khade ho
jaroor koi baat h and achcha to hum chalte h…. (couple dance)
Anchor :=
Date me aaya dulhe ko bda hi maza
Unhe pta nhi h aage ki sza
Zor ka jhatka dheere se lga
No more comments ab nakhre b utha
Song6: shadi
jo kiya h tune to ab nakhre b utha and
Zor ka jhatka joro se lga (sister and jiju)
Anchor :=
Aa gyi vo raat, saj gyi baraat
Bhabhi chali h lekar apne devar ki baraat
Song7: lo
chali me apne devar ki baarat leke(Bhabhi jee)
Anchor :=
Aa rhi hai hamari ekloti behna
Inhe b h aaj kuch kehna
Song8: mera
pyara bhaiya and chote chote bhaiyon k bde bhaiya (groom sister)
Anchor :=
Aa rha h ek chota baccha
Jo keh rha h ki khana milega yahan achcha
achcha
Song9: khana milega pina
milega (kids)
Anchor :=
Aa rhe hai yahan dulhe k saathi
Samjhane inko baari baari
Abhi b dikhao thodi samajhdari
Fir nhi hai hamari koi jimmedari.
Song10: Ek
kunwara fas gya maara (friends)
Anchor :=
Aayi hai ye shubh ghadi
Dekhkar inko humne suni
Gori Shankar k jaise inki Jodi bani
Song11: piya
ka pyar mil jaye(all sisters)
Anchor :=
Umeed h aapko pasand aaya hoga hmara sangeet
smaroh
Song12: Kya kehna (title song)
For Claps after every dance
Wo hoth kya jisme laali nahi
Wo upwan kya jisme maali nahi
Wo sasuraal kya jisme saali nahi
Aur wo mahfil kya jisme taali nahi
Lab surkh sharbathi ho jaaye
Gaalo per cha jaaye laaliya
aur is dance per ho jaaye jordaar Taliya
Bahaaro ki mahfil suhani rahegi
lab pe khusi ki kahani rahegi
chamakte rahege khushiyo ke ye sitare
agar
aapki taaliyo ki meharbaani rahegi
Jokes
Purani Kahawat Hy k Sote Waqt
Koi Tension Lekar Nahin Sona Chahiye.
Hairat hy,
Phir Bhi Log
Biwi K Sath hi Sote Hain.
Hairat hy,
Phir Bhi Log
Biwi K Sath hi Sote Hain.
Ek 10 saal ka bachha bahut dhyan se ek book pad raha tha, jiska
title tha: “Kids ka paalan
poshan kaise kare”.
Mother:
Tum yeh book kyon pad rahe ho.
Kid: Main yeh dekhna chahta hoon ke mera
paalan poshan theek
tara se ho raha hai ya nahi.
Newly married wife husband
se: Tumne apne doston se yeh kyun kaha ki mujhebahut accha khana banana aata hai.
Husband: Ab tumse shaadi karne ki koi wajah toh mujhe
batani hi thi.
Boyfriend to
Girlfriend: Darling main tumse shaadi nahi kar sakta gharwale mana kar rahe hai
Girlfriend:
Tumhare ghar mein kaun kaun hai?
Boyfriend: Ek biwi aur 3 bacche…
Friday, March 22, 2013
Create User and Login in sql server database
CREATE LOGIN loginname
WITH PASSWORD = 'yourpassword';
GO
-- Creates a database user for the login created above.
CREATE USER username FOR LOGIN loginname;
GO
Saturday, March 9, 2013
XML File and Dataset.. (Read and Write XML) (Asp.net, C#)
//Read and Write from dataset to XML
using System.Xml.Serialization;
using System.IO;
using System.Data;
DataSet ds = new DataSet();
string qry = "Select distinct UserID, UName from dbo.tblUsers";
ds = AdminBl.Selectrecord("sp_selectglobal", qry); //Executing stored procedure
//writing xml file
StreamWriter objxml = new StreamWriter(Server.MapPath("~/XMLFile.xml"), false);
// Apply the WriteXml method to write an XML document
ds.WriteXml(objxml);
objxml.Close();
//Read from xml file and Fill the Gridview
DataSet dset = new DataSet();
dset .ReadXml(Server.MapPath("~/XMLFile.xml"));
GridView1.DataSource = dset;
GridView1.DataBind();
Subscribe to:
Posts (Atom)