dev-exchange.com

how to check actual spead of the query in sql studio?

Andy — Tue Mar 02, 2010 11:55 am

Author: Andy

Posted: Tue Mar 02, 2010 11:55 am

i have some query running very slow. i have checked query execution plan but is there any way i can remove the cached query from database?

Help Me

nyks — Thu Nov 26, 2009 11:06 pm

Author: nyks

Posted: Thu Nov 26, 2009 11:06 pm

Hi,
Select count(*) as total from Table.
This is the way how you can express no of rows to user.

Validator in ASP.Net

nyks — Thu Nov 26, 2009 10:58 pm

Author: nyks

Posted: Thu Nov 26, 2009 10:58 pm

Hi,
Yes you can validate your Input Data through validators.
There are 5 validators to be used.
Please i cant give you that code here. but please use google for more information.

database connection settings in asp.net

nyks — Thu Nov 26, 2009 10:51 pm

Author: nyks

Posted: Thu Nov 26, 2009 10:51 pm

Hi,
If your using in-built Sql express server, you dont need to do any thing.
just use Wizard through connection or write ADO.NET code manually. But after doing this you don't need to setting up this connection to the web config file.
ASP.NET takes that setting for granted Automatically.

Hyperlinks inside gridview

facklera — Thu Nov 26, 2009 4:51 am

Author: facklera

Posted: Thu Nov 26, 2009 4:51 am

How do you program a hyperlink in a PDF doc to open into a new browers window? I am converting Word docs to PDF. If an exisiting browser window is open when you click on a hyperlink in the PDF doc it opens in the exisiting browser window instead of opening a new window. Why is this? How can I make it so the hyperlink always opens a new browser window?
_______________________
market samurai ~ marketsamurai ~ marketsamurai.com

setting page request time out in asp.net

eakinasila — Wed Nov 25, 2009 9:30 am

Author: eakinasila

Posted: Wed Nov 25, 2009 9:30 am

How do I limit FTP privileges? For instance, they can only access certain directories? I'm working on Windows XP, and we have an FTP account (don't know exactly where). How Can I restrict access to certain logins/groups/whatever?
_____________________
external keyword tool ~ keyworddiscovery.com ~ keycompete.com ~ compete.com ~ webmasterworld.com

Cheap hosting to open one web site?

mackinroj — Sat Oct 24, 2009 6:40 am

Author: mackinroj

Posted: Sat Oct 24, 2009 6:40 am

Hi cyberfriend,
Myself Macki and i read your query about cheap rate of hosting and domain registration
so I prefer you to go on www.hostso.com they will provide you cheap rate and full
support in inconvenience..ok

Thanks..

SAP training video

Kishore — Sun Sep 13, 2009 9:12 pm

Author: Kishore

Posted: Sun Sep 13, 2009 9:12 pm

That domain name seems to be bit strange... copyright info on the site is even more odd... any way didnt check the videos.

what should i do to give alert box for invalid security code

Kishore — Tue Jul 21, 2009 9:42 pm

Author: Kishore

Posted: Tue Jul 21, 2009 9:42 pm

you are trying to call server side php using java script which is not correct. if you want to call a server side script from client side, you need to use Ajax and this is a different topic. for you here is the simple example for creating captcha, http://www.codewalkers.com/c/a/Miscellaneous/Creating-a-CAPTCHA-with-PHP/

..

PHP-DB - PHP/MySQL simultaneously running

shifanyroma — Wed Jul 15, 2009 2:17 am

Author: shifanyroma

Posted: Wed Jul 15, 2009 2:17 am

Hello I am planning on creating multiple PHP scripts that should constantly be running and I am wondering if PHP scripts can be run at the same time or it waits until another script finishes doing its job

If scripts can run at the same time I have a problem I am curious about

Code:

views = 5

script1.php
loads views from database
views + 1

script2.php
loads views from database
views + 1

script1.php
updates database - views = 6

script2.php
updates database - views = 6

^this should be 7 but can it run at the same time?

Re-install PERL on Vista

shifanyroma — Wed Jul 15, 2009 2:12 am

Author: shifanyroma

Posted: Wed Jul 15, 2009 2:12 am

I have re-installed Perl on my Vista home premium.

A perl script executes successfully in the dos window.

However when I try to run a script from a web page, i.e. from localhost, I get the following message ...

Server Error in '/' Application.
Could not load type 'e:\Perl\bin\PerlIS.dll'.

(There is more, which I did not copy).

A bit of history - when I installed the first Perl, it was from a cd and automatically loaded onto the E drive. Since then, I uninstalled that and installed from a web page download.

I have removed the e:... reference from the path in environment variables.

IIS7 works successfully, as do php scripts.

How do I fix this so that it points to the installation on the c drive?

custom paging using 'next/pre with numeric'

pupilstuff — Fri Jul 10, 2009 7:33 am

Author: pupilstuff

Posted: Fri Jul 10, 2009 7:33 am

hi guys i just want to perform custom paging in which at the footer of the grid view ,there must be a pager 'pervious/next with numeric'

this is what i did

in aspx page

<asp:GridView ID="TableGridView"

OnPageIndexChanging="TableGridView_PageIndexChanging"
runat="server" AutoGenerateColumns="False"
AllowPaging="True" AllowSorting="True" >

</asp:GridView>

<asp:Button ID="btnConnect" runat="server" Style="z-index: 113;
left: 260px; position: absolute; top: 143px" Text="Connect & Populate" OnClick="btnConnect_Click" />

in code behind page

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

public static DataTable Table = new DataTable();
ArrayList ParameterArray = new ArrayList();

protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack && (bool)Session["IsConnectionInfoSet"]==true)
CreateTemplatedGridView();

}

protected void TableGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//CreateTemplatedGridView();
TableGridView.PageIndex = e.NewPageIndex;
TableGridView.DataBind();
}

protected void btnConnect_Click(object sender, EventArgs e)
{
Session["IsConnectionInfoSet"] = true;
CreateTemplatedGridView();
}

void PopulateDataTable()
{
Table = new DataTable();
TableGridView.Columns.Clear();

SqlDataAdapter adapter = new SqlDataAdapter("select * from customer", "Data Source=OPWFMS-7KYGZ7SB;Initial Catalog=Mayank;User ID=sa;Password=sa");
adapter.Fill(Table);

}
void CreateTemplatedGridView()
{
// fill the table which is to bound to the GridView
PopulateDataTable();
// add templated fields to the GridView
TemplateField BtnTmpField = new TemplateField();
BtnTmpField.ItemTemplate =
new DynamicallyTemplatedGridViewHandler(ListItemType.Item, "...", "Command");
BtnTmpField.HeaderTemplate =

new DynamicallyTemplatedGridViewHandler(ListItemType.EditItem, "...", "Command");
TableGridView.Columns.Add(BtnTmpField);

for (int i = 0; i < Table.Columns.Count; i++)
{

TemplateField ItemTmpField = new TemplateField();
// create HeaderTemplate
ItemTmpField.HeaderTemplate = new DynamicallyTemplatedGridViewHandler(ListItemType.Header,
Table.Columns[i].ColumnName,
Table.Columns[i].DataType.Name);
// create ItemTemplate
ItemTmpField.ItemTemplate = new DynamicallyTemplatedGridViewHandler(ListItemType.Item,
Table.Columns[i].ColumnName,
Table.Columns[i].DataType.Name);
//create EditItemTemplate

// then add to the GridView
TableGridView.Columns.Add(ItemTmpField);

}

// bind and display the data
TableGridView.DataSource = Table;
TableGridView.DataBind();
}

}

and in the class file

public class DynamicallyTemplatedGridViewHandler : ITemplate
{

ListItemType ItemType;
string FieldName;
string InfoType;

public DynamicallyTemplatedGridViewHandler(ListItemType item_type, string field_name, string info_type)
{
ItemType = item_type;
FieldName = field_name;
InfoType = info_type;
}

public void InstantiateIn(System.Web.UI.Control Container)
{
switch (ItemType)
{
case ListItemType.Header:
Literal header_ltrl = new Literal();
header_ltrl.Text = "<b>" + FieldName + "</b>";
Container.Controls.Add(header_ltrl);
break;
case ListItemType.Item:
switch (InfoType)
{
case "Command":
break;

default:
Label field_lbl = new Label();
field_lbl.ID = FieldName;
field_lbl.Text = String.Empty; //we will bind it later through 'OnDataBinding' event
field_lbl.DataBinding += new EventHandler(OnDataBinding);
Container.Controls.Add(field_lbl);
break;
}
break;
}
}

private void OnDataBinding(object sender, EventArgs e)
{

object bound_value_obj = null;
Control ctrl = (Control)sender;
IDataItemContainer data_item_container = (IDataItemContainer)ctrl.NamingContainer;
bound_value_obj = DataBinder.Eval(data_item_container.DataItem, FieldName);
switch (ItemType)
{
case ListItemType.Item:
Label field_ltrl = (Label)sender;
field_ltrl.Text = bound_value_obj.ToString();
break;
}

}

}
but for my requirements I want to use that code

class NumericWithNext : ITemplate
{

GridView localGrid;
int intSlotNo = 0;

#region CONTRUCTOR

public NumericWithNext(GridView gv)
{
localGrid = gv;
//intSlotNo = slotNo;
intSlotNo = localGrid.PageIndex / 10;

//constructor
}
public void InstantiateIn(Control container)
{
LinkButton prevTenRecords = new LinkButton();
prevTenRecords.Text = "Previous 10 Pages";
prevTenRecords.CssClass = "PagingLnks";
prevTenRecords.CommandArgument = ((intSlotNo - 1) * 10 + 1).ToString(); ;
prevTenRecords.CommandName = "Page";
//prevTenRecords.Click += new EventHandler(prevTenRecords_Click);
prevTenRecords.Width = Unit.Pixel(125);
if (intSlotNo > 0)
{
container.Controls.Add(prevTenRecords);
}

LinkButton nextTenRecords = new LinkButton();
nextTenRecords.Text = "Next 10 Pages";
nextTenRecords.CommandName = "Page";
nextTenRecords.CommandArgument = ((intSlotNo + 1) * 10 + 1).ToString();
// nextTenRecords.Click += new EventHandler(nextTenRecords_Click);
nextTenRecords.CssClass = "PagingLnks";
nextTenRecords.Width = Unit.Pixel(118);
// nextTenRecords.Visible = false;

LinkButton prev = new LinkButton();
prev.Text = "Previous Page";
prev.CssClass = "PagingLnks";
prev.CommandArgument = "Prev";
prev.CommandName = "Page";
prev.Width = Unit.Pixel(90);
if (localGrid.PageIndex > 0)
{
container.Controls.Add(prev);
}

//for (int pagenum = 1; pagenum <= localGrid.PageCount; pagenum++)
for (int pagenum = (intSlotNo*10)+1; pagenum <= (intSlotNo+1)*10; pagenum++)
{
if (pagenum > localGrid.PageCount)
{
nextTenRecords.Visible = false;
break;
}
LinkButton pageInd = new LinkButton();
if (pagenum == localGrid.PageIndex + 1)
{
//pageInd.ForeColor = System.Drawing.Color.Green;PagingSelected
pageInd.CssClass = "PagingSelected";
}
else
{
pageInd.CssClass = "PagingLnks";
}
pageInd.ID = "PageInd_" + pagenum;
pageInd.Text = pagenum.ToString();
pageInd.CommandName = "Page";
pageInd.CommandArgument = pagenum.ToString();
container.Controls.Add(pageInd);
pageInd.Width = Unit.Pixel(10);
}

LinkButton next = new LinkButton();
next.Text = " Next Page";
next.CommandName="Page";
next.CommandArgument = "Next";
next.CssClass = "PagingLnks";
next.Width = Unit.Pixel(80);
if (localGrid.PageIndex < localGrid.PageCount - 1)
{
container.Controls.Add(next);
}

container.Controls.Add(nextTenRecords);
}

void nextTenRecords_Click(object sender, EventArgs e)
{
//throw new Exception("The method or operation is not implemented.");
intSlotNo++;

}

void prevTenRecords_Click(object sender, EventArgs e)
{
//throw new Exception("The method or operation is not implemented.");
intSlotNo--;
}

plz let me know how can i do that

System.NullReferenceException was unhandled by user code

HostingASPNet — Wed May 06, 2009 8:36 am

Author: HostingASPNet

Posted: Wed May 06, 2009 8:36 am

Hello,

I agree that the right way is to check for null before doing variable assignment.

Regards

Free Web Hosting

gordbell09 — Thu Apr 23, 2009 7:11 am

Author: gordbell09

Posted: Thu Apr 23, 2009 7:11 am

thanx for posting about the free hosts here, would definitely like to use few of them for my personal use

I need your opinion :)

gordbell09 — Thu Apr 16, 2009 7:25 am

Author: gordbell09

Posted: Thu Apr 16, 2009 7:25 am

here is tool that will help in making money from the site better. it is a free service that estimates the number of visitors any site has. so depending on the data from here you can chose the perfect PPC ad network for your self, it has a host of adsense alternatives that can be used
read more at
http://www.statbrain.com/ad-networks/