I was trying to place all the rows of the Column "Title" of the dataset into the string array. But i get an error Identifier Required at strdeals[] in the last line. where am i doing wrong?
string[] strdeals = new string[100];
Dataset dsdeal;
for(int i =0; i< dsdeal.Tables[0].Rows.Count; i++)
{
strdeals[] = dsdeal.Tables[0].Rows[i]["Title"].Tostring();
}
i have a dataset and a table into named Students. Students(StudentName, age)
i wanna name colunm to string array. but not use loops (for foreach..). is there any way?
string[] array = this.dataSetZLC.Student.StudentNameColumn..
How can i send a string session array values to dataset? I have a session array where i stored textbox values. nowi want to send these values to dataset. how can i write the code in c# to send these values to dataset? I dnt want to save these values in database.
View 1 RepliesTrying to do a simple NOT IN cluase, but can't get the Linq syntax to do it.Basically, here's what I am trying to do ( in incorrect syntax):
[Code]....
So, I wasnt to select all rows where d.CD IS NOT one of the values contained in the string array.
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 RepliesI currently have a function that returns a Dataset. I would to create another function to convert the DataSet to an array of objects. I have looked around and havent found anything that can help. Can someone show me a snippet or point me to the right direction.
View 4 RepliesHow can I convert DataSet to byte array
View 2 RepliesHow to assign a array string session to dataset or datatable? I have a array session data in that i stored n number of values. i want to assign these values to dataset. so that i can bind these values to gridview. so anyone pls let me know how to do this? Iam getting error to convert sesion{"noncontractitem"] to datatable.
string[] sessiondata = { txtProductNo.Text, txtItemDescription.Text, ddlUnitOfMeasure.Text, ddlDistributor.Text, rbtlItemType.Text, txtQnty.Text, txtPacking.Text, txtUnitCost.Text };
Session["NoncontractItem"] = sessiondata;
DataTable dts = new DataTable();
dts = (DataTable)Session["NoncontractItem"];
grdSelectedItems.DataSource = dts;
grdSelectedItems.DataBind();
I 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 would like to split the string to the string array.
but when the string hasn't has the splite sperator, i can't put the string into string array directly.
how to do?
if (Str.Contains(','))
{
str_array=Str.Split(',');
}
else
{
str_array=Str; <-- error occurs at this line.
}
I saw post [URL] .... which is converting rows into column item,quantity ,price. I have one other image field .how can bind image in this program?
View 1 RepliesIm still a newbie in both the software and over here.. not quite sure where to put this topic
I have an unbound gridview.. which uses databind instead of sqldatasource..
the thing is how do I modify the title of the column name?
For example.. instead of
MemberID MemberName MemberAddress.... i want it to be like
ID Name Address..
Sample code:
cmdSelectService = new SqlCommand("SELECT JobPost.JobPostID, JobPost.JobPostInformation, JobSpecialization.JobSpecializationName,[code]....
I have a gridview with 3 columns. In second column I want to display some text in 2 rows and then a gridview.
Here is my code:
[Code]....
The problem is my third row is displayed as a row under first column. How do I make it a separate column in my girdview. Not sure what is going wrong.
Just to be forward, my .net and c# expierence is very limited, that one could say I'm a complete noob :) However I do have some grasp on OOP as I usually work in PHP (FWIW). My problem seems to be with this line:
Session["total"] = dt.Compute("SUM(price)", "").ToString();
which will output a total of say "9.2" where as the price is "9.20" from a few record lines as such:
dt.Rows.Add(strRecord, 9.20, dropDownListDistrict_stepTitle.Text);
thus 9.20 + 9.20 = "18.40", but the page displays "18.4".
The label that displays the total sum is:
<asp:Label ID="labelTotal3" runat="server" Text="0" />
From what I've gathered, I'm suffering from some kind of type casting problem? Hopefully I haven't missed anything, its a bit difficult to show all the code but hopefully someone can point me in the right direction? Question is; how can I get an extra decimal place to show up on my sum (or why is it dropping the last decimal place?).
[Code]....
I am trying to insert My_Array_Values into database on seperate rows, ie;
1 ASP_NET
6 Java
8 Perl
how to convert the string to 3 decimal place?i want 0.033 for below:
[Code]....
[Code]....
How can I make the code string connStr = ConfigurationManager.ConnectionStrings "staceys_cakesConnectionString"].ConnectionString;
work generically and not need the staceys_cakesConnectionString? Or how can I set it somewhere else so I only have to change it one place when I change it?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
[Code]....
I have a grid with one itemtemplate field with autogenerated columns=true.I want to show the itemtemplate filed after autogenerated columns .
View 6 RepliesI have 2 datasets as shown below,
dsDBFFulfillment = conn.GetDBFDataSet(ReminderQry);
dsDBHcniID = conn.GetSQLDataSet("spGetRemindpostcards", null, ConnectionType.SRRDConnection);
I have a result in dsDBFFulfillment,Consider the field HcnID,Name,Address In the second dataset dsDBHcniID i have only HcnID.
Now in the third dataset i want a result such that,
1.The records in the dataset dsDBHcniIDshould be removed from dataset dsDBFFulfillment by checking HcnID.
Something like this, dsDBFResult = dsDBFFulfillment.Tables[0].Rows.Remove(("HcnID='" + dsDBFFulfillment["HcnID"] ));
I am trying to display rows which are returned from several stored procedues and then stored in dataset tables.
When I loop through the tables/rows/columns collections no data is displayed.
Here is my code :
[Code]....
And I am viewing the dataset with this code:
[Code]....
I am getting no error message and there should be data returned becaue I can execute the SPROCS through the VS serve explorer without a problem.
i have a strange error creaping into my web app but am unsure as to how to fix it. When i run this code on my debug workstation it works fine but when i transfer it to my server things seam to go wrong.
dev station (windows 7) + VS2010
regional and language settings all set to uk
server (windows 2008r2)
regional and language settings all set to uk
What seams to be happening is that when converting a string to a double it works correctly on the dev environment but moves the decimal place to the end on the server.
example code(vb)
dim lat as string = "52.983829"
dim long as string = "-0.036500"
dim latint as double = lat
dim longint as double = long
now on the dev server the value of latint is 52.983829 as you might expect but on when published to the server it becomes 52983829.0 the same with longint on the dev staion it is -0.036500 but on the server it becomes -36500.0 i get equally confusing problems if i try to change it to an integer instead.
I got "DataRow[] rows " and I want to insert into "DataTable tb " not using loop.
Is there any single statement to insert/add all rows at a time.
which part when wrong if my code is wrong ? I'm using VS2010 have a dataset. Here is my code. [Code]....
View 4 RepliesI work on C# .My input file look likes :
d00 d04 WinMain
d00 d04 lpCmdLine: '/UNREGSERVER'
d00 d04 Run
d00 d04
lpCmdLine: '/UNREGSERVER'
d00 d04 nCmdShow: 10
d00 d04 leaving WinMain
[code]....
If i use the multi delimited than error shows.How to use the multi delimited.If i run the code to to load the text file given in above show the bellow error
Input array is longer than the number of columns in this table.
using vb.net 2005.
I'm trying to a byte array column to a table but getting an exception:
<error>
datatype argument cannot be null
</error>
The code I have is:
[Code]....
Does anyone know the correct syntax for this?