Updating a datagridview with the value selected in a combo box - Visual Basic Discussion Boards

Re: VB/ASP problem - HTML strings in ASP

nlarson114-Oct-07 7:45

nlarson11

4-Oct-07 7:45

server.htmlencode

Re: VB/ASP problem - HTML strings in ASP

Dmitry Khudorozhkov4-Oct-07 7:55

Dmitry Khudorozhkov

4-Oct-07 7:55

server.htmlencode is a .NET method; is there a way to make it in a ordinary (non-.NET) VB and ASP?

-------------------------
Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Re: VB/ASP problem - HTML strings in ASP

nlarson114-Oct-07 8:00

nlarson11

4-Oct-07 8:00

check again. server.HTMLEncode exists in ASP.

Re: VB/ASP problem - HTML strings in ASP

Dmitry Khudorozhkov4-Oct-07 8:05

Dmitry Khudorozhkov

4-Oct-07 8:05

Oops! Thanks a lot.

BTW, is there a server.HTMLDecode method?

-------------------------
Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Re: VB/ASP problem - HTML strings in ASP

nlarson114-Oct-07 8:11

nlarson11

4-Oct-07 8:11

No problem.

No there isn't such a function.

report generation using dataenvironment

devendra20uk4-Oct-07 2:48

devendra20uk

4-Oct-07 2:48

i am generating report using dataenvironment in VB using ODBC -oracle database server.
The report contains some 25 columns ,VB reports an error that "Report width is larger than the page size"
how to fix this problem.

Re: report generation using dataenvironment

mhaneefa4-Oct-07 9:45

mhaneefa

4-Oct-07 9:45

align the page setup and do not allow any entry in adviced page layout, if there is any entry, remove it. It will work

Updating a datagridview with the value selected in a combo box

Mr Oizo4-Oct-07 2:27

Mr Oizo

4-Oct-07 2:27

Hi. I have a form with various textboxes, comboboxes and a datagridview. The datagridview and textboxes are bound to the same datasource and if i enter information into either the textboxes or the datagridview the information is updated to the database correctly. The datatable that they are bound to is called "song". the problem I have is that I want the user to only be allowed to select specific "genres" that are stored in a "genre" table. so i want the combobox to display the values from this "genre" table and when he selects a value the datagridview "genre" field is updated for the "song" table. then later on i want the user to be able to select a genre(on a different form) and all songs per genre are listed. can anyone help me with this? Simple solution? thanks in advance

Mr Oizo

To remove xmlns value from Xml file

Sam.M4-Oct-07 1:39

Sam.M

4-Oct-07 1:39

Hi there,

Through coding i'm creating a xml file. In this manually i'm creating some node eg: "<Field>". Now what's happening is, it's automatically creating xmlns value as: "<Field xmlns="">". But i don't want that. Please help me.
How to remove xmlns value. I don't want that.

Regards n Thks

Sam.M

Re: To remove xmlns value from Xml file

Dave Kreskowiak4-Oct-07 4:08

Dave Kreskowiak

4-Oct-07 4:08

Well, that would depend entirely on how you're generating this XML file. Without seeing the code, it's impossible to tell you how to do it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: To remove xmlns value from Xml file

richardw484-Oct-07 5:00

richardw48

4-Oct-07 5:00

In vb.net I use the following:

Dim ns As New XmlSerializerNamespaces
ns.Add("", "")
'empty strings required to prevent default namespace declarations appearing in xml file

Re: To remove xmlns value from Xml file

ALI_SHAH9-Dec-09 5:31

ALI_SHAH

9-Dec-09 5:31

Hi All,

I saw various option in this thrade and come to solve my own solution for remove xmlns attribute in xml. This is working properly and no any issue with this--->

'Remove the Equifax / Transunian / Experian root node attribute that have xmlns and load xml without xmlns attributes.

If objXMLDom.DocumentElement.NamespaceURI <> String.Empty Then

objXMLDom.LoadXml(objXMLDom.OuterXml.Replace(objXMLDom.DocumentElement.NamespaceURI, ""))

objXMLDom.DocumentElement.RemoveAllAttributes() ResponseXML = objXMLDom.OuterXml

End If

Therefor no need to do any thing else to remove xmlns from xml Thumbs Up | :thumbsup:

Current path of the crystal report,

ShuklaGirish4-Oct-07 0:41

ShuklaGirish

4-Oct-07 0:41

hi,i have created one project its working fine on my machine but when it is installed on some other machine it gives the error Loading report failed because i am loading my reports dynamically through code and i have specified the address of local machine(i.e. d drive).Tell me how te get the path of report file so that i dont have to specify the path manually.

Thanx.

GIRISH

Re: Current path of the crystal report,

ChandraRam4-Oct-07 1:07

ChandraRam

4-Oct-07 1:07

ShuklaGirish wrote:
hi,i have created one project its working fine on my machine but when it is installed on some other machine it gives the error Loading report failed because i am loading my reports dynamically through code and i have specified the address of local machine(i.e. d drive).Tell me how te get the path of report file so that i dont have to specify the path manually.

Thanx.

GIRISH

Maybe you can try specifying the path of the report as relative to where your application is?

Re: Current path of the crystal report,

Dave Kreskowiak4-Oct-07 4:07

Dave Kreskowiak

4-Oct-07 4:07

Depending on where your report is stored relative to your app's .EXE file, you might want to start with something like this:

Dim appPath As String = Application.StartupPath
Dim reportPath As String = Path.Combine(appPath, "somereport.rpt")

' Load your report from the path in "reportPath".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

line continuation character

MissionSuccess4-Oct-07 0:25

MissionSuccess

4-Oct-07 0:25

sorry sir
but i cannot find any forum for vb6.0 here...

plz suggest some remedy for my problem...

how to use the line continuation character in vb6.0 when u r going to write a update query in a string which goes more than 1024 characters(max allowed.)

ex.

strsql="update table set fld1='" & txt1 & "', _
fld2='" & txt2 & "' where id='" & myId & "'"

this gives me the error "end of statement expected...."

plz give me the exact syntax....

Re: line continuation character

Christian Graus4-Oct-07 1:08

Christian Graus

4-Oct-07 1:08

I think the _ needs to be the last character. You can't just put & at the end ? Wow - VB6 really sucks...

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: line continuation character

ChandraRam4-Oct-07 1:15

ChandraRam

4-Oct-07 1:15

MissionSuccess wrote:
how to use the line continuation character in vb6.0 when u r going to write a update query in a string which goes more than 1024 characters(max allowed.)

ex.

strsql="update table set fld1='" & txt1 & "', _
fld2='" & txt2 & "' where id='" & myId & "'"

Probably better to split into two Update queries...

Re: line continuation character

C1AllenS4-Oct-07 1:16

C1AllenS

4-Oct-07 1:16

Hello,

You need to use the following code syntax.

strsql = "update table set fld1='" & txt1 & _<br />
 "' fld2='" & txt2 & "' where id='" & myId & "'"

I hope this helps.

Regards,
Allen

Allen Smith

Software Engineer
ComponentOne LLC
www.componentone.com

Re: line continuation character

Dave Kreskowiak4-Oct-07 4:05

Dave Kreskowiak

4-Oct-07 4:05

You might want to read this[^] article and convert this to a parameterized query. Any user can screw this statement up just by entering a "'" character into one of your textboxes that you blindly throw into your SQL statement.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Looping controls inside of a form

Benny_Lava3-Oct-07 23:36

Benny_Lava

3-Oct-07 23:36

Hi,

I have 60 checkboxes on a form inside a split container.
I need to check the ckeck state of those checkboxes and writethe checkstate in array

I tried with the following code:

For Each grp As Control In Me.Controls
If TypeOf grp Is SplitContainer Then
For Each chk As Control In grp.Controls
If TypeOf chk Is CheckBox Then
If DirectCast(chk, CheckBox).Checked = True Then
timeSpaceArray(i) = 1
i += i
ElseIf DirectCast(chk, CheckBox).Checked = False Then
timeSpaceArray(i) = 0
i += i
End If

End If
Next
End If
Next

but it doesn't work i get all zeros in the array.

Any help greatly appreciated
thanks

Re: Looping controls inside of a form

Christian Graus3-Oct-07 23:46

Christian Graus

3-Oct-07 23:46

unix_master01 wrote:
i += i

surely you want to increment by 1 ? Have you bothered trying to step through this ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Looping controls inside of a form

Dave Kreskowiak4-Oct-07 4:02

Dave Kreskowiak

4-Oct-07 4:02

Have you tried stepping through the code line by line to what what's it doing?? What value does i get to?? Do the grp and chk enumerations return all the controls you expect?? Probably not.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Datagrid Cell

nitin33-Oct-07 23:28

nitin3

3-Oct-07 23:28

how to change fore color of a cell in datagrid control at runtime. i want to change the cell color depending on a value entered in another textbox.

Thanks & Regards

Re: Datagrid Cell

Parwej Ahamad3-Oct-07 23:37

Parwej Ahamad

3-Oct-07 23:37

Get that Cell and set Fore Color.
Or something other ?

Parwej Ahamad
g.parwez@gmail.com

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