Setting Indexed Columns On A Custom SQL Table
Jul 22, 2010
I've read about primary, unique, clustered indexes etc. But I need to understand it via an example.
The image below is the auto-generated aspnet_Users table captured from SQL Server Web Admin Panel.
Taking this as a model; I will create a custom table called Companies and let's say the fields are: ID, Name, ShortName, Address, City, Country.. No values can be duplicate for ID, Name and ShortName fields.
What is your approach on creating indexes for this table? Which should be clustered or non-clustered? Are indexes below logical to you?
Index Columns Primary Unique Clustered ign.Dup.Keys Unique Key
------------------------------------------------------------------------------------------
PK_ID ID True True False False False
Comp_Index Name,ShortName False True True False False
View 3 Replies
Similar Messages:
Mar 5, 2010
I'm creating a table in an asp.net code behind dynamically, and I want to have a footer row that only has 2 cells. The first should span all the columns in the table-1. Is there some way other then keeping track of the # of columns in the table manually for me to set the colspan to be # of all the columns in the table-1? Preferably a HTML or CSS solution?
View 2 Replies
Feb 21, 2011
I've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
Dim current as Double = 0
If Double.TryParse(xyz123.Tables(0).Rows(0)(x).ToString(), current) AndAlso current <> 0 Then
count += 1
totalNumber += current
End If
Next
Dim averageRating as Double = totalNumber / count
View 2 Replies
Sep 1, 2010
i have a table that has some columns and rows i want this table to have borders that are visible inside it i want every column an row to be closed in borders how can i do that?
View 1 Replies
Mar 30, 2010
I have a GridView with bound columns, for which I am manually setting the ItemWidth and HeaderWidth to 500px, and nothing happens. Is there some trick to getting this to work?
This is a column a large amount of text in it, and it keeps sizing to the width of the header text, which is simply "note". I don't want to set Wrap to false, becuase then the colummn could be thousands of px wide in cases.
View 11 Replies
Oct 27, 2010
i have a grid view with all columns as TemplateFields( No BoundField). Based on certain condition i have to set Visibility of few columns false. Suppose when there is no column 'CaseList2' in the DataTable, then the second column of the grid (whose column index is 1 )should be invisible. But when the Gridview binds it gives error DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'CaseList2'
i googled it and found that
GridView1.Columns[1].Visible = false;
should work. But its not working actualy.
Code:
[Code]....
Codebehind:
[Code]....
View 3 Replies
Apr 27, 2016
I have a stored Procedure, which copies the data in one table to another table in other DB.
I have the query to copy the records to other table.
But, tomorrow, new columns are added to the source table, then, how to dynamically copy the data from those columns to the destination column..
View 1 Replies
Dec 6, 2010
I have the following property:
[Code]....
I want to be able to have the user see the available options when they try to do something such as DateRange = .... (i want intelllisense in here and I can set the values). Is this a possible functionality? I am using VS 2008 .NET 3.5
View 1 Replies
Apr 20, 2010
I though it would be very simple but I can not get it today.I have a user control, with a grid control contained in it.
public Unit Width
{
get
[code]...
View 1 Replies
Apr 21, 2010
I've recently started tinkering with ASP.NET MVC, but this question should apply to classic ASP.NET as well. For what it's worth, I don't know very much about forms authentication and membership providers either.
I'm trying to write my own MembershipProvider which will be connected to my own custom user table in my database. My user table contains all of the basic user information such as usernames, passwords, password salts, e-mail addresses and so on, but also information such as first name, last name and country of residence.
As far as I understand, the standard way of doing this in ASP.NET is to create a user table
without the extra information and then a "profile" table with the extra information. However, this doesn't sound very good to me, because whenever I need to access that extra information I would have to make one extra database query to get it.
I read in the book "Pro ASP.NET 3.5 in C# 2008" that having a separate table for the profiles is not a very good idea if you need to access the profile table a lot and have many different pages in your website.
Now for the problem at hand... As I said, I'm writing my own custom MembershipProvider subclass and it's going pretty well so far, but now I've come to realize that the CreateUser doesn't allow me to create users in the way I'd like. The method only takes a fixed number of arguments and first name, last name and country of residence are not part of them.
So how would I create an entry for the new user in my custom table without this information at hand in CreateUser of my MembershipProvider?
View 2 Replies
Jan 25, 2010
I have created a user custom control, and what I would like to do is to pass it the text value from a label where I can carry out some other processing.
View 2 Replies
Mar 3, 2011
I am trying to set up my first custom validator in VS 2010 VB. I want it to use a Sub or Function that is in my code-behind. I have searched the WEB but the instructions and examples that I have found do not show me how to use code-behind.
The main problem that I am running into is that I can not find a way to connect the validator to a sub that preforms the validation check.
View 3 Replies
Apr 30, 2010
i am tryin to make an inherited custom label control.
what i want is i want to have a property for the label where one can select languages.
like <label id="lbl" language="">
so when the user gives "language" property he must be provided with an option of "EN" and "AR" like an intellisense.
View 5 Replies
Mar 14, 2011
i have atable that contains (id, name, commission) i need to have the sum of commission where name=a as'first' and the sum where name=b as 'second' in the same row
View 2 Replies
Aug 23, 2010
I've tried doing this, but it seems to just be ignored. I found a few articles saying that if you wanted to do this then you had to make sure that the parent object was also 100%. I have the following:
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server" style="height:100%">
<title>Untitled Page</title>
[code]...
View 2 Replies
Feb 17, 2011
I can't seem to find anything on how to edit the data editor settings before umbraco 6.2 (Juno). Is there any simple way, it must be possible. If you don't understand what i mean i want to do the same as [URL]
View 2 Replies
Mar 27, 2010
I need to do a partial update of a page using an UpdatePanel but I want to throw it using onkeydown. Is there a way to do this by creating a custome asyncpostback trigger.
View 4 Replies
Jul 7, 2010
I am creating new custom command button control derived from asp.net command button. In my custom control I want to set two images (i.e. one from left and one from right). In center command text will come. I tried background image property using css. But I won't work out for me. The image is coming left but the actual command button style is lost and the second problem is I could not able to set image on right side.
View 7 Replies
Dec 6, 2010
What am I doing wrong here?
Me("Label" & CStr(i)).Text = strURI.Substring(strURI.ToString().LastIndexOf("/") + 1) & ": " & intCount.ToString()
[Code]....
I get an error on Me; it indicates that it cannot be indexed because it has no default property
View 5 Replies
Sep 29, 2010
will bad SQL query or tables not indexed properly cause any problem when we execute it? or it may just take more time to execute??
View 3 Replies
Jan 5, 2010
I'm trying to make our (very heavily AJAX based) website more search engine friendly.We have a system where certain urls redirect to the main page after setting session variables to change the behavior of the main page. This is acheived using the Controller.Redirect method to create an ActionResult.
So for instance, the main page is:
http://radiotuna.com
but if we want to link to a radio station, we use:
http://radiotuna.com/s/66258
which redirects to the main page. However in this case, the displayed content is different due to Session variables that were set prior to the redirect.
What will be indexed by web crawlers when presented with this redirect?
Will Session be preserved in this case?
As far as I can tell there are a few possible outcomes:
crawler follows redirect, session info is preserved, crawled data is associated with http://radiotuna.com/s/66258 (the desired outcome)
crawler does not follow redirect. If we can send a page with the 302, this is OK-ish. Is this permitted?
crawler follows redirect, session info is preserved, crawled data is associated with http://radiotuna.com/ (bad)crawler follows redirect, but session info is discarded, so main (unmodified page) is associated with http://radiotuna.com/s/66258 (bad)
Perhaps a 302 is the wrong status to send back. Perhaps the idea of using redirects in this case is flawed.
EDIT: Why are we doing this? Ideally we'd like only a single URL to appear in the address bar, so we'd like to always redirect to the main page. When coming in from a redirect, this would result in a different title and meta description and it is this that we'd like to be picked up by the crawler and associated against the pre-redirect url.
EDIT2: Would it be better to detect if we're being hit by a crawler and to deliver the page without redirect in this case? How might one detect crawler clients?
View 3 Replies
May 18, 2012
In asp.net, I am having a data table with the column ID, Name, AGe, Rank.
I need to get the records from the Column ID, Name and have to create a new data table with this column and rows.
View 1 Replies
Sep 14, 2010
i have an already existing schema (in a xsd file). now i need to prepare a report, so in the rdlc page i take a table. now how can i set the schema as a dataset to the table?(i'm getting an error -- "the table 'table1' is in the report body but the report has no data set. Data regions are not allowed in reports without datasets.").
View 1 Replies
Aug 18, 2010
I have built a site and worked fine for me, when I passed to a collegaue to deploy into another site he gets the message in subject.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
If Not getQueryString("post") = 0 Then
postID = Request.QueryString("post")
BlogAdmin1.Buttontext = "Edit Blog"
Dim MyCommand As SqlCommand
Dim myAdapter As SqlDataAdapter
Dim ds As DataSet = New DataSet
Dim myUpdateconnection As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("conn"))
MyCommand = New SqlCommand("ADMIN_BLOG_SELECT_POSTBYID", myUpdateconnection)
MyCommand.CommandType = CommandType.StoredProcedure
MyCommand.Parameters.Add(New SqlParameter("@postID", SqlDbType.Int))
MyCommand.Parameters("@postID").Value = postID
MyCommand.Connection.Open()
Try
myAdapter = New SqlDataAdapter(MyCommand)
myAdapter.Fill(ds, "postData")
Catch exp As SqlException
Response.Write(exp.ToString())
End Try
If Not ds Is Nothing AndAlso Not ds.Tables(0) Is Nothing AndAlso ds.Tables(0).Rows.Count > 0 Then
BlogAdmin1.BlogTitle = nullToStr(ds.Tables(0)(0)("title"))
BlogAdmin1.BlogBody = nullToStr(ds.Tables(0)(0)("body"))
BlogAdmin1.BlogCategory = nullToInt(ds.Tables(0)(0)("category"))
End If
MyCommand.Connection.Close()
LoadData()
Else
Response.Redirect("/admin/blogs.aspx", False)
End If
End If
End Sub
It errors here
BlogAdmin1.BlogTitle = nullToStr(ds.Tables(0)(0)("title"))
View 8 Replies
Feb 18, 2011
I have been facing this problem for a while now, what I exactly want to do is ->
I have a 3- Tier Application. For a table (say Employee) I have following classes in my BLL and DAL
1. Employee.cs (Contains database fields as properties)
2. EmployeeKeys.cs
3. EmployeeFactory.cs (Main BLL which make call to DAL method)
4. EmployeeDAL.cs (The DAL)
Suppose I have 6 columns in Employee table.
I know that the DAL returns List<Employee> to the BLL and then the BLL in turn gives me the Employee fields.
I have no problem accesing it.
But suppose I have a dropdownlist control and wish to bind EmplyeeName and EmployeeId with the Dropdown.
Is there any way that I can implement that my DAL returns a Generic list containing only the two fields required to bind the Dropdown.
In short i want my list to return only 2 columns, not all the 6 like the List<Employee>
How do i implement this???
Do I need to create a custom List<CustomEmployeeData>, if so how can i implement it in the 3 tier application.
Basically i m looking to increase the efficiency by getting less data from database. Am i on the right track????
View 2 Replies
