|
Hi, I would like to know how to call a stored procedure from asp.net ?
|
|
|
|
|
Use SQLConnection , Create SQLCommand , Set CommandType to Storedprocedure , Set CommandText to Stored procedure name. Execute the command.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
|
I am doing an ASP .NET application, where I want to display my grid view as with following requirements.
Paging is working for the grid, and page size is set to 10.
After 10 pages, it shows "..." three dots. I want to show next there always. If I go to page number 15, it should show
the first page as Previous.
If i go to the 11 page now it is showing some thing like this
First ... 11 12 13 14 15 16 17 18 19 20 ...
Here is my Pagerstyle settings for the grid
<pagersettings firstpagetext="First" lastpagetext="" mode="NumericFirstLast" nextpagetext=""Next"" />
Please help to fix this...Thanks in advance.
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
modified on Tuesday, April 21, 2009 12:11 AM
|
|
|
|
|
hi everybody
I implemented Role base security in asp.net on my project. its web.sitemap and tree view working absolutely fine. but when I used below code copied from microsoft site.
sitemap defaultprovider="XmlSiteMapProvider" enabled="true"
providers
add name="XmlSiteMapProvider"
description="Default SiteMap provider."
type="System.Web.XmlSiteMapProvider "
siteMapFile="Web.sitemap"
securityTrimmingEnabled="true" />
add
providers
sitemap
in web.cofig file tree view disappears. please advise how can i make it working properly.
thanks in adv for any kind help.
regards
learner
|
|
|
|
|
i am doing membership walkthrough from msdn. at one step it says set default.aspx as start page. i set it as required but when i start website the login.aspx appears instead of default.aspx
|
|
|
|
|
Then it thinks you need to be logged in in order to see the default.aspx page.
|
|
|
|
|
I am able to send mail from localhost. Now Im want to know how to send email with a link (such as http://localhost/kooras/question.aspx).
shahdat
|
|
|
|
|
Look buddy, get a book, read decent online article or do intense meditation.
Hint: Compose your email in HTML 
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Yusuf wrote: intense meditation.
Learning ASP.NET through intense meditation sounds interesting! 
|
|
|
|
|
Basically, it's ok to write directly 'http://localhost/kooras/question.aspx' into your mail body.
|
|
|
|
|
Hi everyone
I am facing very wiered problem ..I am getting time out expired ..while executing procedure through .net... though query runs very fine from SQL
and it doesn't appear all time .. after some time .. say few hours .. time out expired starts coming for specific query only
I am using the following query
----------------------------------------
select tblDirListings.ListingId,tblDirListings.ListingName,tblDirListings.ListingDiscount,tblDirListings.ListingType,tblDirListings.ListingEmailAddress,tblDirListings.ListingPhone,
(select ListingTypeName from tblMSTDirListingType where tblDirListings.ListingType=tblMSTDirListingType.ListingTypeId) as ListingTypeName
from tblDirListings WITH (NOLOCK)
WHERE tblDirListings.TownId=@TownId and (tblDirListings.AgentId=1 or tblDirListings.AgentId=@AgentId)
and tblDirListings.ListingId in(select top 20 ListingId from tblDirListingCategories WITH (NOLOCK) where TownId=@TownId and CategoryId=@CategoryId)
---------------------------------
and calling the store procedure with .net by following coe
----------------------------
sqlCmd = new SqlCommand();
sqladp = new SqlDataAdapter();
sqlds = new DataSet();
sqlCmd.Connection = con;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = procname;
//sqlCmd.CommandTimeout = 1000;
IDictionaryEnumerator ObjEnumerator = Htab.GetEnumerator();
while (ObjEnumerator.MoveNext())
{
sqlCmd.Parameters.Add(new SqlParameter("@" + (ObjEnumerator.Key).ToString(), ObjEnumerator.Value));
}
sqladp.SelectCommand = sqlCmd;
sqladp.Fill(sqlds);
Not sure why it starts appearing after few hours ..then i need to reupload published dll's of app_code and it starts working fine..
Can any one help?
|
|
|
|
|
I would try rewriting the query to use joins instead of running 3 queries in one, that being said, it doesn't seem like the sql query would be that slow.
Also, you are not opening the con object anywhere are you? Because if the connection is already open the dataAdapter will not close it.
I suggest you bust out SQL Profiler on the server and take a look at what is going on. Filter the trace down to your database and see how often this stored proc is getting called. Check to see if any db connections are left open.
Also, view the current activity on the sql server. See if any locks are occuring. I did notice your one query is missing the with (no lock).
select ListingTypeName from tblMSTDirListingType where tblDirListings.ListingType=tblMSTDirListingType.ListingTypeId
I've never used the with no lock in a query (never needed to) but I guess you are doing that for a reason.
I didn't get any requirements for the signature
|
|
|
|
|
Hi Friends,
I need to export PDF Data to excel sheet by using .Net
Is it possible to export???????
Its very urgent
plz reply me...................
|
|
|
|
|
mohanchandra wrote: I need to export PDF Data to excel sheet by using .Net
Is it possible to export???????
yes it is possible [^]
mohanchandra wrote: Its very urgent
who cares
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Can u say the solution?In which way can we solve?????Plz send the code
|
|
|
|
|
He sent you this link[^] to all the information you'll ever need to develop a solution.
Are you asking for code because (a) You're not capable of developing a solution, or (b) you're too lazy, or (c) you left this task until the last possible minute and your arse is about to be trashed, metaphorically speaking?
10110011001111101010101000001000001101001010001010100000100000101000001000111100010110001011001011
|
|
|
|
|
mohanchandra wrote: Can u say the solution?
the solution. Any thing else you want me to say?
mohanchandra wrote: In which way can we solve?????
that way --->
mohanchandra wrote: Plz send the code
Plz send $1500.00
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
mohanchandra wrote: I need to export PDF Data to excel sheet by using .Net
What does this have to do with ASP.NET ?
mohanchandra wrote: s it possible to export???????
Of course it is. But, only when done by real programmers, who know how to use google and otherwise do basic research
mohanchandra wrote: Its very urgent
No, it turns out that it isn't. At least, not to us.
mohanchandra wrote: plz reply me...................
OK - people like you are the reason I don't post here much anymore. Morons who think they can take Western jobs by asking people online to do the work they have no idea how to do. If you're capable, I don't care where you live. But, you're not, you're totally clueless. So, go away.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I make a online dictionary and I want to add it on firefox browse
Can you help me?
|
|
|
|
|
Need to read Mozilla Developer documentations[^]
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
I'm trying to populate the Server attribute of a very simple MsRdpClient implementation from values in a query string but I'm having trouble.
Ideally the intent here is to simply have my application call this one page for RDP connections to all windows servers.
Sample URL: http://localhost/rdp.aspx?svr=192.168.1.112
<html>
<title>RDP Session</title>
<head>
<script language="vbscript">
sub BtnConnect
Dim goToServer
goToServer = Request.QueryString("svr")
connectedTo.innerhtml=goToServer
MsRdpClient.server = goToServer
MsRdpClient.FullScreen = FALSE
MsRdpClient.Width = "800"
MsRdpClient.Height = "600"
'These 2 do not work from the activeX control
'MsRdpClient.AdvancedSettings2.DisplayConnectionBar = FALSE
'MsRdpClient.AdvancedSettings2.PinConnectionBar = TRUE
'Device redirection options
MsRdpClient.AdvancedSettings2.RedirectDrives = TRUE
MsRdpClient.AdvancedSettings2.RedirectPrinters = TRUE
MsRdpClient.AdvancedSettings2.RedirectPorts = FALSE
MsRdpClient.AdvancedSettings2.RedirectSmartCards = FALSE
'Connect
MsRdpClient.Connect
end sub
sub MsRdpClient_OnDisconnected(disconnectCode)
'goback to the page that called this one
history.go(-1)
end sub
</script>
</head>
<body>
...
<object language="vbscript" id="MsRdpClient" onreadystatechange="BtnConnect">
codebase="msrdp.cab#version=5,1,2600,1050"
classid="CLSID:9059f30f-4eb1-4bd2-9fdc-36f43a218f4a">
</object>
...
</body>
</html>
Basically if there is anything in the query string its ignored and the page won't load. Here's a sample screencap - http://img408.imageshack.us/img408/8278/tsclient.png If I remove the query string and just call rdp.aspx directly, it opens an RDP session to my webserver just fine -- so I know the OCX is working correctly.
|
|
|
|
|
Hi, I've created a datagridview with the wizard in VS2005 (C#) and I would like to know how to add a new column and populate it at run time.
Thanks
|
|
|
|
|
How to create instance of following class ?
public class abc
{
private int _abcID;
private string _xyz;
public int abcID
{
get
{
return _abcID;
}
}
public string xyz
{
get
{
return _xyz;
}
}
public def(int abcID, string xyz)
{
_abc= abcID;
_xyz= xyz;
}
}
abc dd = new abc(WHAT PARAMETER TO ENTER ?);
so that i can access -
if (dd.abcID != 200)
thank you
|
|
|
|
|
You need to add constructor methods to the class. E.G. Public
public class abc
{
private int _abcID;
private string _xyz;
public int abcID
{
get
{
return _abcID;
}
}
public string xyz
{
get
{
return _xyz;
}
}
public def(int abcID, string xyz)
{
_abc= abcID;
_xyz= xyz;
}
public abc (int abcID, string xyz)
{
_abc= abcID;
_xyz= xyz;
}
}
I didn't get any requirements for the signature
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
