To run Sql script in C#

To run sql script in C# and the script is executed at the back end. Use a File upload control in the apsx page with button.
 protected void UploadButton_Click(object sender, EventArgs e)
 {
 if (FileUpload1.HasFile)
 {
 try
 {
 string filename = Path.GetFileName(FileUpload1.FileName); FileUpload1.SaveAs(Server.MapPath("~/SQL/") + filename);
 string script = File.ReadAllText(Server.MapPath("~/SQL/") + filename);
 using (SqlConnection conn = new SqlConnection(CS))
 {
 SqlCommand sqlCmd = new SqlCommand(script, conn);
 conn.Open();
 Server server = new Server(new ServerConnection(conn)); server.ConnectionContext.ExecuteNonQuery(script);
 StatusLabel.Text = "Upload status: "+filename+" is uploaded successfully!";
 }
 }
 catch (Exception ex)
 {
 StatusLabel.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
 }
 }
 }

SpinningImage in Windows appln

Hi,
We need to create this class file
public partial class ImageRotator
{
Image img=null;
public bool Rotate(RotationType type, string path)
{
try
{

FileStream fs1 = new FileStream(path, FileMode.Open, FileAccess.Read);
img = Image.FromStream(fs1);
img.Save(AppDomain.CurrentDomain.BaseDirectory + "output1.bmp", ImageFormat.Bmp);
fs1.Close();
fs1.Dispose();
// File.Delete(path);
ImageCodecInfo usedIC = this.GetEncoderInfo("image/bmp");
Encoder encoder = Encoder.Quality;
EncoderParameters encparams = new EncoderParameters(1);
EncoderParameter encparam = new EncoderParameter(encoder, (long)100);
encparams.Param[0] = encparam;
Image test = Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + "output1.bmp");
img.Dispose();
img = null;
if (type == RotationType.Rotate90)
test.RotateFlip(RotateFlipType.Rotate90FlipNone);
else if (type == RotationType.Rotate180)
test.RotateFlip(RotateFlipType.Rotate180FlipNone);
else if (type == RotationType.Rotate270)
test.RotateFlip(RotateFlipType.Rotate270FlipNone);
test.Save(AppDomain.CurrentDomain.BaseDirectory + "output1.bmp", usedIC, encparams);
// File.Delete(AppDomain.CurrentDomain.BaseDirectory + "cute1.jpg");
// usedIC = this.GetEncoderInfo("image/jpeg");
test.Save(path, usedIC, encparams);
File.Delete(AppDomain.CurrentDomain.BaseDirectory + "output1.bmp");
GC.Collect();

}

catch { }
{
return false;
}
}
private ImageCodecInfo GetEncoderInfo(string p)
{
ImageCodecInfo[] encoders = ImageCodecInfo.GetImageEncoders();
foreach (ImageCodecInfo codecInfo in encoders)
{
if (codecInfo.MimeType == p)
return codecInfo;
}
return null;
}
}
We need RotationType class file,
public enum RotationType
{
Rotate90,
Rotate180,
Rotate270
}

Create UserControl using this code,
public partial class SpinningImage : UserControl
{
private Boolean completeImage = true;
private static Single angle = 0;
double dw;
double dh;
Image img = null;
Image resizedImage = null;
public SpinningImage()
{
InitializeComponent();
SetStyle(ControlStyles.AllPaintingInWmPaint, true);
SetStyle(ControlStyles.UserPaint, true);
SetStyle(ControlStyles.DoubleBuffer, true);
}
private string imgPath;

public string ImagePath
{
get { return imgPath; }
set { imgPath = value; }
}

public void setImage()
{

//InitializeComponent();
FileStream fs1 = new FileStream(imgPath, FileMode.Open, FileAccess.Read);
img = Image.FromStream(fs1);
fs1.Close();
fs1.Dispose();
dw = pictureBox1.Width;
dh = pictureBox1.Height;
resizedImage = (Image)QDOES.ImageOptimizer.ResizeToMaxSize(img, dw, dh, 96, 96);

}
public void startTimer()
{ if (completeImage == true)
{
if (enableTimer())
{
pictureBox1.Width = (int)dh;
pictureBox1.Height = (int)dw;
dw = pictureBox1.Width;
dh = pictureBox1.Height;

timer1.Start();
timer1.Interval = 10;

pictureBox1.Refresh();
}
}
}

private void timer1_Tick(object sender, EventArgs e)
{



completeImage = false;
// angle = 0;
angle += 1;

if ((angle >= 0) && (angle < 90))
{
angle++;
}
else if ((angle >= 90) && (angle < 180))
{
if (angle < 180)
angle++;
}
else if ((angle >= 180) && (angle < 270))
{
if (angle < 270)
angle++;
}
else if ((angle >= 270) && (angle < 360))
{
if (angle < 360)
angle++;
}
if (angle == 90)
{
timer1.Stop();completeImage = true;
SaveImage();
}
else if (angle == 180)
{
timer1.Stop();completeImage = true;
SaveImage();
}
else if (angle == 270)
{
timer1.Stop();completeImage = true;
SaveImage();
}
else if (angle == 360)
{
SaveImage();
timer1.Stop(); completeImage = true;
angle = 0;
}
pictureBox1.Invalidate();
}

public bool enableTimer()
{
//string inputPath = AppDomain.CurrentDomain.BaseDirectory + "cute1.jpg";
timer1.Enabled = true;
//timer1.Start();
/* ImageRotator ir = new ImageRotator();
if (String.IsNullOrEmpty(imgPath))
throw new ArgumentException("Invalid input image path.");
if (!File.Exists(imgPath))
throw new FileNotFoundException("Input file not find.");
if (imgPath != null)
{
return ir.Rotate(RotationType.Rotate90, imgPath);
}*/
return false;
}
public void SaveImage()
{
ImageRotator ir = new ImageRotator();
if (String.IsNullOrEmpty(imgPath))
throw new ArgumentException("Invalid input image path.");
if (!File.Exists(imgPath))
throw new FileNotFoundException("Input file not find.");
if (imgPath != null)
{
ir.Rotate(RotationType.Rotate90, imgPath);
}
}
private void pictureBox1_Paint(object sender, PaintEventArgs e)
{
//resizedImage = (Image)QDOES.ImageOptimizer.ResizeToMaxSize(img, dw, dh, 96, 96);
if(resizedImage !=null)
{
Bitmap bm = new Bitmap((int)dw, (int)dh);
Graphics g = Graphics.FromImage((Image)bm);
g.DrawImage(resizedImage, new Rectangle((bm.Width - resizedImage.Width) / 2, (bm.Height - resizedImage.Height) / 2, resizedImage.Width, resizedImage.Height), new Rectangle(0, 0, resizedImage.Width, resizedImage.Height), GraphicsUnit.Pixel);
resizedImage = (Image)bm;
TextureBrush tex = new TextureBrush(resizedImage, WrapMode.Clamp);
float x = (float)dw / 2;
float y = (float)dh / 2;
tex.TranslateTransform(-x, -y);
tex.RotateTransform(angle, MatrixOrder.Append);
tex.TranslateTransform(x, y, MatrixOrder.Append);
e.Graphics.FillRectangle(tex, e.ClipRectangle);
}
}
}


This will give u the spinning effect

To load data in dropdownlist

Hi,

Using the following code, you can load the data in dropdownlist and make the desired value selected in the dropdown list while loading.

clientDropDownList.DataSource = client;
clientDropDownList.DataTextField = "ClientName";
clientDropDownList.DataValueField = "ClientID";
clientDropDownList.Items.Insert(0, new ListItem("select", "0"));
clientDropDownList.DataBind();
clientDropDownList.Items.FindByText(clientList.ClientName).Selected = true;

To create Dynamic DataTable and display in GridView

Hi,
We can create DataTable dynamically and display the content either in GridView or DataList or in Repeater.

DataTable dataTable = new DataTable();
DataRow dataRow;
dataTable.Columns.Add(new DataColumn("Title", typeof(string)));
dataTable.Columns.Add(new DataColumn("Description", typeof(string)));
dataTable.Columns.Add(new DataColumn("Author", typeof(string)));
if (_post != null)
{
dataRow = dataTable.NewRow();
dataRow[0] = _post.Title;
dataRow[1] = _post.Description;
dataRow[2] = _user.DisplayName;
dataTable.Rows.Add(dataRow);
}

myDataList.DataSource = dataTable;
myDataList.DataBind();

To Convert HTML Text to Normal Text

Hi,

If you want to remove the html tag from the text and replace as normal text use the following coding in Javascript.
using System.Text.RegularExpressions;

private string StripTags(string HTML)
{
// Removes tags from passed HTML
Regex objRegEx = new Regex("<[^>]*>");
return objRegEx.Replace(HTML, "");
}

To avoid overflow of div without using overflow:hidden

Hi,
If you are using div. Sometimes the div may overflow in IE6 browser.This is due to nesting of various div.So check the div top position.If u find placing of any div, overflows the existing div. Plz change the top to margin-top property to avoid overflow of particular div.

Refresh() method in Windows Application

Hi,
Refresh() -Forces the control to Invalidate its client area and Immediately redraw itself and its child control.

we can use either Refresh() or invalidate() methods to redraw the client area with the updated position. If you want to drag an image inside the picturebox,you must use any one of these methods.