Re: "operation must use an updatable query" error message [modified] - ASP.NET Discussion Boards

How to use Contains() in an .ASPX page???

code-frog11-Jun-06 16:27

11-Jun-06 16:27

If you try to use Contains in an .ASPX page it will error the reason is the single quote you have to use.

So if you code "Select f1, f2, f3 from T1 where CONTAINS (F2, 'text*')" you will get an error at compile/run because of the single quote around your contains term. You cannot use the \ to escape the single quote either.

Does anyone know a way around this?

- Rex

"You have an arrow in your butt!" - Fiona Cool | :cool:

Welcome to CP in your language. Post the unicode version in My CP Blog [ ^ ] now.

People who don't understand how awesome Firefox is have never used CPhog[^]CPhog. The act of using CPhog (Firefox)[^] alone doesn't make Firefox cool. It opens your eyes to the possibilities and then you start looking for other things like CPhog (Firefox)[^] and your eyes are suddenly open to all sorts of useful things all through Firefox. - (Self Quote)

Re: How to use Contains() in an .ASPX page???

Guffa11-Jun-06 18:53

Guffa

11-Jun-06 18:53

What do you mean? An apostrophe can be put in a string without problems.

Exactly what does your code look like, and what is the error message that you get?

---
b { font-weight: normal; }

OnRowCreated - Setting the properties of a column control

PeteConc11-Jun-06 4:04

PeteConc

11-Jun-06 4:04

Hi. I have a GridView bound to a DataTable. The columns of the GridView are TemplateColumns with a TextBox in it.
The textbox columns appear with the values of the DataTable.

What I am trying to do is setting the TextBox to ReadOnly if certain conditions are met. I tried to do this within a handle to OnRowCreated (I get the created row in the eventargs e.Row). The problem is that I don't know how to get the TextBox object of a specific column in that row and set it's properties to ReadOnly.

Any help?
Thanks!

Re: OnRowCreated - Setting the properties of a column control

minhpc_bk11-Jun-06 15:37

minhpc_bk

11-Jun-06 15:37

To get reference to the TextBox, you simply use the FindControl method in the event handler of the RowCreated event:

TextBox textBox = e.Row.FindControl('TextBoxId') as TextBox;

You now can set the ReadOnly property of the TextBox. However, you'd better use the RowDataBound event to set the ReadOnly property as the RowCreated event always happens, and you might not need that on postback. In addition, you can also use the databinding expression to set the ReadOnly property of the TextBox in the control declaration:

... ReadOnly='<%# ... %>' ...

"operation must use an updatable query" error message

isiran11-Jun-06 2:16

isiran

11-Jun-06 2:16

I have a simple web page that written in C# and Asp.Net.
In that page i have asimple insert query that work by
Microsoft Accees;) .
When I run it in my camputer az a project I don't reciev this message Laugh | :laugh:

but when i placed on my host or on my iis I reciev this massage Confused | :confused:

(.
If You Know How Can I solv this problem plz
answer me az soon az possible Confused | :confused:

Thanks alot Sniff | :^)

Re: "operation must use an updatable query" error message

Guffa11-Jun-06 2:45

Guffa

11-Jun-06 2:45

Please don't cross post.

---
b { font-weight: normal; }

Re: "operation must use an updatable query" error message

sandeep_thakur12-Jun-06 20:29

sandeep_thakur

12-Jun-06 20:29

hii
write in square braces means [ ] which value you have to inserted in data bases . I think tis problem is due to likages of connection
hope this will help you

Best Regards

Sandeep Thakur

Re: "operation must use an updatable query" error message [modified]

isiran13-Jun-06 0:14

isiran

13-Jun-06 0:14

Hi I'm glad to find alot of kind friends. Laugh | :laugh:

I write 4 u what I wrote in my program:

Connection definition...;
OleDBCommand definition...;
commandtext="Insert in to tabale1 Name,family values(@name,@family)"
connection.open();
command.executeNonQuery();
connection.close();
Wink | ;)

I receiv error exactly on Execute line. D'Oh! | :doh:

Befor asking in this site I searched about it and found something about security like as Guffa answered me. Sniff | :^)

By the end of these activities I'll ask my host to check my allowanc again. Blush | :O

Thanks GOD FOR MY KIND FRIENDS Smile | :)

-- modified at 6:15 Tuesday 13th June, 2006

Confirmation E-mail not working

preethishivbaba11-Jun-06 1:47

preethishivbaba

11-Jun-06 1:47

Hi all,

We are into Student information system development.Actually we want to send a student confirmation letter taht he's confirmed registration with us and teh course is gonna start so and sooo date.We have the server and this is connected to fileserver and then to exchange server.

When i compile the whole project there's no errors at all but donno where the problem is..Can anyone plz guide me?

And can anyone tell me how to debug line by line the souce code in .NEt applications?

Thx in advance

preethishivbaba

Re: Confirmation E-mail not working

Tarakeshwar Reddy11-Jun-06 3:32

Tarakeshwar Reddy

11-Jun-06 3:32

preethishivbaba wrote:
And can anyone tell me how to debug line by line the souce code in .NEt applications?

Pressing F9 on a particular line of a method/event will set a break point. Once the breakpoint is reached you can then use F10 - Step Over and F11 - Step Into which ever you need.

Tarakeshwar
MCP, CCIE Q(R&S)

Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes.

!sgub evah t'nseod margorP sihT ?sgub naem ayaddahW

Re: Confirmation E-mail not working

preethishivbaba11-Jun-06 15:39

preethishivbaba

11-Jun-06 15:39

Thanks tarak,.Do u have any solution for my confirmation e-mail problem also.

preethishivbaba

Re: Confirmation E-mail not working

Guffa11-Jun-06 18:57

Guffa

11-Jun-06 18:57

I don't see how anyone could give you any solution to the problem, as you have only described the problem as "not working".

What is the problem?

---
b { font-weight: normal; }

Re: Confirmation E-mail not working

Guffa11-Jun-06 22:04

Guffa

11-Jun-06 22:04

preethishivbaba wrote:
I have a server which is connected to a Fileserver and tehn the exchange server.We send E-mails thru this route.

When i am sending my E-mail its showing error.Actually when i compile the project i am getting an error as below.

It says there's one more process thats usung the same application.I mean teh other dll is not letting this get loaded.Can u plz guide me how to find a solution.

Thx
Preethi

Please clearify; is it a compiling error or a runtime error?

What is the exact error message that you get? What dll are you talking about? What does the code look like?

---
b { font-weight: normal; }

How can i run Server.HtmlEncode() on an XMLControls output?

Red_Wizard_Shot_The_Food10-Jun-06 8:16

Red_Wizard_Shot_The_Food

10-Jun-06 8:16

I have an XMLcontrol on my ASP.Net page but i want its output to NOT parse tags into "& lt", etc
It has been said that I should use Server.HtmlEncode() on the XMLcontrols output but exaclty how do i do this ?

Thanks.

How we canFind File Size before uploading in ASP.NET 2.0

Haridas.R10-Jun-06 3:12

Haridas.R

10-Jun-06 3:12

How we can Find File Size before uploading in ASP.NET 2.0?

Haridas.R
harisofttech@hotmail.com

Re: How we canFind File Size before uploading in ASP.NET 2.0

Tarakeshwar Reddy10-Jun-06 3:34

Tarakeshwar Reddy

10-Jun-06 3:34

You could use the below code.

<br />
System.IO.FileInfo oFile = new System.IO.FileInfo("c:\\Log.txt");<br />
long lSize = oFile.Length/1024;	<br />

It returns the file size as bytes. You can just divide 1024 to get the value in KB.

Re: How we canFind File Size before uploading in ASP.NET 2.0

Haridas.R10-Jun-06 3:54

Haridas.R

10-Jun-06 3:54

Thak you, Tarakeshwar

Haridas.R
harisofttech@hotmail.com

Re: How we canFind File Size before uploading in ASP.NET 2.0

Tarakeshwar Reddy10-Jun-06 4:02

Tarakeshwar Reddy

10-Jun-06 4:02

Your Welcome

Display Date in a DropDownList

Chandan_Kr10-Jun-06 2:06

Chandan_Kr

10-Jun-06 2:06

Hello

,

I m new to ASP.net and I am doing a project. In which when user selects Country(DropDownList) then only State(DropDownList)field should be enabled & only those states should be filled which belongs to selected Country.
I have created a table named State_City which contains two columns State and City. Record should come from table only.

plz help Confused | :confused:

as soon as possible.

Thanks & Regards,
Chandan Kumar

Re: Display Date in a DropDownList

minhpc_bk11-Jun-06 15:47

minhpc_bk

11-Jun-06 15:47

Here are the steps that you might need to do:
+ Set the AutoPostBack of the Country dropdownlist to true.
+ Create an event handler for the SelectedIndexChanged of the Country dropdownlist.
+ In the handler, get the selected value of the Country list.
+ Execute an SQL command to query states based on the specified country.
+ Bind the result to the State dropdownlist.

If you don't know to implement the steps, you can see ASP.NET quick start[^].

However, this way posts the entire page back the server, while you may want to update the dropdownlist only, so you can use AJAX here. The sample code is available out there, just have a good search.

Btw, the subject is asking about the Date, but don't see you mentioned it in your post.

ASP.NET release

TintinV3ck10-Jun-06 1:21

TintinV3ck

10-Jun-06 1:21

What are most of the steps I should follow before releasing an ASP.NET project on the web (security and performance wise)? I've heard that debugging should be set to false, but I'm unsure of other steps..

Please advise

Regards,

Tintin

Re: ASP.NET release

minhpc_bk11-Jun-06 15:51

minhpc_bk

11-Jun-06 15:51