I want to find the smallest number and avoiding the zero values,i dont no how to avoid the zero values.i am having 5 numbers
2345,16546,0,16546,0
Here I want to display only 2345 number not as 0 how?but 0 is the smallest number but i dont want to display the zero and i want to skip all the zero values and display the next smallest values.
How to find Largest number in dropdownList
View 2 RepliesI am developing a asp.net application and i am using SQL Server 2008. I took a IDENTITY column as Record_ID for detail table where i will have trillions of records per year. So just want to ask whats the largest number record id (identity) column can hold and in ASP.NET which data type i should use to handle record id as i am using this id as a reference to update the table data. I don't want to end up being trapped some day.
View 1 RepliesI have a 2D array and i want to search that array. I thought Array.Find might help but it was helping only in 1D. I dont want to use for loop or foreach as that will take some time. So is there any other shortest method to find a value in a 2D array.
[Code]....
Find the Dulicate value from the array
int[] arr=new int[13]
{
1,1,2,6,7,7,8,0,9,7,6,3,4
};
I am trying to add row in DataTable CartDT using row[], which is a string array.
DataTable CartDT = new DataTable();
public void DataTableColumn()
{
CartDT.Columns.Add("Product_Name", typeof(string));
CartDT.Columns.Add("Product_ID", typeof(string));
CartDT.Columns.Add("ItemQTY", typeof(string));
CartDT.Columns.Add("Price", typeof(string));
CartDT.Columns.Add("TotalPrice", typeof(string));
[CODE]..
Now when I execute it, it gives the error that "Input array is longer than the number of columns in this table" The array row[] has exactly 5 elements in it & also DataTable CartDT has also 5 columns. Now i am not able to find exactly where i am wrong.
what is the best way to get the number of null values in an array in C#?
View 4 RepliesI need to count number of repeating and position where they repeat of all number in multidimensional array like this:nd result need to be:Number 1- two times on position 1, one time on position 2, two times on position 3Number 2- one time on position 1, two times on position 2, one times on position 3Number 3- 0 on position 1, one time on position 2, 0 on position 3
View 2 RepliesI need to pass a random number from 1 to 100 from the client to a webservice, and then the webservice will subtract this number from the list of 100 numbers (say 1-100). Then, in the next call, the next random number will be subtracted from the rest 99 numbers and so on.
I need this to be done with AJAX. I don't know where the Array list should be held in the first place (would it be in the web service or in the code behind? ), and how this can be done?
I have written the code below to generate an XML document and it works a charm however the smallest snippet of code is causing me a major headache:
SNOMlabel.text += 1
For some reason this is doubling up and SNOMlabel equals 2 i have debugged the code on this line and it appears to be something to do with when it leaves the Sub btnSave_Click and enters and returns from CreateBookNode, CreateBookNode2, CreateBookNode3.
Code:
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnSave.Click
' Name of xml file to create
Dim subs = SubscriberID.Text
Dim name2 As String
Dim fdate As String
Dim length As Integer
length = Len(Page.User.Identity.Name)..........
Can any one let me know "How to find the number of Tables present in a XML Schema File"?
View 1 Repliesi am using timspan to find number of days between dates
protected void Page_Load(object sender, EventArgs e)
{
TextBox3.Text = DateTime.Now.ToString("dd/MM/yyyy");
}
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from rent_books where isbn='" + TextBox2.Text + "' and member_id='" + TextBox1.Text + "'",
[code]...
I want to know hom many users that uses may website (they logged in in current time)
or how many active seesions are in my site in asp.net using C# ?
I'm putting together a way to cull out bad emails from my table.
I have an email field, of course, and a 'fail' field (integer)
Each time I send out an email, I get a bunch of emails back that the email addresses were undeliverable, so I'd like to (manually), enter them all into an array (or whatever), and then run a stored procedure which updates the 'fail' field by 1
I'm looking for both on the SQL side (I have an sProc that does the deed one at a time - just need the logic to do it in a batch like this), and how to do it in the web page.....
I've a Dictionary object created in which i keep adding a key value pair.The key value pair is of type "object"The value part contains date in this format "2010-11-17T08:51:51-05:00". This dictionary object has an array of date stored in this format.Can someone out in converting this to a right date format and then find the latest date of the entire lot.
View 2 Repliesif grid view contain number then formating is07.7711.00and alingment is rightif contain date then01-25-2011 then 25-jan-2011
View 4 RepliesI'm looking for the correct syntax to get me the last row of a repeater item and use it in a literal below. As you can see I have the item index syntax already. assume that there is a repeater control surrounding the literal already.
I have already bound the data so it will not use obitemdatabound .
<asp:Literal id="Rpt_ItemCount" runat="server"
Text = '<%# (int) DataBinder.Eval(Container, ItemIndex"))%>'></asp:Literal>
I've got a nested gridview and I'm looking for a way to determine the number of rows in a child gridview, so far no luck. Has anyone come across a solution for this ? Both of these gridviews are bound using ObjectDataSource.
View 6 RepliesI have data grid with page size 15. I need to find total number of record(s) in a grid. How to do it?There is two ways to do:
1) Here I have used LINQ. So calling stored procedure again and we can done using .Count () property. But here I don't want make call to data base again.2) Creating our own logic like here I have done like:
(dtgCustomerSearch.PageCount - 1) * (dtgCustomerSearch.PageSize) + dtgCustomerSearch.Items.Count
The above result gives me correct result only when I am on last page.
I have a dataset with the following values:
NAME, NUMBER
Test3, 1
Test2, 2
Test3, 3
I am basically need the ability to do something like dataset.tables(0).row( ' here i would be like where item("NAME") = "Test2" ' ).Item("NUMBER")
I want to send email thought asp.net page for that I need to find SMTP Host and port number below is my code
Dim EMail As New MailMessage
EMail.From = New MailAddress(Emailtaxebox.Text)
EMail.[To].Add(New MailAddress("sa@gmail.com"))
EMail.Subject = Firstnametextbox.Text + lastnametextbox.Text + "Registerd"
EMail.Body = " This is content "
EMail.IsBodyHtml = True
[code]....
how to find SMTP port and host name ? I used default one its gives me error.No connection could be made because the target machine actively refused it.
For some reason the following JSON string creates the correct number of records in the custom objects array, but does NOT populate the objects in the array with and values.
[code]....
I'm trying to return the largest payment and that payments payment date and the project it was posted too, for each clientID. I can get the largest payment using the statement below, but I cannot get the payment date and project name. If the client made payment of the same amount to more than one project I get multiple client rows, but only want one row for each client.
[Code]...
I 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.
I am using TimeSpan to find the number of days between two dates. How can I not count weekends in calculating number of days?
View 3 Replies