i have one dataset that populates some values like value1, value2, value3, value1, value3, etc. And i am showing this values in a dropdown list. But my requirement is that i have to show the same value once. That is the dropdown should be display like this, value1, value2, value3. Not repeat the existing value.
View 3 RepliesI am working a project, it requires me to select everything from a table, one of the fields contains dates. I have to take each take and add negative 6 months if the result equates to today's date then i add that row in the dataset to a listview else i remove that row from the dataset.
The problem i am having is removing the entire row from the dataset before binding it to the listview.
I have a situation where i have a dataset with many, many rows but few columns (5). Lets say in one row i have A,B then somewhere else in the dataset i could have another row that has B,A. What i want to do is if A,B exists then remove the row where B,A exists.
How does one go about doing this?
in my mvc2 application i have an action link like
[Code]....
docid is set to empty string because i want to clear ambient value of docid that is present in request context. i have gone through a lot of material on internet and even tried docid=String.Empty but it does not solve the problem and gives me url like /controller/action/id?docid=x. i also write a routeconstraint as suggested but it did not solve the problem either.clear those route values comming from request context with html.actionLink. i don't want to use html.routeLink
Long ago, I created an ASPNET user for development use.However, every time I boot up my dev system, I'm presented with a user login for ASPNET, among others.I don't want to remove ASPNET; I need it for dev work.But how do I keep it from appearing among the list of User Logins available at boot-up?
View 4 RepliesI am getting Resultset from SQL server2005.It contains 4 tables.
Dataset ds=new Dataset();
ds=BLogiclayer1.TestMethod1(a,b,c,d);. This normal Dataset ds contains Resultset. ( I am working with RDLC reports. I added a Typed dataset to my project. I am using Typed Dataset as report dataset.) I want to add normal Dataset all the table values to Typed Dataset table as rows i. e. only one table in Typed dataset.I am trying like below.
//Typed Dataset name that I have added is salesdata.
salesdata sd=new salesdata();
for(int i=0;i<ds.Tables.Count ; i++)[code]....
I 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 Repliesif any possible arrange the data in dataset ascending or descending order
View 3 Replieshow to retrieve a value from a typed dataset. I am trying to retrieve a value from a row within a row return from a tabale adapter method. Example:
Dim transAPI As New PN_TransactionBLL()
Dim trans As PN.RetrieveGEmailDataTable = transAPI.getGEmail(itemtId)
The tabeadapter method retrieves 1 row of data and I would like to pull the values retrived such as "trans.rowproperty"(if thats the correct syntax) where "rowproperty" would contain the actual value returned.
I've figured out how to use a repeater field, now what I want to achieve is a "total" figure for the column, and this figure needs to appear the footer.
Back in ASP 3.0, I would simply create a variable, and on every step as I looped through the recordset, I would add the current to the variable, including its original value. At the end, I'd have the total. Apparently I can't figure out how to do the same thing in ASP.NET.
This is what I'm doing (which doesn't work):
[code]....
i am using dataset,i retrived the values from the database and i deleted from the data set .is it possible to get values back?
how can i get those values?
MY CODING
string studentno = "select regno from stu_ref where batch='" + dropbatch.SelectedItem.ToString() + "'";
SqlDataAdapter dastudent = new SqlDataAdapter(studentno, cn1);
DataSet dsstudent = new DataSet();[code]....
form the above coding i will get all values form the table stu_ref of regno of student now i need to get the first and the last regno from the table
for eg TextBox1=103301
TextBox2=103378
the total no of student=78
I have to know how to achieve the following senario in an web application,I have a search functionality, where i will give some parameteres which are used as input to my select query in sql database.
Once i click the start search button the parameters will go to database and execute the query. and display the result in application.If i click the Stop Search, i want to retireve the records which are available till that time. How can this be achieved in .net
public static DataSet GetSubCategories(int category_id)
View 4 RepliesI have a requirement to convert LINQ to DataTable.
I stole the following Extension Method from StackOverflow:
[code]....
I have a database table that has the following: SettingName, Value
So I have loaded (select * from settings) into a dataset
Now I want to know how can I get for example the settingname "Price" and get the value of it?
Here is some sample data in the table
SettingName, Value
Price, $10
Amount, 50
Options, OFF
I m working on ASP.NET using C#, i need to compare the data from two DataSets with a "ID" which is in both the DataSets and then add all the matching rows to a New dataset.
View 2 RepliesHow to sort the dataset Values in Descending order , I have Followed the following way
decimal Length = 94;
decimal Width = 7;
decimal Height = 13;
DataTable dtCarton = new DataTable();
[Code]....
I am looking to cache a dataset and then filter the results as they will be used repeatedly. However, I don't know how to assign values in the filtered dataset to variables in C#. I have looked on the internet for the past few hours but all I can get in binding the dataset to a control.
View 4 RepliesI have this data:
5-16-2010, 5
5-16-2010, 3
5-16-2010, 2
5-16-2010, 4
5-15-2010, 2
5-15-2010, 5
5-15-2010, 1
5-14-2010, 3
5-14-2010, 5
I want to group by the date, these values are now in a dataset. What comes up to my mind is an array list with the following: The master array would have each date listed on the dataset above, within each row of this array I would have the list of numbers for that specific date. How do I do that in VB.NET?
I am trying to Export the dataset values into Excel in my application, its working for first time. Again if i click the export button [second time] the button does't cause postback and the entire page is not postback.
View 4 RepliesI'm trying to bind a dataset (where the data is coming from a webservice) to a dropdownlist; the problem is that I'm getting duplicates in the list... how can I display distinct values only:
[Code]....
i am trying to run this code, but even if it has somes results, it gives an exception saying that there are no Rows at positions 0.
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = (ConfigurationManager.AppSettings["Gulfcoast"]);
conn.Open();
SqlCommand cmd = new SqlCommand("SP_GetSavedInvestigation", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rlname", SqlDbType.NVarChar).Value = ddsavedsearch.SelectedValue.ToString();
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
if(ds!=null)
{
Criteria.Text = ds.Tables[0].Rows[0]["rl_criteria1"].ToString();
}
I have always had problems with creating loops so here I go again.
I have a dataset populated with 1 column and multiple rows. What I am trying to do is create a page that will be used for emailing multiple users. The names will need to be separated by a semi colon.
i have a dataset which contains some data.
let dataset have some columns one among them is " Type "
let the values in column type be type1,type2.type3 and so on
now if i want to filter dataset which contains only type3