Posts by hericles

Which table are you referring to exactly? The tblAcc, the Accounts table in the dataset or the database table? Because you have no code that will alter the last two. Your code to add a row to tblAcc looks right so how are you checking that tblAcc has no new rows?

Which version of SQL Server are you trying to restore to? If it is of an older version of MS SQL than your source database you will see this error. If in doubt use

SELECT @@VERSION

on both to make sure they are the same.

Move that code out of the form_load event into its own function. You can call that function from form_load to get the data at startup but you will also be able to call the code at anytime to get any new data (via a button that calls that function for example)

Show us some code and then we can help, otherwise we're flying blind.
Although, if you you debug your code and examine the data source after it has extracted the data from the database, (your dataReader, dataSet, etc) does it have rows of data in it? That will help you know whether the data extraction is the problem or the steps for displaying it on screen.

Is your serial number column set to auto-increment? If yes, pass it null instead of zero.
Once you have added parameters you do not need to add them again, simply change the value they hold:

cmd.Parameters["@name"].Value = new_value_to_insert;

That should get around the duplication error, if that is the problem you are seeing.

You are setting uname and emp_name outside of the while loop so they become set to the data from the first row of the dataset and they never change. This means that inside your while loop your SELECT and INSERT statements are always using the same values.
Simply move the lines where you set uname and emp_name to inside the while loop and use the x variable as your row indicator

Dim uname As String = ds.Tables(0).Rows(x)("uname").ToString
Dim emp_name As String = ds.Tables(0).Rows(x)("full_name").ToString

Any server side code won't be visible in a website anyway so you're perfectly safe.

In that case you can loop through the controls in the form and either reset the text for all of them or for a particular type of control (textbox for example).

foreach (Control ctrl in this.Controls)
     {
          if (ctrl is TextBox)
          {
              ctrl.Text = "";
          } else if (ctrl is ComboBox) {
              ctrl.Items.Clear();
          }
     }

When you use new you create a blank version of the object in question (hence new). What records are you trying to clear? Most collections have a built in method to clear them of all current data.

Do you mean you get an error in the GetBindingSource function? What error messages do you get (and I mean the ones generated by VS, not your MsgBox messages that you have made).
You mention other errors but you haven't referred to what causes them. Where/when do they appear?

That error can sometimes appear if you have any files in the 2005 project that do not have file extensions.

You have a couple of options to do this. Each step requires pulling the menu items out of the database of course but after that you can display the menu as a standard UL but with asp:Labels inside each <li> or use a literal control to output the html for the menu server side. The repeater is a better idea as it allows for differing amounts of menu items (to a degree) whereas the first method doesn't.

Hi,
1) If the two radio buttons are for different options I would suggest you don't. The only time two radio buttons would match to the same column in the database is when they are Yes/No, On/Off types of combinations. To be honest, this question is really no different from 'how do I insert or update to MS SQL?' because that is all you are doing.

2) Not reflecting? what do you mean by that?

When you debug it what line is causing the null error? If is the line

strReturn = ConfigurationManager.ConnectionStrings("YourConnectionName").ConnectionString

the error will be because in the app.config the connection string is named "MyConnName" not "YourConnectionName".

You have 9 columns listed in the SQL statement but ten inputs in the values section including the zero at the end. The zero has no matching column specified.

If it is crashing at line 10 then there isn't any rows in the dataset. Going by your SQL statement I'm not surprised as it is incorrect. Your statement as it appears above will be executing as:

Select * from fees where particulars='DataGridView1.Rows(0).Cells(1).Value'

I strongly doubt you have any row in your database that has 'DataGridView1.Rows().Cells(1).Value' in it. Change it to:

Dim sql As String = "Select * from fees where particulars='" & DataGridView1.Rows(0).Cells(1).Value & "';"

You are pretty close but you aren't setting num to the textbox value that is the upper limit so that needs to be fixed of course.
After For x = 1 To num, include output = output & x.ToString & "."
That'll give you the 1., 2., 3. you want at the start of each row. You also need to reset output after adding it to the listbox so the previous value is discarded.

For future reference, CSS added to the page needs to be inside <style></style> tags in the head element or inside elements on the actual page (e.g. inside <div> or <span>, etc).
Simply typing it in as text will make the browser render it on the page. It doesn't know any better.

Why do you want to log out the user just because they opened a new browser tab? Aren't they allowed to cruise the net AND be on your site?
If you have an issue with users signing in with more than one account at the same time then you need a better way of controlling that. Is that your problem?
If yes, then I would suggest having all ProfileIDs linked to a UserID (so you know which user has the profiles) then if a profile logs in of a user that has another logged in profile you can log out the first or redirect them to the first profile account.

jquery has everything you need. Check out this link (http://api.jquery.com/jQuery.browser/) for the browser detection library and then the standard jQuery for how to switch a stylesheet. Google will show you tutorials on that easily enough.

I haven't done anything like this myself but I think you will need a service running in the background that checks the current open TCP connections against your blacklist and shuts them down if they feature on it. Of course TCP connections appear as IP addresses so your blacklist will either need to consist of IP addresses or you will need to match a domain name to an IP.

So you want to add code in your button click that clicks if the particular radio button is checked and redirect as appropriate.

if(RadioButton1.Checked) {
  // do something
} else if (RadioButton2.Checked) {
    // do something else
}

Is that what you are after?

Place your 2 panels on the form and then in the properties pane set the location of each to be the same. They will then appear exactly on top of each other (not one inside the other) and you can alter the visibility of each as required.

Problem fixed. I opened the font in Font Book and checked out its actual name. It didn't match the actual file name at all. Once I referred to in by its internal name it worked perfectly.

As I mentioned in my first post the line

If(Articulos.Visible == true) {

should work. You keep saying you can't do the versionyou posted in C# but you never mention what goes wrong when you try. A couple of us have now pointed out that using == instead of = when make the if statement work but you don't seem to have tried it. What exactly goes wrong when you make the changes we suggest?

If you are using the same code above for your C# sharp project you will need to use

If(form1.Visible == true)Then   -- note the double ==

as this is the correct C# form to test for equivalence. Single equal signs set a variable and can't be used to as you have here.

Although you wouldn't be following the spec I think 255 would be fine. I have never allowed email addresses longer than 80 characters in any of my databases and I have never had an issue. I'm guessing but I imagine 95% of emails are less than 30 characters.

If you are looking for a team to help work on a project you should chck out codeplex. You can list your project their and interested developers can sign up.

Try taking out the concatenation operator and just have the insert statement as one statement. I'm really sure why you have decided to split up anyway.

What error are you getting?

Just give your function a name and call it like you normally would.

Are you talking about internships? And where are you located?

Add validation either client- or server-side to check the value of the textbox before proceeding. If the length of the input is too short or non-existent then stop and inform the user.

Can you post up some code? If you have added a script manager and an update panel around the section you want to update via AJAX it should work.

HTCc, you left in the initial flaw I mentioned in my first post, namely that the next r value isn't being added to numberTotal each loop. Lines 16 and 17 are not needed (beyond declaring numberTotal) and give an incorrect result as they add number to numberTotal twice for no reason.
It also looks like the only thing you changed was the edit already mentioned by Sam. Not being picky, but your posts should add something not mirror what previous posters have said.

Do you need to add that as a reference in the project first?

Using a CSS font rule doesn't come with a particulary large hit in processing time (web fonts excluded). It isn't really an issue. The browser can cope with rendering the HTML tags. It maybe a sign that your design can be improved but speed won't be affected too much.

You aren't setting the connection property of the command object to be your connection object and so your command objec can't execute. If you handled the catch block with some sort of error message you would have been informed of this. Add

command.Connection = connection

just below where you declare the command object.

You can use FTP to download the files to work on them. Once you're finished FTP them back to the site. Any downtime to a particular page or the site in general should be pretty minimal.
As for the server and password the site administrator will need to give that to you.

If you want to give a <pre> look to it just alter your table CSS rules to include a fixed width font like courier. Then the font will mimic your standard 'code as text' look.

That site is using HTML5, CSS3 and jQuery. You'll need to learn all 3 to get that kind of effect.

First question is who is your target market for the website? IE is still the main browser for people with more limited PC skills (they haven't even managed to download a better browser for example). If your target market includes such people (i.e. possibly older, less educated, etc) then maybe you should be catering to them more. There is definitely the potential that some users will read that and head elsewhere but I don't think that kind of response will occur often (based on nothing but my own opinion).

This is incorrect:

<body style="background-image:images/red-and-black-powerpoint-template.jpg; background-repeat:no-repeat" >

This,which you had in your previous post, is correct:

<body style="background-image:url('image.jpg'); background-repeat:no-repeat"> 

The correct syntax is background-image:url('location_of_image.jpg');
For consistency, seeing you have a style section, you should place all of your CSS there. Having some inline and some in the style section just makes it hard to find later.

Your total won't match the numbers generated because you declare number to be equal to r.Next on line 17 and then add it to numberTotal on line 18. At line 23 you add number to numberTotal again (inside the loop so it does this 100 times) but you aren't changing the value of number in the loop (i.e. you aren't setting it to the next r value) so you are adding the SAME number to numberTotal 100 times.

I'm not sure I understand what you need but if you want to randomly alter one of the buttons in anyway then you first need to randomly select which button to alter.
The Random type can help you there:

Random rand = new Random();
int r = rand.Next(25);

R now holds a number between 0 and 25 (exclusive) which can relate to the button in question. Then you can use a switch statement to select the button based on r. Is that what you are after?

Simply create empty spans beside each of your validation controls (what you want to validate) and when your validation script runs, when errors occur output them to the appropriate span.

Does any of your variables that you are trying to add include the dollar sign ($)? The script is treating your variables are strings rather than numbers which is probably happening because at least one of them can't be converted and so they are being concatenated.
Also,

(salesPrice <= 25)? totalPrice = salesPrice + minShipping
: totalPrice = salesPrice + maxShipping;

is nothing but a fancy IF statement. If (salesPrice <= 25) do first statement, else do second statement.

I read, either interesting computer articles and new techniques if I'm in the mood or general fiction/non-fiction if I'm not, or play chess online. I recently started back on the X-box (and have really enjoyed the Mass Effect series and Portal 2 by the way). And, having 2 dogs, they're always happy to spend an hour down at the park.

Hi revelator, I want to ask a quick question and I intend no offense by it, I'm just interested: What was the structure and focus of this bachelor degree in computer applications if, at the end of it, you are 'bad at programming'? Was it a 3 year year degree? What languages did they offer papers for?

Is that a copy and paste of the code in your site or did you type that in there? I ask because it is correct and should work. Either the code on your actual page has an error in it or something else is going on. Do you have an external style sheet as well? Or any <style></style> section in the page header? In your attempts to fix it you may have specified another rule elsewhere that is conflicting (possible but not very probable).