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?
View 9 RepliesI have a field that may or may not contain comma.
if the field contain some word and separated by comma
how can i remove specific word in the field.
e.g. the field contain --> 11,12,13
how can i remove the number 12 and remain 11,13 in the field?
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?
View 3 Replieshow to create a view in SQL server that references tables in an oracle db?
View 2 RepliesThe 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.
How to remove the unused references in form level, vb.net application and web application?
How can I use fxcop to identity undisposed objects like dataset, dataview, connection, stream...? Any one having custom rules for the same?
I wanna join all the field as a new col.
but how can i ignore the empty field because i always join the field and separate by space like the following.
select (field_1+' '+field_2+' '+field_3) as new_col from TABLEA
but if the field is empty, then there is the double space
how can i ensure all the space is one space only.
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?
View 2 RepliesI 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.
View 2 RepliesI have 6E-11,4.4E-11 values in db and I am converting it to decimal. I have C# code:
string mystring = "6E-11";
decimal myno =Decimal.Parse (mystring, System.Globalization.NumberStyles.AllowExponent);
but it still not work.
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
For example currently, the value is set with lblAmount.Text = Amount & " €"
How can i add (dynamically) superscript to the € sign?
I want to write down like 6th I want th should be in small letters
example
6th
How to write this one ?
I am using visualstudio C# with Sql server. I want to delete previous duplicate values if exists while inserting new values into the table.
View 2 RepliesI'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.
[Code]....
I want to display superscript in a label.I'll be retrieving data from backend and displaying in a label.
For ex, Label1 = 50 deg C
Label2 = 60 deg C
(Here I'm retrieving 50 deg C from back end)
I want to display deg C as superscript.How can I do it?
Is there any way to display deg in degree symbol in asp.net and superscript it too?
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
how can i only display the name columne once in the repeater, when more than 1, then hidden the label
now my table are:
name col. age
mary 11
mary 16
Sam 18
now i would like to hidden the duplicate name as below:
name col age
mary 11
16
Sam 18
how can i manage the datatable to prevent duplicate name to bind to repeater.
[Code].....
and user3 duplicate more time as the table can i remove duplicate data
How do we remove either DataSource or DataSourceID from FormView2?
Code behind reads:
[Code]....
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.
I have one requirement i.e i wanted to replace or remove all the special characters except alphanumeric in the column value
how to do ....
whats wrong with this SQL.
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
View 2 RepliesI want regex operation for removing style tags,css,scripts and html tags from html to plain text in asp.net c#...
View 1 Replies