Smart Coder

Thursday, January 27, 2011

All Important Code

---------

/* Get Machine Name (MachineName)*/

string MchName=System.Environment.MachineName.ToString();

/* Get Operation System (OSVersion)*/
string OsVersion = System.Environment.OSVersion.ToString();

/* Get Machine UserName (UserName)*/
string UName = System.Environment.UserName.ToString();

-------
/* SharePoint Tutorial */

http://www.deitel.com/ResourceCenters/Software/SharePoint/Tutorials/tabid/2783/Default.aspx

________

http://www.queness.com/post/356/create-a-vertical-horizontal-and-diagonal-sliding-content-website-with-jquery

_________________

File upload
--------

try
{
if (Updfile.FileName.Length > 0)
{
a = Updfile.FileName.Split('.');
fileName = Convert.ToString(System.DateTime.Now.Ticks) + "." + a.GetValue(1).ToString();
FilePath = Server.MapPath(@"~\MDAFile");
Updfile.SaveAs(FilePath + @"\" + fileName);
//if (strMode == "EDIT")
//{
// File.Delete(FilePath + @"\" + hdFile.Value);
//}
}
else
{
fileName = hdFile.Value;
}
}
catch
{
fileName = hdFile.Value;
}

___________________________

Work Log

1.Enable auto post back to work in selected index change.
2.Session: Session["Mode"] = "0";

Why use Sp?
a. It works/executes fast as it is in precompiled mode.
b. As it is in the database so if the BL gets leaked there is no chance of leaking the database… so security..

Query String..
Put this code to your submit button event handler.
private void btnSubmit_Click(object sender, System.EventArgs e)
{
Response.Redirect("Webform2.aspx?Name=" +
this.txtName.Text + "&LastName=" +
this.txtLastName.Text);
}
Put this code to second page page_load.
private void Page_Load(object sender, System.EventArgs e)
{
this.txtBox1.Text = Request.QueryString["Name"];
this.txtBox2.Text = Request.QueryString["LastName"];
}

To view a date in a gridview frm table.

To fetch a int data from a gridview select event….
Convert.ToInt32(gvEmp.SelectedRow.Cells[1].Text);

RegEx
Numeric- “\d+\.?\d*”
Email- "\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
Fileuploader=".*(\.txt|\.TXT)$"
String
String two =3D "12";
Int one =3D int.Parse(two.Substring(0,1));
Int two =3D int.Parse(two.Substring(1,1));
Int both =3D int.Parse(two.Substring(0,2));

Work with date time
DateTime tmp=Convert.ToDateTime(dr.ItemArray.GetValue(2));
txtYear.Text = tmp.Year.ToString();
ddlDay.SelectedIndex = Convert.ToInt32(tmp.Day.ToString())-1;
ddlMonth.SelectedIndex = Convert.ToInt32(tmp.Month.ToString()-1);

Using the Regex Class

Add a using statement to reference the System.Text.RegularExpressions namespace.
Call the IsMatch method of the Regex class, as shown in the following example.
// Instance method:
Regex reg = new Regex(@"^[a-zA-Z'.]{1,40}$");
Response.Write(reg.IsMatch(txtName.Text));

// Static method:
if (!Regex.IsMatch(txtName.Text,
@"^[a-zA-Z'.]{1,40}$"))
{
// Name does not match schema
}

Making a CheckAll functionality
To add a check-all functionality in the GridView, simply add a HTML CheckBox to the header template of the checkbox column.

runat="server" type="checkbox" />

SelectAllCheckboxes JavaScript method:

Show Data in formated way data [format{0:dd-MMM-yyyy}] in greidview

Declare a boolean column

CAST('True' AS bit) AS L

Regex for 0, decimal, integer…
^[0-9.\d+]{1,40}$

GET GRIDVIEW ROW
GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int CustId = Convert.ToInt32(GvDisp.DataKeys[row.RowIndex].Value.ToString());

OFFLINE DATATABLE SORTING AND SAVING
dataview v=dt.defaultview;
v.sort="columnName DESC";
dt=v.toTable();

TRY CATCH IN SQL SERVER
BEGIN TRY
BEGIN TRAN
SELECT * FROM Advertisement
COMMIT TRANSACTION

END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() ErrorNBR, ERROR_SEVERITY() Severity,
ERROR_LINE () ErrorLine, ERROR_MESSAGE() Msg
ROLLBACK TRANSACTION
END CATCH

Getting password in edit

txtPassword.Text = ManagePassword.strDecrypt(objUsr.Password, "vtpl2006", "vtpl2009");
ViewState["MyPassword"] = txtPassword.Text;
txtPassword.Attributes.Add("value", ViewState["MyPassword"].ToString());

lblPrice.Text = String.Format("{0:c}", price);
lblTime.Text = String.Format("{0:T}", rightNow);
lblDate.Text = String.Format("{0:d}", rightNow);
lblBigInt.Text = String.Format("{0:#,###}", bigNumber);

For editing a password field

txtPassword.Text = ManagePassword.strDecrypt(objUsr.Password, "vtpl2006", "vtpl2009");
ViewState["MyPassword"] = txtPassword.Text;
txtPassword.Attributes.Add("value", ViewState["MyPassword"].ToString());

public string ConvertSize ( decimal ip )
{
decimal op = ip / 1024;
string strUnit = "";

if ( ip >= 1073741824 )
{
op = ip / 1073741824;
strUnit = "GB";
}
else if ( ip >= 1048576 )
{
op = Convert.ToDecimal ( ip / 1048576 );
strUnit = "MB";
}
else if ( ip >= 1024 )
{
op = Convert.ToDecimal ( ip / 1024 );
strUnit = "KB";
}
else if ( ip > 0 )
{
op = ip;
strUnit = "Bytes";
}
else
{
op = 0.00M;
strUnit = "0";
}

return op.ToString (

SEND MAIL
public void ExecuteHtmlSendMail(string FromAddress, string ToAddress, string BodyText, string Subject)
{
MailMessage mailMsg = new MailMessage();
mailMsg.From = new MailAddress(FromAddress);
mailMsg.To.Add(new MailAddress(ToAddress));
mailMsg.Subject = Subject;
mailMsg.BodyEncoding = System.Text.Encoding.GetEncoding(”utf-8?);
System.Net.Mail.AlternateView plainView = System.Net.Mail.AlternateView.CreateAlternateViewFromString
(System.Text.RegularExpressions.Regex.Replace(BodyText, @”<(.|\n)*?>”, string.Empty), null, “text/plain”);
System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(BodyText, null, “text/html”);
mailMsg.AlternateViews.Add(plainView);
mailMsg.AlternateViews.Add(htmlView);
// Smtp configuration
SmtpClient smtp = new SmtpClient();
smtp.Host = “smtp.gmail.com”;
smtp.Credentials = new System.Net.NetworkCredential(”username”, “password”);
smtp.EnableSsl = true;
smtp.Send(mailMsg);
}
Read Word Doc
protected void Page_Load(object sender, EventArgs e)
{
Microsoft.Office.Interop.Word.ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
object file = "D:\\test1.doc"; // Specify path for word file
object nullobj = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Word.Document doc = wordApp.Documents.Open(ref file, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj, ref nullobj);

Microsoft.Office.Interop.Word.Document doc1 = wordApp.ActiveDocument;
string mContent = doc1.Content.Text;

Response.Write(mContent);
}

Message Show
System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(PagerButtons), "Session Timeout", "alert('Your active session has been expired please login again')", true);

GET PRIVIOUS PAGE NAME
System.IO.Path.GetFileName(Request.ServerVariables["HTTP_REFERER"]) == "inbox_interests.aspx"

JAVASCRIPT NEW WINDOW
','','width=400,height=250,status=no,location=no,menubar=no,%20left=0,%20top=0,%20scrollbars=1');%20%20sub.parent.history.back();">

Javascript Message
With update panel
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript",
"alert('Registration Successfull')", true);

Without update panel
Page.ClientScript.RegisterStartupScript(this,this.GetType(), "alert", "alert('Registration Successfull')", true);

Return data from SP
SqlConnection conn=new SqlConnection();
conn.ConnectionString = @"Data Source=SERVER1\SQLEXPRESS;Initial Catalog=MarryAnNri;Persist Security Info=True;User ID=sa;Password=sa@1234;connection timeout = 2000";
SqlCommand cmd=new SqlCommand("spTest",conn);
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds=new DataSet();
da.Fill(ds);

__________________

/* Show different type of icon in grid view button */

DataView dv = new DataView();
vw_favourite objFav = new vw_favourite();
objFav.SqlLoad("select * from vw_favourite where UserId='" + ((UserDetails)Session["LoggedUserDetails"]).ID + "'");
dv = objFav.DefaultView;

GVFavourite.DataSource = dv;
GVFavourite.DataBind();
foreach (GridViewRow row in GVFavourite.Rows)
{
Label lbl = (Label)row.FindControl("lbl");
Image img = (Image)row.FindControl("imgBtn");
string filename = lbl.Text;
string ext = filename.Substring(filename.Length - 3);
if ( ext.ToLower() == "txt")
{
img.ImageUrl = "~/images/txt.png";//E:\LinearTech\images
}
else if (ext.ToLower() == "pdf")
{
img.ImageUrl = "~/images/pdf.jpg";
}
else if (ext.ToLower() == "doc")
{
img.ImageUrl = "~/images/doc_icon.jpg";
}
___________________________--

/* Graph Charts */

http://www.codeproject.com/KB/web-image/ZedGraphWebAp1.aspx

__________________

/* Mailing and SMS systems */

http://www.codeproject.com/KB/aspnet/EasySMTP_package.aspx
http://www.aspfree.com/c/a/ASP.NET/Creating-Your-Own-Online-Email-System-in-ASP-NET-2-0/

_________________

---------- search page----------------

---------------- google adsence---------------------

________________________

/* Charts , barchart, piechart */

http://www.amcharts.com/download

____________

/* Invoice Format */

http://www.vertex42.com/ExcelTemplates/excel-invoice-template.html

_____________

______________
/* Solving of IIS problem */

http://www.west-wind.com/weblog/posts/698097.aspx

_____________
/* important JavaScript */
http://www.dotnetspider.com/resources/Category545.aspx
______________

/* All column names with table name in another table */
/* It saves every column name with table name in dbo.translations, a new table */

SELECT t.name AS tableName,
SCHEMA_NAME(schema_id) AS [schema],
c.name AS columnName,
CAST(null as varchar(200)) as translation into dbo.translations
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
ORDER BY tableName
________________

What are the differences between stored procedure and functions in SQL Server 2000?
Answer

1) functions are used for computations where as procedures
can be used for performing business logic
2) functions MUST return a value, procedures need not be.
3) you can have DML(insert, update, delete) statements in a
function. But, you cannot call such a function in a SQL
query..eg: suppose, if u have a function that is updating a
table.. you can't call that function in any sql query.-
select myFunction(field) from sometable; will throw error.
4) function parameters are always IN, no OUT is possible
5) EXEC command can't be used inside a Function where it
can be used inside an sproc

_____________

/* SharePoint Tutorial */

http://www.deitel.com/ResourceCenters/Software/SharePoint/Tutorials/tabid/2783/Default.aspx
__________
http://forums.asp.net/p/1209470/2126993.aspx
---------------------------------------
TargetControlID="TextBox1"
WatermarkText="Type First Name Here"
WatermarkCssClass="watermarked" />
----------------------------------
http://www.codeproject.com/KB/aspnet/SendingSMS.aspx

http://forums.asp.net/t/1191703.aspx

--------------------------------
/* Regular Expressions */

ControlToValidate="txtName"
ErrorMessage="ID must be 6-10 letters."
ValidationExpression="[a-zA-Z]{6,10}" />

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

ControlToValidate="txtPWord"
ErrorMessage="Password must contain one of @#$%^&*/."
ValidationExpression=".*[@#$%^&*/].*" />
ControlToValidate="txtPWord"
ErrorMessage="Password must be 4-12 nonblank characters."
ValidationExpression="[^\s]{4,12}" />
------------------------

/* Google absence */

http://ctrlf5.net/?p=159

______________________________

/* Custom Control */

/* Scheduler, Gantt Chart */
http://www.codeproject.com/KB/custom-controls/schedule.aspx
http://demos.telerik.com/aspnet-ajax/scheduler/examples/webservice/defaultcs.aspx

___________________

/* Youtube */

Sunday, November 28, 2010

Bulk Inser in Sql from CSV

0 comments

/* CSV to SQL */
create table UserTable(
UserName varchar(50),
UserPassword varchar(50)
)

BULK
INSERT UserTable
FROM 'D:\Usertable.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
___________

[ Using Procedure ]
In Code behind
-------------

Dbconn.connection();

cmd = new SqlCommand("bulkinsert",Dbconn.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Path",SqlDbType.VarChar,50));
cmd.Parameters["@Path"].Value = FileUpload2.PostedFile.FileName;
cmd.ExecuteNonQuery();
----

Procedure
---------
CREATE Procedure [dbo].[bulkinsert]
@Path Varchar(50)
As
Declare @Str Varchar(2000)
Begin
Set @Str=''BULK INSERT waybill_register FROM ''
Set @Str=@Str+''''''''
Set @Str=@Str+@Path
Set @Str=@Str+''''''''
Set @Str=@Str+'' WITH (FIELDTERMINATOR = '''','''',ROWTERMINATOR = ''''\n'''')''
Exec(@Str)
End

Thursday, November 25, 2010

Important Link

0 comments

/* Free Text Box */

http://jhtmlarea.codeplex.com/

http://jhtmlarea.codeplex.com/releases/view/30759

_____________

/* Jquery Web control for asp.net */

http://dj.codeplex.com/

_____________
/* Jquery Chat */

http://aspnetjquerychat.codeplex.com/

__________

/* Jquery toolkit */

http://jquerytoolkit.codeplex.com/
_________________

/* Char using jquery */

http://www.codeproject.com/KB/webforms/ms-chart-with-jquery.aspx
__________

/* Jquery Image galery */

http://notesforgallery.codeplex.com/
_____________

/* Important DLL free Download */

http://dll.downloadatoz.com/

_______________

/* Telleric */

http://www.telerik.com/community/forums/aspnet/splitter/position-of-sliding-window-when-page-scrolls.aspx

___________

/* Image Slider */

http://mediaeventservices.com/blog/2007/11/15/ajax-image-gallery-powered-by-slideflow-like-cover-flow/

_________

/* Important Jquery */

http://docs.jquery.com/Tutorials:Live_Examples_of_jQuery

___________
/* Jquery for drag drop */

http://code.google.com/p/jsmarty/source/browse/trunk/samples/shared/scripts/jquery-ui-personalized-1.6rc2.js?r=444
_________

/* nicer swiping / ajax examples */

http://leodruker.theorydesign.ca/about/#2

http://visuallightbox.com/lightbox-mac-style-demo.html

http://nooshu.com/recreate-iphone-swipe-effect-using-jquery/
http://nooshu.com/explore/jquery-iphone-animation/
________

Monday, September 20, 2010

Important All Code

0 comments

/* SharePoint Tutorial */

http://www.deitel.com/ResourceCenters/Software/SharePoint/Tutorials/tabid/2783/Default.aspx

________

http://www.queness.com/post/356/create-a-vertical-horizontal-and-diagonal-sliding-content-website-with-jquery

_________________

File upload
--------

try
{
if (Updfile.FileName.Length > 0)
{
a = Updfile.FileName.Split('.');
fileName = Convert.ToString(System.DateTime.Now.Ticks) + "." + a.GetValue(1).ToString();
FilePath = Server.MapPath(@"~\MDAFile");
Updfile.SaveAs(FilePath + @"\" + fileName);
//if (strMode == "EDIT")
//{
// File.Delete(FilePath + @"\" + hdFile.Value);
//}
}
else
{
fileName = hdFile.Value;
}
}
catch
{
fileName = hdFile.Value;
}

___________________________

Work Log

1.Enable auto post back to work in selected index change.
2.Session: Session["Mode"] = "0";

Why use Sp?
a. It works/executes fast as it is in precompiled mode.
b. As it is in the database so if the BL gets leaked there is no chance of leaking the database… so security..

Query String..
Put this code to your submit button event handler.
private void btnSubmit_Click(object sender, System.EventArgs e)
{
Response.Redirect("Webform2.aspx?Name=" +
this.txtName.Text + "&LastName=" +
this.txtLastName.Text);
}
Put this code to second page page_load.
private void Page_Load(object sender, System.EventArgs e)
{
this.txtBox1.Text = Request.QueryString["Name"];
this.txtBox2.Text = Request.QueryString["LastName"];
}

To view a date in a gridview frm table.

To fetch a int data from a gridview select event….
Convert.ToInt32(gvEmp.SelectedRow.Cells[1].Text);

RegEx
Numeric- “\d+\.?\d*”
Email- "\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
Fileuploader=".*(\.txt|\.TXT)$"
String
String two =3D "12";
Int one =3D int.Parse(two.Substring(0,1));
Int two =3D int.Parse(two.Substring(1,1));
Int both =3D int.Parse(two.Substring(0,2));

Work with date time
DateTime tmp=Convert.ToDateTime(dr.ItemArray.GetValue(2));
txtYear.Text = tmp.Year.ToString();
ddlDay.SelectedIndex = Convert.ToInt32(tmp.Day.ToString())-1;
ddlMonth.SelectedIndex = Convert.ToInt32(tmp.Month.ToString()-1);

Using the Regex Class

Add a using statement to reference the System.Text.RegularExpressions namespace.
Call the IsMatch method of the Regex class, as shown in the following example.
// Instance method:
Regex reg = new Regex(@"^[a-zA-Z'.]{1,40}$");
Response.Write(reg.IsMatch(txtName.Text));

// Static method:
if (!Regex.IsMatch(txtName.Text,
@"^[a-zA-Z'.]{1,40}$"))
{
// Name does not match schema
}

Making a CheckAll functionality
To add a check-all functionality in the GridView, simply add a HTML CheckBox to the header template of the checkbox column.

runat="server" type="checkbox" />

SelectAllCheckboxes JavaScript method:

Show Data in formated way data [format{0:dd-MMM-yyyy}] in greidview

Declare a boolean column

CAST('True' AS bit) AS L

Regex for 0, decimal, integer…
^[0-9.\d+]{1,40}$

GET GRIDVIEW ROW
GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int CustId = Convert.ToInt32(GvDisp.DataKeys[row.RowIndex].Value.ToString());

OFFLINE DATATABLE SORTING AND SAVING
dataview v=dt.defaultview;
v.sort="columnName DESC";
dt=v.toTable();

TRY CATCH IN SQL SERVER
BEGIN TRY
BEGIN TRAN
SELECT * FROM Advertisement
COMMIT TRANSACTION

END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() ErrorNBR, ERROR_SEVERITY() Severity,
ERROR_LINE () ErrorLine, ERROR_MESSAGE() Msg
ROLLBACK TRANSACTION
END CATCH

Getting password in edit

txtPassword.Text = ManagePassword.strDecrypt(objUsr.Password, "vtpl2006", "vtpl2009");
ViewState["MyPassword"] = txtPassword.Text;
txtPassword.Attributes.Add("value", ViewState["MyPassword"].ToString());

lblPrice.Text = String.Format("{0:c}", price);
lblTime.Text = String.Format("{0:T}", rightNow);
lblDate.Text = String.Format("{0:d}", rightNow);
lblBigInt.Text = String.Format("{0:#,###}", bigNumber);

For editing a password field

txtPassword.Text = ManagePassword.strDecrypt(objUsr.Password, "vtpl2006", "vtpl2009");
ViewState["MyPassword"] = txtPassword.Text;
txtPassword.Attributes.Add("value", ViewState["MyPassword"].ToString());

public string ConvertSize ( decimal ip )
{
decimal op = ip / 1024;
string strUnit = "";

if ( ip >= 1073741824 )
{
op = ip / 1073741824;
strUnit = "GB";
}
else if ( ip >= 1048576 )
{
op = Convert.ToDecimal ( ip / 1048576 );
strUnit = "MB";
}
else if ( ip >= 1024 )
{
op = Convert.ToDecimal ( ip / 1024 );
strUnit = "KB";
}
else if ( ip > 0 )
{
op = ip;
strUnit = "Bytes";
}
else
{
op = 0.00M;
strUnit = "0";
}

return op.ToString (

SEND MAIL
public void ExecuteHtmlSendMail(string FromAddress, string ToAddress, string BodyText, string Subject)
{
MailMessage mailMsg = new MailMessage();
mailMsg.From = new MailAddress(FromAddress);
mailMsg.To.Add(new MailAddress(ToAddress));
mailMsg.Subject = Subject;
mailMsg.BodyEncoding = System.Text.Encoding.GetEncoding(”utf-8?);
System.Net.Mail.AlternateView plainView = System.Net.Mail.AlternateView.CreateAlternateViewFromString
(System.Text.RegularExpressions.Regex.Replace(BodyText, @”<(.|\n)*?>”, string.Empty), null, “text/plain”);
System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(BodyText, null, “text/html”);
mailMsg.AlternateViews.Add(plainView);
mailMsg.AlternateViews.Add(htmlView);
// Smtp configuration
SmtpClient smtp = new SmtpClient();
smtp.Host = “smtp.gmail.com”;
smtp.Credentials = new System.Net.NetworkCredential(”username”, “password”);
smtp.EnableSsl = true;
smtp.Send(mailMsg);
}
Read Word Doc
protected void Page_Load(object sender, EventArgs e)
{
Microsoft.Office.Interop.Word.ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
object file = "D:\\test1.doc"; // Specify path for word file
object nullobj = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Word.Document doc = wordApp.Documents.Open(ref file, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj,
ref nullobj, ref nullobj, ref nullobj, ref nullobj);

Microsoft.Office.Interop.Word.Document doc1 = wordApp.ActiveDocument;
string mContent = doc1.Content.Text;

Response.Write(mContent);
}

Message Show
System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(PagerButtons), "Session Timeout", "alert('Your active session has been expired please login again')", true);

GET PRIVIOUS PAGE NAME
System.IO.Path.GetFileName(Request.ServerVariables["HTTP_REFERER"]) == "inbox_interests.aspx"

JAVASCRIPT NEW WINDOW
','','width=400,height=250,status=no,location=no,menubar=no,%20left=0,%20top=0,%20scrollbars=1');%20%20sub.parent.history.back();">

Javascript Message
With update panel
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertScript",
"alert('Registration Successfull')", true);

Without update panel
Page.ClientScript.RegisterStartupScript(this,this.GetType(), "alert", "alert('Registration Successfull')", true);

Return data from SP
SqlConnection conn=new SqlConnection();
conn.ConnectionString = @"Data Source=SERVER1\SQLEXPRESS;Initial Catalog=MarryAnNri;Persist Security Info=True;User ID=sa;Password=sa@1234;connection timeout = 2000";
SqlCommand cmd=new SqlCommand("spTest",conn);
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds=new DataSet();
da.Fill(ds);

__________________

/* Show different type of icon in grid view button */

DataView dv = new DataView();
vw_favourite objFav = new vw_favourite();
objFav.SqlLoad("select * from vw_favourite where UserId='" + ((UserDetails)Session["LoggedUserDetails"]).ID + "'");
dv = objFav.DefaultView;

GVFavourite.DataSource = dv;
GVFavourite.DataBind();
foreach (GridViewRow row in GVFavourite.Rows)
{
Label lbl = (Label)row.FindControl("lbl");
Image img = (Image)row.FindControl("imgBtn");
string filename = lbl.Text;
string ext = filename.Substring(filename.Length - 3);
if ( ext.ToLower() == "txt")
{
img.ImageUrl = "~/images/txt.png";//E:\LinearTech\images
}
else if (ext.ToLower() == "pdf")
{
img.ImageUrl = "~/images/pdf.jpg";
}
else if (ext.ToLower() == "doc")
{
img.ImageUrl = "~/images/doc_icon.jpg";
}
___________________________--

/* Graph Charts */

http://www.codeproject.com/KB/web-image/ZedGraphWebAp1.aspx

__________________

/* Mailing and SMS systems */

http://www.codeproject.com/KB/aspnet/EasySMTP_package.aspx
http://www.aspfree.com/c/a/ASP.NET/Creating-Your-Own-Online-Email-System-in-ASP-NET-2-0/

_________________

---------- search page----------------

File Upload

0 comments

protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
try {
FileUpload1.SaveAs("C:\\Uploads\\" + FileUpload1.FileName);
Label1.Text = "File name: " +
FileUpload1.PostedFile.FileName + "
" +
FileUpload1.PostedFile.ContentLength + " kb
" +
"Content type: " +
FileUpload1.PostedFile.ContentType;
}
catch (Exception ex) {
Label1.Text = "ERROR: " + ex.Message.ToString();
}
else
{
Label1.Text = "You have not specified a file.";
}

Grid Check box

0 comments

protected void Button1_Click(object sender, EventArgs e)
{
Label lb1 = new Label();
CheckBox chk1 = new CheckBox();
foreach (GridViewRow grd in GridView1.Rows)
{
chk1 = (CheckBox)grd.FindControl("CheckBox1");
if (chk1.Checked == true)
{
lb1 = (Label)grd.FindControl("Label1");
}
TextBox1.Text = lb1.Text.ToString();
}
}

Grid View Check box with link button click

0 comments

CheckBox chk1;
for (int k = 0; k < gvPackageCourses.Rows.Count; k++)
{
chk1 = ((CheckBox)gvPackageCourses.Rows[k].Cells[2].FindControl("chkBoxCourses"));
chk1.Checked = false;
}
LinkButton sel = ((LinkButton)sender);int rowindex = Int32.Parse(sel.CommandArgument);

Label lblId;
vw_enqueryreg objvw = new vw_enqueryreg();
//objvw.FlushData();
objvw.LoadSql("select courseid from vw_enqueryreg where StudentId='"+rowindex+"'");
////objvw.Where.StudentId.Value = rowindex;
////objvw.Where.StudentId.Operator = VTPLfx.WhereParameter.Operand.Equal;////objvw.Query.Load();int rowno = objvw.DefaultView.ToTable().Rows.Count;
CheckBox chk;
for (int i = 0; i < gvPackageCourses.Rows.Count; i++)
{
chk = ((CheckBox)gvPackageCourses.Rows[i].Cells[2].FindControl("chkBoxCourses"));
//////if(objvw.DefaultView.ToTable().Rows[i][0]==)
for (int j = 0; j < rowno; j++)
{
lblId = ((Label)gvPackageCourses.Rows[i].Cells[0].FindControl("lblprimaryKey"));
long id = long.Parse(lblId.Text);
if (id.ToString() == objvw.DefaultView.ToTable().Rows[j][0].ToString())
{
chk.Checked = true;
}
}
//chk.Checked = true;
}
//int rowIndex = Int32.Parse(link1.CommandArgument);
//for (int i = 0; i < gvEnquiryList.Rows.Count; i++)//{
// int temp = Convert.ToInt32(gvEnquiryList.Rows[i].Cells[2].Text.ToString());
//}

Smart Coder

Thursday, January 27, 2011

All Important Code

Sunday, November 28, 2010

Bulk Inser in Sql from CSV

Thursday, November 25, 2010

Important Link

Monday, September 20, 2010

Important All Code

File Upload

Grid Check box

Grid View Check box with link button click

Total Pageviews

Blog Archive