C#: .Net WebForms

Working with 2 Datasets
DataSet ds1 = new DataSet(); ds1 = Dal.sp_vw_SelectTuristasMainData(); // ds1: UserID,SubType,tbxUsername,tbxPassword,tbxEmail,ddlDays,ddlMonths,ddlYears // ds2: UserID,SubType,tbxUsername,tbxPassword,tbxEmail,Birth DataSet ds2 = new DataSet(); ds2.Tables.Add("Users"); ds2.Tables["Users"].Columns.Add("UserID"); ds2.Tables["Users"].Columns.Add("SubType"); ds2.Tables["Users"].Columns.Add("tbxUsername"); ds2.Tables["Users"].Columns.Add("tbxPassword"); ds2.Tables["Users"].Columns.Add("tbxEmail"); ds2.Tables["Users"].Columns.Add("Birth"); DataRow dr2; int i = 0; foreach( DataRow dr1 in ds1.Tables["sp_vw_SelectTuristasMainData"].Rows ) { dr2 = ds2.Tables["Users"].NewRow(); dr2["UserID"] = dr1["UserID"].ToString(); dr2["SubType"] = dr1["SubType"].ToString(); dr2["tbxUsername"] = dr1["tbxUsername"].ToString(); dr2["tbxPassword"] = dr1["tbxPassword"].ToString(); dr2["tbxEmail"] = dr1["tbxEmail"].ToString(); dr2["Birth"] = dr1["ddlDays"].ToString() + "/" + dr1["ddlMonths"].ToString() + "/" + dr1["ddlYears"].ToString(); ds2.Tables["Users"].Rows.Add(dr2); i++; //dr1.ItemArray.GetValue(0) } this.DataGrid1.DataSource = ds2; this.DataGrid1.DataBind();

Convert an ArrayList to a StringArray
string[] SA = (string[])AL.ToArray(typeof(String));

Create an ArrayList from a DataReader Data
ArrayList AL = new ArrayList(); while( dr.Read() ) { AL.Add( dr["name"] ); }

Convert a StringArray to a Simple String
simpleString=null; // important!!! for( int i=0; i<SA.Length; i++ ) { if( i==SA.Length-1 ) { simpleString+= SA[i]; } else { simpleString+= SA[i] + ","; } }

NewsLetter Loop
ArrayList email = new ArrayList(); email.Add( "email1@somesite1.com"); email.Add( "email2@somesite2.com" ); email.Add( "email3@somesite3.com" ); IEnumerator myEnumerator = email.GetEnumerator(); while( myEnumerator.MoveNext() ) { //Response.Write( myEnumerator.Current ); //Response.Write( "<br>" ); MailMessage myMail = new MailMessage(); myMail.From = "someone@yoursite.com"; myMail.To = myEnumerator.Current.ToString(); myMail.Subject = "From: " + myMail.From; myMail.Body = "msg here"; myMail.BodyFormat = MailFormat.Html; string imgPath = Server.MapPath("someimg.jpg"); MailAttachment myAttach = new MailAttachment(imgPath); myMail.Attachments.Add(myAttach); SmtpMail.Send( myMail ); Response.Write( "Email sent to: " + myMail.To + "<br>" ); } // External emails don´t need smtp address

Generate CheckBoxes in RunTime
public class RuntimeCheckBoxes : Page { protected PlaceHolder PlaceHolder1; protected CheckBox cbx; private void Page_Load(object sender, System.EventArgs e) { for( int i=1; i<=5; i++ ) { cbx = new CheckBox(); cbx.CheckedChanged += new System.EventHandler(cbx_CheckedChanged); cbx.ID = i.ToString(); cbx.AutoPostBack = true; PlaceHolder1.Controls.Add(cbx); PlaceHolder1.Controls.Add(new LiteralControl("<p>")); } } protected void cbx_CheckedChanged(object sender, System.EventArgs e) { cbx = (CheckBox)sender; if( cbx.Checked == true ) { string s1 = cbx.ID.ToString(); Response.Write( s1 ); } } }

Create EventHandler for Buttons and LinkButtons in RunTime.
Hyperlink renders as an html link, so there´s no event handler for it
public class WebForm1 : System.Web.UI.Page { protected System.Web.UI.WebControls.PlaceHolder PlaceHolder1; private void Page_Load(object sender, System.EventArgs e) { LinkButton btn = new LinkButton(); btn.Text = "Click"; btn.Click += new EventHandler( MyMethod ); this.PlaceHolder1.Controls.Add( btn ); } private void MyMethod( object sender, System.EventArgs e ) { LinkButton btn = new LinkButton(); btn = (LinkButton)sender; btn.Text = "Cliked"; } }

Access permission to .aspx pages in Geckos via localhost
In IIS configure the site to allow Anonymous Access Properties / Directory Security / Authentication and AccessControl / Edit button

Create a Thumbnail
private void Page_Load(object sender, System.EventArgs e) { string strImgName = "Image.jpg"; //Output to Browser Screen : Original Sized System.Drawing.Image origImg = System.Drawing.Image.FromFile(Server.MapPath(strImgName)); //int w = origImg.Width; //int h = origImg.Height; Response.ContentType = "image/jpeg"; //origImg.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg); //Output to Browser Screen : Thumbnail Sized int intH = 63; int intW = 50; System.Drawing.Image thumbImg = origImg.GetThumbnailImage(intW, intH, null, new System.IntPtr()); Response.ContentType = "image/jpeg"; thumbImg.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg); origImg.Dispose(); thumbImg.Dispose(); }

Add / Remove FileExtention
using System.IO; // Add '.dcm' extention in Dicom files with no extention // private void AddRemoveFileExtention() { //string path = Path.GetFullPath("."); string path = @"C:\Inetpub\wwwroot\Folder"; DirectoryInfo pathDi = new DirectoryInfo( path ); // Has Files? // FileInfo[] fi = pathDi.GetFiles(); MessageBox.Show( fi.Length + " files" ); // Loop through files // foreach( FileInfo file in fi ) { if( file.Extension == "" ) { // Add .dcm Extention // file.MoveTo( file.FullName + ".dcm"); } } // Remove Extention : optional // //foreach( FileInfo file in fi ) //{ // if( file.Extension == ".dcm" ) // { // // Remove .dcm Extention // int ix = file.FullName.LastIndexOf(@".dcm"); // file.MoveTo( file.FullName.Substring(0,ix) ); // } //} }

Basic Usage of System.IO to Create and Check the Existence of Files and Folders
using System.IO; public class CreateCheckDirectoriesFiles : Page { private string path1, path2; private void Page_Load(object sender, System.EventArgs e) { path1 = Server.MapPath("."); path2 = Server.MapPath(".") + @"\MyFolder\"; Response.Write("Path1: " + path1); Response.Write("<br>"); Response.Write("Path2: " + path2); Response.Write("<p>"); Response.Write( "Directories:<br>" ); DirectoryInfo rootDi = new DirectoryInfo( path1 ); DirectoryInfo[] diArray = rootDi.GetDirectories(); foreach( DirectoryInfo dir in diArray ) { Response.Write( dir.Name ); Response.Write( "<br>" ); } DirectoryInfo di = new DirectoryInfo( path2 ); Response.Write( "<p>'MyFolder' Directory Exists? : " + di.Exists ); FileInfo[] fi = di.GetFiles(); Response.Write( "<br>'MyFolder' Directory Has Files? : " + fi.Length + " files" ); foreach(FileInfo fileInfo in fi) { string extention = fileInfo.Extension; } di = new DirectoryInfo( path2 ); DirectoryInfo subDir = di.CreateSubdirectory("MySubFolder"); Response.Write( "<p><font color='blue'>MySubFolder Created</font>" ); DirectoryInfo[] subDi = di.GetDirectories(); Response.Write( "<br>'MyFolder' Directory Has SubDirectories? : " + subDi.Length + " subdirectories" ); } }

Delete a Folder and all the contents inside of it
private void DeleteFolder() { string path = @"C:\...\SomeFolder\"; DirectoryInfo di = new DirectoryInfo( path ); if( di.Exists ) { di.Delete( true ); } }

Rename and Unrename files
using System.IO; public class RenameUnrename : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { //RenameImages(); // Add Prefix 1-1 UnRenameImages(); // Subtract Prefix 1-1 } private void RenameImages() { //Jpgs // DirectoryInfo di = new DirectoryInfo( @"c:\inetpub\wwwroot\ProjectNameHere" ); FileInfo[] fi = di.GetFiles(); if( fi.Length>0 ) { foreach( FileInfo fileInfo in fi ) { string extention = fileInfo.Extension; if( extention==".jpg" || extention==".JPG" ) { fileInfo.CopyTo( @"c:\inetpub\wwwroot\ProjectNameHere" +@"\"+ "1-1" +"_"+ fileInfo.Name ); fileInfo.Delete(); } } } //Dcms // di = new DirectoryInfo( @"c:\inetpub\wwwroot\ProjectNameHere\" ); fi = di.GetFiles(); if( fi.Length>0 ) { foreach(FileInfo fileInfo in fi) { string extention = fileInfo.Extension; if( extention==".dcm" || extention==".DCM" || extention=="" ) { fileInfo.CopyTo( @"c:\inetpub\wwwroot\ProjectNameHere\" +@"\"+ "1-1" +"_"+ fileInfo.Name ); fileInfo.Delete(); } } } } private void UnRenameImages() { //Jpgs // DirectoryInfo di = new DirectoryInfo( @"c:\inetpub\wwwroot\ProjectNameHere\" ); FileInfo[] fi = di.GetFiles(); if( fi.Length>0 ) { foreach(FileInfo fileInfo in fi) { string extention = fileInfo.Extension; if( extention==".jpg" || extention==".JPG" ) { int i = fileInfo.Name.ToString().IndexOf( "_" ); string s = fileInfo.Name.Remove(0,i+1); fileInfo.MoveTo( @"c:\inetpub\wwwroot\ProjectNameHere" +@"\"+ s ); } } } //Dcms // di = new DirectoryInfo( @"c:\inetpub\wwwroot\ProjectNameHere\" ); fi = di.GetFiles(); if( fi.Length>0 ) { foreach(FileInfo fileInfo in fi) { string extention = fileInfo.Extension; if( extention==".dcm" || extention==".DCM" || extention=="" ) { int i = fileInfo.Name.ToString().IndexOf( "_" ); string s = fileInfo.Name.Remove(0,i+1); fileInfo.MoveTo( @"c:\inetpub\wwwroot\ProjectNameHere" +@"\"+ s ); } } } } }

Upload a file to Access database
using System.Data.OleDb; using System.IO; public class Upload : Page { protected Button UploadBtn; protected HtmlInputFile UploadFile; private void UploadBtn_Click(object sender, System.EventArgs e) { //Get the file name HttpPostedFile currentFile = HttpContext.Current.Request.Files.Get(0); string imgName = Path.GetFileName( currentFile.FileName ); //note : UploadFile.PostedFile.FileName; //returns all path :( if(imgName != "") { //Get attributes from the UploadedFile //Stream imgStream = UploadFile.PostedFile.InputStream; int imgLen = UploadFile.PostedFile.ContentLength; byte[] imgBin = new byte[imgLen]; // Binary or Byte array of our data //int n = imgStream.Read(imgBin,0,imgLen); string imgConType = UploadFile.PostedFile.ContentType; if(imgLen <= 200000) { if( (imgConType == "image/gif") || (imgConType == "image/pjpeg") || (imgConType == "application/pdf") ) { try { OleDbConnection myCon = new OleDbConnection(); myCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\\\\inetpub\\wwwroot\\DataBase\\db01.mdb"; string mySql; mySql = "INSERT INTO Images (Bin,Name,ConType) "; mySql += "VALUES (?,?,?)"; OleDbCommand myCmd = new OleDbCommand(mySql,myCon); myCmd.Parameters.Add("@Bin", OleDbType.Binary).Value = imgBin; myCmd.Parameters.Add("@Name", OleDbType.VarChar, 50).Value = imgName; myCmd.Parameters.Add("@ConType", OleDbType.VarChar, 50).Value = imgConType;//example: image/gif or image/jpeg myCon.Open(); myCmd.ExecuteNonQuery(); myCon.Close(); Response.Write("Your image has been uploaded"); } catch (System.Exception ex) {Response.Write(ex.Message.ToString());} } else {Response.Write("Invalid Image Type");} } else {Response.Write("imgSize is larger than 200kb");} } else {Response.Write("No Image To Upload");} } } ... Get the file ... using System.Data.OleDb; public class View : Page { private void Page_Load(object sender, System.EventArgs e) { int ImgID = 140; string mySql = "SELECT * FROM Images WHERE Id = ?"; OleDbConnection myCon = new OleDbConnection(); myCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\\\\inetpub\\wwwroot\\DataBase\\db01.mdb"; OleDbCommand myCmd = new OleDbCommand(mySql, myCon); myCmd.Parameters.Add("@Id", OleDbType.Integer).Value = ImgID; myCon.Open(); OleDbDataReader myDr = myCmd.ExecuteReader(); if (myDr.Read() != false) { Response.BinaryWrite( (byte[]) myDr["Bin"] ); //Response.ContentType = myDr["Name"].ToString(); //Response.ContentType = myDr["ConType"].ToString(); } else { Response.Write("No Such Image In Db!"); } myCon.Close(); } }

Upload a file to a folder in the remote server
using System.IO; using System.Web.Caching; public class UploadFile_ToFolder : Page { protected LinkButton send; protected HtmlInputFile myFile; private string folderPath; private string imgName; private void send_Click(object sender, System.EventArgs e) { //Get the file name from the upLoad textField HttpPostedFile currentFile = HttpContext.Current.Request.Files.Get(0); imgName = Path.GetFileName(currentFile.FileName); //Concat the imgName + folderPath folderPath = @"C:\\inetpub\wwwroot\"; //Save img into folderPath currentFile.SaveAs(folderPath + imgName); // Cache file path ... needed for future file deletion Cache.Insert ( "cacheKey", folderPath + imgName, null, DateTime.Now.AddHours(1), Cache.NoSlidingExpiration ); } }

Upload an Image to SqlServer DataBase
/// <summary> /// Create a database UploadImgs /// Run this file ONCE to generate the Table /// http://aspfree.com/authors/123aspx/DBImagesCS/imageupload_csharp.asp /// </summary> public class CreateTable : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { SqlConnection myCon = new SqlConnection(); myCon.ConnectionString = "Data Source=KA;Database=UploadImgs;User ID=sa;Password=xxx;"; myCon.Open(); string mySql; mySql = "CREATE TABLE [dbo].[Images] ("; mySql += "[Id][int]IDENTITY(1,1)NOT NULL ,"; mySql += "[Name][varchar](50)NULL ,"; mySql += "[Data][image]NULL ,"; mySql += "[ConType][varchar](50)NULL)"; mySql += " ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]"; SqlCommand myCmd = new SqlCommand(mySql,myCon); myCmd.ExecuteNonQuery(); // This part is needed in order to the view_images from a Db to work! string mySql2; mySql2 = "ALTER TABLE [dbo].[Images] WITH NOCHECK ADD CONSTRAINT [Id] "; mySql2 += "PRIMARY KEY NONCLUSTERED ([Id]) ON [PRIMARY]"; SqlCommand myCmd2 = new SqlCommand(mySql2,myCon); myCmd2.ExecuteNonQuery(); myCon.Close(); } } ... Get the file ... using System.Data.SqlClient; public class View : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { //get the image id from the url //string imgId = Request.QueryString["id"]; string imgId = "1"; //build our query statement string mySql = "SELECT Data, ConType FROM Images WHERE Id = " + imgId; SqlConnection myCon = new SqlConnection(); myCon.ConnectionString = "Data Source=KA;Database=UploadImgs;User ID=sa;Password=xxx;"; //myCon.ConnectionString = "data source=localhost;initial catalog=UploadImgs;integrated security=SSPI;workstation id=sa;packet size=4096"; //myCon.ConnectionString = "User ID=sa;Password=xxx;Initial Catalog=UploadImgs;Data Source=KA;"; SqlCommand myCmd = new SqlCommand(mySql, myCon); //open the database and get a datareader myCon.Open(); SqlDataReader myDr = myCmd.ExecuteReader(); if (myDr.Read() != false) { Response.ContentType = myDr["ConType"].ToString(); Response.BinaryWrite( (byte[]) myDr["Data"] ); } else { Response.Write("No Such Image In Db!"); } myCon.Close(); } }

...

Hosted by www.Geocities.ws