Robby
Moderators
-
Posts
3848 -
Joined
-
Last visited
Content Type
Profiles
Forums
Blogs
Events
Articles
Resources
Downloads
Gallery
Everything posted by Robby
-
Is this your own site or application? Or is it provided by some other person/company?
-
Then I don't understand.
-
The whole point of having one form per page is because you don't need more. Everything you described can be achieved with a single form. The web controls have events which can be used to figure out the users' selections.
-
Do you mean create or click, I get the impression that you want to create the links with those changing query strings, is this correct?
-
Need an ID that is unique across tables
Robby
replied to
discocarp's topic in
Database / XML / Reporting
uniqueidentifier is SQL Server specific, Sorry Peter I should've read your post in its' entirety. -
Need an ID that is unique across tables
Robby
replied to
discocarp's topic in
Database / XML / Reporting
Create an ID field with uniqueidentifier data type and Is RowGUID and NOT NULL -
I suggest that you contact their support ... http://www.devcomponents.com/
-
I reformated the string just for ease of reading, try it out. Also, Make sure that the columns mark as Int are indeed int in the table. I'm sure that you're doing some Server-side validation to ensure that there are no nulls, etc... String insertCmd1 = "INSERT INTO tblSupplemental(" + "id,fn,shsh,born_date," + "Address,tel,postcode,faf," + "memoir,degree,un,gd," + "po,mp,smd,emd) " + "VALUES(" + textBox1.Text.Trim() + ", " + "N'" + textBox2.Text.Trim() + "'," + Convert.ToInt32(textBox3.Text) + ", " + "N'" + textBox4.Text.Trim() + "'," + "N'" + textBox5.Text.Trim() + "'," + "N'" + textBox6.Text.Trim() + "'," + "N'" + textBox7.Text.Trim() + "'," + "N'" + textBox8.Text.Trim() + "'," + "N'" + textBox9.Text.Trim() + "'," + "N'" + textBox10.Text.Trim()+ "'," + "N'" + textBox11.Text.Trim() + "'," + "'" + textBox12.Text.Trim() + "'," + "N'" + textBox13.Text.Trim() + "'," + Convert.ToInt32(textBox14.Text) + "," + "N'" + textBox15.Text.Trim() + "'," + "N'" + textBox16.Text.Trim() + "')";
-
barski, + is used in C#, N is used in SQL Server.
-
Place this in the <head> of your aspx file... <script src='someDirectory/SomeFile.js'></script>
-
Your error is from your select statement...rtrim()
-
It depends on how much we're talking about: 1 Blank CD-R, 1 CD Player, or 1 car with a CD player in it. :)
-
What do you mean 'auto load' ?
-
I doubt that it has anything to do with the OS.
-
In the function, Return False
-
It's difficult to answer without knowing your knowledge level. You can create a page with a few text boxes and then use an SQL update statement to write their current contents to a database. That's the short answer.
-
Can you post the relevant code?
-
Yeah, my laptop works ok ( :) ) with a P3 500 , 128 RAM (ouch) , I manage
-
Many Deletes and Inserts will grow the DB size, as well as if you store binary/images data.
-
I don't get it... What method are you using to save/update the database from the dataset? Either way, you don't need to include the ID field as part f your update, that usually causes this type of error.
-
I'm sure there is some method that is not exactly the same, these things are not intermitent, it either works or it does not. Post the relevant code and we'll see if someone can spot the err.
-
Btw, This is only a guess on my part.
-
Cool :)
-
You may need admin permissions to install.
-
It may be having trouble stopping IIS or its' dependancies. Try stopping it through the admin panel.
