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.
I have an asp.net database which has users table. In this table password is saved as sncrypted. Now, I am creating my own users table. I want to copy user's data from my old table t this table. I can to decrypt old users table password. Which encryption technique is used by default in aspnet database for passwords.
View 2 RepliesI 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..
Here I Need Copy From One Table To Another Table.
The Two Tables are in Different DataBases and Both Tables are Having Same Fields And Same Properites.
Dim ds As New AccessDataSource
ds.DataFile = "c:InputTest.mdb"
ds.DataSourceMode = SqlDataSourceMode.DataSet [code]....
I have an aspx webpage with a databound DropDownList and a databound GridView control. The GridView datasource is using a WHERE clause to return its' data. I.e. The user selects a work area from the DropDownList and members of that area appear in the Gridview. The GridView has 3 columns, WrkArea, LastName and FirstName. The page also has a Button.
What I am trying to accomplish is when the user clicks the Button, the data from the GridView is copied to a separate SQL table. I am working in VB. I have been looking at other posts but have to admit, I am really confused.
I have a gallery upload page on which currently I have a table with two rows:First row: Gallery description multline Text BoxSecond row: Gallery Uplead FileUpload controlAt the bottom i have a submit buton to post the data on the database.I want to make it possible for the user to key in multiple gallery details before posting them to the database.I also want this page to always display one more empty set of the two rows described above.That is when the user clicks browse for uploading the second Gallery another empty set for the third Gallery need to be automaticall added.This implies that at the end when the user clicks the submit button there will be one last empty set which wont be posted to the databse.
View 1 Repliesi am trying to export gridview into dataset using Datatable but if u used "Microsoft.Office.Interop.Excel" the datatable showing me sum error. is there any other way to export gridview in dataset???
View 1 RepliesI want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....
how to copy from one table to another table in dataset using c#
View 2 RepliesI wonder how to muliply two columns in a table and the result is displayed in the blank column and be specified by its row..
View 3 Repliesi need to extend this so that i can inlcude another column from a different table. so let's say i have a colume in table Price and the column i want to display in datagrid header is cost, how can i do this? there is code backend but could i simply code the below to include this column?
[code]....
I want to export the table and all the data to a file outside the db. Then I want to detach this db, attach a different db with the same table, and reimport the table data from the file.
I thought you could create a table with :
select *
into table IN externaldb
from table
What is the proper syntax for this? I got an invalid path error. I just want to create the file on mu local C root.
Using formview or details view, I want to allow users to both input data into columns (I know how to do that) and add additional columns to the existing table if necessary.
View 3 RepliesIs there a way to copy a row from one table and insert to another but at the same time insert extra values to destination table?Let's say source table Item has values:
ItemID
ItemType
ItemProducer
ItemModel
Destination table ItemHist:
ItemID
ChangeDate
ChangeReason
ChangedBy
ItemType
ItemProducer
ItemModel
I want to copy row from source table where itemid is 25, insert it into destination table and add extra values: ChangeDate, ChangeReason, ChangedBy. I tried:
INSERT INTO ItemHist (ItemID, ChangeDate, ChangeReason, ChangedBy, ItemType, ItemModel) VALUES (ItemHist.ChangeDate=GetDate(), ItemHist.ChangeReason="why not", ItemHist.ChangedBy="me")
SELECT ItemID, ItemType, ItemProducer, ItemModel FROM Item WHERE ItemId=25
but obviously it didn't work ("The name 'ChangeDate' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.").
i am Using sql server 2005. i want to copy the data of the excel file to the table.
i wrote the query like :
INSERT INTO test(empId,empName,empMailId,empContactNo)
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C: estExcel.xls',
'SELECT * FROM [Sheet1$]')
got the following error :
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.
then did this
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
again am trying the same above query ,now am getting the following error:
Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
i want to copy the data of the excel sheet to the table.
I pivoted my gridview with this code. But This code is not mine. Just tested and worked. But i dont know how can i add remove/add buttons to all columns.
[Code]....
1. As per my knowledge we use dataadapters/dataset when we want to deal with the huge amount of column/data. Is there anyway that if I want to update one or two columns in a table without using dataadapter/dataset?
2. There is a way that without clicking a button we can get the data using objectdatasource, I mean to say that there is no vb.net data in the code behind then how to debug if there is not data in vb.net in code behind.
Iam working on an asp.net application.Recently client come with new requirement. Need a control which is similar to table or like gridview with rows and columns.It should allow user to enter data in the cells. And when the user press tab it should go to next cell and finally if we press enter key, it should validate the data entered in the current row and if data is correct it should create a new empty next row(like entering data manually in an sqlserver table). How can i implement this functionality? Can i use gridview / javascript to implement this functionality.
View 1 RepliesHere Am Using This Query to
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = 'TableName')
But Am getting Total Records instead of i need Specific Columns.....
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 RepliesWhen i open the The Configure Data Source wizard, the "Specify columns from a table or view" shows gray, I cannot choose it. How can I do it.
View 4 RepliesI would like to copy DataColumn from tableA to table B:
As I think it should be like this:
TableA in perdefined.
DataColumn[] dataColum = new
DataColumn[TableA .Columns.Count];
TableA .Columns.CopyTo(dataColum, 0);
DataTable TableB = new DataTable();
TableB .Columns.AddRange(dataColum);
//
=> but it raised an error at the line error, ID is belong to another table (in tableB)...
As I dont like another way:
DataTable TableB = TableA.Copy(); TableB.Clear(); // => getting structure of table A, not nice this way
I have a table in my database called "Profiles". This holds data on Female and Male personal characteristics.On my aspx, I have a formview in edit mode which is binded to an object data source with a GetDataByUserId Select methodwhich retrieves data from the "Profiles" Table via a DAL.The "Profiles" table has some columns which relates to females only and some just males and some are generic to both.See example below
UserId - / of Type GUID
GenreId / of Type BOOL.
Hip Size (For females)
Dress Size ( For Females)
ChestSize (For Men )
TrouserSize (For Men)
Weight ( For both )
When the User logs in , they go to an update Page which has the Formview in Edit Item Mode and contains drop down Lists whichare binded to the Users Selected Value. The DDL are in turn bound to their related table such as HIP, Dress, Chest, Trouser etc.bjectiveIf a female user logs in I just want to show them the (Hip Size) DDL and DressSizeDDL in the Edit item template of the formview and not the ChestSize DDL or TrouserSize DDL.At present the GetProfileByUserId returns all colums from the tableMy question is how do I do this and just show DDL which are relevant to the Female or Male Only. In some cases the usermay not have selected an item in the previous form so they could also be NULL.Am i on the right path by writing a Select Query that checks to see if the User is Male or Female by checking the Genre column in Profiles first.Do I also need 2 panels, 1 to hide Female DDLS and the other to Hide MaleDDLs subject to logged in user genre.
I was given an assignment to parse out a text file, without a header record, using only a handful of the 300+ fields supplied. Since there is no header record to define the fields as in a CSV file, I was given these preliminary instructions after creating the HTML page using the file upload control and a few labels and such:
1- create a data table
2- add the columns I want to use to the table
3- save the uploaded file
4- define a stream reader
5- read each row and use MID to extract the data I need
6- write this data to the data table
7- display all the records in a grid view
I've managed to get to step #7 and that's where I'm having trouble. When I look at the data in the grid view, all the fields are in one column, the first column.
I had a little trouble earlier on and a colleague told me to concatenate the parsed fields using a comma and double quotes ("fld1","fld2","fld3"...) which sounded odd but I listened and now, I realize he was leading me down the wrong path.
So:
I used "Dim dtWork as New DataTable"
then "dtWork.Columns.Add("Lastname") for each column I wanted
then saved the file "Dim sPath As Sting="C:..."
defined a stream reader "Dim rdr As New StreamReader(sPath)
Read the rows "Dim sCurrentRow As String = rdr.ReadLine"
and parsed the data "Dim sLastName As String = Mid(sCurrentROw, 3, 25)"
did this for all my fields I wanted and then concatenated each field as described above into a string "Dim sData As String = sLastName & "," & sFirstName & ","....
and added it to the data table "dtWork.Rows.Add(sData)"
So that's the jist of it sans the datasource = dtWork and then the databind. Now, how do I get each parsed field into each respective column the right way?