Re: need urgent help how to synchronize web & windows database. Please help - ASP.NET Discussion Boards

prabhat kumar mokama9-Jun-09 23:12

9-Jun-09 23:12

m devloping a search engine like google in asp.net . i have a textbox when i enter a sentece in text box . it is diffrenciated in many keys . i want this key in bold letter.

my code is.

Imports System.Data
Imports Oracle.DataAccess.Client
Partial Class Search_files
Inherits System.Web.UI.Page
Dim con As New OracleConnection(ConfigurationManager.ConnectionStrings("constr1").ConnectionString)
Dim cmd As New OracleCommand
Dim da As New OracleDataAdapter
Dim ds As New DataSet
Dim dr As OracleDataReader
Dim fileNamePart(20) As String
Dim filterfilename As New ArrayList()
Dim filenameLen, i, j, index, indexarr, count As Integer
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If txtfiledesc.Text <> "" Then
filenameLen = txtfiledesc.Text.Length
indexarr = 0
j = 0
count = 0
For i = 0 To filenameLen - 1
count = count + 1
If Asc(txtfiledesc.Text.Chars(i)) = 32 Then
For index = indexarr To indexarr
fileNamePart(indexarr) = txtfiledesc.Text.Substring(j, count - 1)
Next
indexarr = indexarr + 1
j = i + 1
count = 0
End If
Next
fileNamePart(indexarr) = txtfiledesc.Text.Substring(j, count)

' Dim jim As Integer = fileNamePart.Length
Label1.Text = ""
Dim filterarr, filterarr1 As Integer
For filterarr = 0 To indexarr
If fileNamePart(filterarr).ToString.ToLower = "the" Or fileNamePart(filterarr).ToString.ToLower = "be" Or fileNamePart(filterarr).ToString.ToLower = "is" Or fileNamePart(filterarr).ToString.ToLower = "an" Or fileNamePart(filterarr).ToString.ToLower = "a" Or fileNamePart(filterarr).ToString.ToLower = "are" Or fileNamePart(filterarr).ToString.ToLower = "of" Or fileNamePart(filterarr).ToString.ToLower = "for" Or fileNamePart(filterarr).ToString.ToLower = "in" Or fileNamePart(filterarr).ToString.ToLower = "on" Or fileNamePart(filterarr).ToString.ToLower = "at" Or fileNamePart(filterarr).ToString.ToLower = "to" Or fileNamePart(filterarr).ToString.ToLower = "shall" Or fileNamePart(filterarr).ToString.ToLower = "will" Then
' fileNamePart(filterarr) = fileNamePart(filterarr + 1)
For filterarr1 = filterarr To indexarr - 1
fileNamePart(filterarr1) = fileNamePart(filterarr1 + 1)
Next
fileNamePart(filterarr1 + 1) = Nothing
' ReDim Preserve fileNamePart(fileNamePart.Length - 1)
filterarr = filterarr - 1
End If
Next
Dim ind1 As Integer
For ind1 = 0 To 10
If (fileNamePart(ind1) <> fileNamePart(ind1 + 1)) And (fileNamePart(ind1) <> Nothing) Then
filterfilename.Add(fileNamePart(ind1))
End If
Next
'fileNamePart = DirectCast(Resize(fileNamePart, 5), String())
Dim z As Integer = 0
While z < filterfilename.Count
Label1.Text = Label1.Text & " || " & filterfilename.Item(z) ' fileNamePart(0)
z = z + 1
End While
popdata()
Else
Dim scrpt As String = "<script language='javascript'>window.alert('Plz Insert A Data To Search');</script>"
ScriptManager.RegisterClientScriptBlock(Me.Page, GetType(String), "showsuccess", scrpt, False)
End If
End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

End Sub
Public Sub popdata()
If con.State <> ConnectionState.Open Then
con.Open()
End If
cmd.Connection = con
If filterfilename.Count = 1 Then
cmd.CommandText = "select KM_SRL,KM_SRL_DESC,KM_ATTACHMENT_REF,KM_AUTHOR,KMLVL,LVLDESC from hrm.KM_REPOSITORY_VIEW where STATUS='LIV' and KM_SRL_DESC LIKE '%" & filterfilename.Item(0).ToString() & "%'"
ElseIf filterfilename.Count = 2 Then
cmd.CommandText = "select KM_SRL,KM_SRL_DESC,KM_ATTACHMENT_REF,KM_AUTHOR,KMLVL,LVLDESC from hrm.KM_REPOSITORY_VIEW where STATUS='LIV' and KM_SRL_DESC LIKE '%" & filterfilename.Item(0).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(1).ToString() & "%'"
ElseIf filterfilename.Count = 3 Then
cmd.CommandText = "select KM_SRL,KM_SRL_DESC,KM_ATTACHMENT_REF,KM_AUTHOR,KMLVL,LVLDESC from hrm.KM_REPOSITORY_VIEW where STATUS='LIV' and KM_SRL_DESC LIKE '%" & filterfilename.Item(0).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(1).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(2).ToString() & "%'"
ElseIf filterfilename.Count = 4 Then
cmd.CommandText = "select KM_SRL,KM_SRL_DESC,KM_ATTACHMENT_REF,KM_AUTHOR,KMLVL,LVLDESC from hrm.KM_REPOSITORY_VIEW where STATUS='LIV' and KM_SRL_DESC LIKE '%" & filterfilename.Item(0).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(1).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(2).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(3).ToString() & "%'"
ElseIf filterfilename.Count = 5 Then
cmd.CommandText = "select KM_SRL,KM_SRL_DESC,KM_ATTACHMENT_REF,KM_AUTHOR,KMLVL,LVLDESC from hrm.KM_REPOSITORY_VIEW where STATUS='LIV' and KM_SRL_DESC LIKE '%" & filterfilename.Item(0).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(1).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(2).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(3).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(4).ToString() & "%'"
ElseIf filterfilename.Count = 6 Then
cmd.CommandText = "select KM_SRL,KM_SRL_DESC,KM_ATTACHMENT_REF,KM_AUTHOR,KMLVL,LVLDESC from hrm.KM_REPOSITORY_VIEW where STATUS='LIV' and KM_SRL_DESC LIKE '%" & filterfilename.Item(0).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(1).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(2).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(3).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(4).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(5).ToString() & "%'"
ElseIf filterfilename.Count = 7 Then
cmd.CommandText = "select KM_SRL,KM_SRL_DESC,KM_ATTACHMENT_REF,KM_AUTHOR,KMLVL,LVLDESC from hrm.KM_REPOSITORY_VIEW where STATUS='LIV' and KM_SRL_DESC LIKE '%" & filterfilename.Item(0).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(1).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(2).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(3).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(4).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(5).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(6).ToString() & "%'"
ElseIf filterfilename.Count = 8 Then
cmd.CommandText = "select KM_SRL,KM_SRL_DESC,KM_ATTACHMENT_REF,KM_AUTHOR,KMLVL,LVLDESC from hrm.KM_REPOSITORY_VIEW where STATUS='LIV' and KM_SRL_DESC LIKE '%" & filterfilename.Item(0).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(1).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(2).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(3).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(4).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(5).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(6).ToString() & "%' or KM_SRL_DESC LIKE '%" & filterfilename.Item(7).ToString() & "%'"
Else
Dim scrpt As String = "<script language='javascript'>window.alert('Plz give more appropriate sentencse or word');</script>"
ScriptManager.RegisterClientScriptBlock(Me.Page, GetType(String), "showsuccess", scrpt, False)
Exit Sub
End If
da.SelectCommand = cmd
da.Fill(ds, "tab1")
GridView1.DataSource = ds.Tables("tab1")
GridView1.DataBind()
If con.State <> ConnectionState.Closed Then
con.Close()
End If
End Sub
End Class

Re: keyword show in bold later

prabhat kumar mokama9-Jun-09 23:09

prabhat kumar mokama

9-Jun-09 23:09

i m devloping a search engine like google in asp.net . i have a textbox when i enter a sentece in text box . it is diffrenciated in many keys . i want this key in bold letter.

need urgent help how to synchronize web & windows database. Please help

Yajjoj9-Jun-09 22:31

Yajjoj

9-Jun-09 22:31

I have a task that i have to synchronize/update both my web(asp.net & SQL 2005) and windows application databases(VB.net & SQL 2005).

My scenario is my web app. and windows app. both accept reservations. I want any reservation happen to my web or windows app will reflect to both databases(online & local) at the same time.

Please help me.
WTF
Thanks.

al hajjaj

Re: need urgent help how to synchronize web & windows database. Please help

N a v a n e e t h9-Jun-09 22:41

N a v a n e e t h

9-Jun-09 22:41

brine_fury wrote:
I want any reservation happen to my web or windows app will reflect to both databases(online & local) at the same time.

That's not possible. How the server database can communicate with your local one? Why don't your windows application connect to online database, pull all missing records and update the local database?

brine_fury wrote:
WTF

Do you mean this[^] Poke tongue | ;-P

Navaneeth

How to use google | Ask smart questions

Re: need urgent help how to synchronize web & windows database. Please help

Manas Bhardwaj9-Jun-09 22:42

Manas Bhardwaj

9-Jun-09 22:42

You dont actually need two databases.
Write a web service(data access layer) which talks to a single database.
Use this web wervice in both web and windows to perform the actions.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: need urgent help how to synchronize web & windows database. Please help

Abhijit Jana9-Jun-09 22:48

Abhijit Jana

9-Jun-09 22:48

Yup. I am agree with your view.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: need urgent help how to synchronize web & windows database. Please help

Baran M9-Jun-09 22:54

Baran M

9-Jun-09 22:54

ya If we split the logical layers then we can do that easily. Web service is an ultimate solution. Smile | :)

Re: need urgent help how to synchronize web & windows database. Please help

samMaster10-Jun-09 1:03

samMaster

10-Jun-09 1:03

Web service is an ultimate solution but if you think this way is not possible you can move just the reservations table on web service and you can synchronize other tables at a specific time. On this way you have enough time to convert all your database to web service. Good luck!

nested gridview [modified]

vikas shukla9-Jun-09 22:24

vikas shukla

9-Jun-09 22:24

hi sir
i am using nested gridview for some specific purpose.so i have expand/collapse sign for see and hide the child gridview.
but sir now i do not want expand sign for all rows.means for some rows child gridview has not any information.so i want hide that expand picture for that row.

', 'one','<%#Eval("status") %>');">

" alt="Click to show/hide StatusDetail <%# Eval("Item_Code") %>" width="9px" border="0" src="images/plus.gif"/>

please help me.
thanx

sir your suggestion was good but now i am facing following error after adding runat="server"
"The server tag is not well formed."?
please guide me.

modified on Thursday, June 11, 2009 1:45 AM

Re: nested gridview

N a v a n e e t h9-Jun-09 22:33

N a v a n e e t h

9-Jun-09 22:33

Make the expand image runat=server. You can use FindControl() method to find this image and toggle it's visibility depending on your condition.

Smile | :)

Navaneeth

How to use google | Ask smart questions

how to retrieve data from a website.

jainiraj9-Jun-09 21:54

jainiraj

9-Jun-09 21:54

here is a link.....

http://www.moneycontrol.com/stocks/marketstats/mostactive.php?optex=NSE&index=31&opttopic=mostactive[^]

How can i retrieve this table or data from table in the given link......
plz help me......
thanks in advance....

Re: how to retrieve data from a website.

Christian Graus9-Jun-09 22:13

Christian Graus

9-Jun-09 22:13

How is this an ASP.NET question ?

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: how to retrieve data from a website.

Abhijit Jana9-Jun-09 22:30

Abhijit Jana

9-Jun-09 22:30

Check if they provide the RSS for the information then read content from RSS or you can read the content from page directly.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: how to retrieve data from a website.

David Mujica11-Jun-09 4:44

David Mujica

11-Jun-09 4:44

Check this article out:
http://www.west-wind.com/presentations/dotnetWebRequest/dotnetWebRequest.htm[^]

I created a test ASP.net web page with a button on it and used the following code to retrieve to the web page you wanted. what you would have to do is parse through the string, "lcHtml", which contains the table data.

Good luck.

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

       Dim myURL As String = "http://www.moneycontrol.com/stocks/marketstats/mostactive.php?optex=NSE&index=31&opttopic=mostactive"

       ' *** Establish the request

       Dim loHttp As HttpWebRequest


       loHttp = WebRequest.Create(myURL)

       ' *** Set properties

       loHttp.Timeout = 10000     ' 10 secs
       loHttp.UserAgent = "Code Sample Web Client"

       ' *** Retrieve request info headers

       Dim loWebResponse As HttpWebResponse
       loWebResponse = loHttp.GetResponse()

       Dim enc As Encoding

       enc = Encoding.GetEncoding(1252)  ' Windows default Code Page

       Dim loResponseStream As New StreamReader(loWebResponse.GetResponseStream(), enc)

       Dim lcHtml As String

       lcHtml = loResponseStream.ReadToEnd()

       loWebResponse.Close()

       loResponseStream.Close()

       Response.Write(lcHtml)

       'System.Diagnostics.Debug.WriteLine(lcHtml)


   End Sub

Re: how to retrieve data from a website.

AftabR7-Jul-09 21:48

AftabR

7-Jul-09 21:48

very good..bosss........

i am having 6 months of experience in asp.net what i want is to display only the matter in the table where share and their respective prices have been declared....can you please assist with this...

thanks again...

Re: how to retrieve data from a website.

David Mujica8-Jul-09 3:25

David Mujica

8-Jul-09 3:25

This guy seems to already have a method for parsing through a website ...

Check his posting out.

http://www.codeproject.com/Messages/3111655/Need-to-capture-raw-HTML-of-any-page-displayed-on-browser-and-write-to-file.aspx[^]

Re: how to retrieve data from a website.

AftabR8-Jul-09 4:49

AftabR

8-Jul-09 4:49

David,

What I want is the code to retrieve that specific table in either excel format or in txt format on to my local computer. Can you assist with that code please??????

Re: how to retrieve data from a website.

David Mujica8-Jul-09 6:25

David Mujica

8-Jul-09 6:25

At this time, I have no time to work on such a project. I'm busy at work and home. I find this project interesting, so I may work on it for my own knowledge, but I can't guarantee any timeframe for completion.

Re: how to retrieve data from a website.

AftabR8-Jul-09 7:43

AftabR

8-Jul-09 7:43

Thanks you...
i will eagerly wait for your post....

Unble to write files to a folder in ASP.NET application.

NN219-Jun-09 21:42

NN21

9-Jun-09 21:42

Hi All,

I am having one ASP.NET application in which I m trying to write multiple files in folder (C:\Inetpub\wwwroot\Test\MyData\reports). I am failed to write files in folder if I omit the write permission to Everyone.

I do not want to give Everyone permission due to security reasons. I am using windows XP and IIS 5.1 but my client can use different os such as Windows 2000, 20003 etc and different IIS 5.x or 6.0. So I need a solution which will work on all the platforms.

I tried to find out the correct way for achieving this but found no correct solution. Tried following things:

1. I have given Full permission to 'reports' folder for ASPNET account using security tab, but it didnt work.Same thing I tried with IIS_WPG but it is also not working.

2. I have read about impersonation but I think it is not suitable for my requirement as I do not want to give permission for a specific user and also I can not instruct the client to change user name and password in web.config.

3. One thing which worked in my case is when I given write permission to 'Users(<machinename>\Users)' group using security tab. I dont know how it worked or is it the correct solution and if yes, then will it wiork for different OS and IIS.

Thanks in advance for any help.

Regards,
NN

[Message Deleted]

rsrajiv9-Jun-09 21:35

rsrajiv

9-Jun-09 21:35

[Message Deleted]

Re: Help in .net Guestbook

Christian Graus9-Jun-09 21:38

Christian Graus

9-Jun-09 21:38

I would guess that you're getting newlines in your text, but you need to replace them with break tags if you want to render the text onto your page.

.Replace(Environment.NewLine, "<br/>"); on the string before you render it. Or before you store it.

Re: Help in .net Guestbook

rsrajiv10-Jun-09 20:08

rsrajiv

10-Jun-09 20:08

HI Christian Graus

Thanks for reply

value is not getting in dropdown after a button click

anbusenthil9-Jun-09 21:15

anbusenthil

9-Jun-09 21:15

i hav a dropdown which is binded to a table

here
i will select the text from dropdown and press a button
to save details in db

here while saving or inserting a record
i am not getting any values in dropdown which i hav selected

pls reply

tanx

Re: value is not getting in dropdown after a button click

jloubani9-Jun-09 21:18

jloubani

9-Jun-09 21:18

you have to insure the drop down property AutoPost back is true

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.