Re: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005 - ASP.NET Discussion Boards

Re: multiple web.sitemap files?

N a v a n e e t h4-Oct-07 19:17

N a v a n e e t h

4-Oct-07 19:17

Google google google.... Check this[^]

My Website | Ask smart questions

theming problem

mmm!@#4-Oct-07 16:30

mmm!@#

4-Oct-07 16:30

hi...how can i customize my theme that only i choose appear in my account but not other user account?
if other user, they have their id that they can choose their own theme. im using database from VS2005 build in.what should i add? Cry | :((

Trying to update a value in the database. Asp.Net/C#/SQL/VS2005

foolios4-Oct-07 14:12

foolios

4-Oct-07 14:12

I don't really know how to check why it's not working.
I have a try/catch that tells me in the catch that it didn't succeed but not sure how to really know what's going on with it.

Here's my update attempt:

SqlCommand comm = new SqlCommand("UPDATE inventoryTbl SET categoryID = @category WHERE id = @category", conn);

comm.Parameters.Add("@category", System.Data.SqlDbType.SmallInt);
comm.Parameters["@category"].Value = txtbx_itemCategory.Text;

try
{
// Execute the command
comm.ExecuteNonQuery();
// Reload page if the query executed successfully
//Response.Redirect("addrelatives.aspx");
}
catch
{
// Display error message
bttnApplyChanges.Text = "Error";
}
finally
{
// Close the connection
conn.Close();
}

Re: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005

Christian Graus4-Oct-07 14:32

Christian Graus

4-Oct-07 14:32

Why do you have two columns you want to set to the same value ? Why not just use the one column for both, if they are the same ?

I'm not sure if having the same param name twice in your SQL even works, it may.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005

foolios4-Oct-07 15:29

foolios

4-Oct-07 15:29

You are correct. I noticed it and you replied before I could modify.

Here is what it should be:

SqlCommand comm = new SqlCommand("UPDATE inventoryTbl SET categoryID = '@category' WHERE id = '@ID'", conn);

Or so it is almost like what it should be. Something is still wrong.

Re: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005

Christian Graus4-Oct-07 15:38

Christian Graus

4-Oct-07 15:38

Now that you've made that change, are you also assiging a value to the @ID parameter ? Are id and categoryId strings ? If so, that's not a good idea. If not, lose the quotes.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005

foolios4-Oct-07 16:00

foolios

4-Oct-07 16:00

I believe so here, not as strings:

comm.Parameters.Add("@ID", System.Data.SqlDbType.SmallInt);
comm.Parameters["@ID"].Value = DropDownList2.SelectedValue;
comm.Parameters.Add("@category", System.Data.SqlDbType.SmallInt);
comm.Parameters["@category"].Value = txtbx_itemCategory.Text;

Not sure what you mean by lose the quotes? You mean they should be:

comm.Parameters.Add(@ID, System.Data.SqlDbType.SmallInt);
comm.Parameters[@ID].Value = DropDownList2.SelectedValue;
comm.Parameters.Add(@category, System.Data.SqlDbType.SmallInt);
comm.Parameters[@category].Value = txtbx_itemCategory.Text;

Re: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005

foolios4-Oct-07 17:27

foolios

4-Oct-07 17:27

Thanks, removed the quotes from the sqlcommand.

Thanks

OlieColie4-Oct-07 14:10

OlieColie

4-Oct-07 14:10

Thank You...Yes it works

Re: Thanks

Christian Graus4-Oct-07 14:31

Christian Graus

4-Oct-07 14:31

Don't start a new thread to say thank you, answer on the existing thread. It's great that you say thanks, few people do. But, it's better for it to be on the same thread, not least because the person who answers you then gets an email.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Textbox C#

OlieColie4-Oct-07 13:30

OlieColie

4-Oct-07 13:30

How can I set a textbox value to a number....I tried the ToString method but im not sure

Re: Textbox C#

Colin Angus Mackay4-Oct-07 13:44

Colin Angus Mackay

4-Oct-07 13:44

OlieColie wrote:
How can I set a textbox value to a number....I tried the ToString method but im not sure

What do you mean you are not sure? You are not sure that will work? You are not sure it is the best way?

Have you tried it? Did it work?

MyTextBox.Text = myNumber.ToString();

There isn't much more to it than that.

Upcoming FREE developer events:
* Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ...

My website

Re: Textbox C#

N a v a n e e t h4-Oct-07 19:21

N a v a n e e t h

4-Oct-07 19:21

OlieColie wrote:
How can I set a textbox value to a number....I tried the ToString method but im not sure

Your question doesn't make any sense. Do you want to case text box value to a number ? Then check the following code

int MyNumber = (int)Text1.Text;
int MyNumber = int.Parse(Text1.Text);
int MyNumber = Convert.ToInt32(Text1.Text);

These are different methods for casting

My Website | Ask smart questions

dynamic anchor with onserverclick as control

Chandiv4-Oct-07 9:14

Chandiv

4-Oct-07 9:14

Hello,

I recently constructed an asp site using simple server controls for input. The site consists of several pages that list buttons dynamically based on what was clicked on the previous page. Everything worked great with Buttons or ImageButtons. We just received the complete site's UI from a graphic designer that uses HTML/CSS. I'm now trying to integrate everything and in one particular case I have to keep the buttons as anchors so the CSS displays everything properly. If I manually write the anchor on the html side as the following: <a href="" mce_href="" id="Wireless" runat="server" onserverclick="catButton_Click">Wireless</a> then it creates a button and I can catch the event in the code behind. Since I need to have these buttons appear dynamically, I have to do this in a loop in the code behind.

In the code behind I am creating the corresponding Div tag and creating a PlaceHolder inside. I am using div.InnerHtml += <a href=\"#\" onserverclick=\"catButton_Click\" runat=\"server\" id=\"" + arr[i].ToString() + "\">" + arr[i].ToString() + "</a>

This displays all the buttons on the page, and it successfully posts back when I click the button, but it does not register correctly as an event. I have a feeling it has something to do with other server controls on the page that also use __doPostBack and somehow the order of things is messed up. I'm still a beginner in ASP.NET so I could be missing something but any help is GREATLY appreciated as I'm working on a short deadline. Thanks,

Forrest

Trigger validationsummary message box

JimFeng4-Oct-07 8:35

JimFeng

4-Oct-07 8:35

When I set a onClientClick=”jsfunction()” on a submit button the validationsummary message box would not show up; How can I trigger validationsummary message box in the function jsfunction() if it is invalidate page?

Re: Trigger validationsummary message box

Christian Graus4-Oct-07 14:43

Christian Graus

4-Oct-07 14:43

You can call the javascript methods to fire validation directly. It's Page_Validate(), I believe.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Adding a button to a table created in codebehind

Chajon4-Oct-07 6:40

Chajon

4-Oct-07 6:40

I have created a table that pulls from a database of users' comments. As it is sort of a wiki, I want the user and/or other users to be able to edit the comments once they have been posted. However, when I try to add an Edit button, it requires that I append .toString(), which causes the button to appear as System.Web.UI.WebControls.ImageButton instead of an actual working image button. Is there any way to add a button that actually works? And, yes, I am aware that the code is incomplete and that the button does not currently DO anything. Smile | :)

Right now I'm just trying to make it show up. Any help would be greatly appreciated.

while (reader.Read())
{
	HtmlTableRow r = new HtmlTableRow();
	HtmlTableCell c0 = new HtmlTableCell();
	c0.InnerText = reader[0].ToString();

	HtmlTableCell c1 = new HtmlTableCell();
	
	// Troublesome part...
	ImageButton a = new ImageButton();
	c1.InnerHtml = a.ToString();
	// I also tried c1.InnerHtml = a; and countless other variations
	// End troublesome part

	r.Cells.Add(c0);
	r.Cells.Add(c1);
	table.Rows.Add(r);
}

Re: Adding a button to a table created in codebehind

talasila804-Oct-07 7:26

talasila80

4-Oct-07 7:26

Have you tried c1.Controls.Add(a) instead of c1.innerhtml =

Re: Adding a button to a table created in codebehind

Chajon4-Oct-07 7:41

Chajon

4-Oct-07 7:41

Beautiful! Thank you so much. Big Grin | :-D

Removing anonymous access to web service

gauthee4-Oct-07 5:04

gauthee

4-Oct-07 5:04

HI,

we have a web service and our application(.net 1.1, C#, oracle) consumes this web service. By default the security(authentication) is given anonymous, now as for security reasons we want to remove this option.

So lets say we use Integrated Windows Authentication. Doing so we would get Access Denied 401 error. On searching though it is found that we could pass few credentials and access the web service (this works fine)

What are the cons in providing user credentials in the code?
What are the steps to be followed to make a web service secure and accessible?
Is there a way that a web service can be accessed after removing anonymous access and not providing any credentials in the code?

gauthee

Re: Removing anonymous access to web service

balaji baskar4-Oct-07 8:46

balaji baskar

4-Oct-07 8:46

Hi,

This link would be of great use: http://articles.techrepublic.com.com/5100-22-5034851.html[^]

let me know whether this is the topic you were looking in for! Cool | :cool:

Balaji

Re: Removing anonymous access to web service

gauthee4-Oct-07 19:55

gauthee

4-Oct-07 19:55

Thanks Balaji!

the article was helpul however it was just an abstract! Is there some sort of practical example so that it would be easy for us to relate!

gauthee

Problem while creating .mdf file

bhattiprolu4-Oct-07 4:58

bhattiprolu

4-Oct-07 4:58

hi all... i am getting the following problem while connecting to the .mdf file

"failed to generate a user instance of SQL Server.
Only an integrated connection can generate a user instance.
The connection will be closed"

how to fix this error????????

Re: Problem while creating .mdf file

Matthew Hazlett4-Oct-07 9:24

Matthew Hazlett

4-Oct-07 9:24

Most likely your connections tring is wrong, read this:
http://www.monblog.ch/port80/?p=200611251307222[^]

Matthew Hazlett
Fighting the good fight for web usability.

web server capture

orsini4-Oct-07 4:42

orsini

4-Oct-07 4:42

Could someone tell me where to find a good server capture applicatio, i want to see what is post back to the server any time i make a request.
i just went to Adobe MAX and I saw someone using it, but i couldnt find the name of it.
thanks

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.