.NET , ASP.NET , C# , VB.NET , MS SQL ....

Prevent showing more then one application instance C# WinForms

2010-12-07T11:22:00.000-08:00

Hi to all of you who came to my blog and use this infos that I wrote.
After some time spent with Android development and Java programming language I am back :)

I have one interested business project that I was done in C# for one big Bosnian Company .
In this project I needed to prevent starting more instances of my application .
I done this before but with some others technics now I use this:

I fund some this sample of code on the net and here it is :

1- we need to create one class in our project

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.InteropServices;

namespace ORI2010
{
   // this class just wraps some Win32 stuffthat we're going to use
   internal class NativeMethods
   {
   public const int HWND_BROADCAST = 0xffff;
   public static readonly int WM_SHOWME = RegisterWindowMessage("WM_SHOWME");
   [DllImport("user32")]
   public static extern bool PostMessage(IntPtr hwnd, int msg, IntPtr wparam, IntPtr lparam);
   [DllImport("user32")]
   public static extern int RegisterWindowMessage(string message);
   }
}

2- in Program.cs file in our WinForm project we need to put this code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;
using System.Threading;
using System.Runtime.InteropServices;
using ORI2010;

namespace Invlidi
{
   static class Program
   {
        static Mutex mutex = new Mutex(true, "{8F6F0AC4-B9A1-45fd-A8CF-72F04E6BDE8F}");
   [STAThread]
   static void Main()
   {
   if (mutex.WaitOne(TimeSpan.Zero, true))
   {
   Application.EnableVisualStyles();
   Application.SetCompatibleTextRenderingDefault(false);
   Application.Run(new Form1());
   mutex.ReleaseMutex();
   }
   else
   {
   // send our Win32 message to make the currently running instance
   // jump on top of all the other windows
   NativeMethods.PostMessage(
   (IntPtr)NativeMethods.HWND_BROADCAST,
   NativeMethods.WM_SHOWME,
   IntPtr.Zero,
   IntPtr.Zero);
   }
   }

   }
}

3- finally in our first and main app form we put this code:

   protected override void WndProc(ref Message m)
   {
   if (m.Msg == NativeMethods.WM_SHOWME)
   {
   ShowMe();
   }
   base.WndProc(ref m);
   }
   private void ShowMe()
   {
   if (WindowState == FormWindowState.Minimized)
   {
   WindowState = FormWindowState.Normal;
   }
   // get our current "TopMost" value (ours will always be false though)
   bool top = TopMost;
   // make our form jump to the top of everything
   TopMost = true;
   // set it back to whatever it was
   TopMost = top;
   }

Yes it is simply as you see here. Until some new post about Microsoft technology hello from me and my new friend Android :)

How to download trunk source code from http://code.google.com

2010-09-16T16:18:00.000-07:00

After a while I am here again. This time I'll give you a couple of information on how to download source code trunk from code.google.com .

First you need to install client software for checkout source code:

Here is one that I use http://tortoisesvn.net/downloads .

Let install it and all you need to do next is to copy your code.google.com trunk link .

and then open your Windows Explorer choose Folder make an right mouse click on it

and choose SVN Checkout and downloading start ;)

Sqlite & Asp.net C# Simple operation

2010-06-20T02:23:00.000-07:00

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. Think of SQLite not as a replacement for Oracle but as a replacement for fopen()
More about Sqlite HERE

This is what I need for a long time . Working with asp.net and database all the time I needed something like this . Before I was using office access but it is not good for the job I need to done.
After sometimes i found sqlite and now I star using it in my private , demo , test project . For now I am very satisfied with it:))

In this post I will show you simple operation with sqlite and asp.net :
Simple front design:

First we need to copy some line of code in our web config project file:

Second thing is that we need to import Sqlite.dll into our project (after we downloaded it) .
We do reference to Sqlite .dll after that we need to create one simple database which we can do with one of many sqlite managers :sqlitemanager

Next step is to import our database in project App_Data folder:
Then we need to write connection string :

After that we add some code instruction to add and delete values from our database :

Thats all folk's :))

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SQLite;

using System.Data.Common;

using System.Data;

using System.IO;

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

{

private SQLiteConnection sql_con;

private SQLiteCommand sql_cmd;

private SQLiteDataAdapter DB;

private DataSet DS = new DataSet();

private DataTable DT = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

LoadData();

}

private void SetConnection()

{

sql_con = new SQLiteConnection ("Data source="+HttpContext.Current.Server.MapPath("App_Data\\phone.sqlite")+";

Version=3;New=False;Compress=True;");

}

private void ExecuteQuery(string txtQuery)

{

SetConnection();

sql_con.Open();

sql_cmd = sql_con.CreateCommand();

sql_cmd.CommandText = txtQuery;

sql_cmd.ExecuteNonQuery();

sql_con.Close();

}

private void LoadData()

{

SetConnection();

sql_con.Open();

sql_cmd = sql_con.CreateCommand();

string CommandText = "SELECT * FROM phonebook";

DB = new SQLiteDataAdapter(CommandText, sql_con);

DS.Reset();

DB.Fill(DS);

DT = DS.Tables[0];

GridView1.DataSource = DT;

GridView1.DataBind();

sql_con.Close();

}

private void Add(string name,string number)

{

string txtSQLQuery = "insert into phonebook (name,number ) values ('" + name + "','"+number+"')";

ExecuteQuery(txtSQLQuery);

LoadData();

}

private void Delete(string name)

{

string txtSQLQuery = "delete from phonebook where name='" + name + "'";

ExecuteQuery(txtSQLQuery);

LoadData();

}

protected void Button1_Click(object sender, EventArgs e)

{

Add(TextBox1.Text, TextBox2.Text);

}

protected void Button2_Click(object sender, EventArgs e)

{

Delete(TextBox3.Text);

LoadData();

}

Simple using of AjaxControlToolkit in code behind C#

2010-05-25T11:08:00.000-07:00

In this short post I will show you using AjaxControlToolkit in code-behind .
I needed AjaxControlToolkit in my web site because of effects that I want to use on it.
So , I get AjaxControlToolkit from : http://www.asp.net/(S(fu2l2uzphr2u3u45q2dnez55))/ajax/AjaxControlToolkit/Samples/ and I add reference to AjaxControlToolkit dll in my web site project.

In picture above you can see a PanelIT to which I want to make some rounded corners and drop shadows

The code : In first part we need to made panel corners rounded , so I use this.FindControl() to find a panel control with name "pIt" to whom we will make our wished changes . After that we initialize a AjaxControlToolkit.RoundedCornersExtender and set the needed values to his properties and after that we add those AjaxControlToolkit.RoundedCornersExtender to our TargetControlID = "pIt" panel control.
In the next step we use  AjaxControlToolkit.DropShadowExtender initialization and settings a properties values and adding to TargetControlID = "pIt" .

   private void panelIt()
   {
   Panel p = (Panel)this.FindControl("pIt");//" + i.ToString());
   p.BackColor = Color.White;

   AjaxControlToolkit.RoundedCornersExtender r = new AjaxControlToolkit.RoundedCornersExtender();
   r.BorderColor = Color.Black;
   r.Corners = AjaxControlToolkit.BoxCorners.All;
   r.Radius = 5;
   r.TargetControlID = p.ID;
   this.Panel1.Controls.Add(r);

   AjaxControlToolkit.DropShadowExtender sh = new AjaxControlToolkit.DropShadowExtender();
   sh.TargetControlID = p.ID;
   sh.Rounded = true;
   sh.Width = 7;
   this.Panel1.Controls.Add(sh);

   }.

....our desired panel looks like this ....

VS2008 site running port and Eset Nod32 4.0 issue

2010-05-09T00:20:00.000-07:00

Recently I had a problem with my personal AV Nod32 version 4.0 . Problem was after we had usual everyday update and when I was try to start my web site project it show an "The page cannot be displayed" After some checking I saw that port where site was running is different then port in IE Url :$:

Then I use my special magic trick and ask the "Mighty Google" to show me successful path to solve my problem X:D

To solve it I excluded VS2008 from the active browser filtering - this is in: setup -> advanced firewall setup -> antivirus & anti spyware -> web access protection -> HTTP -> webbrowsers

Deselecting vsdev , devenv.exe in here fixed the problem - interestingly enough disabling the firewall and antivirus / antispyware did not solve the issue, so it is worth looking for a similar setting if you are running different security software:

Problem was exterminated successfully :))

Crystal reports change report field/cell font color with case/switch conditions

2010-04-13T10:56:00.000-07:00

Hi to all visitors of those magnificent blog :)) After some vacation and travelling (South France , Côte d'AzurI saw some beautiful sights and places ) I am back again here in Sarajevo (Bosnia & Herzegovina) and start with my ordinary life :)

In this post I will show you how to make some colorfull font result of crystal report cell according to value of some other cell.
First thing we need to add some cell (store procedure result columns or table columns ) on our crystal report.
Next , we need to make a right click on that cell/column and choose Format Field.

Next, we choose Font tab and in part color we click on marked button.

Last thing to do is to select Report Fields in opened windows and make some drag & drop of our conditional report field in bottom part of windows where we use our famouse case / switch command.

In code part here we check if those field conatains some of those values 2,1,0 we then change font color of selected report field/cell.

So, in final report we will see in this case PDF document some columns cells with Red,Blue,Black color results.

MSSQL return a single line value consisting of multiple rows of values

2010-02-25T09:08:00.000-08:00

In this post i'll show you how simple you can create one string value from multiple sql rows values.

In picture below we had some sql data table with 4 rows .

Now, our task is to create one single line string value from columns vorname and nachname:
so we use sql code :

We see on picture above code that we use to complete successfully our task :)

Copy code :

declare @str varchar(300)
select
@str = case
when @str is null
THEN vorname + ' '+nachname
else @str + ' , ' + vorname + ' '+nachname
end
FROM dbo.tbl_CorectNumber
WHERE (anrede ='Herr' )
SELECT @str

Read *.csv coma separated values file and insert it in mssql database C#

2010-01-29T11:08:00.000-08:00

Reading *.csv file values is very simple . I will show you in the next few lines :

   private void btnImportExcelToDb_Click(object sender, EventArgs e)
   {
   if (txtExcelPath.Text != "")
   {
   FileInfo f = new FileInfo(txtExcelPath.Text);
   if (f.Extension ==".csv" )
   {
   todb(numbers(txtExcelPath.Text));

   }
   else {
   MessageBox.Show( "File is not valid excel type!","WRONG FILE TYPE!",MessageBoxButtons.OK,MessageBoxIcon.Warning);
   }


   }
   }

in button event click I write check if the file that we read is file with *.csv extension and if so then I call 2 methodes that make magic :)

Method which I use for reading a values in string array of lines :

   private string[] numbers(string filepath)
   {
   string[] ar = null;
   try
   {

   using (StreamReader sr = new StreamReader(filepath))
   {
   String line;
   ar = sr.ReadToEnd().Split(new string[] { "\r\n" }, StringSplitOptions.None);

   }
   }
   catch (Exception e)
   {
   MessageBox.Show(e.Message);
   }
   return ar;
   }

"\r\n" this is line break string characters :

and after that I call another method todb(string[] ar)

a method that use string array as parameter

   private void todb(string[] ar)
   {
   con = new DataClasses1DataContext();

   int br = 0;
   for (int i = 1; i < ar.Length-1;i++ )
   {
   tbl_ImportedNumber t = new tbl_ImportedNumber();
   string[] li=ar[i].Split(';');

   t.anrede = li[0];
   t.vorname = li[1];
   t.nachname = li[2];
   t.strasse = li[3];
   t.plz = li[4];
   t.ort = li[5];
   t.gebdat = li[6];
   t.telefon0043 = li[7];
   t.telefon = li[8];
   t.land = li[9];
   t.date = DateTime.Now.Date;
   t.@checked = false;
   con.tbl_ImportedNumbers.InsertOnSubmit(t);
   con.SubmitChanges();
   br++;
   } lblCount.Text = br.ToString();
   }

in this method i read values from line and use a linq to store values in database :)
thats all code , any question ? Ask :)

Asp.net facebook share button on your site

2010-01-06T08:48:00.000-08:00

This is method which you can use when you want to add facebook share button on your web site.
I use some existing code from internet.

The code is simple you can see all on screen shoot. You need Label on page which I called here labelSteps_1_2 and method fbShare() to place her in Page_Load event of page :

Visual Studio 2010 and jQuery sample of using ...

2009-12-31T14:54:00.000-08:00

Hello and Happy New Year 2010 . Best wishes to all visitors of this most famous blog :) (Let's start New Year with joking )

This time I'll show you simple sample of "How to use jQuery in Visual Studio 2010 Beta 2".

First thing for all of you who did not get yet VS2010 Beta 2 , you can get it Visual Studio Beta 2 Download . I got for my self a Visual Studio 2010 Ultimate (.ISO) .

After you download and do install VS 2010 next thing you need is to download jQuery library jQuery Download.

I get a DEVELOPMENT (120KB, Uncompressed Code) version of file.

Next , we can start with excersise .

Start Visual studio IDE choos favorit IDE language / project settings after that we Choose File/New Web Site / Empty Web Site template.

Next we create a Folder where we will put our downloaded jQuery library, I name it "Scripts" and script library (first thing I must to do is to rename the downloaded jQuery.txt to jQuery.js file).

After that I add Web page to project Default.aspx page and put on two div and button .

In head of our html code I simple add reference to jQuery library file, and write little jQuery script:

This script we use for our demostration of using jQuery in VS2010 it is script that make toggleing a div on button click.

We create a page like this with div and image as background which doing a toggle show and hide on our button click

I think you can see all you need in provided screenshoots ... for 2009 year this is my last post .. bye :))

C# Using Linq to save image to SQL DB

2009-12-19T07:43:00.001-08:00

In this post I will show you "How to save Image to a sql db"

1. You need to create a database and table with column of image type:

2.Must add LINQ to SQL Classes into your project (Asp.net C# web project)

3.Drag & Drop your table onto this file

YOU CAN FOUND SAMPLES HOW TO USE LINQ IN ASP.NET
How to Linq & Visual Studio

4 . This is code that you need to inset image :

In Insert Button click event

protected void btnUnos_Click(object sender, EventArgs e)

{

vijesti v = new vijesti();

v.Id = Guid.NewGuid();

v.naslov = txtNaslov.Text;

v.link = txtLink.Text;

v.autor = this.User.Identity.Name;

v.datum = DateTime.Now.ToString();

v.slikaMala = ImgToDb(new FileInfo(Server.MapPath("~//NewsImages//mala.jpg")));

v.slikaSrednja = ImgToDb(new FileInfo(Server.MapPath("~//NewsImages//srednja.jpg")));

con.vijestis.InsertOnSubmit(v);

con.SubmitChanges();

}

private byte[] ImgToDb(FileInfo info)

{

byte[] content = new byte[info.Length];

FileStream imagestream = info.OpenRead();

imagestream.Read(content, 0, content.Length);

imagestream.Close();

return content;

}

Vijesti is my table name:

Image columns are slikaMala,slikaSrednja:

I use here one method ImgToDb

to which I sending a file info as a parameter (that is the image path)

do reading image to a byte[] array and and return as array after that calling

con.vijestis.InsertOnSubmit(v);

con.SubmitChanges();

and image is in ms sql database ;))

VS 2008 SP1 Toolbox doubling items problem ??

2009-12-13T02:21:00.000-08:00

Today I had some weird problem with my magnificent companion mighty Visual Studio 2008 SP1 . I run the VS and try to deploy one test page on my hosting space and found that VS toolbox had some problems :$ ? It happens that there were (I do not know exactly now )like 6 o 7 time doubled all item on it. (Weird) . So after little googleing I found solution :

You do not need to reinstall VS or do any other big changes . It will be enough to go to this place on your XP "C:\Documents and Settings\YourUsrName\Local Settings\Application Data\Microsoft\VisualStudio\9.0" and delete four toolbox.tbd files . After that start VS and go to the path You want to go :))

Reseting a toolbox :

Picture after deleting and starting VS again , it create new toolbox.tbd files :)

Get image from http URI to panel.Background

2009-11-26T09:50:00.000-08:00

C# : // Create the requests.

WebRequest requestPic = WebRequest.Create(picUri);

WebResponse responsePic = requestPic.GetResponse();

Image webImage = Image.FromStream(responsePic.GetResponseStream());

pnlMapa.BackgroundImage = webImage;

VB.NET :

' Create the requests.

Dim requestPic As WebRequest = WebRequest.Create(picUri)

Dim responsePic As WebResponse = requestPic.GetResponse()

Dim webImage As Image =

Image.FromStream(responsePic.GetResponseStream())

pnlMapa.BackgroundImage = webImage

With those few line of code you can very fast get any

Internet image in your (application web or windows) :

Open new IE page from code behind VB.NET , C#

2009-11-08T08:25:00.000-08:00

With those line you can manage to show new Internet explorer window, page from code behind in vb.net or C# .

There are javascript arguments that you can change for your needs :

Specified argument was out of the range of valid values. Parameter name: index

2009-10-25T10:52:00.000-07:00

Let's prevent this error message "

Specified argument was out of the range of valid values. Parameter name: index

I have a GridView with some columns and I need to hide one column with GUID number , column[1] . It's very easy to make this :) you only need to write this in GridView_RowDataBound event :

protected void gvClanovi_RowDataBound(object sender, GridViewRowEventArgs e)

{

e.Row.Cells[1].Visible = false;

}

, but when I Set GridView properties "AllowPaging = True " and try to run page it show me the Error! . So we need to make some changes and I done this:

Check with this line of code :

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

Event now looks like:

protected void gvClanovi_RowDataBound(object sender, GridViewRowEventArgs e)

{

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

{

e.Row.Cells[1].Visible = false;

}

That's all folk's ;)

C# get serial number of your PC motherboard

2009-10-14T10:57:00.000-07:00

In this post i will show how you can get your PC motherboard serial number. Btw . Those sort of information can be very useful when you need to create some protection generating a protection for your software product and similar things ;)

One important thing in this post you will need to add reference to System.Menagement dll

We need to add the :

using System.Management;

and in button click event next code:)

private void button1_Click(object sender, EventArgs e)

{

ManagementObjectSearcher MOS = new ManagementObjectSearcher("Select * From Win32_BaseBoard");

foreach (ManagementObject getserial in MOS.Get())

{

label1.Text="Your motherboard serial is : "+ getserial["SerialNumber"].ToString();

}

for the end of this post , I will like to said hello to one beautiful girl called Sandy ;)

VB.NET Hide Column DevExpress Code Behind

2009-10-09T14:32:00.000-07:00

We can hide a gridview column in Vb.net , code behind at gridview_RowCreated event:

This is sample where we can hide a fixed column ( here that is column 12) . You can make dynamically sending a desired column number :

Protected Sub gvRekonstrukcije_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvRekonstrukcije.RowCreated

e.Row.Cells(12).Visible = False

End Sub

Generate random number VB.NET function

2009-10-09T14:28:00.000-07:00

Simple function to generate an random number .

Private Function RandomNumber(min As Integer, max As Integer) As Integer
Dim random As New Random()
Return random.Next(min, max)
End Function

Show picture in PictureBox dynamically / programatically

2009-10-09T14:22:00.000-07:00

With those two lines you can dinamically / programmatically show an image in PictureBox

We need form with PictureBox control on it and one picture somewhere on the file system :

Bitmap bbb =new Bitmap(Image.FromFile("C:\\Code392.bmp"));

pictureBox3.Image = bbb;

Table to XML file C# MSSQL

2009-10-04T01:31:00.000-07:00

In this post I will show you pretty simple sample about how you can done fast mssql table export to xml file in c#:

You need simple event where you can put this sort of C# code:

private void button1_Click(object sender, EventArgs e)

{

if (textBox1.Text != "" && textBox2.Text !="" && textBox3.Text != "")

{

string cmd= "Select * from "+textBox3.Text+"";

string conn= textBox2.Text;

DataSet ds = new DataSet();

System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd,conn);

da.Fill(ds);

// Write to XML here

ds.WriteXml(textBox3.Text+".xml", XmlWriteMode.WriteSchema);

dataGridView1.DataSource = ds.Tables[0];

}

MessageBox.Show("Uspješno !");

}

ASP.NET Increasing a upload file size lenght for FileUpload Control

2009-09-16T12:52:00.000-07:00

If you ever need to do uploading a file with asp.net FileUpload control , file that had size over 4 mb , you will get some errors and most probably problem is with file size . So , we need to make some changes in Web.Config file . Here is default upload file size limit 4096 Kb . Our job to fix that error is to change limit size to fit file upload size and we do that with simply changing a 4096 Kb to our desired size .

EXAMPLE
web.config file

xml version="1.0" encoding="UTF-8" ?>
<configuration>
<configSections>
<system.web>
<httpRuntime
executionTimeout="90"
maxRequestLength="4096"
useFullyQualifiedRedirectUrl="false"
/>
system.web>
configSections>
configuration>

VB.NET Check if Session is not empty

2009-09-16T12:42:00.001-07:00

This is most useful line of code when we need to do simple check if Session content is not empty:

VB.NET

IF (Session("Regije") IsNot Nothing OrElse [String].Empty.Equals(Session("Regije")) Then

End IF

JavaScript check if ComboBox.Text is not equals NULL

2009-09-16T12:31:00.000-07:00

With this JavaScript code we do check if ComboBox.Text property is not equals NULL

We write this code in Client Side of Control .

Example : on Client Side Click event of ASPxButton Controls, if ComboBox is NULL we will see an JavaScript Alert with Message . ClientSide options are part of DevExpress control toolkit ;)

if(combo.GetValue() != null){

callback1.PerformCallback();

}else{

alert(' You didn't choose any option in ComboBox !');

}

Read PDF dokument from database

2009-09-10T11:03:00.000-07:00

Part of code that I use for reading a PDF document from database into Internet explorer.

We first need one asp.net page with link . When we click on it we do Response.Redirect() to this page and send a parameter ID which we read in Page Load and use him to do simple sql query which will read a PDF data stored in it . (We store PDF as Byte array in data table column) .

This time I will not post all the detail about it, if someone need more info let's message me and I will try to show more about these simple task :)

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Request.QueryString("id") IsNot Nothing Then

Dim ImageID As Integer = Convert.ToInt32(Request.Params("id"))

Dim strConnString2 As String = System.Configuration.ConfigurationManager.ConnectionStrings("conString").ConnectionString()

Dim con2 As New Data.SqlClient.SqlConnection(strConnString2)

Dim command2 As SqlCommand = New SqlCommand("procKOP_DokumentiSelect", con2)

command2.CommandType = CommandType.StoredProcedure

command2.Parameters.AddWithValue("@ZahtjevID", ImageID)

command2.Parameters.AddWithValue("@TipSelecta", 0)

con2.Open()

Dim reader As SqlDataReader = command2.ExecuteReader()

If reader.Read() Then

Response.ContentType = "application/pdf"'

Response.BinaryWrite(DirectCast(reader("fldDokument"), [Byte]()))

End If

reader.Close()

con2.Close()

End If

End Sub

Searching string in all Store procedures in database

2009-09-10T10:36:00.000-07:00

I'll show you how to do search trough all SP in one database to find a sting , text .

It's very useful part of MS SQL code :

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%user_name()%'

AND ROUTINE_TYPE='PROCEDURE'

select * from sysobjects o inner join syscomments c on o.id=c.id

where c.text like '%user_name()%'

Here you can see two simplest piece of Sql code that executes search trough all Store procedure in selected database for termin "user_name()" . It is very fast and useful .

Goodbye :) I am going to finish my Iftar hehe

Asp.Net prevent Button Click until long time Insert Query done ! .

2009-09-06T11:29:00.000-07:00

In this post you will see how to do some simple prevention on Asp.net page button click until long time inserting query done .

If you work a lot with SQL Store procedure , or other ways of T-SQL communication between your Asp.net page and database , It's so possible that you have to do some prevention when user try to insert or update some long data to SQL .

With this line of code when user make first click button become a disabled until inserting,updating done!.

protected void Page_Load(object sender, EventArgs e)

{

Button1.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(Button1, null) + ";"); // C#

}

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

Button.Attributes.Add("onclick", " this.disabled = true; " &

ClientScript.GetPostBackEventReference(Button1, Nothing) & ";") // VB.NET

End Sub

MSSQL : Update a column in one table with values from some other table

2009-09-06T10:54:00.000-07:00

In this post I will show you one useful MS T-SQL Query .

It's about updating a one column from one tables with values from some other table.

The query :

UPDATE t1

SET t1.column1= t2.column2 FROM dbo.someTable1 t1 INNER JOIN

dbo.someTable2 t2 ON t1.joinColumn =t2.joinColumn

We do simple update a column in table someTable1 alias t1 with values from someTable2

we do inner join on join column in this sample that is a joinColumn .

That' all folk's for this time ;) Goodbye ...

Fast export of AspxGridView data to Excel ,PDF ,CSV ,RTF file type C#,VB.NET

2009-09-06T03:52:00.000-07:00

Hi to all of you who came in this place searching some info about programming . In this blog post I will show you how to very , very fast export Your data from AspxGridView to Excel spreadsheet ( or PDF or CSV or RTF file type ).

First of all in this post I will use DevExpress Asp.net controls toolkit (8.2.4). That's mean DevExpress toolkit is requirement.

You can find 60 days trial version on this link: http://www.devexpress.com/Downloads/

Let's start with show J

First we need to start our Visual Studio 2008 ( my favorite version, but this version of DevExpres controls works fine with VS2005 ).

As we start new Web Site Project template , we need to find our AspxGridView control on VS Toolbox and do simple drag & drop on our test page.

Next step ,we need to do simple connection between aspxgridview and sqldatasource, I hope you all know how to do that J.

After we successfully connect to our sqldatasource next step is to add one button from VS Toolbox of course with one fast and simple drag & drop.

Let's we change text property of our button I will write ' Export to Excel' , next step to do is one more drag & drop , now we will add most useful control that we need to make our task fast and efficient

That's AspxridiewExporter.

Only one thing we need to do with it and that is to connect AspGridViewExporter property 'GridViewID' with our AspxGridiew ID :

Next step is to make double click on our button and in his Click property write this magical command :

ASPxGridViewExporter1.WriteXlsToResponse(); // Case we use C#

Me.ASPxGridViewExporter1.WriteXlsToResponse() // or we use VB.NET

If we wish to export our AspxGridView data to some others file formats we only need to write this commands : ASPxGridViewExporter1.WriteCsvToResponse(); // for CSV file C#

ASPxGridViewExporter1.WritePdfToResponse(); // for PDF C#

ASPxGridViewExporter1.WriteRtfToResponse(); // for RTF C# Me.ASPxGridViewExporter1.WriteCsvToResponse() //for VB.NET Me.ASPxGridViewExporter1.WritePdfToResponse()

Me.ASPxGridViewExporter1.WriteRtfToResponse()

Last thing is to make run of our test site and do some simple Click on button ‘Export to Excel’ and if all goes right we will see ‘File Download ’ dialog with options Open, Save ,Cancel . We do Click on Open and we see Excel spreadsheet with our AspxGridView content in it :P

The mission ‘Fast GridView export to Excel with DevExpress Asp.net controls ’ is successful ,

That’s all for this post J

Goodbye

....napokon u svijetu bloga

2009-09-05T04:12:00.000-07:00

Nakon dužeg razmišljanja i nagađanja , evo i Ja se odlučih na korak čarobnog postanja u virtualnom svijetu .

Moje postanje će prvenstveno da se odnosi na pisanje iz oblasti IT -a.

Ja kao dot net programer nastojat ću da na ovaj način čisto vodim zabilješke iz svoga svakodnevnog rada , a koji se sastoji isključivo od programiranja s .NET platformom (C#,VB.net,asp.net i odnedavno i MS T-SQL).

Časnom pionirskom se kunem , da ću se trudit da pišem korisne postove i to što češće.

Attempted translation :

.... finally in the world of blog

After long thought and speculation I decided to step into magical world of Posting in the virtual world. My posting will primarily be related to writing in the field of IT. I am a dot net developer and I will try in this place write some useful articles from my notes at everyday work, which consists entirely of programming with .NET platform (C #, VB.net, asp.net, and recently, MS T-SQL). Holy pioneering a swear, I'll try to write useful posts and as often as possible .