Re: Getting "Index was out of range" error.. - ASP.NET Discussion Boards

Elham M26-Jul-12 1:18

26-Jul-12 1:18

I did it but it doesn't different between your code and add image as background , I want when user copy my text in a web page and paste it on word both text and logo paste

Re: prevent to copy my web pge

StianSandberg26-Jul-12 1:52

StianSandberg

26-Jul-12 1:52

Isn't your question about preventing this?

--------------------
When Chuck Norris' dreams come true, your worst nightmares begin.

Re: prevent to copy my web pge

RamShankarMCA26-Jul-12 2:12

RamShankarMCA

26-Jul-12 2:12

Did you mean, you want the users to avoid following things

1) Dont save your page
2) avoid right click and ctrl+c

Re: prevent to copy my web pge

Elham M26-Jul-12 2:55

Elham M

26-Jul-12 2:55

yes exactly, or if user copy my page also my logo paste on it

Re: prevent to copy my web pge

Pete O'Hanlon26-Jul-12 3:00

Pete O'Hanlon

26-Jul-12 3:00

You can't do this I'm afraid. If the user turns off JavaScript, your page is purely the content and the user can copy it as they like.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Getting "Index was out of range" error..

Diana Tsilidi24-Jul-12 9:06

Diana Tsilidi

24-Jul-12 9:06

Hi! I am making an e-shop and i have a search function where you can search for a product in the website. So, it returns the products on the search result page. Then, i want to be able to add the product to cart from the result page. For some reason, the same code i use elsewhere is not working.. i am getting the "Index was out of range. Must be non-negative and less than the size of the collection." error.

Here is my code:

Protected Sub DataList1_ItemCommand(sender As Object, e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles DataList1.ItemCommand

       Dim currentCommand As String = e.CommandName
       Dim currentRowIndex As Integer = Int32.Parse(e.Item.ItemIndex)
       If currentCommand = "ProductID" Then
           Session("Product") = DataList1.DataKeys(currentRowIndex)
           Response.Redirect("Search.aspx", False)
       ElseIf currentCommand = "AddtoCart" Then
           ' Label2.Text = currentRowIndex
           Session("Product") = DataList1.DataKeys(currentRowIndex)
           ShoppingCart.Instance.AddItem(Session("Product"))
           

Response.Redirect("ViewCart.aspx", False)

       End If
   End Sub

As you can see, i used the Label2 to check the value of the currentRowIndex. In the search i made i had 2 records, for the first one currentRowIndex=0 and for the second currentRowIndex=1.

What am i doing wrong? Smile | :)

Re: Getting "Index was out of range" error..

jkirkerx24-Jul-12 10:20

jkirkerx

24-Jul-12 10:20

That's pretty slick code there, and you even knew how to access data from the EventArgs. Strange if you know how to use the eventarg, that you didn't test the value of it e.Item.ItemIndex to make sure it's a value from 0 to the max value of int32.

I don't see the purpose of passing the session value to the shopping cart instance

Dim currentRowIndex As Integer = Convert.ToInt32(e.Item.ItemIndex)
Session("Product") = DataList1.DataKeys(currentRowIndex)
ShoppingCart.Instance.AddItem(DataList1.DataKeys(currentRowIndex))

Re: Getting "Index was out of range" error..

Bernhard Hiller24-Jul-12 21:51

Bernhard Hiller

24-Jul-12 21:51

Such an error can be thrown when you do DataList1.DataKeys(currentRowIndex).
For debugging purposes, I'd add some lines after Dim currentRowIndex ... for checking that value:

If currentRowIndex<0 Then
    'show an error message for negative values
ElseIf currentRowIndex>=DataList1.DataKeys.Count Then
    'show an error message that the index is to big
EndIf

You should show the value of currentRowIndex and DataList1.DataKeys.Count in the error messages, and then do some further analysis based on those values.

Re: Getting "Index was out of range" error..

jkirkerx25-Jul-12 8:45

jkirkerx

25-Jul-12 8:45

I should of wrote

If Not currentRowIndex > Integer.MinValue And currentRowIndex < Integer.MaxValue Then
    'Deal with the Error
Else    
    'now run the code

End If

Re: Getting "Index was out of range" error..

Diana Tsilidi25-Jul-12 9:09

Diana Tsilidi

25-Jul-12 9:09

Thank you so much guys! I solved the problem Big Grin | :-D

Actually it was something stupid in the asp code.. i forgot to use DataKey field so, of course, DataList1.DataKeys.Count was always = 0 :P

Re: Getting "Index was out of range" error..

jkirkerx26-Jul-12 9:15

jkirkerx

26-Jul-12 9:15

Good to hear,

you should still improve the code you posted to better handle and invalid input, it will bite you back in the future,

In the future, you will start checking the error logs on your web server, and you will see all these errors, from input that was not validated. I see bots pick up trying to break a website all the time.

Re: Getting "Index was out of range" error..

Diana Tsilidi26-Jul-12 19:32

Diana Tsilidi

26-Jul-12 19:32

I added the code you suggested. But unfortunately i don't know a lot about security yet, for now i'm trying to fix the basics. I guess in 2-3 weeks you will see my posts here asking about security issues Laugh | :laugh:

System.Byte[] error

Jassim Rahma23-Jul-12 21:41

Jassim Rahma

23-Jul-12 21:41

I am getting the data from MySQL like this:

SQL

SELECT item_id, item_category, item_code, item_description, quantity_type_id, quantity_type, item_quantity as available_quantity, CONCAT(item_quantity, ' ', quantity_type) as item_instock, is_blocked FROM storebook_items ORDER BY item_description;

where item_quantity is int, quantity_type is varchar and item_instock a combination of both as you can see..

when I run the above on my database server as query then everything is fine

but when I populate the result to a datagrid (XtraGrid) I get System.Byte[] in the item_stock column.

Re: System.Byte[] error

Bernhard Hiller24-Jul-12 0:25

Bernhard Hiller

24-Jul-12 0:25

That's a feature of the CONCAT function. It is described in the manual: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat[^].
CAST the numeric value to a string before you CONCAT it; an example is given in the manual.

Re: System.Byte[] error

Jassim Rahma24-Jul-12 3:22

Jassim Rahma

24-Jul-12 3:22

Thanks

how to select and read data in dropdownlist?

mohammad ehsan23-Jul-12 19:45

mohammad ehsan

23-Jul-12 19:45

Hello.
I intend to bind my dropdownlist to sqlserver and read the items(CityName)that i have them in DB(Table City)and then list and fill them into the dropdownlist.
for this matter i have written the code below in Page_load that whenever i start to debug all city items to be seen in dropdownlist:

if (!IsPostBack)
    {
        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PersonTest"].ConnectionString))
        {
            conn.Open();
            using (SqlCommand cmd = new SqlCommand("SELECT CityName , id FROM City", conn))
            {
                DataTable dt = new DataTable();
                SqlDataAdapter adpt = new SqlDataAdapter(cmd);
                adpt.Fill(dt);
                DropCity.DataTextField = "CityName";
                DropCity.DataValueField = "CityId";
            }
        } 
    }

but after i start to debug there is no item in dropdownlist.
meanwhile i know that i can use ASP.net DataBinding(by wizard)ability, but i want to do it with myself . and also i don't know which one is better to be used in forms? which one do you suggest to use?
what shall do?

Re: how to select and read data in dropdownlist?

_Amy24-Jul-12 1:52

_Amy

24-Jul-12 1:52

Hi,
Try this:

if (!IsPostBack)
    {
        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PersonTest"].ConnectionString))
        {
            conn.Open();
            using (SqlCommand cmd = new SqlCommand("SELECT CityName , id FROM City", conn))
            {
                DataTable dt = new DataTable();
                SqlDataAdapter adpt = new SqlDataAdapter(cmd);
                adpt.Fill(dt);
                DropCity.DataTextField = "CityName";
                DropCity.DataValueField = "CityId";
                DropCity.DataBind();//You was missing this line.
            }
        } 
    }

All the best..

Read the article "Table Valued Parameters".

--Amit

how can i detect when user click back button in android webkit?

buffering8323-Jul-12 16:29

buffering83

23-Jul-12 16:29

Hello,

I want to detect when user click back button in android webkit.

I can detect back button event by below code.

But it does not work in android webkit.

Response.Cache.SetNoStore();

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Is there any way to catch back button button?

hi

My english is a little.
anyway, nice to meet you~~
and give me your advice anytime~

how to build a project

Harihareshwara23-Jul-12 5:57

Harihareshwara

23-Jul-12 5:57

i want to build my own project please help me .......by giving guide...send the guidelines to my account......

Re: how to build a project

Richard MacCutchan23-Jul-12 7:33

Richard MacCutchan

23-Jul-12 7:33

Go here[^] and start learning. And for future reference please read How to get an answer to your question[^].

One of these days I'm going to think of a really clever signature.

Re: how to build a project

AmitGajjar27-Jul-12 18:06

AmitGajjar

27-Jul-12 18:06

it's very simple

(ctr + Shift + b) Smile | :)

Thanks
-Amit Gajjar (MinterProject)

capture image through Webcam in asp.net 4.0 C#.

ranjitsahani23-Jul-12 1:33

ranjitsahani

23-Jul-12 1:33

<pre lang="c#">capture image through Webcam in asp.net 4.0 C#.</pre>

Re: capture image through Webcam in asp.net 4.0 C#.

Richard MacCutchan23-Jul-12 3:18

Richard MacCutchan

23-Jul-12 3:18

Is this a statement, command or question? If the latter then typing it into Google will yield many interesting links.

One of these days I'm going to think of a really clever signature.

Re: capture image through Webcam in asp.net 4.0 C#.

Sandeep Mewara23-Jul-12 3:28

Sandeep Mewara

23-Jul-12 3:28

What have you tried so far? There are articles on the same in CP itself.
Look at these: http://www.codeproject.com/search.aspx?q=webcam+asp.net&x=0&y=0&sbo=kw[^]

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

Jassim Rahma22-Jul-12 5:18

Jassim Rahma

22-Jul-12 5:18

Hi,

Why I am getting the above error for the following code:

sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
sql_command = new MySqlCommand("sp_upload_resume", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;

sql_command.Parameters.AddWithValue("param_full_name", txtFullName.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_email_address", txtEmail.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_gender", cboGender.Value.ToString()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_nationality", cboNationality.Value.ToString()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_date_of_birth", cboDateOfbirth.Date).MySqlDbType = MySqlDbType.Date;
sql_command.Parameters.AddWithValue("param_designation", Convert.ToInt32(cboDesignation.Value)).MySqlDbType = MySqlDbType.Int32;
sql_command.Parameters.AddWithValue("param_resume_ext", file_extension).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_resume_format", document_type).MySqlDbType = MySqlDbType.VarChar;
// sql_command.Parameters.AddWithValue("param_resume_data", document_binary, file_size).MySqlDbType = MySqlDbType;
sql_command.Parameters.Add("param_resume_data", MySqlDbType.LongBlob, file_size).Value = document_binary;

// event log parameters;
if (Request.ServerVariables["REMOTE_ADDR"] != null) sql_command.Parameters.Add("param_ip_address", MySqlDbType.VarChar).Value = HttpContext.Current.Request.UserHostAddress;
else sql_command.Parameters.Add("param_ip_address", MySqlDbType.VarChar).Value = DBNull.Value;
sql_command.Parameters.Add("param_browser_platform", MySqlDbType.VarChar).Value = Request.Browser.Platform;
sql_command.Parameters.Add("param_browser_version", MySqlDbType.VarChar).Value = String.Format("{0} {1}", Request.Browser.Browser, Request.Browser.Version);
sql_command.Parameters.Add("param_gateway_version", MySqlDbType.VarChar).Value = Request.Browser.GatewayVersion;
sql_command.Parameters.Add("param_is_mobile", MySqlDbType.Bit).Value = Request.Browser.IsMobileDevice;
sql_command.Parameters.Add("param_mobile_manufacturer", MySqlDbType.VarChar).Value = Request.Browser.MobileDeviceManufacturer;
sql_command.Parameters.Add("param_mobile_model", MySqlDbType.VarChar).Value = Request.Browser.MobileDeviceModel;
sql_command.Parameters.Add("param_screen_width", MySqlDbType.Int32).Value = Request.Browser.ScreenPixelsWidth;
sql_command.Parameters.Add("param_screen_height", MySqlDbType.Int32).Value = Request.Browser.ScreenPixelsHeight;
sql_command.Parameters.Add("param_browser_type", MySqlDbType.VarChar).Value = Request.Browser.Type;
sql_command.Parameters.Add("param_machine_name", MySqlDbType.VarChar).Value = Environment.MachineName;
sql_command.Parameters.Add("param_os_version", MySqlDbType.VarChar).Value = Environment.OSVersion.VersionString;
sql_command.Parameters.Add("param_user_name", MySqlDbType.VarChar).Value = Environment.UserName;

sql_command.Parameters.AddWithValue("param_record_identity", MySqlDbType.Int32).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;

// execute the query;
int result_rows = sql_command.ExecuteNonQuery();

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