|
Hi
I use stored procedures for binding and editing my gridview.
I bind my Grid view with one table joining an other table:
SELECT MAD_Dictionary.*,MAD_ProductCategory_Dictionary.*
FROM MAD_Dictionary LEFT OUTER JOIN MAD_ProductCategory_Dictionary
ON MAD_Dictionary.DIC_ID = MAD_ProductCategory_Dictionary.PCD_DictionaryID
WHERE MAD_ProductCategory_Dictionary.PCD_CategoryID = @CatID
ORDER BY MAD_ProductCategory_Dictionary.PCD_Priority
But when I try to edit one Of these table with sp ,I get this error :
Ur sp has too many arguments specified
I copy sp's query and replace this code instead of sp in aspx page,and just change SelectCommandType from stored procedure to command with same query.and its work!!
I dont know why same code in sp doesnt work?
but I need use sp ,not query in my aspx page.
what can I do.
(when my binding query is not joining query,it is work)
my edit sp:
ALTER PROCEDURE [dbo].[MAAD_Dictionary_UpdatePriority]
(
@PCD_ID INT,
@PCD_Priority INT
)
AS
BEGIN
SET NOCOUNT ON;
UPDATE MAD_ProductCategory_Dictionary
SET PCD_Priority = @PCD_Priority
WHERE (PCD_ID = @PCD_ID)
END
tanx sigh:
saeedeh
|
|
|
|
|
hello
i want to know that if we use gridview with sqlDataSource what are the disadvantages. and what are the benefits if we use it without sqlDataSource then we have to write down all the code to handle add,del,edit events is there are any other disadvantages.
please reply soon
|
|
|
|
|
Hi All,
I have to disable right click and backspace key of IE.Can anyone help me in doing this.
Thanks...
|
|
|
|
|
It's basically a waste of time. It can be done with javascript (see google), but it's so easy to circumvent, it's not worth the time implementing it.
|
|
|
|
|
I got some code but not getting where should I call them???
Following is the code which I got:
<b>Code 1:</b>
<script language = "javascript">
function Disable() {
if (event.button == 2)
{
alert("This action is not possible")
}
}
document.onmousedown=Disable;
</script>
<b>Code2:</b>
<script language=JavaScript>
var message="foo";
function click(e) {
if (document.all) {
if (event.button==2||event.button==3) {
alert(message);
return false;
}
}
if
((document.layers)||(window.navigator.userAgent.toLowerCase().indexOf('gecko
') != -1)) {
if (e.which == 3) {
alert(message);
return false;
}
}
}
if
((document.layers)||(window.navigator.userAgent.toLowerCase().indexOf('gecko
') != -1)) {
document.captureEvents(Event.MOUSEDOWN);
}
document.onmousedown=click;
</script>
<b>Code3:</b>
<script language=JavaScript>
var am= "This function is disabled!";
bV = parseInt(navigator.appVersion)
bNS = navigator.appName=="Netscape"
bIE = navigator.appName=="Microsoft Internet Explorer"
function nrc(e)
{
if (bNS && e.which > 1)
{
//alert(am);
return false
}
else if (bIE && (event.button >1))
{
//alert(am);
return false;
}
}
document.onmousedown = nrc;
if (document.layers) window.captureEvents(Event.MOUSEDOWN);
if (bNS && bV<5) window.onmousedown = nrc;
</script>
Please help me...
Thanks...
|
|
|
|
|
To echo the previous - waste of time. What are you going to do when the user disables Javascript? More to the point, it's immensely annoying when a web developer decides I can't have control of my browser. Find another way to solve whatever problem you have.
|
|
|
|
|
Our Project requirement is that no one should view the source code so I need to disable right click.
Please tell me how do I go about it.
Thanks...
|
|
|
|
|
varshavmane wrote: Our Project requirement is that no one should view the source code so I need to disable right click.
It's not going to happen. Disabling right click is not going to help. If you want to keep your code hidden, run it on the server. If you pass the code to the client, there will always be a way for them to get access to it. Disabling right click is a waste of time.
Or rewrite the whole thing as an ActiveX/Java client.
|
|
|
|
|
I have remove all the toolbars of IE and now I want that right click should be disable so that no one can get the code via right click or by going to view source.
Please help me...
|
|
|
|
|
Like said before, you can't hide your code. Even if you hide the toolbars and disable temporary internet files. The only thing you can accomplish is make it harder to get the code.
|
|
|
|
|
have you ever heard of fiddler?[^]
what you are trying to do is not possible as long as tools like fiddler are available for everyone.
|
|
|
|
|
how can i use different language like KANNADA in my online newspaper project using C# ASP.NET , without font installing.
deepjyoti
|
|
|
|
|
How can i add blog creation in my C#,ASP.NET website.same like subdomain.using blog creation wizard.
deepjyoti
|
|
|
|
|
deepjyoti81 wrote: How can i add blog creation in my C#,ASP.NET website.same like subdomain.using blog creation wizard
 What does that mean? What "blog creation wizard"?
|
|
|
|
|
Somehow I can't get my generated RSS feed to work with firefox. I have an ASP.NET page which generates an RSS feed from data parsed out of a HTML page. The feed works in IE7, but firefox only recognizes it as an XML file.
36 Response.Clear(); 37 38 Response.ContentType = "text/xml"; 39 Response.ContentEncoding = Encoding.UTF8; 40 41 Response.Write("<?xml version=\"1.0\"?>\r\n"); 42 Response.Write("<rss version=\"0.92\">\r\n"); 43 Response.Write("<channel>\r\n"); 44 Response.Write("<title>CII Mededelingen RSS feed</title>\r\n"); 45 Response.Write("<description>Deze feed geeft alle recente mededelingen door van de academie CII</description>\r\n"); 46 47 foreach (Announcement announcement in parser.Announcements) 48 { 49 Response.Write("<item>"); 50 Response.Write("<title>" + announcement.Title + "</title>\r\n"); 51 Response.Write("<description>" + Server.HtmlEncode( announcement.Body) + "</description>\r\n"); 52 Response.Write("<pubDate>" + announcement.DatePosted + "</pubDate>\r\n"); 53 Response.Write("</item>\r\n"); 54 } 55 56 Response.Write("</channel>\r\n"); 57 Response.Write("</rss>\r\n"); 58 59 Response.End();
What am I doing wrong?
WM.
What about weapons of mass-construction?
"You can always try to smash it with a wrench to fix that. It might actually work" - WillemM
|
|
|
|
|
Just a shot in the dark, try type="application/rss+xml", but I think Firefox needs an extension (like Sage) to handle the rss.
|
|
|
|
|
That shot was a hit, firefox now recognizes the feed. Thanks for your help 
WM.
What about weapons of mass-construction?
"You can always try to smash it with a wrench to fix that. It might actually work" - WillemM
|
|
|
|
|
How did you format your code so nicely?
|
|
|
|
|
I use a plugin in VS2005 called CopyAsHtml, I don't remember who made it, but I use it for quite some time now. It's a pleasure to work with as it saves me a lot of time formatting my code for the web.
WM.
What about weapons of mass-construction?
"You can always try to smash it with a wrench to fix that. It might actually work" - WillemM
|
|
|
|
|
That's a great tool. Thanks for the recommendation!
|
|
|
|
|
I want to select one Row from a datagrid so I create a textBbox(txtname) and Button for the user to write the name in textBox and By the click of the button it select the corresponding row. But it's not selecting the row neighther I'm getting any mistake message I'm I missng some thing? I wrote the code on Button_Click sqlCommand as follows:
SqlCommand myCommand = new SqlCommand("SELECT * from employee where fullname Like %+txtname+%" ,con);
Thank you.
|
|
|
|
|
Of course you are getting an error message, that query is not possible to run. Do you have code for catching and ignoring the error?
You haven't shown the code for running the query. Do you run it at all?
You can not use controls from the ASP.NET code in the SQL query, the database can not access the controls. Add a parameter in the query and add a parameter object to the command object with the value from the control.
---
Year happy = new Year(2007);
|
|
|
|
|
thanks Guffa,
I have the code for cthin the Error. actually the whole code is here below.
try
{
con.Open();
SqlCommand myCommand = new SqlCommand("SELECT * from employee where fullname Like %+txtname+%" ,con);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
myAdapter.Fill(ds,"isp_email.staff");
con.Open();
myCommand.ExecuteNonQuery();
dgupdate.DataSource=ds;
dgupdate.DataBind();
con.Close();
}
catch(Exception err)
{
Console.WriteLine(err.Message);
}
finally
{
con.Close();
}
Thanks
|
|
|
|
|
Dear CPians,
I is there a way to use OutputCache in WebControls?
It is very easy to use it in UserControls, But what happens with WebControls?
Am I missing something important?
Thanking you in advance.
|
|
|
|
|
Basically, you can only use the OutputCache directive with a content element like the web page or web user control, and at runtime the ASP.NET parser will process this directive to decide if it should initialize the element from scratch or simply get the output markup from cache. For the custom control, you cannot apply this directive and if you want to support caching for custom controls, you'll need to think of other solutions. For example, you simply use a web user control as a container for your webcontrol.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
