Search results for query: *

Is there a way to email a file to someone w/in windows forms. the user would not input anything; just click a button so the To: & From: would be inputted already

I want to be able to find which date is older between two rows w/ the same data.. Except the date(s).. One should be odler than the other and I want to be able to delete the one that is older... I'm not sure of a date function to do that...

HERE IS MY INSERT STATEMENT INSERT INTO Tbl_Temp_CDR(Bill_Duration) SELECT TmpEgress.Egress_Seconds FROM TmpEgress, Tbl_Temp_CDR T1 WHERE TmpEgress.Pkey = T1.CDR_Seq_Key HERE IS THE ERROR Server: Msg 515, Level 16, State 2, Line 1 Cannot insert the value NULL into column 'CDR_Seq_Key'...

I'm looking to find gaps in sequences.. Ie. DATA ID 1 2 3 4 6 7 8 9 A I have 10 lines, w/ the number 5 missing, so I want to find which is missing then replace the A w/ the missing number. Else Delete the A... Any Ideas??? THANKS ahead of time

This is just a general issue/question, I have a statement w/ 3 (ORDER BY) Ie. ORDER BY A ASC, B ASC, C ASC And it is not sorting correctly... the first several rows are fine, the rest aren't. could the sort be wrong due to Datatype(s), if so how? and if not.. Is there a way around this?? THANKS

Is there a way to take a table w/ ie. (225,000,000) lines in it and split into 1125 files of 200,000 lines and BCP those out into csv files???

I have a table that looks like this: RANGE Directories 5136451 ABC 51364522 ABC 5136453 XYZ 5136454 ABC 5136455 XYZ 5136456 CDE 5136457 ABC 5136458 ABC 5136459 XYZ 51364511 CDE 51364512 ABC 51364513 ABC 51364514 ABC 51364515 ABC 51364516 ABC...

I was trying to use a Temp Table w/ all of my product IDs, to cycle thru two other tables and merge them. However, I'm getting there is more than one value, this statement is terminated..This is due to the other two tables have several (millions) of the same ID... IS there a way around this? So...

Is there a way around deploying a .net application and running the .exe w/o having to install the .net framework???

I am doing an insert into a table and before/after I do the insert I want to run a delet on any dupes there might be in the table.. here is what i have DELETE FROM ANI WHERE ANIID <= ( SELECT MAX(ANIID) FROM ANI WHERE ANI = ANI ) AND ANI = ANI any help would be AWESOME

When I have null values in my SqlTable, they pull through the system w/ values. Ie. dates will be 1/1/1900 currency will be $0.00 I need to not let this happen.. how do I do that.. THANKS

I'm trying to pass a param that is used to tell how to order by.. IE. 3 records ITEM TYPE Item1 P Item2 W Item3 S Ok, the user puts in Items w/ P so the sort order/OrderBy would put the P's first then the S's or the W's Or, the user wants items of type W... So...

I have one dropdownlist, 2 buttons.. the DDL is on autopostack (so that when a user selects an item; that item is saved as a variable then they are redirected to another page) however, when they go back (ie. backbutton) and try to click one of the buttons they still go to the previous page, not...

I have a datagrid w/ datestimes, some of which are null... Is there a way that I can have it so when I load/update/delete that the null values appear null and not w/ 1/1/1900???

My datagrid isn't updating the right value . I type the value into the record and hit update, and instead of updating the record w/ the value I put in the TxtBx it will update w/ the value from the last record in the datagrid. Ie. it's updating the right record, but w/ the value from the last...

Is there a way to place a session variable inside a hyperlink. Ie. I have a datagrid w/ a hyperlink col. when they click on it; I would like that value to be stored as a session v. I have set them as a request item, but would rather it be a session...

I am using a dataadapter, stored procedure.. I had it updating correctly, but now it's not... I changed it over from being a dynamic Datagrid to using a DS/DA/Connection thru the design instead of at runtime. But my update will still be at runtime since it uses another Stored Procedure to update...

I have a page w/ a Data grid and some other random controls(txtboxes, labels, usercontrol) Well I have two buttons 1. print 2. export to excel and I'm getting the following error Also, it's stating that the txtdueDate is outside of the form tag, but it isn't and is part of my Datagrid...

I have a page w/ a Data grid and some other random controls(txtboxes, labels, usercontrol) Well I have two buttons 1. print 2. export to excel and I'm getting the following error Control 'Dg__ctl2_txtDueDate' of type 'TextBox' must be placed inside a form tag with runat=server...

Below is my code, however it's not finding the value If e.Item.ItemType = ListItemType.Item Or _ e.Item.ItemType = ListItemType.AlternatingItem Then AdventVal += Convert.ToSingle(DataBinder.Eval(e.Item.DataItem, "MVValue")) ElseIf e.Item.ItemType =...