Asp.Net Ado.Net, C#.Net,Javascript Jquery Entity Framework,Ajax,MVC..! Happy coding..! :)

Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package. .Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier. Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people, system and devices through software".I'm Choulla Naresh..!

Monday, June 30, 2014

multi Stored Procedure Binding DropDown list Selected Values To bing Gridview Using Sessions

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

public partial class drpgrid : System.Web.UI.Page

{

adosession obj;

protected void Page_Load(object sender, EventArgs e)

{

obj = new adosession();

DataSet ds = obj.bindgrid(Convert.ToInt32(Session["id"]), "ById");

DataTable dt = new DataTable();

dt.Columns.Add("id", typeof(int));

dt.Columns.Add("name", typeof(string));

dt.Columns.Add("address", typeof(string));

if (Session["dt"] == null)

{

dt.Rows.Add(ds.Tables[0].Rows[0][0].ToString(), ds.Tables[0].Rows[0][1].ToString(), ds.Tables[0].Rows[0][2].ToString());

grd.DataSource = dt;

grd.DataBind();

Session["dt"] = dt;

}

else

{

DataTable dt2 = (DataTable)Session["dt"];

dt2.Rows.Add(ds.Tables[0].Rows[0][0].ToString(), ds.Tables[0].Rows[0][1].ToString(), ds.Tables[0].Rows[0][2].ToString());

Session["dt"] = dt2;

grd.DataSource = dt2;

grd.DataBind();

}

-----------------------------------------------------------------------------------

Stored Procedure

USE [naresh]

/****** Object: StoredProcedure [dbo].[sp_getgridvalues] Script Date: 06/30/2014 13:04:30 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE procedure [dbo].[sp_getgridvalues]

@id int,

@type varchar(50)

begin

if(@type='Byid')

select id,name,address from gridsession where id=@id

else

select * from gridsession

end

Multi Stored Procedute

USE [naresh]

/****** Object: StoredProcedure [dbo].[sp_getgridvalues] Script Date: 06/30/2014 13:04:30 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE procedure [dbo].[sp_getgridvalues]

@id int,

@type varchar(50)

begin

if(@type='Byid')

select id,name,address from gridsession where id=@id

else

select * from gridsession

end

Sending Mail From Asp.net Page To Gmail Using SMTP. Gmail Port Number 587

<body>

<h3>Send Mail To Your's Gmail Using ASp.net</h3>

<table>

<tr>

<td>Gmail User</td>

<td>

<asp:TextBox ID="txtfrom" runat="server" ></asp:TextBox>

</td>

</tr>

<tr>

<td>Gmail Password</td>

<td>

<asp:TextBox ID="txtpassword" TextMode="Password" runat="server" ></asp:TextBox>

</td>

</tr>

<tr>

<td>Subject</td>

<td>

<asp:TextBox ID="txtsub" runat="server" ></asp:TextBox>

</td>

</tr>

<tr>

<td>

<asp:TextBox ID="txtto" runat="server" ></asp:TextBox>

</td>

</tr>

<tr>

<td>

<asp:TextBox ID="txtbody" runat="server" TextMode="MultiLine" Columns="30" Rows="10"></asp:TextBox>

</td>

</tr>

<tr>

<td>

<br />

<asp:Button ID="btnsubmit" runat="server" Text="Submit" onclick="btnsubmit_Click" />

</td>

</tr>

</table>

</div>

</form>

</body>

ASPX.CS Code:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Net.Mail;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnsubmit_Click(object sender, EventArgs e)

{

MailMessage newmsg = new MailMessage();

newmsg.From = new MailAddress(txtfrom.Text);

newmsg.Subject = txtsub.Text;

newmsg.To.Add(txtto.Text);

newmsg.Body = txtbody.Text;

SmtpClient smtp = new SmtpClient();

smtp.Host = "smtp.gmail.com";

smtp.Port = 587;

smtp.Credentials = new System.Net.NetworkCredential(txtfrom.Text, txtpassword.Text);

smtp.EnableSsl = true;

smtp.Send(newmsg);

Response.Write("msg is send");

}

Sunday, June 29, 2014

Grid Add 10 records at a Time using sessions and Onrowdatabound

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Grid.aspx.cs" Inherits="Grid" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<asp:GridView ID="grdout" AutoGenerateColumns="false" runat="server" OnRowDataBound="nnn" DataKeyNames="Id">

<asp:TemplateField HeaderText="ID">

<asp:TextBox ID="txt1" runat="server"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Name">

<asp:TextBox ID="txt2" runat="server"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Role">

<asp:TextBox ID="txt3" runat="server"></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Gender">

<asp:DropDownList ID="drp" runat="server"></asp:DropDownList>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<br />

<asp:Button ID="Button1" runat="server" Text="ADD NEW ROW"

onclick="Button1_Click" />

</div>

</form>

</body>

</html>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

public partial class Grid : System.Web.UI.Page

{

//int count;

protected void Page_Load(object sender, EventArgs e)

{

int count = 10;

if (!IsPostBack)

{

Session.Clear();

for (int i = 0; i <= count; i++)

{

naresh();

}

protected void nnn(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

var ddl = (DropDownList)e.Row.FindControl("drp");

SqlConnection con = new SqlConnection("Data Source=KCLINK-45-PC\\SQLEXPRESS;Initial Catalog=naresh;Integrated Security=True");

SqlCommand cmd = new SqlCommand("select * from gender");

cmd.Connection = con;

con.Open();

SqlDataAdapter dap = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

dap.Fill(ds);

ddl.DataSource = ds;

ddl.DataTextField = "gender";

ddl.DataValueField = "id";

ddl.DataBind();

ddl.Items.Insert(0, new ListItem("--Select--", "0"));

}

private void naresh()

{

DataTable dt = new DataTable();

dt.Columns.Add("Id", typeof(string));

dt.Columns.Add("Name", typeof(string));

dt.Columns.Add("Role", typeof(string));

dt.Columns.Add("Gender", typeof(string));

if (Session["dt"] == null)

{

dt.Rows.Add("", "", "", "");

Session["dt"] = dt;

grdout.DataSource = dt;

grdout.DataBind();

}

else

{

DataTable dt2 = (DataTable)Session["dt"];

dt2.Rows.Add("", "", "", "");

Session["dt"] = dt2;

grdout.DataSource = dt2;

grdout.DataBind();

}

protected void Button1_Click(object sender, EventArgs e)

{

DataTable dtt = new DataTable();

dtt.Columns.Add("Id", typeof(string));

dtt.Columns.Add("Name", typeof(string));

dtt.Columns.Add("Role", typeof(string));

dtt.Columns.Add("Gender", typeof(string));

if (Session["dt"] == null)

{

dtt.Rows.Add("", "", "", "");

Session["dt"] = dtt;

grdout.DataSource = dtt;

grdout.DataBind();

}

else

{

DataTable dt3 = (DataTable)Session["dt"];

dt3.Rows.Add("", "", "", "");

Session["dt"] = dt3;

grdout.DataSource = dt3;

grdout.DataBind();

}

Friday, June 27, 2014

Read Notpad Data in C#

StreamReader sr = new StreamReader("D:\\PODB.txt");

string line;
while (( line = sr.ReadLine()) != null)
{

Response.Write(line);
}

Wednesday, June 25, 2014

Text To Voice Converter

Design Like this

Add References

After....
.Cs File

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Speech;

using System.Speech.Synthesis;

using System.Text;

using System.Windows.Forms;

namespace TextToVoice_Convert

{

public partial class Form1 : Form

{

SpeechSynthesizer ss=new SpeechSynthesizer();

public Form1()

{

}

private void btnRead_Click(object sender, EventArgs e)

{

ss.Rate = TraceBarSpeed.Value;

ss.Volume = TrackBarVolume.Value;

ss.SpeakAsync(Txtmsg.Text);

}

private void btnPause_Click(object sender, EventArgs e)

{

ss.Pause();

}

private void btnContinue_Click(object sender, EventArgs e)

{

ss.Resume();

}

private void btnLoad_Click(object sender, EventArgs e)

{

OpenFileDialog ofd = new OpenFileDialog();

ofd.Filter = "Text files |*.txt";

ofd.ShowDialog();

string fname;

fname = ofd.FileName;

var sr = new System.IO.StreamReader(fname);

Txtmsg.Text = sr.ReadToEnd();

sr.Close();

}

private void btnExit_Click(object sender, EventArgs e)

{

Application.Exit();

}

private void btnRecord_Click(object sender, EventArgs e)

{

SaveFileDialog sfd = new SaveFileDialog();

sfd.Filter = "wave Files |*.wav";

sfd.ShowDialog();

String fname;

fname = sfd.FileName;

//SpeechSynthesizer ss = new SpeechSynthesizer();

ss.Rate = TraceBarSpeed.Value;

ss.Volume = TrackBarVolume.Value;

ss.SetOutputToWaveFile(fname);

ss.Speak(Txtmsg.Text);

ss.SetOutputToDefaultAudioDevice();

MessageBox.Show("Text Recorded as voice", "conform");

}