DataSource Controls :: Creating Cluster Index From View Error / Cannot Create The Clustered Index 'RateViewIndex'
Feb 26, 2010
Here is my code in SQL
[Code]....
Error i am facing is :
Msg 8668, Level 16, State 0, Line 2
Cannot create the clustered index 'RateViewIndex' on view 'NoteToPass.dbo.RateView' because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate function or grouping column from select list.
View 1 Replies
Similar Messages:
Mar 5, 2010
Here is my code in SQL
[Code]....
Error i am facing is :Msg 8668, Level 16, State 0, Line 2Cannot create the clustered index 'RateViewIndex' on view 'NoteToPass.dbo.RateView' because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate function or grouping column from select list.
View 4 Replies
Apr 10, 2010
where should we use clustered index and non clustered index.i mean in day to day use which on e to choice and how to make decision.
View 8 Replies
Feb 2, 2010
what is difference in cluster index and noncluster index?
which is faster?how many cluster index and non cluster index per table?
what is composite primary key?on how many columns we can create composite key?
hao many maximum composite key's we can create on one table?
View 2 Replies
Feb 18, 2010
1) we have only one select query to select 5 column form the table(i.e. select col1,col2,col3,col4,col5). so in that case should we go for stored procedure Or we can directly write the select query in the .Cs file only ( means in Database layer). when we should go for the SQL server stored procedure and when we should go for in line query in Visual Studio itself.
2)how to decide when to use Clustered and when to use Non Clustered index?
View 4 Replies
Dec 21, 2010
I've procedure that does the below task.1. Create a #table from an existing table2. Insert data into the temp table, this copies few duplicate records into my temp table3. After insert, I'm creating a cluster index for the temp table to enhance my search option later.While creating the Index, I get the below message.[CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is 'type ad, len 16'.
View 1 Replies
Nov 3, 2010
How to change cluster index to non cluster index, if it is primary key?
View 2 Replies
Apr 13, 2010
I have a user defined function GetAddress which takes address id (int) as a parameter and returns a address which may contain some 200 to 300 characters...In the execution plan for that function it is displaying cluster index seek cost as 100%...I have clustered index for address id in the address table..is that costing the resources more...How to decrease the cost of the function or a query...!!
View 1 Replies
Jan 25, 2011
I have two control page in my aspx page. first one left side "tree view",second one right side " form design".Form design will change based on tree view selected index changed.i have 4 level child node(site, master , slave, space). I have seperate forms to each level of node.
cannot update tree node when update the forms. so i reload tree view.
now i need how to auto selected index change to tree node.
ex.
1 parent node
1.1 child node
1.2 child node
i have update "1.2 child node" rename to "1.3 child node"
and reload treeview so it will chage...
how set tree node.selected index = 1.3 child node....
View 3 Replies
Jan 10, 2010
I single table in SQL Server having 50 columns col_1 to col_50 having type varchar(MAX)..The table is having nearly 2 crore data into it which is unstructured i.e. just put in by bulk copy. I have to perform search operation on this table. How to index the table so as to make the search fast? or any other way to make the search fast.
View 2 Replies
Jan 4, 2010
I'm stumbling on a basic LinqDataSource insertion problem. For some reason, I cannot insert records. The run-time returns the following error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index The mark-up is as follows with the InsertParameters group. Adding or removing the group leads to the same error. (Note that updating works fine):
[Code]....
The events are void (just a convenient way to to troubleshoot). However, the run-time error occurs before the events are fired.
View 3 Replies
Jan 3, 2011
gvOff.DataSource = o.ViewData(dCity.SelectedValue);
gvOff.DataBind();
gvOff.Columns[0].HeaderText = "ZZZZZZZZ";
gvOff.Columns[1].HeaderText = "YYYYYYYY";
gvOff.Columns[2].HeaderText = "XXXXXXXX";
Header count is correct.
AutoGenerateColumns: Flase/True ( i tried both)
If i remove the gvOff.Columns[index].HeaderText portions, GridView works fine, but when i put the gvOff.Columns[0].HeaderText, i get the exceptional error.
, i couldn't solve it. If you need further info, inform me.
EDITED:
Hold on! I commented the HeaderText portion and tested
int i = gvOffer.Columns.Count;
I found count is 0 eventhough the columns print out with DataBind()... Why?
NOTE: AutoColumn in this case is set to true. I guess i will have to edit the column
names from DataTable.
View 1 Replies
May 14, 2010
I'm working on a project where we're using Windows Desktop Search (WDS) to index files on a web share and then later allow the user to search via a website for documents in the share.
These documents are transferred to the share via FTP, however it would seem that either the computer never goes idle to index or at some point the indexing stops. Is there a way from the command line or within the program itself to force this to happen without having to re-invent the wheel? Using .NET 3.5 and C#.
View 1 Replies
Mar 11, 2010
I have a gridview with dynamic buttons for edit and save.Save button is disable by default. In the edit button command argument i bind the id of the record.
now when i click edit button i want my save button to get enable and edit button will disable for that particular row. I dont kow how to get the selected row index through dynamic button.
View 3 Replies
Oct 20, 2010
i have the following problem concerning the index::
my source code::
[Code]...
the problem is appeared when i have added the pager to my list view ,,i have out of range for index exception ... how to determine the page iam in and specify the right index either i use list view or grid view or other such controls..
View 1 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
Feb 8, 2010
i have a drop down list and a text box, inside a listview row (and this is a repeating layout). i populate each dropdownlist with same contents ( these contents/items come from a custom collection object).
i have added a required field validator in the listview's item template, that has its validation group = the validation group of the drop down list, and validates if the textbox is blank or not. this validation takes place on the selected index changed of the drop downlist for that row.
1. on selected index changed, EACH dropdownlist validates only its corressponding textbox perfectly (which is what i want)
but if i enter some text in one of the textboxes after doing 1, the dropdownlist for THAT particular row, assigns the correct value to the text entered. but for other rows (for which i changed their corresponding ddls to test the required field validation and for which the text boxes are still blank), their ddls by itself assign the values to the blank text without validating.
markup of code for listview is [Code]....
code behind for the ddl selected index changed is [Code]....
method GetIndexFromId retrieves index of the custom object inside a collection depending on the Id (which is a property) of the object.
i notice that the ddl selectedindexchanged is being hit as many number of times as many rows i change (i.e as many ddls in different rows i change to check the required field validation)
View 7 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 7, 2010
I have a situation where I have a file with each Account Record contains Monthly Expense Total Fields and Monthly Budget Fields for 2009, 2008 and 2007. I'm working with 72 fields (36 Expense and 36 Budget).
Need to create New Year Proceure that will shift data from 2008 to 2007, 2009 to 2008 and move Zeros to 2009 for both Expenses and Budgets.
I can do this using Parameters and Update SQL but I am under the impression that I must specificaly name each field in defining Parameters and SQL Update Command.
Since all fields are sequential withing a record, is there a way that I can use a For/Next loop to index my way through the fields moving data from one year to another?
When using DataReader I'm able to use reader.item(index) to access data record fields.
View 3 Replies
Jan 20, 2011
I have this sqldatasource:
<asp:sqldatasource id="SqlDataSourceX" runat="server" connectionstring="<%$ ConnectionStrings:MyConn%>" providername="System.Data.SqlClient"
selectcommand="SELECT ItemNum, MIN(DateAdded) as [DateAdded]
FROM Items WITH (NOLOCK)
WHERE [DateAdded] between @DateFrom AND @DateTo
[Code]....
When I call select in codebehind, after 30sec it throws timeout expired SqlException:
[Code]....
again , this select took up to 3 sec to be executed. In application I tried to use SqlConnection and SqlTableAdapter instead of SqlDataSource, with the same query, and again it took up to 3 sec.
If I choose tighter interval (e.g '2011-01-20 00:00:00' - '2011-01-21 00:00:00') , there is no timeout exception, so I know that sqldatasource select is executed correctly. So the conclusion is that sql server is not using index while executing query sent from sqldatasource, but is using index whenever else. I have also checked the index statistics on sql server and it is like that. In profiler i can see slight difference between this two cases. As for SqlDataSource, in events table, in first column "EventClass" after 30 sec, there is this: "RPC:Completed" and application throws timeout. If i use SqlConnection and SqlTableAdapter then at the same place there is this: "SQL:BatchStarting" and "SQL:BatchCompleted" and application does not throws timeout(the index has been used).
what is so special on SqlDataSource connection, that Sql Server performs differently compared to other types of connections?
View 3 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
