i have a datatable with several columns and rows. now i want to copy the last column fully (all rows) and create the new column with that values.
it means last column values sholud be moved to new column (now this is the last column).
I have a DataSet comprised of two DataTables. One of the DataTables is further comprised of the results of two different SQL calls. I need to alphabetize the results of those SQL calls. After the seconds set of results is added to the DataTable I tried the following but the end result (displayed on the page) did not alphabetize the returned results. There was no error. Can anyone advise me please. 'programs' is the DataTable name, title is the column name.
programs.DefaultView.Sort = "Title ASC";
i have a column seq_no in datatable. if the column with data 2,4,5 how can i have the max number of the column. C#
View 5 RepliesI have a datatable that looks as follows:
Make,Ford,0
Model,Fusion,0
Year,2010,0
Make,Ford,1
Model,Focus,1
Year,2010,1
I'd like to loop through each row and replace all the values of the same type in the 3rd column with a different value.
So for example I would change all the 0 to 1234 and all the 1 to 1235. So I'd end up with:
Make,Ford,1234
Model,Fusion,1234
Year,2010,1234
Make,Ford,1235
Model,Focus,1235
Year,2010,1235
Whats the best way to do that ?
[Code]....
Refer to datatable columns with database column names?
I have a datatable dt with 4 columns. I want to retrieve only distinct values from column1 of datatable.
How can I achieve this using c# code?
i have a sum column in my datatable and want to add the values?
is compute a good method to use?
I have gridviwe having 2 columns:
1) DocNumber 2)Title
query select docnumber,title from tbl_docs.
BindwithGridviwe(sql);
Now the issue is that that every document doesn't has document number. I want to make invisible the docuNumber column of the grid viwe if all values in the docNumber retrieved are null.for example:
docnumber tite
null Document 1
null Document 2
null doucment 3
null document 4
if returned result match above where all docnumber are null then make the gridviwe docnumber column ivisible eslemake the greidviwe column visible.
i dont know why this happens and when happens......i have one employee table that contain date field and that field contain two different values one is -'2008-10-01 00:00:00.000' and second is '2008-10-01 12:00:00.000'.can anyone explain when this type of value insert in database.
View 2 RepliesI am grabbing an XML feed an throwing it into a dataset. I am looping through the datatable that is in the dataset and adding a column to the datatable (Distance) that is the result of a calculation. What I then need to do is sort the dataset on the new column (Distance) I added, but it is not working... Here is a sample of my code.
[Code]....
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
I'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.
The current code:
[Code]....
Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?
Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?
I have one table it's contain multiple columns and one of them is
[Call_Ref_No] [numeric](18, 0) IDENTITY(1,1) NOT NULL
In this column I am facing issue is some time its missing the identity value... For example
1
2
3
5
6
8
9
Here in this example 4 and 7 is missing...I could not able to find these two reference in my table so what I can do? How I can stop this occurrence.
i have to combobox which default selected value is "select all" and other values USA GERMANY vs.
and i have countries table.how can i query all country names when "select all" value is selected.My stored procedure is look like this
select * from countries where countryname=@prmcountryname
I have a Datatable that contains a column called Tags, Tags can have values such as
row[0] = Tag1
row[1] = Tag1, Tag2
row[2] = Tag2, Tag3
row[3] = Tag1, Tag2, Tag3
row[4] = Tag4, Tag6
and are seperated by comma's etc..
I have the value of Tags for the current document and have run a query to select all other documents that have either of the Tags in there row. for example lets say the current document Tags are (Tag1, Tag2, Tag3)
so from the example rows above all the rows above are returned apart from row[4] Here is the bit i'm lost with, i now want to sort the datatable by how many tags are matched with the current document. so for the example i've talked about so far they should be ordered
row[3] = Tag1, Tag2, Tag3
row[1] = Tag1, Tag2
row[2] = Tag2, Tag3
row[0] = Tag1
Not used linq before but was told it could do this. so far i have
var query = from c in dt.AsEnumerable()
orderby c.Field<string>("Tags").CompareTo(dr["Tags"]) ascending
select c;
I'm trying to retreive a column value from gridview5 to use it in a query to display resuls in gridview, Also how do you hide a column in the grid?
Where (p.Link_ID Like GridView5.?
[code]....
I am trying to do a lookup in a table with a value stored in an xml column.
I tried this several ways but I can't get it to work.
Here is some code:
[Code]....
This is my code so far:
SQL = "insert into " & tableNameToday _
& "(ID, Name, Calories, Of_Which_Fat, Protein, Carbohydrate, Of_which_sugars," _
& "Fat, Of_Which_Saturated, Of_Which_Monounsaturates, Of_Which_Polyunsaturates," _
[Code]....
how do i multiply the columns like this. for now static explanation would be ok but eventually i would like to make it dynamic so there would be a text box for users to enter the amout they like e.g 160g then the table would know to multiply the columns by 1.6.
i have 3 columns in database table. like below
StreetCode Address State
my Input is = 221 Hyd tg GA
StreetCode = 221
Address = Hyd tg or Hyd --> like that
State = GA
i need to search my database table with 3 columns matched records above string.
the input is not coming separately it is mixed of one string with space of string.
but see Address is = Hyd tg is one string how to seach 3 column values in one string input.
I have req where i have to check the value coming from db is null or not and assign value according to that.Problem here is the field datatype is 'Datetime' so all the time when I tried to use the below line of code its giving me error.How can I pass a null value to datetimefield if value coming from db is null.
(reader["FieldName"] == DBNull.Value) ? string.Empty : (DateTime?)(reader["FieldName"]);
I came to know that string.empty is making problem,what value we can pass instead of string.empty for a datetime column in C#.
What I want is ,Field value will get null value assigned not zero.
If I am passed a datatable and I cant change the column structure..is there anyway to set an existing column to a Primary key so I can easily Find() the row I am looking for?
View 1 RepliesI have a table converted from Access and the identity keys were lost. Now I need to make the id column the identity column, but it already has a lot of null values, how do I auto generate integer values for the null rows? The row ids are incremented, so if there is a way to auto increment the ids
View 7 RepliesHow can i move the RESET button inside sort order column , so that my code doesnot break?
[Code]....
I create a table as picture below :
when I insert any character to column Name then A new string random will auto insert into column Random (picture below) I had used Trigger but It was error !
I want to column Random use to code :
DECLARE @myid uniqueidentifier
SET @myid = NEWID()
insert into table_1 values(@myid, substring(CONVERT(varchar(255), @myid), 1, 5))
but It must auto like column Number (column Number is Identity)
I am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 Replies