ASP.NET

Problem in inserting "Hindi" Text in MySql5.0 using ASP.Net

10-Jun-09 1:46

<input type="button" value="Print" onclick="window.print();">

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.

mkumar251110-Jun-09 1:12

mkumar2511

10-Jun-09 1:12

Hello all,
I want to insert a Hindi text value into a mysql5.1 database from an asp.net TextBox when a "INSERT" button is clicked. And I also want to retrive the same value from MySql5.1 to an asp.net TextBox when a "SHOW" button is clicked. Please help me how this will be possible. I am uinging Visual Studio 2005 and C# for code behind.

Thanks in advance.
Confused | :confused:

Re: Problem in inserting "Hindi" Text in MySql5.0 using ASP.Net

Manas Bhardwaj10-Jun-09 1:28

Re: Problem in inserting "Hindi" Text in MySql5.0 using ASP.Net

10-Jun-09 1:28

How come it become MySQL 5.0 from 5.1 overnight Confused | :confused:

. Referring to your previous [^]post with same question.

mkumar2511 wrote:
I want to insert a Hindi text value into a mysql5.1 database

You need to use nvarchar datatype in the database.
in the web application, you need to make sure that you comply with the unicode

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.

Abhijit Jana10-Jun-09 1:36

to set theme in master pg

10-Jun-09 1:36

Manas Bhardwaj wrote:
How come it become MySQL 5.0 from 5.1 overnight Confused. Referring to your previous [^]post with same question.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

anbusenthil10-Jun-09 0:16

anbusenthil

10-Jun-09 0:16

in which event i can set theme in master page
since master pg does nt contain pre init event

Do not repost

Manas Bhardwaj10-Jun-09 1:06

Re: to set theme in master pg

10-Jun-09 1:06

This is considered rude.

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.

Manas Bhardwaj10-Jun-09 1:10

to set diff themes dynamically

10-Jun-09 1:10

You can not directly set the theme on master page. Read this[^]

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.

anbusenthil9-Jun-09 23:36

anbusenthil

9-Jun-09 23:36

how to set diff themes dynamically

Protected Sub Page_PreInit(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreInit
Page.Theme = Session("theme")
End Sub

is tis correct

Re: to set diff themes dynamically

Abhijit Jana9-Jun-09 23:45

Convert Vedio files in to FLV format in asp.net ( C# )

9-Jun-09 23:45

anbusenthil wrote:
Protected Sub Page_PreInit(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreInit
Page.Theme = Session("theme")
End Sub

is tis correct

So what are you getting after doing that? Theme is changing and runtime or not ? Smile | :)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

asbis9-Jun-09 23:32

asbis

9-Jun-09 23:32

I am trying to convert vedio file to flv using ffmpeg but it is not generating any vedio and image file. can any body help me by sending me the sample code Project.How to convert uploded vedio files into flv format

ashishbisen

Re: Convert Vedio files in to FLV format in asp.net ( C# )

saanj9-Jun-09 23:39

saanj

9-Jun-09 23:39

Checkout this thread:

http://forums.asp.net/t/1182391.aspx[^]

Regards
Saanj

Either you love IT or leave IT...

i want to populate a gridview in other page

prabhat kumar mokama9-Jun-09 23:17

Re: i want to populate a gridview in other page

9-Jun-09 23:17

hi all !!
i have developing a page which have three drop down and two text boxes and a button . when i click the button the grid view populated in another page taken data from text boxes and drop down from previous page .

Abhijit Jana9-Jun-09 23:29

Re: i want to populate a gridview in other page

9-Jun-09 23:29

prabhat kumar mokama wrote:
i have developing a page which have three drop down and two text boxes and a button . when i click the button the grid view populated in another page taken data from text boxes and drop down from previous page .

Yes Sure. You can sen the value of dropdown list and the texbox by Query String to the next page. Read the Query string value and based on that value you can retrieve the data from database and bind it with the grid view. Or you can also pass the data by Session.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

saanj9-Jun-09 23:36

saanj

9-Jun-09 23:36

You can also use hidden form fields to pass information from one page to another.

Regards
Saanj

Either you love IT or leave IT...

chk t query

anbusenthil9-Jun-09 23:16

anbusenthil

9-Jun-09 23:16

select @themeid=t.themeid,@themename=t.th_name from emptheme e left outer join themesetting t on
e.themeid=t.themeid and e.empguid=@sessionvalue

is tis query correct after joins ...
is it possible to use and join condition

tanx

Re: chk t query

Manas Bhardwaj9-Jun-09 23:19

9-Jun-09 23:19

anbusenthil wrote:
is tis query correct after joins ...

This is not database forum.

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: chk t query

Abhijit Jana9-Jun-09 23:24

keyword show in bold later

9-Jun-09 23:24

anbusenthil wrote:
select @themeid=t.themeid,@themename=t.th_name from emptheme e left outer join themesetting t on
e.themeid=t.themeid and e.empguid=@sessionvalue

is tis query correct after joins ...
is it possible to use and join condition

is tis query correct after joins ...
is it possible to use and join condition
First of all this is ASP.Net Forum and This is your repost. While asking problem regarding the same post then continue with that thread itself rather than post a new question.
I believe you are using SQL Server to run your query. So what is the output for that statement ?

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: chk t query

Paddy Boyd10-Jun-09 2:02

Paddy Boyd

10-Jun-09 2:02

anbusenthil wrote:
is tis query correct after joins ...

It depends on what you want it to show and what your data model is... How're we supposed to know. If you want to know if it's syntactically correct, why don't you run it...

prabhat kumar mokama9-Jun-09 22:54

9-Jun-09 22:54

hi ! all !!

i m doing a search application in asp.net 2.0 , when i enter a sentence in text box the related data show to me , but i want the keyword that i have enter in text box that show me in bold later,
plz help me ...........

Abhijit Jana9-Jun-09 23:03

9-Jun-09 23:03

Replaced the searched text as <b> Your Text</b> . Means, if you want to find "Your Text" and its available then just replace text with <b> Your Text </b>

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

saanj9-Jun-09 23:06

saanj

9-Jun-09 23:06

Without seeing the code, it's hard to specify how can you do it. But assuming that you are putting individual search result in a string variable and your search keyword is "Giant" (for example):

string searchResult = "Andy the Giant Killer";
searchResult = searchResult.Replace("Giant", "Giant");

Regards
Saanj

Either you love IT or leave IT...

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

prabhat kumar mokama9-Jun-09 23:09