You can direct set pageIndex property of the gridview in page load event like below code GridView1.PageIndex = 2; Page index starts from 0 so 2 will display page 3 in gridview. Hope this might help you. My DotNet Stuff

If you can post some sample code than it will be great help for other user to answer. Let me ask you one thing you have set allowpaing='true' but do you write PageIndexChange event like below protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { gridView.PageIndex = e.NewPageIndex; gridView.DataBind(); } If not then try this. Other wise just provide some code which is causing an issue so other user can look into that. Hope this will help. My DotNet Stuff

What ever I believe is never compare one thing with another because both has some unique advantage. It's upto developer to whom prefer, Where they fill that this is the good for them they can prefer that way.............. Dot Net Stuff

Congrats Vikram! Wish you a very happy married life.

Hello Dear, We developed one project nameed Richmedia. We are servering advertising banner on in.msn.com. So when msn page call from any corner of the world it will ping our server on proirity base. Our database is Sql Server 2005. We have optimised all dotnet code after we came to know about that in SQL Server LOg File there are lots of error. And all error is like same Error: 18056, Severity: 20, State: 23. 2009-02-20 17:53:25.07 spid249 The client was unable to reuse a session with SPID 249, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. Can Anyone tell me why I am getting this error frequently? Any help would be appreciated. TarDak

Hi I am developing one application which is registering Impressions and clicks for banner advertising site. When any flash banner runs it will call to my aspx page with some value as a Query String I will catch that parameter and add into database. Our application is running on MSN India. So it will generate huge load on our server. Recently we come to know that we are loosing impression means we are not registering all impression served by server. So I downloaded Microsoft Web Stress Tool. Site Manager and One more tools to check virtually load on the server But it is display lots of bad request like Socket error, Http error, Session Error, Request failed due to 401 response something like that. So My problem is that how can I reduced this error. If Msn pinging my server 1lac time per day I want to register 1 lac impression. I don't want to loose even single impression. Is there any solution?????? http://www.tardak.com

Hi All, I am working in Web Development Firm. We have client name MSN India. When ever anyone open in.msn.com page from all over the world three banners are loading on the every page. Some of them are serving from our Richmedia server. Msn tracking how many times our banner runs on MSN Portal and we also the same thing. But the report is showing different no. Normally when any banner(Flash) running on msn it is calling our one page name getbase.aspx we are simply inserting into one temporary table. After some specific interval we are running job which will check the detail and find the location and update or insert into the master table from where we are generating reports. Our DB Admin is telling our DB server has capacity to open 42k connection / 1Sec. And when any one banner is running on high priority then it will send 150 to 200 request / 1sec. Then also we are not getting same reports due to timeout expired. Is there any other possible way to reduce the load on db server? So we can stop timeout? It’s very urgent. If any sample code can you put it will be acceptable. <a href="http://www.tardak.com">http://www.tardak.com</a>

There is no other way to open a new window other then any client side script. You have to use either Javascript or vbscript.

Add target="_blenk" attribute in A href tag link below link Click Got it? Techie From Surat

You can not use smtp.gmail.com you have to use mail.yourdomainname.com. and if you are sending from local system then use localhost or 127.0.0.1 I hope it will help you. http://techiefromsurat.blogspot.com

Hi, If in login table you told that value is like table1,table2 etc. After retriving data from that column you directly inserted in insert query I don't think so you can insert data more that one table at a time. As per your code you are trying to write this query insert into table1,table2 values ('1','1'); It will generate error. Am I right? Other wise after retriving that data split it with , then loop and fire insert query. Just reply am I write with above query. And also describe the error message perfactly. http://techiefromsurat.blogspot.com

Hi First time it comming fine because it's clear so now In the SelectedIndex_Changed event DropDownLost1.Clear(); Code to bind data to DropDownList Then DropDownList1.Items.InsertAt(0,"Select"); I think it will solve your problem Techie From Surat http://techiefromsurat.blogspot.com/

Hi I am using GridView. And in that gridview One hyperlink filed is there. Till now I was passing only one parameter as a querystring to DataNavigateUrlFormatString property but now it is required to pass 2 value So how can I do Here is the code which was workig fine DataTextField="CrName" SortExpression="CrName" /> But now I added this one so it is giving error Like "Index(zero base) must be greater than or equal to zero and less than the size of the argument list." DataTextField="CrName" SortExpression="CrName" /> Can any one figure it out what is the problem and how can we solve? Thanks in advance http://techiefromsurat.blogspot.com/

HI Senthil Use this code in Aspx page inside gridview Column Heading <%#FormatString(Eval("ColumnName").ToString(),20)%> in .cs file just write down this function public string FormatString(string strval, int length) { string temp = strval; if (temp.Length > length) temp = temp.Substring(0, length - 3) + "..."; return temp; } Just guese here I am passing 20 as a lenth variable so it will add ... if string is more than 20 characters http://techiefromsurat.blogspot.com/

Hi buddy, I don't think so that you can share any variable or object with Javascript(ClientSideScript) and C#(ServerSideScript). And if you want to use variable then you can use hidden field server side so both C# and Javascript can access it easily. Hope it will help http://techiefromsurat.blogspot.com/

Hi lipi, I hope you have heard about GridView inside GridView. Just try that you can easily do that. If you haven't heard about that just go through this code, Put one GridView on aspx page with inside This master gridview put another gridview with name 'GridView2' ok Write RowBound event of GridView1(Master gridView) protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { GridViewRow row = e.Row; if (row.DataItem == null) { return; } GridView gv = new GridView(); gv = (GridView)row.FindControl("GridView2"); //Prepare the query for Child GridView by passing the Employee ID of the parent row DataSet ds = ChildDataSource(((DataRowView)e.Row.DataItem)["employeeID"].ToString()); gv.DataSource = ds; gv.DataBind(); } Here is the ChildDataSource Method private DataSet ChildDataSource(string strEmployeeId) { DataSet ds = new DataSet(); string Query = "Select * from Employee_Master where EmployeeId='" + strEmployeeId+ "'"; // This is my structure to access data ok just use here your code ds = dataacesslayer.SqlHelper.ExecuteDataset(DBCon.ConnectionString, CommandType.Text, Query); return ds; } And let me know is your problem solved or not? http://techiefromsurat.blogspot.com/

Hi, I am working on a project and I am showing 4 different datagrid on the page. On the top of page there are 4 button for download, email, print and view full report. and also same option on the each indivisual grid. Our requirement is when user click on the individual button then it will download,print, email or full report will do respected task for perticular grid, but when user click on the top of the page then I want to give download all the four grid in one excel file, I want to send all the data as a email also same for print. I have done some thing for email and print but it't not too good if you have any example ready made then it will graceful. If you can give any suggesion then also it will be grace full. Please help me it's very urgent

There is no built in dialog box in asp.net like desktop application either u have to develop it or u can use javascript

Hi, I am developing one portal in that I am using richtext box to format the text. I did it. And I am saved it as HTML Encode using System.Microsoft.Application.AntiXss library Dll. I working fine. But when I am retriving it from the database and display on the page in side it is dispaling like <P align=center><B><FONT color=#ff6600 CVbhz="0" lHr4T="0">Looking for Executive Trainees</FONT></B></P> <P CVbhz="0" lHr4T="0">NTPC is looking for promising, energetic, young graduate engineers & professionals with brilliant academic record to join the organization as: </P> <P><B CVbhz="0" lHr4T="2">Executive Trainees<BR>Electrical (130), Mechanical (195), Civil (25), Control & Instrumentation (105), <A class=kLink oncontextmenu="return false;" id=KonaLink1 onmouseover=adlinkMouseOver(event,this,1); style="POSITION: static; TEXT-DECORATION: underline! important" onclick=adlinkMouseClick(event,this,1); onmouseout=adlinkMouseOut(event,this,1); href="http://www.mbajunction.com/jobs/displayjob.asp?fwid=6961#" target=_top><FONT style="FONT-WEIGHT: 700; FONT-SIZE: 8.3pt; COLOR: orange! important; FONT- Sorry When I paste it here it is looking different what I am seeing. just replace < with '<', > with '>' and like that. any suggestion would be acceptable Thanks and Regards

I think this code will work just try it. And let me know it's working or not just change image format as per requirement and variable name and also that database fieldname. Response.Clear(); Response.ContentType = "image/jpeg"; System.Drawing.Image image = null; Cmd = new SqlCommand("SELECT fieldname FROM tablename where field='" + id + "'", Con); Cmd.CommandType = CommandType.Text; SqlDataReader Dr = Cmd.ExecuteReader(); if (Dr.Read()) { byte[] imageData = (byte[])Dr[0]; MemoryStream memStream = new MemoryStream(imageData); image = System.Drawing.Image.FromStream(memStream); image.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg); }