Asp dot net gyan ganga

Open new window with size and hide titlebar

2009-09-17T00:15:00.000-07:00

sName="Prabhat";
string newUrl = "test.aspx?Name=" + sName;
string javaScript = "window.open('" + newUrl + "');";
Response.Write("<script language=javascript>window.open('" + newWindowUrl + "',null,'height=410,width=450,status=0,toolbar=no,menubar=no,location=no,titlebar=no')<script>");

Deployment of Asp.net web application without source code

2009-06-26T03:07:00.000-07:00

In order to precompile your web application you need to use a Visual Studio command prompt .
and then use this .......
aspnet_compiler -p {Path of website to compile} -v / {Path of website after compilation}
e.g -
aspnet_compiler -p C:\Website -v / C:\PrecompiledWebsite

Confirm message box in asp.net

2009-06-03T04:30:00.000-07:00

// Call this method on button in html source.

onclientclick="return confirm('You sure you want to delete the record?');"

Insert value in sql server using stored procedure and output parametter

2009-04-02T05:58:00.000-07:00

SqlParameter[] Param = new SqlParameter[2];

Param[0] = new SqlParameter("@ParentId", lblSponsorID.Text.Trim().ToString());
Param[1] = new SqlParameter("@LRPosition", iposition);
Param[2] = new SqlParameter("@OutEG_ID", SqlDbType.Decimal);
Param[2].Direction = ParameterDirection.Output;

Boolean bflag = objExecuteSQLClass.dbAddUpdateParSP(Param, "InsertMemberDetails");

if (Param[2].Value != null)
{
string aa = Param[2].Value.ToString();
}

All database Function Class

2009-01-12T02:04:00.000-08:00

Just copy and past all function in C# class. and save as clsConnection.cs in App_Code folder.

public String gSqlConnectionString = ConfigurationManager.AppSettings["gConnectionString"];
public SqlConnection gSqlConnection;
public SqlCommand gSqlCommand;
public DataSet gDataSet;
public SqlDataReader gSqlDataReader;
public SqlDataAdapter gSqlDataAdapter;
public DataTable gDataTable;
public Boolean bIsExists;
public String sID;

public void chkConnection()
{
if (gSqlConnection != null)
{
gSqlConnection.Close();
}

if (gSqlDataReader != null)
{
gSqlDataReader.Close();
}

}

public void dbUpdate(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gSqlCommand = new SqlCommand(v_sSql, gSqlConnection);
gSqlConnection.Open();
gSqlCommand.ExecuteNonQuery();
gSqlConnection.Close();
}

public DataSet dbGetDateSet(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gDataSet = new DataSet();
gSqlDataAdapter = new SqlDataAdapter(v_sSql, gSqlConnection);
gSqlDataAdapter.Fill(gDataSet);
return gDataSet;
}

public DataTable dbGetDataTable(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gDataTable = new DataTable();
gSqlDataAdapter = new SqlDataAdapter(v_sSql, gSqlConnection);
gSqlDataAdapter.Fill(gDataTable);
return gDataTable;
}

public Boolean dbCheckData(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gSqlCommand = new SqlCommand(v_sSql, gSqlConnection);
gSqlConnection.Open();
gSqlDataReader = gSqlCommand.ExecuteReader();
if (gSqlDataReader.Read())
{
bIsExists = true;
}
else {
bIsExists = false;
}
gSqlDataReader.Close();
gSqlConnection.Close();
return bIsExists;
}

public string dbGetID(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gSqlCommand = new SqlCommand(v_sSql, gSqlConnection);
gSqlConnection.Open();
gSqlDataReader = gSqlCommand.ExecuteReader();
sID = string.Empty;
if (gSqlDataReader.Read())
{
sID = gSqlDataReader.GetValue(0).ToString();
}
gSqlDataReader.Close();
gSqlConnection.Close();
return sID;
}

Execute Procedures Class

2009-01-12T01:53:00.000-08:00

This class have two procedure . both are used in insert, update and delete oeration.
First one function is used to perform insert, update and delete oeration.
second function is used to perform insert, update and delete oeration and return selected table.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

///

/// Summary description for clsExecuteProcedures
///

public class clsExecuteProcedures
{
clsConnection conn = new clsConnection(); // connection class object
int iSizeParam;
int iCount;

public bool dbUpdate(SqlParameter[] v_arrParam, string v_sStoredProcedure,bool v_bIsExecute)
{
try
{
conn.gSqlConnection = new SqlConnection(conn.gSqlConnectionString);
conn.gSqlConnection.Open();
conn.gSqlCommand = new SqlCommand(v_sStoredProcedure, conn.gSqlConnection);
conn.gSqlCommand.CommandType = CommandType.StoredProcedure;

iSizeParam = v_arrParam.Length;

for (iCount = 0; iCount < iSizeParam; iCount++)
{
conn.gSqlCommand.Parameters.Add(v_arrParam[iCount]);
}

conn.gSqlCommand.ExecuteNonQuery();
conn.gSqlConnection.Close();

v_bIsExecute = true;
return v_bIsExecute;
}
catch
{
v_bIsExecute = false;
return v_bIsExecute;
}
}

// this function return select value from the database.
public DataTable dbUpdateReturnId(SqlParameter[] v_arrParam, string v_sStoredProcedure)
{
try
{
conn.gDataTable = new DataTable();
conn.gSqlDataAdapter = new SqlDataAdapter();
conn.gSqlConnection = new SqlConnection(conn.gSqlConnectionString);
conn.gSqlConnection.Open();
conn.gSqlCommand = new SqlCommand(v_sStoredProcedure, conn.gSqlConnection);
conn.gSqlCommand.CommandType = CommandType.StoredProcedure;

iSizeParam = v_arrParam.Length;
for (iCount = 0; iCount < iSizeParam; iCount++)
{
conn.gSqlCommand.Parameters.Add(v_arrParam[iCount]);
}

conn.gSqlDataAdapter.SelectCommand = conn.gSqlCommand;
conn.gSqlDataAdapter.Fill(conn.gDataTable);
conn.gSqlConnection.Close();
}
catch
{

return conn.gDataTable;

}
return conn.gDataTable;
}
}

Reading a text file to a remote PC

2009-01-12T01:41:00.000-08:00

Put a file upload control in your page give id like "FileUpload1".
create a folder in your application like "TxtFile" folder name.
First save file in folder and then read the file
after reading delete the file.

StreamReader sr;
string sfileExtension = System.IO.Path.GetExtension(sFileName);
string sFileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.PostedFile.SaveAs(Server.MapPath("TxtFile") + "\\" + sFileName);

try
{
sr = new StreamReader(Server.MapPath("TxtFile") + "\\" + sFileName);

StringBuilder NameList = new StringBuilder();
NameList.Append(sr.ReadToEnd());
string info = NameList.ToString();
sr.Close();
File.Delete(Server.MapPath("TxtFile") + "\\" + sFileName);
}
catch (Exception ex)
{
Response.Write("File Reading Failed Due to : " + ex.Message.ToString());
}

Character limit on a multi line text box

2008-07-29T14:18:00.000-07:00

//Write code on page load event

TextBox1.Attributes.Add("onkeydown", "return checkcharacter(this,50)");

//write javascript function between head section on html page

<script language="javascript">
function checkcharacter(txt,maxLen){
try{
if(txt.value.length > (maxLen-1))
return false;
else if( txt.value.length == (maxLen-1))
alert('you can enter only 50 character !!!!!!!! ');
}
catch(e){
}}
</script>

Delete multiple record from gridview by single database interaction

2008-07-11T15:47:00.000-07:00

//write code on page load
if (!IsPostBack)
{
binddata();
}

// Bind Function

public void binddata()
{
string strSql = " select * from test_test";
ds1 = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(strSql, con);
adp.Fill(ds1, "aa");
GridView1.DataSource = ds1.Tables[0];
GridView1.DataBind();
}

// write code in button click

StringBuilder store_id = new StringBuilder();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox c = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (c.Checked)
{
store_id.Append(GridView1.Rows[i].Cells[1].Text+"','");
}
}
string c_id = store_id.ToString();
string ss = "delete from test_test where c_id in ('"+c_id+"')";
SqlCommand cmd = new SqlCommand(ss,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
binddata();

query for Select current week values from table in sql server 2000

2008-06-20T03:57:00.001-07:00

SELECT * FROM test_test where c_date Between (SELECT (DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0))) AND(SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 6))

Select date from calender control and show in text box

2008-06-18T03:10:00.000-07:00

// write code in Calendar SelectionChanged event
protected void cdrCalendar_SelectionChanged(object sender, EventArgs e)
{
TextBox1.Text = cdrCalendar.SelectedDate.ToString("MM/dd/yyyy");
}

show selected checkbox value in text box in gridview

2008-06-10T03:05:00.000-07:00

//write code on button click
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox c = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (c.Checked)
{
string abc = "select * from candidate where c_id='" + GridView1.Rows[i].Cells[1].Text + "'";
SqlDataAdapter adp1 = new SqlDataAdapter(abc, con);
DataSet ds1 = new DataSet();
adp1.Fill(ds1, "aaa");
TextBox2.Text = ds1.Tables[0].Rows[0][1].ToString();
TextBox3.Text = ds1.Tables[0].Rows[0][2].ToString();
}
}

Default focus on submit button

2008-03-19T08:13:00.000-07:00

//write code on page load
Page.RegisterHiddenField("__EVENTTARGET", Button1.ClientID);

Code for select all checkbox in gridview on button click

2008-03-19T07:57:00.000-07:00

for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox ca = (CheckBox)GridView1.Rows[i].FindControl("chkSelect");
ca.Checked = true;
}

Select check box and delete values from Gridview

2008-02-13T14:20:00.000-08:00

for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox c = (CheckBox)GridView1.Rows[i].FindControl("chkSelect");
if (c.Checked)
{
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "delete from inbox where mail_id='" + GridView1.Rows[i].Cells[1].Text + "'";
con.Open();
cmd.ExecuteNonQuery();
con.Close();
BindData();
}
}