You can reach so far you can dream.

how to configure DHCP in windows server 2003?

2010-12-08T00:43:00.000-08:00

The Dynamic Host Configuration Protocol (DHCP) is an auto configuration protocol used on IP networks. Computers that are connected to IP networks must be configured before they can communicate with other computers on the network. DHCP allows a computer to be configured automatically, eliminating the need for intervention by a network administrator. It also provides a central database for keeping track of computers that have been connected to the network. This prevents two computers from accidentally being configured with the same IP address.
Here is some links for configuring DHCP in the local network:
1. http://www.windowsreference.com/windows-server-2003/install-and-configure-dhcp-server-in-win-server-2003-step-by-step-guide/

2. http://www.windowsnetworking.com/articles_tutorials/DHCP_Server_Windows_2003.html

How to get the path of AppData for an application?

2010-11-23T07:16:00.000-08:00

Often in windows OS, a separate directory is created for an application for a user for saving user-specific information and user has the administrative right on that folder. Recently, I was working on a project with winxp platform. While client was testing the same software on win 7 , he found that the application failed to create the or modify a file in the system directory where the application was loaded. So, then the concept of Appdata came and I implemented the solution using the link provided by client.
Here is the link
http://stackoverflow.com/questions/946420/allow-access-permission-to-write-in-program-files-of-windows-7
And here is my code for getting the AppData folder


XmlDocument xmldoc = new XmlDocument();

           string xmlfilepath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
           //loading the file
           xmldoc.Load(xmlfilepath + "/" + "enstatics.xml");
           //returning the xmldoc
           return xmldoc;

DNS setup in Ubuntu Linux

2010-11-23T07:09:00.000-08:00

Recently, I assigned a project of setting mail server as network lab project for fourth year 1st term students. Anyway, no group came out with what I expected. Anyway, the first thing is here is needed is a successful DNS server.
Here is a post I created for DNS setup in Ubuntu Linux with BIND software.
DNS setup in ubuntu
Here is the link http://cseku.technopeople.net/setting-up-dns-linux.aspx

Working with xml file in C#

2010-11-23T06:22:00.000-08:00

Well, Currently I am working with a project called webcam desktop application which mainly captures snapshot and video from the webcam. Before, starting the project, I had very little concept about how to do that and before me, an experienced developer worked on it. Anyway, my task was to fix the bugs. Whenever, I started bug-fixing, I found that previous coder used Appsetting to store information, which polls some static information from the system and nothing customization saved at run time, can be restored in the next run of the system. So, I came to plan to save the information in the xml file. Here I am going to show several things like

1. Creating xml file dynamically
2. Modifying the xml file
3. Reading from the xml file.

Creating XML file dynamically

//code for creating and saving default config
public void create_config_xml_file()
{
try {
//xml doc
XmlDocument xmldoc = new XmlDocument();

//xml declaration
XmlDeclaration xmldeclaration = xmldoc.CreateXmlDeclaration("1.0", "utf-8", null);

//create root element
XmlElement rootNode = xmldoc.CreateElement("myconfigdata");
xmldoc.InsertBefore(xmldeclaration, xmldoc.DocumentElement);
xmldoc.AppendChild(rootNode);

//adding more children to the root node

//imageformatindex
XmlElement ifiElement = xmldoc.CreateElement("imageformatindex");
ifiElement.InnerText = "1";
rootNode.AppendChild(ifiElement);

//currentdirectory
XmlElement currDirElement = xmldoc.CreateElement("currentdirectory");
currDirElement.InnerText = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
rootNode.AppendChild(currDirElement);

//fileprefix
XmlElement fpElement = xmldoc.CreateElement("fileprefix");
fpElement.InnerText = "ISeeStand";
rootNode.AppendChild(fpElement);

//filesuffixid
XmlElement fsElement = xmldoc.CreateElement("filesuffixid");
fsElement.InnerText = "2";
rootNode.AppendChild(fsElement);

//sequential
XmlElement seqElement = xmldoc.CreateElement("sequential");
seqElement.InnerText = "0";
rootNode.AppendChild(seqElement);

//sequentialvid
XmlElement seqVidElement = xmldoc.CreateElement("sequentialvid");
seqVidElement.InnerText = "0";
rootNode.AppendChild(seqVidElement);

//videncoder
XmlElement videncElement = xmldoc.CreateElement("videncoder");
videncElement.InnerText = "WMVideo9 Encoder DMO";
rootNode.AppendChild(videncElement);

//framesize
XmlElement fsizeElement = xmldoc.CreateElement("framesize");
fsizeElement.InnerText = "800 x 600 @5.00 fps";
rootNode.AppendChild(fsizeElement);

//framerate
XmlElement frateElement = xmldoc.CreateElement("framerate");
frateElement.InnerText = "5.00 fps";
rootNode.AppendChild(frateElement);

//getting appdata folder
string app_path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);

//saving that document
xmldoc.Save(app_path+"/"+"enstatics.xml");

}
catch (Exception exc) {
MessageBox.Show("Failed to create the xml configuration file."+exc.Message);
}
}

From the above code, we can see how to use XMLDocument object and XmlNode for creating a XML file.

Modifying the XML file

The following code saves some info into the xml file accessing a particular XmlNode

//saving the image format index to the xml file
try {
XmlDocument xmldoc = MyStaticMgr.loadMyXMLDoc();
XmlNode formatIndexNode = xmldoc.GetElementsByTagName("imageformatindex")[0];
//setting the preferences to the xml node
formatIndexNode.InnerText = (ImageformatComboBox.SelectedIndex + 1).ToString();
//now saving the xml file
int result=MyStaticMgr.saveMyXMLDoc(xmldoc);
}
catch (Exception exc) {
MessageBox.Show("Failed to save the preferences"+exc.Message);
}

Reading from XML file

The following code will demonstrate how to access a particular node of the xml file for a particular information

//making a default choice
try {

XmlDocument xmldoc = MyStaticMgr.loadMyXMLDoc();
XmlNode formatIndexNode = xmldoc.GetElementsByTagName("imageformatindex")[0];
int format_index = int.Parse(formatIndexNode.InnerText);
//now setting that index to the combobox
ImageformatComboBox.SelectedIndex = format_index - 1;
}
catch (Exception exc) {
string messageBoxText = exc.Message;
string caption = "Exception Occurred";
MessageBox.Show(messageBoxText, caption);
}

From the above codes we found a particular section like this

XmlDocument xmldoc = MyStaticMgr.loadMyXMLDoc();

and

//now saving the xml file
int result=MyStaticMgr.saveMyXMLDoc(xmldoc);

Actually, MyStaticMgr is a static class which handles the basic operation like opening an xml document and returning the document object or saving the xmldocument object. Here is the code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Windows.Forms;

namespace ISeeStand
{
public static class MyStaticMgr
{

//code for loading the xml document
public static XmlDocument loadMyXMLDoc()
{
XmlDocument xmldoc = new XmlDocument();
string xmlfilepath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
//loading the file
xmldoc.Load(xmlfilepath + "/" + "enstatics.xml");
//returning the xmldoc
return xmldoc;

}

//code for saving to the xml file
public static int saveMyXMLDoc(XmlDocument xmldoc)
{
int saved = 0;
try {
string xmlfilepath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
//loading the file
xmldoc.Save(xmlfilepath + "/" + "enstatics.xml");
//yes the file is saved
saved = 1;
}
catch (Exception exc) {
string messageBoxText = exc.Message;
string caption = "Exception Occurred";
MessageBox.Show(messageBoxText, caption);
}

//returning the result
return saved;

}

}
}

Handling event from Context Menu strip after a Right Click

2010-08-29T09:16:00.000-07:00

Recently I deal with this problems for 1-1.5 hours. Anyway, lastly I figured it out how to perform this operations: Here are the steps. We need three controls for this

Windows form

ListView Control

ContextMenu Strip

Step-1:Loading listview items::

The following code loads the items to listview control.

protected void load_courses()
{

//code for loading the courses
try {
OleDbConnection conn = new OleDbConnection(StaticData.connection_string);
conn.Open();
string select_courses = "select * from Course";
OleDbDataAdapter oda = new OleDbDataAdapter(select_courses, conn);
DataTable dt = new DataTable();
oda.Fill(dt);

//databinding to the listview
TestlistView.Items.Clear();
for(int i=0;i < dt.Rows.Count;i++)
{
DataRow row = dt.Rows[i];
ListViewItem lvi = new ListViewItem(row["CourseNo"].ToString());
lvi.SubItems.Add(row["CourseID"].ToString());
lvi.SubItems.Add(row["Credit"].ToString());
TestlistView.Items.Add(lvi);
}

}
catch (Exception exc) { }
}

private void Form1_Load(object sender, EventArgs e)
{

//code for loading the courses
load_courses();

}

Step-2:Handling the right click event on listview items:

private void TestlistView_MouseClick(object sender, MouseEventArgs e)
{

if (e.Button == MouseButtons.Right)
{
Point pt = TestlistView.PointToScreen(e.Location);
contextMenuStrip1.Show(pt);
}

}

Step-3:Handling context menu strip event

private void contextMenuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
if (e.ClickedItem.Text == "Upload")
{
MessageBox.Show("Upload started for:" + TestlistView.SelectedItems[0].Text);
}
}

Thats how we can use right click event to show a context menu strip and handle menu strip click events.
thanks. Masud(29-08-2010)

Full functional LAN set up

2010-05-06T11:43:00.000-07:00

For few days, I was trying to implement some important things to implement in the LAN of CSE Discipline, Khulna University. I was trying to develop a fully functional computer network. Such one network will contain the following entities:

A Web server

Here is the necessary help for that
1. http://blog.ifitcangowrong.com/windows/install-iis-60-on-windows-server-2003
2. http://technet.microsoft.com/en-us/library/aa998483%28EXCHG.65%29.aspx
3. http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/750d3137-462c-491d-b6c7-5f370d7f26cd.mspx?mfr=true

A DNS Server

Here is necessary help for that I think:
1.http://www.petri.co.il/install_and_configure_windows_2003_dns_server.htm
2.http://helpdeskgeek.com/networking/install-and-configure-dns-on-windows-server-2003/
3. http://support.microsoft.com/kb/814591

An Email sever (POP and SMTP)

1. http://www.ilopia.com/Articles/WindowsServer2003/EmailServer.aspx
2. http://www.windowsreference.com/windows-server-2003/step-by-step-email-server-setup-in-windows-server-2003/
3. http://articles.techrepublic.com.com/5100-10878_11-5035180.html
4. http://www.windowsnetworking.com/articles_tutorials/Windows_POP3_Service.html

Using image map and popupcontrol extender

2010-04-20T03:22:00.000-07:00

In interactive map client provided me a jquery library which is called zoom map and he instructed to work according to that but I found some problem in work with multiple version of jquery. For example jquery-min-1.3.2 does not support the coexistence with jquery-1.4.2.js. Anyway, I am going to describe here, how to use image map and popupcontrolextender. To perform this we need to follow these steps:

Step-1: We have to register the AjaxControlToolkit for using its control which we are calling here PopupControlExtender.


<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

Step-2:
Consider an image containing lots of hot spot and when there is a click on that hot spot certain popup-winow will show up. So, here is the code for image and map.


< img id="homeimg"  src="maps/map-bg-w-dots.jpg"  style="border-width:0px"  runat="server" alt="" usemap="#homemap" / >
< map name="homemap" id="homemap">
< area id="hole1area" runat="server" target="_self"  onclick="showdetails(1)" shape="circle" style="cursnor:pointer" alt=""  coords="314,178,7"/>
< area id="hole2area" runat="server" target="_self"  onclick="showdetails(2)" shape="circle" style="cursor:pointer" alt=""  coords="285,56,7"/>
< /map>

Here, onclick="showdetails(1)" can be used to populate data from some xml file relevant to hole1area if needed. As for example I have done in
my map project

Step-3:
Now we need the popup control extender that will generate a popup. So, here is the code below:


< asp:ScriptManager runat="server">< /asp:ScriptManager>
< cc1:PopupControlExtender runat="server" ID="MyPopupExtender1" OffsetX="550" OffsetY="300" PopupControlID="popupwindow1" TargetControlID="hole1area">
    < /cc1:PopupControlExtender>
< cc1:PopupControlExtender runat="server" ID="MyPopupExtender2" OffsetX="550" OffsetY="300" PopupControlID="popupwindow2" TargetControlID="hole2area">
    < /cc1:PopupControlExtender>


< div id='popupwindow1'>
Description for hole1...............
< /div>
< div id='popupwindow2'>
Description for hole2................
< /div>

Here, several thing to notice:
TargetControlID= the control which will be clicked on.
PopupControlID= the control which will be shown as popup.
OffsetX= the X position where popup will be shown
OffsetY= the Y position where popup will be shown.

So, this is the simplest way to use image map and popupcontrolextender. And whenever I started working client become excited as I was not using his solution but finally I ended up with good solution and he was quite satisfied. So, this project was one of the challenging task to me.

thanks. Masud.

The challenging task in interactive map project

2010-04-20T02:25:00.000-07:00

Few days ago I a project successfully called Interactive Map project. The development URL of this project is:
http://cpdemo.com/vistaverde/development.html
From this project I got an outline professional work and fancy works. Anyway, I was satisfying client's requirements and at time I found client has made an easy requirements visually but technically it is a tough one which I didn't perform ever. Actually, the life software engineer is quite thrilling in that sense that it is full of challenges and that's why I could not leave this despite of being a university lecturer. Anyway, here the way I solved the problem.

Requirement: to stop hiding the popup-window at click outside the popup window.
Relevance description: I was using asp.net ajax control toolkit to make a popup-window after a mouse click on some hot spot on an image map. And default behavior of the popup window as designed by the toolkit developers was to be hidden at the mouse click outside the popup window. I tried a lots of ways but I could not stop the mouse click. I used e.stopPropagation(){for FF} and e.cancelBubble=true {for IE} but nothing works for me and lastly I found some tutorials and several combination of them works.

Steps to solution:
step-1: to override the default behavior of the toolkit we need to override the function. For example, I was using popupcontrolExtender control for making popup-window. Anyone can easily download source from this URL to see the behavior of the control as set by the developers:
http://ajaxcontroltoolkit.codeplex.com/releases/view/16488#DownloadId=41941
Here, I found that _onBodyClick: handler is managing the click on the body of html page and making the __VisiblePopup hidden. So I need to override this handler as I found. This whole modification will be contained inside a dll. So I created a dll project on Visual Studio called MypopupControl

Step-2:
To override this handler I created a javascript file that contains the overridden handler which looks like the following. It is named as 'myjsfile.js' in my solution.

//starting of javascript code

try
{

AjaxControlToolkit.myPopupControlBehavior= function(element)
{
AjaxControlToolkit.myPopupControlBehavior.initializeBase(this,[element]);
};
AjaxControlToolkit.myPopupControlBehavior.prototype =
{
_onBodyClick:function()
{
if(this._popupVisible)
{
return false;
}
}
};
AjaxControlToolkit.myPopupControlBehavior.inheritsFrom(AjaxControlToolkit.PopupControlBehavior);

AjaxControlToolkit.myPopupControlBehavior.registerClass('AjaxControlToolkit.myPopupControlBehavior', AjaxControlToolkit.PopupControlBehavior);

if(typeof(Sys)!=='undefined')Sys.Application.notifyScriptLoaded();

}catch(exc){}

Here we can see that _onBodyClick handler is modified so that a visible popup wont be hidden by the mouse click on the body.

Step-3:
I also created a C# file called 'myPopupControlExtender.cs' that contains the following contents: Please note that myPopupControlExtender class inherits PopupControlExtender class of AjaxControlToolkit namespace that means it will have all the properties of PopupControlExtender class.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using AjaxControlToolkit;

[assembly: WebResource("MyPopupControl.myjsfile.js", "text/javascript")] //the custom/override javascript file is an embedded resource

namespace MyPopupControl
{

[ClientScriptResource("AjaxControlToolkit.myPopupControlBehavior", "MyPopupControl.myjsfile.js")]

public class myPopupControlExtender : PopupControlExtender
{

}

}

Here, we can see that an assembly entry is used to embed the javascript file and it will be resided inside the C# dll we will be creating.

Step-4: The mostly important step of this process is to declared the javascript file as the embedded resource and without this whole process wont be effective. So, to do this:
Right click on js file>Properties> Build Action >Embedded Resource

Step-5: Now we need to just build the project and we will get a brand new dll called MyPopupControl which is containing the modified behavior of PopupControl and in my case I created new popupcontrolextender which was named as 'myPopupControlExtender' and as its inherits all the properties of popupcontrolExtender plus containing the modified behavior of _onBodyClick:function()...so that serves my purpose of the project.

thanks. Masud.

Creating DB script with data from Sql sever 2005

2010-03-13T12:57:00.000-08:00

Creating Database script with data is quite easy for deploying an application with existing data. Anyone can create such script following these steps as dictated by diagrams. This process will be helpful to the people not having SQL server Management Studio installed.

Window-1: Visual Studio: View>Server Explorer>Data Connections>Select One Connection>Publish to provider

Window-2: Select a database > Next

Window-3: Script to file > Next

Window-4: Type of data to publish: Schema and Data >Next

Window-5: Review Summary: >Next

Window-6: Database Publishing Progress > Finish

Window-7: Completed.

Exporting data from sql server table to excel file

2010-02-06T10:07:00.000-08:00

Exporting data from sql server table to excel file requires two levels to query execution. They are given below.

1. Enabling OPENROWSET (executed by DBA)

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

2.

This is second part by which actually data will be exported from sql table to excel file. Here is the query worked for me.

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=E:\testing.xls;',
'SELECT BusCatID,Description FROM [Sheet1$]')
SELECT BusCatID,Description FROM hooser_burger_db.dbo.BusinessCategory

Before executing the query developer has to create an .xls file and he/she has to denote the header or column name of sql sever tables to be exported in the excel file. Then after running the query he can consume the data from the file.

Masud (7-2-2010)

Databinding with combobox in C# windows application

2010-01-31T12:25:00.000-08:00

It is quite similar to the databinding with dropdown list in ASP.NET. Anyway, here is the code for databinding.
# code for databinding with combobox


try {
                SqlConnection conn = new SqlConnection();
                conn.ConnectionString = Properties.Settings.Default["MyConnStr"].ToString();
                conn.Open();

                string select_cats="select * from BusinessCategory";
                SqlDataAdapter sda=new SqlDataAdapter(select_cats,conn);
                DataTable dt=new DataTable();
                sda.Fill(dt);

                //databinding to the combobox
                TestcomboBox.DataSource = dt.DefaultView;
                TestcomboBox.DisplayMember = "Description";
                TestcomboBox.ValueMember = "BusCatID";




           
            }
            catch (Exception exc) {

                //MessageBox.Show(exc.Message);
            }

Here we see 'Description' is used here as text property and 'BusCatID' is used here as value property with combo box.

Creating paypal shopping cart

2010-01-31T01:19:00.000-08:00

Before finishing the my project http://www.biznesmakler.pl I found that client wants me to change payment procedure through paypal. He wants a way to perform payment by buyer to paypal without login to paypal account that means payment with credit card only. Apparently I found that there is no available way for payment without login to paypal account. Actually, if anyone has a paypal account he wont be able to make payment to paypal without login according to current strategy...that if paypal checks a credit card for once it has a record for that card and it will prompt for registration next time. As I was trying to integrate with paypal in express checkout and it needed login to paypal for account confirmation.

Anyway, I thought there is no way to pay without login..but there is. And the only exclusive way to make payment is payment with shopping cart. And its quite east to integrate the site paypal shopping cart techniques. Lets summarize the way of paypal shopping cart integration.

1. Login to paypal business account
2. Click Merchant service tab
3. Select create New Button Link. After a process of creating button you will be provided with the button code with a button id.
4. Now you can redirect your buyer for payment in this way. Here is the code.


               //redirect to option 1 button
                StringBuilder builder = new StringBuilder();
                builder.Append(bizcart.scartPostURL);
                builder.Append("&cmd=_s-xclick");
                builder.Append("&hosted_button_id=" + bizcart.valuationOption1ButtonID);
                paypal_redirect_url = builder.ToString();

Here bizcart.valuationOption1ButtonID is the button id we have generated.
Thats the way to work with paypal shopping cart.

Masud. (31.1.2010)

Creating PDF using ASPpdf service

2010-01-08T13:24:00.000-08:00

Here I will be discussing about creating pdf document using asppdf service. Here are some steps to be followed:
1. downloading and installing asppdf
2. Integration with application
3. coding for creation the pdf document

Mainly I prefer asppdf for creating PDF directly from a web URL. When I tried to use iTextSharp for converting a html or aspx page to PDF then it got stuck and my project exposed to risk of failing to satisfying some basic needs. However, here I am going to describe them in details

1. downloading and installing asppdf
one can download a 30-days free trial from the following URL:
http://asppdf.com/download.html
and then will provide a key which should be used during installation. After installing you will get a .dll in Bin folder of the installation directory.This dll is the object to work with.

2. Integration with application
You can get the dll from such a path:E:\Program Files\Persits Software\AspPDF\Bin\
Now you have to create a reference to that dll suing VS-200x

3. coding for creation the pdf document

using ASPPDFLib; //this is the required namespace of the dll

public string createAspPDF(string sourceURL, string destdirectory, string filename)
{
string created_pdf_url = string.Empty;
try {
HttpContext.Current.Session["access"] = "yes";
IPdfManager mymanager = new PdfManager();
IPdfDocument mydocument = mymanager.CreateDocument(System.Reflection.Missing.Value);
mydocument.ImportFromUrl(sourceURL, Missing.Value, Missing.Value, Missing.Value);
String myfilename = mydocument.Save(HttpContext.Current.Server.MapPath(destdirectory) + filename, true);
created_pdf_url = destdirectory + myfilename;
}
catch (Exception exc) {
return exc.Message;
}
return created_pdf_url;

}

where, sourceURL="http://www.nochallenge.net/biznesmakler"
destdirectory=destination directory in biznesmakler,
filename=file name for the pdf file,
created_pdf_url=the url of pdf file just created.

So that is the way to deal with pdf directly from a web url.

thx
Masud (1-9-2009)

Creating PDF file using ASP.NET,C#

2009-12-26T05:27:00.000-08:00

This is an interesting thing to accomplish creating PDF file in ASP.NET ,C#. Let me share with you the techniques of creating PDF. Here are the following steps.
step-1: download the following itextsharp .dll from the following link
step-2: Add reference to the .dll in your project using Visual studio
step-3: Now use the following code only to create a simple paragraph in .pdf file.
//creating pdf source code
try {
Document mydoc = new Document(PageSize.A4.Rotate());
PdfWriter.GetInstance(mydoc,new FileStream("masud.pdf",FileMode.Create));
mydoc.Open();
mydoc.Add(new Paragraph("This is the first paragraph written by me"));
mydoc.Close();
MessageBox.Show("PDF created successfully!");

}
catch (Exception exc)
{
MessageBox.Show("Failed to create PDF file"+exc.Message);
}

This is how you can create PDF uisng some dll. So interesting!

thanks. Masud (26-12-2009)

Working With Google Checkout

2009-11-12T08:37:00.000-08:00

Recently I have worked on shopping cart using Google checkout.This is quite easy to work with Google checkout rather than Paypal or others. However, I will be describing here in brief:

Steps:
1.Shopping cart account in Google
2.Downloading GCheckout.dll and installing in VS.
3.Working with GCheckout Button.

Here I will be describing in details.

1.Shopping cart account in Google
Generally for this you will have to have a google account. And using this account you can create shopping cart account. So if you have account then do the following.
a. log in to Google.
b. visit https://sandbox.google.com/checkout/main
c. Here you will find a control panel having 'Edit Payment Method'. Here you will put your credit card info to which customer will pay you. And also some other info you have to pay like country, city, shipping address etc.
d. Then go to main panel and collect Merchant ID, Merchant Key which will be used in your website for accessing the shopping cart account. Generally
these keys will be generated by Google.

2.GCheckout.dll
a.You can make a Google search and download this dll. For Asp.net developer, there is a .NET version of GCheckout. You have to download that. After downloading this dll you have to Add reference to this dll and in this way, the dll will be copied to website Bin directory.
b. Add reference: Solution Explorer>Website Name>Add Reference>browse the dll

3.Working With GCheckout Button
To work with GCheckout Button you have to do the following:

a.Toolbox>Choose Item>browse dll.
This way new controls (dll) will be shown up in toolbox (GCheckoutButton,GCheckoutDonateButton);
b. Now drag and drop the control to the .aspx page and you will see automatically the following code will be generated.
i. in directive section:
< %@ Register Assembly="GCheckout" Namespace="GCheckout.Checkout" TagPrefix="cc1" % / >
ii.in page body:
< cc1:GCheckoutButton ID="MyGCheckoutButton" runat="server"
onclick="MyGCheckoutButton_Click" / >

Here, we see that this button is clicked and handler is generated to handle the event.
c. Web configuration section:
You have to put the following configuration in app setting.
< appSettings >
< add key="GoogleMerchantID" value="XXXXXXXXXX" />
< add key="GoogleMerchantKey" value="YYYYYYYYYY" />
< add key="GoogleEnvironment" value="Sandbox" />
< /appSettings>

The Merchant ID and Merchant Keys will have to be inserted in the above section to make the system works.

d. Coding in the Button event handler function.
You have to put the following code in the function:

CheckoutShoppingCartRequest chkoutShoppingCartReq = MyGCheckoutButton.CreateRequest();
chkoutShoppingCartReq.AddItem("Business Plan: Plan No"+Session["PlanID"], "Business Plan Consultancy Fee", decimal.Parse(Session["PlanCost"].ToString()), 1);
GCheckoutResponse obtainedResponse = chkoutShoppingCartReq.Send();
Response.Redirect(obtainedResponse.RedirectUrl, true);

Here obtainedResponse.RedirectUrl is the URL to which website will be redirected for payment.
e.When you will be working in the Setting in Merchant Account you have to generally set the thank you page (for payment) as the redirect URL so that after successful payment, the user can be acknowledged that his/her payment is received successfully and he/she is free to go.

This is the way..Google Checkout works.

Thanks. Masud (13-11-2009)

Some CSS tips I used

2009-09-17T03:18:00.000-07:00

I was not that much recognized in CSS but nowadays I found that CSS has a great power to turn the website into an online space. Here is something I worked:

1. padding> padding used to shift the text from the original space it was supposed to stay.
padding-left:10px;
2. no wrap>It removes line break inside the text

my value

view:
myvalue

CSS File:


.mytext
{
padding-left:10px;
white-space:nowrap;
}

Often these two things are very useful.

Masud (17-07-2009)

A bunch of tricky problems and solution

2009-09-05T02:39:00.000-07:00

This weekend I faced a bunch of tricky problems that I solved after working hard on it. Here is a little description for that: Actually I am being a bit informal in case of description. I will be just copy and paste the report I used in my business.

1.a: Notorious problem for coping one whole page to other
Once upon a time I designed some pages according to some provided pages like
index.aspx buyabiz.aspx
I designed new pages like indexc.aspx or buyabizc.aspx. and so far I was working on it....
but the page name remain index.aspx....for it.which cause notorious problem to make ur head hung. It will give undefined errors. So we have to be careful.

2. I learned to use as in stored procedure that reduces the query size. Let me explain with an example:

select C.CityName, V.Voivodeship from City as C, VoivodeshipInfo as V where C.VoivodeshipID=V.VoivodeshipID order by C.CityName

3. Use of nvarchar(50) will save only 50 chars from the input taken
4. Negative balance showing:
This is a very typical problem. When u try to format in currency in this way:
string.Format("{0:C}",-25.50)..result is ($25.50)....:-)
This is a killing me problem. I used the picture format notation to solve this problem. The format I used is:

string.Format("{0:$#,#.00}",-25.50)..output is -$25.50 which I expected.

5.Look at this:
a.select DateTime, Name from Timetable as T where DateTime='2/9/2009': fails
b.select DateTime, Name from Timetable as T where T.DateTime='2/9/2009':works

here 5.a is incorrect but b will correct

6.To edit a column from SQL server Mgmt studio :
Table>Columns>Modify...

The column must allow null and have a default binding value
7. In CSS design:
display:none ---hides the control

lets look at it:

#menunav ul li:hover #submenu
{
display:block;
width:115px;
height:100px;
}
This is the hover syntax in css. when mouse is hovered on submneu-title then the
submenu is displayed and otherwise it is hidden.

8. when to redirect using the syntax in LinkButton or Response object:

Response.Redirect("www.cse.com"); won't work because it searches a page within ur website called www.cse.com.

Solution:
Response.Redirect("http://www.cse.com");

Adding command to Item in DataList

2009-08-25T03:45:00.000-07:00

This is much simple and I did it without tutorial from the context of command knowledge.Lets make an overview here. Here is the HTML code that adds a command to the link button which is a control of a DataList Item:

1. HTML code
< asp:DataList >
< ItemTemplate >
< ItemTemplate >
< asp:LinkButton ID="hypTest" runat="server" CommandName="MySelect" >< strong >< %# DataBinder.Eval(Container.DataItem, "BusinessName") % >< /strong >< /asp:LinkButton >
< br / >
< asp:Label runat="server" Text='< %# DataBinder.Eval(Container.DataItem, "ShortDescription") % >' BorderStyle="None" Height="48px" Width="180px" >< /asp:Label >
< asp:Label ID="conidLabel" runat="server" Text='< %# "contractordetails.aspx?conid=" + DataBinder.Eval(Container.DataItem, "contractorid") % >' Visible="false" >< /asp:Label >
< asp:Label ID="contid" runat="server" Text='< %#Eval("contractorid") % >' Visible="false" >< /asp:Label >
< br / >
< /ItemTemplate >
< /ItemTemplate >
< /asp:DataList >

Here we can see that how a command is added to the link button for issuing command which we will use later.

2. Programmer's Task:
Here is the code what programmer will do. Actually here I have done a code for updating balance for a contractor for each client click.

try {
DataListItem myselectedItem = e.Item;
Label myLabel = myselectedItem.FindControl("conidLabel") as Label;
Label contid = myselectedItem.FindControl("contid") as Label;

if (e.CommandName == "MySelect")
{

/*click fee handling code:here*/
try
{

int catid = int.Parse(Session["catid"].ToString());
float clickfee = 0;

/*getting click fee*/
try {
Category category = new Category();
if (category.LoadByPrimaryKey(catid))
{
clickfee =float.Parse( category.ClickFee.ToString());
}
/*click fee obtained*/

}
catch (Exception exc) {
StatusLabel.ForeColor = Color.Red;
StatusLabel.Text = "Failed to retrieve click fee!";
}

/*subtracting from balance*/
try {
Contractor contractor = new Contractor();
int contractorid = int.Parse(contid.Text);
if (contractor.LoadByPrimaryKey(contractorid))
{
float currentBalance =float.Parse( contractor.PrepaidAmount.ToString());
currentBalance = currentBalance - clickfee;
contractor.PrepaidAmount = currentBalance;
/*saving change*/
contractor.Save();
}

}
catch (Exception exc)
{
StatusLabel.ForeColor = Color.Red;
StatusLabel.Text = "Failed to subtract click fee from balance!";
}

}
catch (Exception exc) { }

/*Redirecting to the contractor details page*/
string redirect_url = myLabel.Text;
Response.Redirect(redirect_url);

}

//StatusLabel.Text = "done!";
}
catch (Exception exc)
{
StatusLabel.ForeColor = Color.Red;
StatusLabel.Text = exc.Message;
}

Here we can see we can get the selected item using
DataListItem myselectedItem=e.Item;
whereas for getting the selected row from GridView we had to do a lot of work.
However, Now we can access this item for further operation like getting some hidden value and use them for further operatiuons:

Label myLabel = myselectedItem.FindControl("conidLabel") as Label;
Label contid = myselectedItem.FindControl("contid") as Label;

I think this will help.

Thanks
Masud (25-08-2009)

Selecting a item from Dropdownlist

2009-08-15T08:47:00.000-07:00

This is an interesting thing I did few days ago while I was working in my office. Suppose the DDL(Dropdownlist) is containing some items. You wanna select one from the list programmatically at runtime. Generally at first I tried to do in this way:

MyDDL.Text="item text";
But this will not work and actually it will not also show any error. You will just try and try but nothing will happen. So we need to click the right way.

As we already saw the two things for databound DDL is:
* DataTextField
* DataValueField

Suppose Subcategorydesc=dataTextField
SubCatID=datavaluefield

And we want to select a subcategory called "Marketing" having subcatid=3. Then the code will be like this:

MyDDL.Items.getByValue("3").Selected=true;

thanks
Masud.

Gridview editing problem: Textbox cant store new value in the editing mode

2009-08-05T06:59:00.000-07:00

This is a common problem I have faced during my work. Every events are properly handled you will not get the new value in the update time. This is ridiculous thing and often your head can be cracked. But the solution to this problem is quite simple. Lets look at the example that I did....

Suppose this is the code for Update:

protected void ImgGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
/*Image info to be updated*/
try {
/*Extracting different elements from Gridview*/
GridViewRow myRow = ImgGridView.Rows[e.RowIndex];
/*getting pic id*/
Label PicIDLabel = myRow.Cells[2].FindControl("PicIDLabel") as Label;
/*getting image title*/
TextBox titleTextBox = myRow.Cells[1].FindControl("ImgTitleTextBox") as TextBox;

/*updating ad image*/
AdImage adImage = new AdImage();
adImage.ConnectionString = ConfigurationManager.ConnectionStrings["BIZNESConnectionString"].ConnectionString;
if(adImage.LoadByPrimaryKey(short.Parse(PicIDLabel.Text)))
{
adImage.ImgTitle=titleTextBox.Text;

adImage.Save();

}

ImgGridView.EditIndex = -1;
showAdImageInfo();

StatusLabel.ForeColor=Color.Green;
StatusLabel.Text="Image information updated successfully!";
StatusImage.ImageUrl = "adimages/ok.gif";

}
catch (Exception exc)
{
StatusLabel.Text = exc.Message;

}

}

So found no problem in update code every time I debug the code ....I spend the whole day on it and at last I found a forum that probably I have to check for autopostback option of the page.
So my Page_Load was like this:
protected void Page_Load(object sender, EventArgs e)
{

string access = (string)Session["access"];
/*checking access*/
if (access != "yes")
Response.Redirect("SellerAdminLogin.aspx"

/*showing images*/
showAdImageInfo();

}
For that killing problem to resolve we have to check the postback option. Lets look at the editing function:

protected void ImgGridView_RowEditing(object sender, GridViewEditEventArgs e)
{

/*Image editing code*/
ImgGridView.EditIndex = e.NewEditIndex;
showAdImageInfo();

}

If autopost-back is not checked every time gridview will loaded with values from databse so when update command will be clicked then data will be loaded from database to the textbox and new value in the textbox will be lost. So we need to check the auto-postback option:

protected void Page_Load(object sender, EventArgs e)
{

if(!Page.IsAutoPostBack)
{
string access = (string)Session["access"];
/*checking access*/
if (access != "yes")
Response.Redirect("SellerAdminLogin.aspx"

/*showing images*/
showAdImageInfo();

}
}

Thus update will easily work and we will be able to update the gridview data

thanks.
Masud

Image Carousel Tools

2009-08-04T15:58:00.000-07:00

I came to learn a very interesting thing which is implemented using JQuery and named as Image carousel. I came to learn from my mentor while doing the project
http://nochallenge.net/biznesmakler.
Here I have made some cosmetic customization which evolves the existing carousel to a professional level as said by project manager. However I will be dealing with next couple of my posting with image carousel as well as lightBox slideshow

thanks.
Masud

Adding Select text in databound Dropdownlist

2009-08-04T15:33:00.000-07:00

To create a data-bound dropdownlist we have to follow several steps. This time we are using Business entity which is CSharp Business Entity template and it is same as creating the business object. Suppose a business entity Category having three fields.

Category:
CatID
CatDescription
Active

Now we want to make a databound dropdownlist(DDL). Lets call the dropdownlist is CatDropDownList. So we have 2 steps:
1. Creating databound DDL
2. Inserting select text

Here we go:
1. Creating databound DDL.
try
{
Category category=new Category();

/*Generating and executing query*/
category.Query.AddResultColumn(Category.ColumnNames.CatID);
category.Query.AddResultColumn(Category.ColumnNames.CatDescription);
category.Query.Load();

/*databinding*/
this.CatDropDownList.Datasource=category.DefaultView;
this.CatDropDownList.DataTextField=Category.ColumnNames.CatDescription;
this.CatDropDownList.DataValueField=Category.ColumnNames.CatID;
this.CatDropDownList.DataBind();

2.Inserting Select text:
Generally if you add item now then DDL will not retain that item. this time you have to insert the values in the DDL. The required code is:
this.CatDropDownList.Items.Insert(0,"select a category");

}
catch(Exception exc){}

Now comes how use the value selected by the DDL.This is quite simple.
int selectedCatID=Convert.ToInt32(CatDropDownList.SelectedValue);
here selectedCatID will give the selected CatID of the category you selected....

Thanks.
Masud (5.8.9)

Adding cc and bcc in MailMessage

2009-07-24T16:05:00.000-07:00

This is a pretty little thing but it may cause sometimes a lot of problem when you are implementing the email function. Suppose you are using System.Net.Mail namespace for implementing email functionality.So code is:

using System.Net.Mail;

MailMessage msg=new MailMessage("from@gmail.com","to@gmail.com");
msg.CC="masudcseku@gmail.com"; /*Error*/
msg.CC.Add("masudcseku@gmail.com");/*correct*/

msg.bcc="masud_mnthk@yahoo.com"; /*Error*/
msg.bcc.Add("masud_mnthk@yahoo.com");/*correct*/

This is a pretty little thing huh!...but often this will be useful.
**************************************
Masud(7.25.2009)

Issuing a javascript object by ASP.NET at load time

2009-07-24T15:54:00.000-07:00

This is a nice feature ASP.NET provides that ASP.NET is providing a javascript object populated with data which can be used by client-side script very effectively. Let see this step by step.
Steps:
1. Suppose in ASP.NET you are using some variable (ex:testaskingprices) having some value. Now you want to transfer this value to access by the client-side code. So then you have execute this code in Page_Load event of page

this.ClientScript.RegisterArrayDeclaration("myAskPriceList", testaskingprices);

where
testaskingprices=the ASP.NET variable
myAskPriceList=the javascript variable issued for use

**************************************
Masud (25.7.9)

Allowing paging in Gridview when datasource is not predefined

2009-07-14T13:58:00.000-07:00

Suppose you are not setting predefined data source means you are not using sqldatasource as the data source then this article is helpful for enabling the paging option. Suppose you will determine data source at run-time means you are using SqldataAdapter then u are welcome:

In the html code of Gridview you have to set AllowPaging="true"

Here is the code for handling paging manualy:
protected void TestGV_pageIndexChanging(object sender, GridViewPageEvent e)
{
TestGV.pageIndex=e.NewPageIndex;
TestGV.dataBind();
}

Here we see page index is updated as the index of page changes. By default page size=10 however it can be changed in the html code of Gridview.

Thats for today
Masud (15.7.9)

Removing underline from a hyper link

2009-07-14T13:37:00.000-07:00

This is a nice thing and expected attribute often. This time we have to take the help of Cascading Style sheet. Here we should follow 2 steps:
1. define a class in css file
2. apply the class to the control

Lets discuss:
1.class hyp in css file:
.hyp
{
font-weight:bold;
display:run-in;
text-decoration:none;
cursor:pointer;
}
Here text-decoration is set to none therefore underline will not be shown.
2. using class to the control:
<asp:HyperLink ID="mylink" runat="server" CssClass="hyp" NavigateUrl="mypage.aspx">
Go to my page
</asp:HyperLink>

Here we see that css class is set to the control but one thing must be done while using the css class. Css file must be linked to the page in head section. Here is that code

<link href="default.css" type="text/css" rel="Stylesheet"/>

I think this will be helpful.

thanks.
Masud (15.7.9)

Formatting data in Gridview cell

2009-07-14T02:07:00.000-07:00

This is an important thing u need when working with grid-view. Suppose u want to format the numerical data in currency form or date form then you have to do a little trick.
Suppose your column name is
"Amount" should be shown as currency (ex: $100)
"PaymentDate" should be shown as date (ex:7/12/2009), generally SQL 2005 will show it as (7/12/2009 12.00 AM) which is a bad format.

so lets check it out. Suppose we are using TemplatedField in GridView and as field we are using labels ..so the code like this.

<asp:GridView ID="TestGV" runat="server">
<Columns>
<asp:TemplatedField>
<ItemTemplate>
<asp:Label ID="CurrencyLabel" runat="server" Text='<%#String.Format("{0:c}",Eval("Amount"))%>' > </asp:Label>
</ItemTemplate>
</asp:TemplatedField>
<asp:TemplatedField>
<ItemTemplate>
<asp:Label ID="PaymentDateLabel" runat="server" Text='<%#String.Format("{0:d}",Eval("PaymentDate"))%>' > </asp:Label>
</ItemTemplate>
</asp:TemplatedField>
</Columns>
</asp:GridView>

So this is the required code for converting into the desired format of data.

thanks.
Masud (15.7.9)

Adding client side (javascript) function to ASP.NET server contorl

2009-07-13T15:41:00.000-07:00

This is critical things I was looking for many days..that is how to add javascript event to the server side ASP.NET control. This is very needed often but I could not manage it for a long time. However, this time I got some. We have to follow 2 steps.
1. Define client side function
2. Add function/event to the control.

1. Define the client side function
Suppose a text box...I want to limit total chars in it is 100. If we want to use javascript for this then code will be like this. This code will be scripted in the .aspx page...that means will be in the script tag in the main page.

function allowInsert(total) /*here total=100*/
{
var mybox=document.getElementById("mytextbox"); /* server control ID="mytextbox"*/
var text=mybox.value;
var len=text.length;
int mylen=0;
mylen=parseInt(len);

/*testing condition*/
if(mylen< total)return true;
else return false;
}

2. Adding function to the server control
In Page_Load event of .aspx.cs (code-behind) page we have to add the following line
Let mytextbox is the ID of the control.So....
mytextbox.Attributes.Add("onkeyup","javascript:return allowInsert(100)");

Now when a char will be entered in mytextbox then each time this function will be checked
whether it is allowed or not.

thanks.
Masud(14.7.9)

Use of stored procedure in a table data show

2009-07-13T15:18:00.000-07:00

Most of us heard about the stored procedure. I also heard about it but I could not know how to use it. However stored procedure is very helpful for the big queries which is tough to build every time we use. So centrally a function/procedure is stored and called when we need that certain actions it perform....so this is called stored procedure. Here are some tips about stored procedure.

1.create a stored procedure:
How to build a stored procedure: Suppose u want to show info of the students of CSE discipline.
So the code is:

CREATE procedure dbo.showAllInfo
(
/*parameter list*/
@discipline varchar(50)

)
as
select * from Student where discipline=@discipline

EXEC dbo.showAllInfo

Now save the document using any name and execute this sql in VS or any other tools that has access to DB. When it is executed successfully then you will see a new entry called showAllInfo in the stored procedure folder of your DB.

2. Use of stored procedure
Here is how to use stored procedure. Lets take a glance on it. Let we are using SqlConnection object.

try
{
SqlConnection conn=new SqlConnection(ConfigurationManager.ConnectionStrings["MASUDDBConnectionString"].ConnectionString);
conn.open();
SqlCommand comm=new SqlCommand();
comm.Connection=conn;
comm.CommandText="showAllInfo";
comm.CommandType=CommandType.StoredProcedure;
comm.Parameters.AddWithValue("discipline","ParamValue"); /*paramvalue=CSE*/

SqlDataAdapter sda=new SqlDataAdapter(comm);
DataTable dt=new DataTable();
sda.Fill(dt);

/*databinding*/
SomeGridView.dataSource=dt;
SomeGridView.dataBind();

/*results rendered successfully*/

/*closing conn*/
sda.Dispose();
conn.Close();

}
catch(Exception exc)
{
}

Updating an entry of table using mygeneration tool

2009-07-13T15:09:00.000-07:00

To change an entry of the table is also interesting and easy. You don't need to write an update query or even think of creating and closing a sql connection...even no chance to hurt a primary key also. Just follow these steps. Lets consider the Admin table. Suppose Admin wants to change the password having AdminID=5. So here lies the following code:

try
{
Admin admin=new Admin();
admin.ConnectionString=ConfigurationManager.ConnectionStrings["MASUDDBConnectionString"].
ConnectionString;
if(admin.LoadByPrimaryKey(5))
{
admin.AdminPassword="new password";
admin.Save();
/*entry updated successfully*/
}

}
catch(Exception exc)
{
/*error notification*/
}

So this is the easiest way to update a table entry as I believe. what do you think about this?

thanks
Masud(14.7.9)

How to show a table data with mygeneration business object?

2009-07-13T14:49:00.000-07:00

As from the last blog we came to learn about how to add a new entry in the table without any touch to the table. Lets consider the admin table. So we have got the following things already in hand:
1. _Admin.cs (Abstract class)
2. Admin.cs (Extension of _Admin)
3. Admin.sql (All doodad's stored procedures)

And it is expected we have already added some rows to the table. Now comes how we can show the value from the table. This is the most interesting part of mygeneration tool. You have 2 options
a. show values of one item
b. show values of all items in table

show values of one item:

This is quite easy. Here is the code following.
Suppose AdminID of Admin table is 5. So the following code shows Admin's info having AdminID=5.

try
{
Admin admin=new Admin();
admin.ConnectionString=ConfiguraionManager.ConnectionStrings["MASUDDBConnectionString"].
ConnectionString;
if(admin.LoadByPrimaryKey(5))
{
/*Loaded the single instance*/

Response.write("Email:"+admin.AdminEmail+" Admin Pass:"+admin.AdminPassword+"
");

}

}
catch(Exception exc)
{}

show values for all items:

try
{
--------
same as previous
--------
if(admin.LoadByAll())
{
/*All instances loaded*/
admin.Rewind(); /*setting pointer to 0th row*/
do
{
Response.write("Email:"+admin.AdminEmail+" Admin Pass:"+admin.AdminPassword+"
");

}while(admin.MoveNext());

}
}
catch(Exception exc)
{}

So these are the way to access rows in the table. I think it is quite interesting, isn't it?

thanks.
Masud (14.7.9)

Adding a new entry in tha table (using Mygeneration)

2009-07-07T03:36:00.000-07:00

If you want to add a new entry in the database table then this topic is going to help you. Let us consider that we have a table in the database called Student and schema like this

table name: Student
Fields:
{
name varchar(50),
roll varchar(10),
cgpa float,
address varchar(50),
email varchar(50),
birthDate smalldatetime
}

During the creation of table two things must be done:
1. setting a column as an identity element with auto-increment 1
2. setting that column as the primary key.
Lets consider how this can be done. Suppose Admin is table
lets create the table using a sql query:

USE BIZNES
go
create table Admin
(
AdminID smallint IDENTITY,
AdminEmail varchar(50),
AdminPassword varchar(50),
Primary key(AdminID)
)
go
SET IDENTITY_INSERT Admin ON

Another Process:
Suppose you have created table using GUI of SQL server 200x and you want add that constraint.Use the following steps:
a. Right click on table and do to table definition
b. Select the desired column and set
Identity=Yes
Autoincrement=1
Not for replication=Yes
c. Set this column as primary key

where BIZNES is the database name. So if you design a table like this using a query
the created table is perfectly suitable for input to mygeneration tool. So please design
your own table setting identity and primary key and generate business objects like _Admin.cs file or other stored procedures.

We have already learned how to create _Student.cs or Student.cs file. If you are not familiar with this please follow my previous blogs about mygeneration tool. So now a small snippet of code is needed for you to add an entry in the database. That is:

Student std=new Student();
std.ConnectionString=ConfigurationManager.ConnectionStrings["MASUDDB
ConnectionString"].ConnectionString;
std.AddNew();
std.name="Masud";
std.roll="040201";
std.cgpa=4.63;
std.address="Farmgate,Dhaka";
std.email="test@gmail.com";
std.birthDate="25/04/1998";
std.Save();

This is how a new row or entry is created in database. You don't need an insert query for getting an entry. You can handle all this in a fine manner...isn't it?

thanks.
Masud
7.7.9

Steps for working with Mygeneration tools

2009-07-02T13:36:00.000-07:00

After installing the software you will have to follow the following steps to make it completely workable.
1. Create your tables (as per your database design)
2. Create abstract classes
3. Extend the abstract classes
4. Store them in App_Code folder in your website
5. Executing the dooDad's stored procedures

Now lets come step by step
1. Table creation
I think people already know this how to create a table in the a database. Let me remind one important thing those who are working SQL Server 2005 or higher. While connecting to the database then:
Server: (local)\sqlexpress
Here we often write (local)/sqlexpress and generally get an error number 40. Those who are suffering this problem it can be cure for them. Though it is expected people are acquainted with process of table creation however let me give a clear view.
a. Click Server Explorer from View
b. Find Data Connections
c. Data Connection>Create New SQL server database
d.Server: (local)\sqlexpress
e. Now let database name Test..
f. Test>Tables>New Table
g. Generate different fields
h. Save the table

2. Create abstract class
When your expected tables are created then actually your interaction with database is really over. Now mygeneration tool will take care of all the things. So open mygeneration tool and follow the steps.
a.Open>Templates>C#>CSharp_SQL_BusinessObject
b. Execute
c. Now fill the following like these
Output File Path: C:/test folder/
Namespace: TestNamespace
Select a database:Test
Select Table: Maximus
Select Language: C# (default)
d. Press Ok
Now you will find an abstract class named Maximus.cs, but the class file in it named as
_Maximus. It will have following type of code

namespace TestNamespace
{
public class _Maximus
{
/* different codes*/

}

}

So rename the Maximus.cs to _Maximus.cs. And this is the abstract class file for you
which will be used for further database operations

3. Extend abstract class
This is very simple. Lets follow the steps
a. Create a Maximus.cs class file from VS
b. Now open the file and write the following code

public class Maximus: TestNamespace._Maximus
{

}
c. Now save the Maximus.cs file.

4. Store these files
Now an important thing is to store these files where. Follow these steps
a. Create/Open the App_Code folder in your website
b. Create two folder in it named DAL and BO
c. Now store _Maximus.cs in DAL
d. And store Maximus.cs in BO
e. As you storing these files in App_Code so these class files will be automatically complied.

5. Execute the stored procedure
a. Open Mygeneration tool
b. File>New>Mygeneration Project>Add template instance
A window will popup. Now insert the following info
name:test
Template: Microsoft SQL Server>d00Dads Stored Procedures
c. Now click Record Template input
Now another window will popup
d. Insert info like this
Output file path:C:/test/
Select a database: Test
Select table: Maximus
Press Button Ok. and return to previous window and also press Ok
e. You will discover test like
New Project >test
f. Now right click on test and select execure
Here you will find a black screen giving message that stored procedure created successfuly.
g. Now open C:/test. Here you will find a file Maximus.sql
h. Open this file using Mygeneration tool
i. Then execute from toolbar

Now your duty is finished. get relaxed and you can do all database works just calling Maximus class. Now from your website in any page you can create code like this:

Maximus maxOb=new Maximus();
maxOb.Name="Masud";
maxOb.Roll=040201;

where Name and Roll are fields of Maximus table you created. However thats all for today.
Next time I will be more specific using example.

thanks.
Masud(3.7.9)

My Generation Tools

2009-06-26T01:39:00.000-07:00

Those people who want to create abstraction about database applications that means don't want to care about low level database application I have a nice suggestion for them----use mygeneration tool which can take care of all database operations. Those who are interested with this just visit the following link and download the softyware
http://www.mygenerationsoftware.com
I will continue how to use of mygeneration tool in next some blogs

thanks
Masud (26.06.09)

How to send email from a website

2009-06-20T17:26:00.000-07:00

This is a nice piece of task I get much pleasure. I think this is a very interesting task for a CSE student who is not yet recognized with the technique of sending an email. Let me state the process step by step. There are two sections:
a.Administrative part
b. Developer's part.

Administrative part:
For Administrative part you have to just set the configuration (shown above) in your web configuration (web.config) file. If you do it to the hosting company server's file then no need to think about other thing. But if you want to make local server (your computer) as the mail server then you have to do some other configuration:
1. Open Control Panel
2. Open Administrative tools
3. Select Internet Information Service (IIS)
4.Select Default SMTP>Properties
5. Click Access tab>Relay (Relay Restrictions)>Grant Access for 127.0.0.1
when you are done with this configuration you are ready to write the funtion for sending email. The required configuration is:


<system.net>
<mailSettings>
<smtp from="test@nochallenge.net">
<network host="localhost"
userName="test@company.net"
password="****"
port="25"
defaultCredentials="false"/>
</smtp>
</mailSettings>
</system.net>

Developer's Part:
As a developer you just have to write a function for sending email.
Here is the code

protected void SendingEMail()
{

string from="test@yahoo.com";
string to="test@gmail.com";
MailMessage msg=new MailMessage(from,to);
msg.Subject="This is test mail";
msg.Body="Please respond if you get this mail";
SmtpClient client=new SmtpClient("localhost");
client.Send(msg);
Response.write("Mail Sent successfully!");

}

thanks
Masud(26.06.09)

How to upload an Image to web server

2009-06-20T16:41:00.000-07:00

In this blog I am going to discuss about how to upload an image in web server. Before you upload an image to the server at first you have to ensure that the web server gives you exact permission to upload the image. If permission is not set to true and you yourself are the web administrator here then you have to set that permission true by yourself. For that you have to use Plesk File Manager (or probably others) for granting permission.
Use the following steps:
1. Open Plesk file manager for web server (provided by Hosting company)
2. Login as administrator
3. Click edit/modify for a folder
4. For all users grant modify permission for the target folder you want to store in your image files.
5. Logout from the Plesk file Manager.

Now comes the user's task to do. He/she has small parts to do. Use the following steps.
1. Drag and drop FileUpload control from toolbox of visual studio. This control has a Browse button. Clicking this button you can select any file and path will be shown in the textbox of this control.
2. If you want to upload just image then you check file extension for images and allow to upload
3. Now look at the following snippet of code (C#).

protected void uploadImage()
{
try
{
string fileName=FileUpload1.FileName;
string serverPath=Server.MapPath("images/"); /*images is the folder in webserver you want to upload images */
if(FileUpload1.HasFile) /*already uploaded to server*/
{
FileUpload1.SaveAs(serverPath+fileName); /*image saved to web server folder*/

}
else StatusLabel.Text="No Image file selected";
}catch(Exception exc)
{
StatusLabel.Text=exc.Message;
}

}

Making alignment with table

2009-06-20T15:02:00.000-07:00

<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td align="left">Masud</td>
<td align="left">Assad</td>
<td align="left">Mamun</td>
<td align="left">Sayed</td>
</tr>
<tr>
<td align="right">Shakila</td>
<td align="right">Shamima</td>
<td align="right">Shahnaz</td>
<td align="right">Tonni</td>
</tr>

<tr>
<td align="center">Grand father</td>
<td align="center">Grand Mother</td>
<td align="center">Father</td>
<td align="center">Mother</td>
</td>
</table>

Start design with table

2009-06-17T23:57:00.000-07:00

If you want to start designing web page the start design with the table control. Nothing can be in a good shape without using table. During my university years, I spent a lot of time to discover that table is the key of all kind of design efficiently and with full control. Those who have little knowledge about HTML language they can easily realize my following code. Just start like this:

A Simple web page design:

<table>
<tr>
<td>First Column</td>
<td>Second Column</td>
<td>Third Colimn</td>
</tr>
</table>

This is a simple page design using a table which has three columns. Now each of these 3 columns can be further nested with other different controls like table, GridView, labels, buttons.....more and more.
However, just start with this ...you will be benifitted I am sure!

Thanks.
Masud (18.06.09)

Learn to design web form by coding

2009-06-17T05:38:00.000-07:00

Those people are still designing the web pages based upon the design view of Visual studio I think I am suggesting those people to stop that jsut from now and start coding just from now. I was a design-view user of visual studio which made me just a fool with a tool. However, time passed and things changed. I started designing web pages using raw xhtml which made me comfortable with website designing and to be very frank this made faster in design and many things have become clearer of the mark-up language like xhtml. However, my later blogs will contain different tutorials and solutions of the problems I have faced during my job-life.

Thanks.

Masud (17.06.2009)