DataSource Controls :: Remove A Bunch Of Exponent Superscript References From A Html Field?
May 7, 2010
I dont know if this is possible or not, but I have a column that I need to remove a bunch of exponent superscript references from a html field (and leave the rest). Does anyone know how to do this with SQL?
I have a web application that dynamically loads assemblies based on database configuration entries to perform certain actions (dynamic plugin style architecture).The calls to the objects are in a Factory Pattern implementation, and the object is cached (in a static dictionary<> within the Factory) as the calls can be made many thousands of times in a minute.The calls to this factory are made from both the main web application and a number of webservices, some in different assemblies/projects.When I need to update one of these DLLs, I have to recycle IIS to get the DLL released.As this has an impact on another application on the server, I wanted to know if there was a way I could release the DLL without restarting IIS?
The following seems reasonable, but it returns an error:
<asp:Repeater ID="RepeaterF" runat="server" DataSourceID="DSF" > <ItemTemplate> <% If Eval("Item_Batch") = 0 Then %><tr><td></td><td colspan="2"></td><td></td></tr><% Else %>........
Error: "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."
I am finding it difficult to accept that the whole Repeater approach has any benefits over just creating a loop in code, iterating through a recordset, and building a html table into a variable, then dumping it to the page. This repeater is spawning pages of code and objects, and surely this is all using up server resources.
I have a 20 to 30 fields on a form. Most of them are optional. However, the users can fill out what they want. If a user dosen't fill in a field when data is sent to the database it's sent as blank, instead of NULL. Is there a way I can generically say "for all textboxes if Equals("") then DBNull.Value". Without going through each and every textbox?
I am using Reporting Services to render a report directly to PDF. It requires that I use two web references: ReportExecution2005.asmx and ReportService2005.asmx. The performance on web references seems really poor. Since my web server (IIS7) and my SQL Server (2008) are on the same box, is there a way I can reference them directly? If not is there any way I can explicitly cache them or something. First load is really really slow, second load is perfectly acceptable.
how can i find the value in the field which contain "," and remove it in sql e.g:
the field is: 11,12,13 how can i find 12 and remove it becomes=> 11,13 if the field is 12,13,14==> 13,14 if the field is 9,10,11,12 ==> 9,10,11 if the field is 12 only ,then result is empty
I'm trying to remove extraneous characters like quotes, commas, etc from my dataset. I get the fact in the standard way of doing things in your code behind you simply go
string data = data.replace(",",""); or something like this. However, a datasource doesn't seem to give me that capability. What can I do to make it do this? I'm importing data from an excel sheet into a gridview. The commas are goofing up my view. I'd like to replace any commas in the dataset with spaces. Here is the code I have.
removing duplicate rows from datatable or (dataset) by columnd ID (unique). Below function is working but I would like to edit/adjust the remaing (former) duplicate row's value, not the ID value btw.
Example:
ID name sport ------------------------------- 356 John Football 357 Johny Hockey 357 Johny Hockey 358 mike Soccer
should be:
ID name sport -------------------------------------------------------------- 356 John Football 357 Johny newFoo Hockey 358 mike Soccer
Public Function RemoveDuplicateRows(ByVal dTable As DataTable, ByVal colName As String) As DataTable
Dim hTable As New Hashtable() Dim duplicateList As New ArrayList() For Each drow__1 As DataRow In dTable.Rows If hTable.Contains(drow__1(colName)) Then duplicateList.Add(drow__1) Else hTable.Add(drow__1(colName), String.Empty) End If Next For Each dRow__2 As DataRow In duplicateList dTable.Rows.Remove(dRow__2) Next Return dTable End Function
I have a Document name column with varbinary(max) type column in my table
first time when i upload document i am storing doc as a byte array
Dim fs As Stream = Me.fileupload1.PostedFile.InputStream Dim br As New BinaryReader(fs) Dim bytes As Byte() = br.ReadBytes(fs.Length)
in my application i have remove atttachmentDoc button, i want to remove uploaded doc from db
so when i pass like this to my storedprocedue
Dim obj As New cls1 Dim bData() As Byte = New Byte(0) {} bData=nothing With obj Dim dt As DataTable = Read_Doc() If dt.Rows.Count > 0 Then If Not IsDBNull(dt.Rows(0)("Document")) Then .Document = bData .Document_extension = "" .Remove_Attachment(Me.Selected_ID) End If End If End With
i got error
dbAccess.executeQuery: Procedure or function 'SP_DML1' expects parameter '@Document', which was not supplied.
select a.Del_Date,a.Deliverables, b.Cost_Code, c.UserName, c.Email from mtblDeliverables a join mtblContract_New b on a.Cost_Code = b.Cost_Code Join mtblUser c on b.Proj_Lead = c.UserName where a.Del_Date = DateAdd(dAY, 10, GetDate ());
This will show me all records which has a Del_Date = GetDate()+10 days.My data in the SQL is stored in datetime format.When i execute this, no records are shown. Is this because of the time part in the GetDate(). how to remove the timepart in the GetDate ().
I am using ssrs 2005 .My text field contains the following data As follow : Database is as:i am getting value as :Total Population (in 1000s)but in ssrs it is displaying as like this : (Total Population (in 1000sBut i want as like in Database.Please let me know what is to be done at the earliest