How do I replace characters within a dataset?

Question

1.00/5 (2 votes)

See more:

Hello, I am using example code that works to display the contents of the Microsoft Index Service on our 2008 R2 File Server running iis8. Problem is, I need to use the Replace function to replace the "C:" and the "\" characters with "http://" and "/" in the path to work with the Intranet. I can't seem to figure out how to do that as I continue to get errors and knowing nothing about this language, I have been reading for days and can find nothing. I'm wishing I would have just started to learn the entire language instead of polluting my mind with all the bits and pieces. HELP PLEASE!!! Thank you in advance, Bill

Here is the VB code:

VB

Imports System.Data

Partial Class _WebForm1
    Inherits System.Web.UI.Page

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim strCatalog As String

        ' Catalog Name
        strCatalog = "IIS_Index"

        Dim strQuery As String
        strQuery = "Select DocTitle,Filename,Create,Size,Path,URL from SCOPE() where FREETEXT('" & TextBox1.Text & "')"
    Dim connString As String = "Provider=MSIDXS.1;Integrated Security .='';Data Source='" & strCatalog & "'"

        Dim cn As New System.Data.OleDb.OleDbConnection(connString)
        Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn)
        Dim testDataSet As New DataSet()

        cmd.Fill(testDataSet)

        ' Bind DataGrid to the DataSet. DataGrid is the ID for the
        ' DataGrid control in the HTML section.
        Dim source As New DataView(testDataSet.Tables(0))
        DataGrid1.DataSource = source
        DataGrid1.DataBind()
    End Sub
End Class

Here is the HTML

ASP.NET

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="search.aspx.vb" Inherits="_WebForm1"debug="true" %>

<HTML>
<HEAD>
<title>Intranet Index Services</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">

</HEAD>
<body MS_POSITIONING="GridLayout">
    <form id="Form1" method="post" runat="server">
        <asp:TextBox id="TextBox1" style="Z-INDEX: 101; LEFT: 238px; POSITION: absolute; TOP: 76px" runat="server"></asp:TextBox>
        <asp:DataGrid id="DataGrid1" style="Z-INDEX: 102; LEFT: 25px; POSITION: absolute; TOP: 145px" runat="server" AutoGenerateColumns="False">

    <Columns>
        <asp:BoundColumn DataField="DocTitle" HeaderText="DocTitle"></asp:BoundColumn>
        <asp:BoundColumn DataField="filename" HeaderText="FileName"></asp:BoundColumn>
	<asp:BoundColumn DataField="Create" HeaderText="Create"></asp:BoundColumn>
        <asp:BoundColumn DataField="size" HeaderText="Size"></asp:BoundColumn>
        <asp:BoundColumn DataField="path" HeaderText="PATH"></asp:BoundColumn>
	<asp:BoundColumn DataField="url" HeaderText="URL "></asp:BoundColumn>
    </Columns>
		</asp:DataGrid>
<asp:Button id="Button1" style="Z-INDEX: 103; LEFT: 400px; POSITION: absolute; TOP: 100px" runat="server" Text="Button"></asp:Button>
<hr style="Z-INDEX: 104; LEFT: 0px; POSITION: absolute; TOP: 140px">
</form>
</body>
</HTML>

Posted 31-Oct-14 13:47pm

bills382

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Accepted Answer · 2014-10-31T17:47:00

1. You can do the replace when you select data from your data source by writing replace sql in your select statement. but in oledb replace function not available, so you may need to implement replace using InStr() and Len() functions.

2. You can change the dataset or datatable column values by using simple for loop and change the values using string replace[^]. then bind the updated datatable to your gridview

3. you can use RowDataBound Event of your GridView and change set the cell value after replacing. check this [^] answer and modify according to your needs.

I haven't provide direct answer to your question, you need to try your self and find your own solution. in case of issue you better ask question with what you have tried and where you stuck. good luck!