|
Thank you for the reply mate. Very useful info!
|
|
|
|
|
I'm having an error message sounding like :
Prepared statement '(@id text)SELECT * from isp_email.staff where @id like +txtname.' expects parameter @id, which was not supplied.
This message appear when I press button to select a row at run time. What could be the problem?
SqlCommand myCommand = new SqlCommand();
myCommand.Connection=con;
myCommand.CommandText="SELECT * from isp_email.staff where @id like +txtname.Text";
SqlParameter myparam = new SqlParameter("@id",SqlDbType.Text);
myparam.Value=ID;
myCommand.Parameters.Add(myparam);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
con.Open();
myCommand.ExecuteNonQuery();
dgupdate.DataSource=ds;
dgupdate.DataBind();
con.Close();
Thank you.
|
|
|
|
|
Try this instead. Also you should attempt to use stored procedures whenever possible.
myCommand.CommandText="SELECT * from isp_email.staff where @id like '" + txtname.Text + "'";
only two letters away from being an asset
|
|
|
|
|
It does not give any change still get the same error. Do you think there can there is any difference? Because I never use them but looks like it works.
Thank you very much.
|
|
|
|
|
Sorry missed something, try this
myCommand.CommandText="SELECT * from isp_email.staff where id = @id and name like '" + txtname.Text + "'";
Assuming id and name are the names of the columns in the database
only two letters away from being an asset
|
|
|
|
|
Actually you shouldn't try this, because the query would be vulnerable to a SQL Injection. Instead do it like this:
myCommand.CommandText="SELECT * from isp_email.staff where id = @id and name like '%' + @name + '%'";
myCommand.Parameters.Add("@name", txtname.Text);
|
|
|
|
|
I think in place @id, he need to give the column name and there exactly he may be doing wrong.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Still no different. but I've tried this "SELECT * from isp_email.staff where fullname=@fullname and fullname Like %'"+txtname.Text+"'%"; and the error was like:Incorrect syntax near 'Ndayahundwa,Claude'. could I be on the write truck?
|
|
|
|
|
Continue in the same thread instead of starting a new.
You are still trying to use an ASP.NET control from the database. I already explained that the database can not use it.
---
Year happy = new Year(2007);
|
|
|
|
|
Thanks What do you mean by running thread? If you could be more specific please because I'm afraid I'm not getting what exactly you are trying to advise me
Thank you.
|
|
|
|
|
What exactly he wanted to say is you have earlier also posted the same question in this forum so inspite of creating a new forum continue that thread only.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi Friends,
I have developed some crystal reports on my development machine everything is working fine.
But when i deployed them on server where we haven't got visual studio and crystal reports installed.
it gives error.
that is assembly refrence for CrystalDecion framework not found.
there is not any DLL file for crystal framework its in GAC so can any one tell me .
Whats the best way to deploy Crystal reports with a web solution.?
thanks
Naveed Kamboh
|
|
|
|
|
hi frind,
the best way you must create setup packg for your site and it will include the crystall report dll's in the packg.
|
|
|
|
|
Hi,
I got the following error when i am trying to bind data to grid dynamicaly.
DataBinding: 'System.Data.DataRowView' does not contain a property with the name
|
|
|
|
|
Not a diffcult one to debug. The datasource appears to not have a column with the name the datagrid column is bound to.
only two letters away from being an asset
|
|
|
|
|
The name of the Field in the Item Templates where you are not binding the data is not presnt in the database or selection list.
|
|
|
|
|
Hi, i have created a forum which is about trading. Now, the only problem i have is how to check who is logged in? I want to show the users which users are logged in??
Regards,
Adrian
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
ADY007 wrote: Hi, i have created a forum which is about trading.
That's nice. Now, do you have specific question? What are you using? What have you tried? There aren't many mind readers here so you have to explain a little bit more.
only two letters away from being an asset
|
|
|
|
|
So, I am using asp.net with vb.net. When they register they are creating another row in the Members database automatically.
Now when they login, I need to know how to log all the sessions from different users and put them on the page.
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
Create an application variable that will hold the names (and other info if necessary) of users who log in successfully, then use it to display. Of course you also need to handle logouts and abandoned sessions.
only two letters away from being an asset
|
|
|
|
|
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...
|
|
|
|