I want to extract data from table into a view. MEans i have datatime field with value '12/31/2010 12:00:00 PM' in a table .
I want to change the field format in view to Date like '12/31/2010'.
Iam using oracle 10g.
i have a grid view which displays only one value and i need to extract that value and display it in a textbox?
View 4 RepliesI happen to have used datasets and hence data tables in most of data access approaches.
This time arround i want to exctract the integer value and use it in the if statement for testing.
I however face a problem in the fact that though i can select the particular cell in a table i still get a table adapter which is not what i need and is not covertible to int value.
See the code below:
[code]....
How can I extra this particular xFiled value and return and integer value rather than a data table?
i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function..
View 5 RepliesI have a strongly typed view for Contacts table In my index page , i am accessing the tables as --- "foreach (var item in Model)"
This table has an association with Groups Table
How can i access Groups table data from view.
intellisense gives me possibility to write like "item.Groups.GroupTitle"
But it returns null(object not initiated) How to solve this?
I developed a web site more then a year ago with .net2.0/c#/mssql 2005. it works fine but i was asked to replace mssql with mysql.
I wrote a class to complete data access works (unfortunately, I didnt use nhibernate or other data access tools :((
I edited the class to use System.Data.Odbc objects rather than System.Data.SqlClient.
It works fine in selecting data but not manipulating data. when i try to insert new data it adds null data for all fields in the table.
in debug mode, i noticed that it might be caused by OdbcParameter but not sure.
I have a package which imports several files on a regular bases . For the import I use a staging table. Now I want to split that stagingtable into two other (existing) tables with keeping the relation ( third table??) . In each record there is a dealerID which has to be injected also in the other two tables (the splittables).
How can I use a conditional split to extract the right columns to the right table? I only see that i can enter a expression for each column, but in fact i only want to split the table by "fingerpointing" the right columns. is that possible? And how should i put the relation between them in 'relation' table?
I need to pass many records with number of fields(i.e 5rows and 5 columns) in either array or table form to oracle for processing. Is it possible to pass array/table from asp.net pages? If no, any solutions for this? I have been thinking of passing it as string concatenated with delimiter and split it. Seems like it is not appropriate as i have to pass 5 strings(5rows)
View 2 RepliesActually i need to transfer data from one table to another table in mysql with codition of Time.for example i need to transfer data at 10.00am when user login at 10.00am it must be insert into another data table.. if anybody know time control
View 2 Repliesi have one task. i store the table records in tab delimiter then i want read that txt file data's line by line via asp.net application codebehind file after that i want insert into another table
[code]...
i am developing an appilication using asp.net 3.5 with c#.net and SqlServer 2005 as backend databse.
in my application i have to import the data from excel file to database. the fields in excel file and fields in databse table are same. i just want to import all data to that database table.
I need to fetch the data from a table with Alias name in oracle.
example: select f1 'Field Name1',f2 'Field Name2' from sometablename;
I am building a little app to upload a picture and various downloads for different file types for the photos, but I also need be able to select the catergory they will go into. So I have two tables one that stores the catergory names and one that holds the paths to the photos and downloads the tables are related through the catergoryID.
What I need is those catergories to show up in the photo's and downloads table so that when I go to upload the photos I will be able to select the categories.
I have also built the DataSet and the Business Logic.
I work with Visual studio 2005 and Sql server data base. I extract 1 million rows from a database and I put the rows in a Sql table. With a simple direct extraction, in a few minutes I complete the operation:
Dim cmd As New SqlCommand(query, cnSql)
cmd.ExecuteNonQuery()
cmd.Dispose().
But, if I must select and modify some fields between extraction and introduction, it takes a lot of time!
I work in this way. I extract rows from Dbase, Table1, and I put all into a Collection using dataReader:
Dim cmd As New SqlCommand(query, cnSql)
Dim coll As New Collection
coll.Clear()
Dim dr As SqlDataReader = cmd.ExecuteReader()
I replace some fields with the string "YES".
Dim toRepl As String = ""
If dr.HasRows Then
Do While dr.Read
toRepl = dr(5).ToString
If Len(toRepl) <= 3 Then ToRepl = "YES"
collPrel.Add(dr(0).ToString)
collPrel.Add(dr(1).ToString)
.................. ..............
collPrel.Add(toRepl)
collCount = collCount + 1
Loop
End If
dr.Close()
cmd.Dispose()
Now, I insert all into a SQL Table2:
Dim a As String = "", b As String = "", c As String = "" etc.
For i = 1 To collPrel.Count Step 6
a = collPrel.Item(i).ToString
b = collPrel.Item(i + 1).ToString
.............. ...............
f = collPrel.Item(i + 5).ToString
queryIns = "INSERT INTO Tab (name, adress, etc)
VALUES ('" & a & "', '" & b & "', '" & c & "', etc. )
Dim cmdIns As New SqlCommand(queryIns, cnSql)
cmdIns.CommandTimeout = 600
cmdIns.ExecuteNonQuery()
cmdIns.Dispose()
Next
This way to work goes right but it is necessary a lot of time for completing the operation.
what's a recommended way to page data to a view from a controller into a table?
View 6 Repliesi have a some Records in My Data table. i want to get Distinct Records so i have used data View for That. when i look in into DataTable.DefaultView it Shows Empty.
i have Cleared the RowFilter of this Default View.
Im coding in VB Im looking to transfer data from a gridview to a table. In the grid view i have enabled Selection, and on the code behind, as i need help getting started selecting the attributes adding it to a table. The grid is being populated from a table however i would like to take the information selected and store it in another table, which will have some more attributes. i have found a way which will add the row by an sql query from one table to another however i would like to give the user the option to select and add data to the table.
And i was thinking i could use this SQL query in the code behind but im not sure how to add it to the code behind of the select.
[Code]....
I am working in asp.net and in that i am using grid view and now i want to convert grid view data which is dynamic to the html table so i can send an email.
View 1 RepliesI have two tables Contact and Addresses. Addresses is the child table of Contact. When i create view for Contact. i also want to get addresses for user as many as user wants. For contact table i bind the textbox and add validation like this
[Code]....
how can i bind address field on create view screen. i want to update the all teh contact data on one submit.
I have a table which contains 2 lables,1 checkbox and i1 image.how to connect this to a list view.how to write Eval code in the Text property of list view.
View 3 RepliesI am trying to bind a table to my grid view. This grid view has an extra column Serial Number where I want to show numbers starting from 1 till the last entry.
View 4 RepliesI am using PL/SQL Developer. I have an view "MEDPRO_MULTIPLE_ID". Suppose If I want to see the columns inside the view. What Command Should I use.
View 5 RepliesWhen adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined.I mean assuming I have a view like this
CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.
var foos = myDB.FilteredFoos.Include("Bar").ToList();
foreach (Foo foo in foos) { ...
I run queries in my stored procedure and pass values to it as a perameter e.g.
SELECT p.Profile_Id
FROM Profile p
WHERE (p_Gender = p.gender_id)
now is there a way that i can get the actual query executed with paramaters value like this:-
SELECT p.Profile_Id
FROM Profile p
WHERE ('M' = p.gender_id)
You'll have to excuse my ignorance, I'm coming at this from a front-end perspective, and don't really know how to deal with data views in ASP.NET.
Basically, I'm trying to change the layout of some repeated data from a straight table, to something more design-heavy. It's the same data, just re-organised slightly. The current ASP.NET code looks like this:
[Code]....
However, I want to replace all of this, such that each 'row' of data renders like this:
[Code]....
How is this done? Can I just edit the code above, or would I need to do something more advanced in terms of not using a data grid and using some other control instead? Is it something that can be done in just a .aspx file or would it need to be done in C# and compiled?
