Data Controls :: Getting Error When Try To Insert Data Into Database - Out Of Range Value
Apr 20, 2013
I am working on website where i am getting error when try to insert data into database from my asp.net website
The Error says that :
" System.Data.SqlClient.SqlException :
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
[Code] ....
View 1 Replies
Similar Messages:
Jun 14, 2013
I have insert.aspx page that users can enter data and when they click on insertbutton it insert data into database below is SP
create procedure [dbo].[InsertFreeState2]
@Name nvarchar(40)
,@mobile varchar(20)=null
,@Tell varchar(15)=null
,@Transfer nvarchar(20)
,@Type nvarchar(20)
,@id int =0
[code]....
here when users enter new mobile number it should insert data into database and show 'You have been registered' and if they enter Mobile number that was in table it shouldn't insert data into database and show=='You can just register 1 Time'
problem is when I enter new mobile number it inserted data into database but it showed this message'You can just register 1 Time' but here it should show 'You have been registered' I mean in both condition it show this message 'You can just register 1 Time'
it never show this message='You have been registered'
what should i do?
View 1 Replies
Mar 19, 2010
I want to insert a particular value against a range of dates into my sql server database from the front end using c#.
the table has the column date and worker. so i desire that the user writes the name of the worker and then enters a From and To range into two textboxes so that thorugh a loop function the name of the worker gets written into the table along with the range of chosen dates.
View 18 Replies
Jun 29, 2010
I have used to code below successfully to export a gridview to an excel spreadsheet, however when i use it for a gridview with data from a different table i receive the following error:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
The thing is it works locally fine but when i upload to my shared server i receive the error above?
how to resolve/troubleshoot this?
aspx file:
[Code]....
code behind button click:
[Code]....
View 7 Replies
Oct 21, 2010
I get the error:
Index was out of range. Must be non-negative and less than the size of the collection.
when vieing a page with a datalist on it. i have other controls in the datalist. what would cause this? here is my code behind.
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
Label theiruseridLabel = DataList1.Items[0].FindControl("theiruseridLabel") as Label;
HyperLink hp2 = DataList1.Items[0].FindControl("HyperLink2") as HyperLink;
HyperLink hp3 = DataList1.Items[0].FindControl("HyperLink3") as HyperLink;
Label Label1 = DataList1.Items[0].FindControl("Label1") as Label;
string userName = theiruseridLabel.Text;
ProfileCommon userProfile = System.Web.Profile.ProfileBase.Create(userName, true) as ProfileCommon;
hp2.Text = userProfile.FirstName;
hp3.Text = userProfile.CompanyName;
Label1.Text = userName;
}
View 1 Replies
Jan 19, 2010
I recently had to remove a field from my datakey on all three gridview tables. On the top level table the field (ignum) remains as a non key field. On the two lower level tables it was removed completely. Now, the top level gridview opens correctly, but when I click on select this should bring up all the records in the second gridview associated with the selected row in the first gridview, but I get the following error:
[Code]....
I've looked at everything I can thing of and everything looks ok. The tables look good, I've removed all references to the removed field and I've restructured all the code to account for the changes. I'm missing something, but I don't know what. I've gone through debug step by step and the error occurs as I leave the GridView1_SelectedIndexChanged code. It goes down to the End Sub line with no errors, but when I step again it errors out. Here is that section of code.
[Code]....
View 13 Replies
Mar 22, 2011
I add all row [Code].... in my [Code].... helping with this [Code].... Here is my [Code]....
[Code]....
But when i do that, getting strange error like this;
View 3 Replies
Apr 3, 2010
Server Error in '/EBOOKS' Application.
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Source Error:
Line 61: Dim favorname As String = GridView1.DataKeys(row.RowIndex).ToStringLine 62: Line 63: ' Pass the value of the selected Employye ID to the Delete //command. My coding as
Protected Sub btnMultipleRowDelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnMultipleRowDelete.Click
' Looping through all the rows in the GridView
For Each row As GridViewRow In GridView1.Rows
Dim checkbox As CheckBox = CType(row.FindControl("cbRows"), CheckBox)
'Check if the checkbox is checked.
'value in the HtmlInputCheckBox's Value property is set as the //value of the delete command's parameter.
If checkbox.Checked Then
' Retreive the Favorname
Dim favorname As String = GridView1.DataKeys(row.RowIndex).ToString
' Pass the value of the selected Employye ID to the Delete //command.
SqlDataSource1.DeleteParameters("Favorname").DefaultValue = favorname.ToString()
SqlDataSource1.Delete()
End If
Next row
End Sub
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
Width="563px" AutoGenerateColumns="False">
<RowStyle CssClass="fontsmallthennormal" />
<HeaderStyle CssClass="fontnormalblue8" />
<EditRowStyle CssClass="fontsmallthennormal" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="cbRows" runat="server"/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Favorname" HeaderText="Favorname" SortExpression="Favorname" />
<asp:BoundField DataField="FavorDate" HeaderText="FavorDate" SortExpression="FavorDate" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1"
ConnectionString="<%$ ConnectionStrings:yyyy %>"
runat="server" SelectCommand="SELECT [US], [Favorname], [FavorDate] FROM [TBL_FAVORITES] WHERE ([US] = @US)"
DeleteCommand="DELETE from TBL_FAVORITES where [Favorname]= @Favorname"
>
<SelectParameters >
<asp:ControlParameter ControlID="txtusername1" Name="US" PropertyName="Text" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="Favorname" />
</DeleteParameters>
</asp:SqlDataSource>
View 5 Replies
Sep 23, 2010
i have erro in this code Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
Asp.net control gridview
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace WebApplication2
{
public partial class _Default : System.Web.UI.Page
{
string query, strcn;
public SqlConnection cn;
public SqlDataAdapter da;
public DataSet ds;
private void fill()
{
string strc = "Data source =V_v_S-PC; initial catalog=Entry; User Id=sa; password=sa;";
cn = new SqlConnection(strc);
cn.Open();
string strq = "Select*from th";
da = new SqlDataAdapter(strq, cn);
ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
fill();
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
fill();
}
protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
// GridViewRow row = (GridViewRow)GridView1.Rows[e.AffectedRows];
// TextBox textID = (TextBox)row.FindControl("textbox3");
//TextBox textEname = (TextBox)row.FindControl("textbox4");
//GridView1.EditIndex = -1;
//cn.Open();
//SqlCommand sc = new SqlCommand("update e set Ename=" + textEname.Text + " where Id=" + textID.Text + "", cn);
//sc.ExecuteNonQuery();
}
protected void TextBox3_TextChanged(object sender, EventArgs e)
{
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//int iKey = Convert.ToInt16(gv.DataKeys[e.RowIndex].Values["MovieId"]);
//string TaskID = grdTask.DataKeys[e.Row.RowIndex].Value.ToString();
int ike = Convert.ToInt16(GridView1.DataKeys[e.RowIndex].Values["Id"]);
TextBox tex = (TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0];
string idne = tex.Text;
strcn = ConfigurationManager.ConnectionStrings["SachinConnectionString"].ConnectionString;
cn = new SqlConnection(strcn);
cn.Open();
query = "update e set Ename='" + idne + "' where Id= " + ike + " ";
//string strUpdate = "update tbl_Movie set MovieName='"+strMovieName+"' where MovieId="+iMovieId+"";
SqlCommand com = new SqlCommand(query, cn);
com.ExecuteNonQuery();
GridView1.EditIndex = -1;
fill();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
fill();
}
}
}
View 4 Replies
Jan 25, 2011
I am invoking GridView1 RowCommand and updating table but getting null value error or index out of range.
here is my code:
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Primary")
{
[Code]....
View 20 Replies
Jan 27, 2010
i have a web site and the user is entering a number range like,
From:___ To: ____ Submit
Ex. From: _1_ To:_5_ Submit
But when the user click on the "Submit" button, this is what the code should do. It should insert the values in the database in this manner
1
2
3
4
5
View 5 Replies
Nov 23, 2010
i use objectdatasource control for bind record and also in gridview paging.in my gridview there is a linkbutton(edit) when i click it then it redirect to next page with some key value.but problem is when i try to paging in gridview an error is occure that is Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
protected void grdClassList_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow row = grdClassList.Rows[Convert.ToInt32(e.CommandArgument)];//error
[code]...
View 7 Replies
Jan 1, 2011
I have a datalist menu,that has few menuitems.each menuitems should load a usercontrol in seperate dynamic tab panel.but when I click on menu for third time I faced this runtime error:"Specified argument was out of the range of valid values. Parameter name: value" on pageload method in line : PlaceHolder1.Controls.Add(newtabCon);
here is my code:
[Code]....
View 1 Replies
Nov 15, 2010
i added in the draft Grid View, and injected within the Grid View, and I added in Tempelatield Templatefield inside it i add chickbox And placed in Header Tempelatield checkbox another inside chickbox I added the code below
[Code]....
She then worked Storedprocedure I added the code below
[Code]....
And added to the special linkbutton the deletion process deletes selected from the chickboxI added the following code inside
[Code]....
have a problem when he chose chickbox one performs the deletion process, but if you choose headerchickbox and click on the button,It seems to me the following error messageIndex was out of range. Must be non-negative and less than the size of the collection.Parameter name: index
View 2 Replies
Mar 1, 2011
i am trying to do a really simple thing but it won't work...
[Code]....
this is the error i get
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
i can see different columns in gridview but when hidding gives me error
View 1 Replies
Dec 23, 2015
I'm facing error in code behind. It is showing the above exception. Code behind code is as follows
HTML
<asp:GridView ID="gv_TPBill" runat="server" AutoGenerateColumns="false" DataKeyNames="Instance Name"
OnRowDataBound="OnRowDataBound" OnSelectedIndexChanged="OnSelectedIndexChanged">
<Columns>
<asp:TemplateField HeaderText="Client Name" ItemStyle-Width="150">
[Code]....
View 1 Replies
May 22, 2010
I am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
View 9 Replies
Oct 19, 2010
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 Replies
Dec 3, 2010
I have a GridView on a page for maintainance of the database (mdf). Under this GridView1 I have a FormView1 where I use the ItemInsertTemplate to Insert new rows in my database (which shows the data in GridView1). The first textbox (BIDTextBox) i have on this template, contains text which identify a person. I would like to have a routine which checks if the same value that is entered in the BIDTextBox allready exists in the database. This routine should be fired upon leaving the control BIDTextBox.
I have tried with some stored procedure in my database, but that dosn't seem to do the trick. The most logical to me seems to do a loop thru my table "Ansatte" in my database using sql, selecting any occurence from the field "BID" in my table "Ansatte" that is simillar to the text entered in the BIDTextBox.
View 6 Replies
Aug 20, 2010
how can i insert data into dyanamically created table from database
View 2 Replies
Jan 7, 2014
how to insert data in DB table from view state gridview ?
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.GetMaxId();
this.GetPersons();
[code]...
View 1 Replies
Apr 23, 2014
I want to insert data in sql server from sheet within excelsheet ,there are three sheets in the file which i want to upload in three different tables,currently i am doing by selecting an individual sheet and the table to upload thus doing it three times for three sheets can i do it in one go,like passing all the sheets to a function or something like that or how can i do it in a better way and also i cannot directly upload sheet into table as i have to map one column of excel to different table of database to get its value like i need statecode but statename is provided in the sheet so i map statecode to statename in a staging table and then i upload the data...
View 1 Replies
Feb 2, 2010
I can't seem to access a label that is outside the DataList. I wish to add the data in the label into a database, aswell as data that is inside the datalist (this is already working though). My SQL-query with only the specific label looks like this at the moment:
[Code]....
The data is added to the database when pressing a button inside the datalist (using onItemCommand). If I write UserIDLabel.Text the regular way it doesn't work either. The label is in the MasterPage, while the datalist is in a .aspx-page. If it is possible to somehow access the data that is in this label and add it to the database I would be ever grateful. Or is it somehow possible to add data that is in a Session and add it to the database?
View 3 Replies
Oct 26, 2010
I want to insert data in to the database by click on button and input box appears.The data entered in input box must insert into the database site that can quickly descirbe me asp.net controls and advance properties , actuallly i had created lots sites in php. Now time for asp.net
View 4 Replies
Nov 16, 2010
i'm currently doing a shopping website. The customer will have to selected the item they want to buy and it will appear in the detail view when they click add in the grid view. I need the info inside the detail view to be insert into a database call Orderlist.
i've try using INSERT INTO OrderList (ProductName, Price,) VALUES (@ProductName, @Price) but it don't seems to work.
Was it because i can't insert it like this as it is detailview? This method can work if is Textbox instead of detailview.
View 5 Replies
