September 27, 2008
· Filed under Today, i want to know? · Tagged chrome
hi friends
You know google chrome is out and everyone was so excited about that including me as a very passionate user i tried to do all of the things now in chrome i have imported my firefox settings (bookmarks) into chrome. All bookmarks are showing good I liked that but shortly I needed to perform a simple task in chrome that is “searching for a bookmarked site among all the bookmarks i have” and till now i don’t know how to search for my bookmark in mighty chrome.
So if anyone of you know how to seach bookmarks in chrome please let me know. And one more thing what about tags how can I tag my pages?
July 19, 2008
· Filed under Today
Hey guyz you remember jadu from movie koi mil gia well i have pictures of his fishes
look at them
July 19, 2008
· Filed under Today
well while surfing on web i found this pic its so cute
July 17, 2008
· Filed under Axp.net, C#, Today · Tagged asp.net, C#, Data Access, web development
hey guyz finally we have to learn how to update our tables in database so only for you guys here is my sample code
string giftId = GridView1.SelectedRow.Cells[0].Text.ToString(); //getting an id
SqlDataSource myDbSource = new SqlDataSource();
myDbSource.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//myDbSource.InsertCommand = “update gifts set giftActivate=1 where giftId=” + Entrydate + “)”;
myDbSource.UpdateCommand = “update gifts set giftActivate=’1′ where giftId=” + giftId;
myDbSource.ProviderName = “System.Data.SqlClient”;
myDbSource.Update();
Well this code set giftActive flag to 1 for all the rows matched with giftid value.
July 17, 2008
· Filed under Axp.net, C#, Devlopment, Today · Tagged asp.net, C#, Data Access, web development
Hey guyz today i will show you how to fire delete query by using our beloved control sqldatasource.
Here is the code
SqlDataSource myDbSource22 = new SqlDataSource();
myDbSource22.ConnectionString = ConfigurationManager.ConnectionStrings["lalConnectionString"].ConnectionString;
myDbSource22.ProviderName = “System.Data.SqlClient”;
myDbSource22.DeleteCommand = “delete from ProductsGroups where pid = ” + productId;
myDbSource22.Delete();
All it does it deletes all the rows for a given productID from table productgroups. Simple right 
July 17, 2008
· Filed under Axp.net, Devlopment, Today · Tagged asp.net, C#, Data Access, web development
hey guyz how are you ??
Me back with my sqldatasource series. Today i will show you how to fire insert query using sqldatasource control into code behind i am using c#.
Below is the sample code UserID is the parameter passing into a function as an argument.
DateTime Entrydate = DateTime.Today;
SqlDataSource myDbSource = new SqlDataSource();
myDbSource.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
myDbSource.InsertCommand = “insert into tbl_invoices (user,Entrydate) values (” + UserID + “,’” + Entrydate + “‘)”;
myDbSource.ProviderName = “System.Data.SqlClient”;
myDbSource.Insert();
myDbSource.SelectCommand = “SELECT IDENT_CURRENT(‘tbl_invoices’)”;
DataView dv = (DataView)myDbSource.Select(new DataSourceSelectArguments());
DataTable dt = dv.Table;
string invNumber = dt.Rows[0][0].ToString();
return invNumber.ToString();
//return string.Empty;
Code above is very simple what it does simple take UserID as an argument and then insert a new record into tbl_invoices table and then after it i am firing a select statement that returns the latest ID into tbl_invoices table. SELECT IDENT_CURRENT(‘table name’) return the id of the last record inserted into the table.
Happy coding bye
July 16, 2008
· Filed under Axp.net, Devlopment, Today · Tagged asp.net
Hi in asp.net 2.0 this new datasource control has been added and i liked it alot and i used it on many places so i thought it would be nice if I share my knowledge with all my readers so first of all i would just like to show you how to retrieve some data from your database into C# code behind file.
string userID = string.Empty;
string UserName=”najam”;
SqlDataSource myDbSource = new SqlDataSource();
myDbSource.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
myDbSource.SelectCommand = “select userId from Users where userName=’” + UserName + “‘”;
myDbSource.ProviderName = “System.Data.SqlClient”;
DataView dv = (DataView)myDbSource.Select(new DataSourceSelectArguments());
DataTable dt = dv.Table;
if (dt.Rows.Count > 0)
{
userID = dt.Rows[0][0].ToString();
}
Above code will return user id if username supplied. You will see no data adapters or command object.
If you like instead of creating sql datasrouce control in code behind just drag and drop it onto ur aspx page and then in your code behind reference it that will shorten the line of code for fetching data from your database.
July 16, 2008
· Filed under Today
Ummm whats new in my life?
Well finally my Ms in telecom is completed all courses are clear and i am fleeing like a free bird. Tension free consitration on my job no more travling in triangle from home to office and then from there to university.
Hopefully now i will get some time to write for my blog. If anyone still reading please keep reading
October 19, 2007
· Filed under Firefox, Tips & Tricks, Today · Tagged Browsing, Firefox
Surrounded by computers and internet all the time when at work, in university labs or when browsing internet from your home. During long sessions we come across some really good websites and solutions and add them to our bookmarks but as soon as you switch PC your favorites bookmarks are gone. Its very difficult to manage your bookmarks on multiple PC’s but not anymore if you are a firefox fan. One can easily synchronize his/her bookmars by installing a little extension called foxmarks and signing up for an account in foxmarks.com. You probable already know about other solutions like google browser sync and del.icio.us but both of them are very heavy for a dial up user with a distortion in phone line where foxmarks works like a breeze.
Try foxmarks extension for yourself and give me your feedback on this post.
Bye Everyone
thanks for reading 
September 30, 2007
· Filed under Today
Hi guyz,
After many days I am back and back for good recentlly i purchased a domain name and hosting package, so that i can have my own website and I want my settings persistent which was not possible in the case of free hosting like in my case my hosting provider remove the mysql database support.
Can’t tell you how happy I am after getting my website up and running its currently in beta state I will design it from scratch as time permits and planning to use table less design. With my website I have configured a wordpress blog and currently its using a template that I pick form internet after designing my main website I will design my own wordpress template.
Below is the screen shot of my new website.
my blog snapshot is give below
please visit http://www.najamsikander.com and for blog please visit http://www.blog.najamsikander.com
