I have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 RepliesI want to know that how many tables we can have in database and what is the maximum no. of columns.I also want to know the maximum size for each datatype.
View 3 Repliesim creating a database that needs a unique constraint on columns. does anyone know how to add this within the northwind database?
View 4 RepliesI have a datasource, which includes many columns, idealy, I need use a gridview to show:
1) first 3 columns: template fields, these fields depends on values in some columns of datasource. I use template fields, hard coded. works fine.
2) the other columns. This is I do not know how to do it. In the data source, there are about 10-20 columns data, each time, the # of columns of the data varies. idealy, I need show each of them as a seperated column in gridview. The entire data source may have 30 columns, but some of them are used in 1), and I only want show these 10-20 columns in gridview. Some columns in data source, I may not use them at all. is there a way to do this? or have to seperate them as a detail view style UI?
I wanted to know if it is possible to dynamically add columns to a table in the Database?I know how to create a table dynamically in the DB the code for it is given below, howver I do not know, how do I add columns to it dynamically.
Dim NewTable As String = "CREATE TABLE Dynamic " +
" (" +
" job_id smallint" +
" IDENTITY(1,1)" +[CODE].....
[Code]....
Refer to datatable columns with database column names?
I have five textboxes(tb1, tb2, ... tb5) on the page, each textbox represent a column in the database table.
I need to search the database table based on the text in the textboxes. User can either enter text in all five textboxes or none.
What's the best way to do a search?
I am thinking for one textbox(tb1), depends on if tb1.text is empty or not, I need to do 2 searches
[Code]....
for two textboxes(tb1 & tb2), depends on if tb1.text and/or tb2.text are empty or not, there are 4 combinations, so I need to do 4 searches
[Code]....
for three textboxes, there are 8 combinations,
Does that mean for five textboxes, I need to do 2 to the power of 5, 32 combinations, 32 if statements?
i am making relation between two datatables and m getting this error
in this ds.Tables(0).Columns("In_ID") datatype is string
ds.Tables(1).Columns("row_id") datatype is integer
how i do the type casting here to make dataset relation
ds.Relations.Add("Rel_1", ds.Tables(0).Columns("In_ID"), ds.Tables(1).Columns("row_id"), True)
I have a stroed procedure which is mapped in myEDMX file under EntityContainer >>Function Imports. When I add or remove a column from the stored procedure, I am not able to remove the old columns from the model. I right click on the stored procedure in Model browser and got to Edit Function Import. The return type is complex.
I select "get column information" and get the updated return fields but can not update the collection. It will work if I click on "Create New Complex Type" but it will generate a new name for the collection and the old collection is still in the mode. I even tried deleting and adding the stored procedures and can not get it to work. I can only edit the edmx.cs and the XML to remove it but there is got to be a better way.
I created a gridview that is made up of 4 gridviews and using a stored procedure to populate it. I create columns at runtime because the number of columns changes all the time.To make the grids editable I am adding template fields at runtime as I create the columns, this is to ensure that a user is able to edit the cells and some foot values update. Reason why I have four grids is to freeze rows and columns like in excel using javascript. The problem is that performance is very bad especially in IE, the grids take a long time to load. I am not sure if this is caused by the data load or the creation of text boxes. see some of the code below for my _aspx page:
[Code]....
in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]
View 1 RepliesCreating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
I have 3 different databases where some tables are common.
View 16 RepliesI recently installed the latest Oracle Data Provider for .NET(ODP.NET 11.2.0.1.2), due to the fact that Microsoft Oracle Client is deprecated. Ever since the new installation, my SqlDataSource control stopped working. When I try to configure the data source of the SqlDataSource and test the connection, it always gives me the following error message:Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.
OCIEnvCreate failed with return code -1 but error message text was not available. at DataObjectSupport(721,6)
I know for sure the connection settings are definitely correct and the database is online for sure, because any databinding I did manually works perfectly well. I can manually bind to a Gridview, ListBox controls and display the data without any problem. The only problem I have is using the SqlDataSource. This is painful because Gridview and Listview have a lot of cool built-in features. When you databind the controls in the code behind file, you lose all the features.
I have added ASPNET to the Oracle home directory and granted it full control access and retarted the computer but it doesn't work. I'm using Visual Studio 2010 and the database is Oracle 10g. Does anybody know why I'm having problem with SqlDataSource only?
i have list<player> with duplicates.
i need to create another list<player> from the first list <player> with out any duplicates.
I am trying to generate a Grid view from database, in one of my database columns the values are 'y' and 'N'. and i need to show this values in a check box .I tried to keep a check box in item template and tried to bind it, but could get much success.
[Code]....
I have a GridView that has several dynamic columns (I do not know how many at design time and it could be 0-12 columns, hence need for dynamic columns). I have the columns in the grid and data bound to them - works great. There are other standard, design-time TemplateField columns with TextBox controls in them. These are bound with values that the user can edit. The grid is posted back via a Submit button. My question is "Why does gv.Columns.Insert() cause all my TextBox data to be null on Postback, but gv.Columns.Add() works like a champ?"
protected void BuildColumns()
{
// The first column to begin to insert the columns in the GridView
int columnIndex = 5;
BoundField aoColumn = new BoundField();
aoColumn.HeaderText = "New Column 1";
gvMyGrid.Columns.Insert(columnIndex, aoColumn); // kills txtQuantity.Text on postback
gvMyGrid.Columns.Add(aoColumn); // works fine
columnIndex++;
foreach (MyEntity my in _myEntityCollection)
{
BoundField myColumn = new BoundField();
myColumn.HeaderText = String.Format("{0:d}", my.StartDate);
gvMyGrid.Columns.Insert(columnIndex, myColumn);
columnIndex++;
}
}
I then go on to assign values to these BoundFields in the _RowDataBound method and all of this works great. However, when I post back and try to reference some TextBox and they are all null. And yes, I have the BuildColumns() call wrapped in if (!IsPostBack) on Page_Load. Of course I would like to use .Insert() so that the columns can go in the proper location and not at the end of the Columns array.
I'm binding a gridview from a webservice with 30 columns and 10 rows, I need to print the same in a PORTRAIT, for that i decided to display columns as rows and
rows as columns like below:
EMP1 1 2 3 4
EMP2 1 2 3 4
I've created a Data Base project with some CLR functions and stored procedures.
I'd like to deploy the assembly under different schema then the default dbo.
Is it possible?
I've created a new ASP.NET website. I've generated an Entity Data Model from my database and have dropped a entitydatasource and gridview onto my page and wired up the gridview to pull from the entitydatasource. Now I get columns like this: id extension prefix did_flag len ten_id restriction_class_id sfc_id name_display building_id floor room phone_id department_id
In each case where the item is named something_id this reflects a foreign key relationship in the database - and I did choose to have the EDM expose foreign key relationships. I'd like to make it so the gridview pulls in the values for these foreign keys rather than just showing the ID numbers - so, for example, department_id might have a value of "101" right now but it should pull from the department table "Marketing".
I'm trying to add these 4 co,umns to the table as bit type woth a defaut of FALSE. What am I doing wrong here? I get a syntax error near (
create PROCEDURE [dbo].[AddADIFields]
AS
ALTER TABLE dbo.tblTESTS ADD (AI1 Bit 0,AI2 Bit 0,AI3 Bit 0,AI4 Bit 0)
I am SELECTING two columns:
SELECT ([FirstName] + [LastName]) AS [FullName], UserID WHERE CustomerID = @CustomerID
I would just like to know if there is a way to add a space between the two columns in the select statement.
This SqlDataSource Binds to a DropDownList so TextValue = "FullName" and DataValue = "UserId"
but of course, the way it is now the fullname is all one word.
I am looking for a fast way (either by script or Query statements) that would enable me uniquely extract some tables from my database schema.
The tables I wish to extract have some unique columns like x and y coordinate columns and i want to extract only the tables that have these coulmns in them.
My database schema is very large with 100s of tables that i cant just go through the tables one by one.
GridView1.Columns.Count is always zero even SqlDataSource1.DataBind();
But Grid is ok I can do
for (int i = 0; i < GridView1.HeaderRow.Cells.Count;i++)
I rename request headers here but
GridView1.Columns[i].Visible = false;
I can't use it because of GridView1.Columns.Count is 0. So how can I hide them ?
I am developing an web application. One of this form has a textbox. When the user enter chars i need to fetch the records from db and display as 4 columns in AUTOCOMPLETEEXTENDER CONTROL TOOL KIT and it's column name also. When the user click any one of the row, i need to get the 2nd clicked column name and display it in textbox.
how to display 4 columns and it column name in autocompleteextender control?