SQL Server :: Finding Spatial Index Settings For Geography Data Type Column?
Aug 9, 2010
I have a column in SQL Server 2008 called MapLocation which is stored as the geography data type. This column is used to store the location of a building in one table, and the location of landmarks in another table. I have to list all landmarks within 4 miles of a building.
I have a clustered primary key on an automatically generated int column in each table. I assume that I need to create a spatial index on the MapLocation column in the landmarks table. This I guess would aid finding all landmarks within 4 miles.
My problem is that I am not sure what settings to use for this spatial index. I have set the spatial index to have the following settings:
Cells per object: 16 Level 1: Medium Level 2: Medium Level 3: Medium Level 4: Medium Tessalation Scheme: Geography gridAre these the best settings? Am I doing the right thing?
Is there a way to find out which column is selected in the Gridview row command? When I click on a gridview row in a specific column, is there a way to get the column index of the selected row?
I have a grid view with 4 columns and 12 rows. Getting the row index is not problem; ;however, I cannot find a way to get the column index of the cell that i select.
I want to change one of my table columns data type. Now the column data type is varchar and i want to change it to float. Updated all the column data to numeric and tried to convert the datatype with the following syntax
alter table vibration_values alter column dis_v float
but getting the error as
Error converting data type varchar to float.
The statement has been terminated.
Suprisingly every thing worked well in sqlserver 2005 and not working in sqlserver 2000.
I have a listview control which is bound to DataTable object. When a user clicks "Add", I am creating a new row in the underlying datasource and refreshing the datatable so that it includes the new row and displaying the listview. My requirement is to "select" the newly added row after listview is refreshed. I have the ID of the newly created row and it is bound as one of the columns in the datatable.Now my question is, how can I get the index of that particular row which was newly created from the Listview so that I can set its SelectedIndex.
This is my programs complete code, the only problem is i want to fix the amount of decimal places that show up in my gridview. The problem is if i do this on the asp side the location of the column gets thrown off and the column is duplicated. I figured if i just remade the table on the asp side it would work only problem is if i remove the sql for that particular column the asp side column cannot get data.
I am tring to write some custom filters for a gridview and want to base the filters available based on the datatype of the Columns in the GridView. How would I go about determining the datatype of each column?
I am using ASP.NET 2.0 and C#. I have a gridview, which has template columns. The columns have header text available. I would like to do sorting on each of the column header in the gridview the user clicks.
How to identify which column, the user has clicked?
is there any way to find a item from a list by providing the index???my list name is listStockItems i have a index of a particular item in that list and now i want to get the Stock_Item object from that list by providing the index to list.
I have been trying to hide a column but make use of the value in another function but the function i am trying to hide it give me and error at the embolded line. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Public Sub FetchDetails() Dim valtable As DataTable = New DataTable() valtable.Columns.Add("LINK") valtable.Columns.Add("WATCH PERIOD") valtable.Columns.Add("DAY ENTRY") valtable.Columns.Add("listid") Dim seltext As String = "SELECT [Watchlistname], [Watchlisturl], [Watchlistdate],[listid] FROM [Watchlist]" Dim madap As SqlDataAdapter = New SqlDataAdapter(seltext, Connection()) Dim mdset As DataSet = New DataSet() Dim i As Integer = 0, pager As Integer = 0 madap.Fill(mdset, "WATCHLIST") Session("tab") = mdset.Tables("WATCHLIST") For Each arow As DataRow In Session("tab").Rows Dim valrow As DataRow = valtable.NewRow() valrow("LINK") = arow("Watchlisturl") valrow("WATCH PERIOD") = arow("Watchlistname") valrow("DAY ENTRY") = arow("Watchlistdate") valrow("listid") = arow("listid") valtable.Rows.Add(valrow) Next 'Dim str As String = ChrW(8358) gridWatchlist.DataSource = valtable gridWatchlist.DataBind() gridWatchlist.HeaderRow.Cells(1).Visible = False gridWatchlist.HeaderRow.Cells(2).Text = "WATCH PERIOD" gridWatchlist.HeaderRow.Cells(3).Text = "DAY ENTRY" gridWatchlist.Columns(4).Visible = False End Sub
i know how to find the index of selected row in asp gridview , but i need to find the index of selected column in asp gridview ?for ex:i have i gridview contains columns with header ( the header is the primary key i looking for ) , this grid contain linkbutton , i want to get the column header name on click on linkbutton ?
I used the script where the image array has static images.I want to convert it dynamically by finding my images names from index.aspx.cs files which are stored in hidden fields.
I want to split this hidden filed and assign it to imagearray.how can i do this
var mygallery2=new fadeSlideShow({ wrapperid: "fadeshow2", //ID of blank DIV on page to house Slideshow dimensions: [568, 313], //width/height of gallery in pixels. Should reflect dimensions of largest image imagearray: [ ["images/1.jpg", "", "", ""], ["images/2.jpg", "", "", ""], ["images/3.jpg"], ["images/4.jpg", "", "", ""] //<--no trailing comma after very last image element! ], displaymode: {type:'auto', pause:2500, cycles:0, wraparound:false}, persist: false, //remember last viewed slide and recall within same session? fadeduration: 500, //transition duration (milliseconds) descreveal: "always", togglerid: "fadeshow2toggler" })
I want to import a spreadsheet into SQL. The import/export wizard forces Column A to be a double. In Excel, the column is formatted as text. When I try to convert from double to text/varchar/nvarchar, the import process fails. Why can't I convert a number to text in SQL?
I attempted to change a table columns data type and in the process caused a lot of issues. I had a date column in one of my tables and stupidly changed it from varchar to date. When I tried to run queries on it I keep getting the 'cant find column 3 error'. Now that tables structure is :
[Code]...
So column 4 is actually the date column. All other queries work for this table. I then tried to change it back and then copied all data to a new table and now I am using the new table and converting the dates as needed but I am still getting the error.
SELECT * FROM postlinks WHERE postlinks.date >= CONVERT(datetime,CONVERT(varchar(10),GetDate(),112))
