|
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
|
|
|
|
|
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 
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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".
|
|
|
|
|
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....
|
|
|
|
|
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 )
|
|
|
|
|
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...
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Get that Cell and set Fore Color.
Or something other ?
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
Parwej Ahamad wrote: Get that Cell
i am a bigginer in vb.net , i dont understand what u told. will u give me a sample code for that ? 
Thanks & Regards
|
|
|
|
|
Grid1.Rows(1).Cells(1).ForeColor = Color.Blue
or
Me.Grid1.Rows(1).Cells.Item(1).Style.ForeColor = Color.Blue
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
is this method applicable on visual studio 2003 ?
Thanks & Regards
|
|
|
|
|
|
For everyone still using the old DataGrid in 2002/2003, I highly recommend bookmarking this FAQ[^]. It's indispensible, explaining how to do about a 100 different things with the old DataGrid.
|
|
|
|
|
Hi
How Change Properties (Such as Top and Left) controls in rpt file(Crystell Report) at runtime by vb.net?
Plz help me.
Thanks
|
|
|
|
|
hi
i just wanted to ask u how can i solve the exception error "couldnot find installable ISAM"
this exception occurs when i run this code :Dim excelConnection As System.Data.OleDb.OleDbConnection = New
System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:/test.xls;Extended Properties=Excel 8.0;")
excelConnection.Open()
Dim excelCommand As New System.Data.oledb.OleDbCommand("INSERT
INTO [OBDC; Driver={SQL
Server};Server=(local);Database=FullDate;Trusted_C onnection=yes].[Population]
SELECT * FROM [Population$];", excelConnection)
'Dim ExcelCommand As New System.Data.OleDb.OleDbCommand("SELECT
INTO [ODBC;Driver={SQL
Server};Server=(local);Database=FullDate;Trusted_C onnectionÂ*=yes].[Population] FROM [Population$];", excelConnection)
excelCommand.ExecuteNonQuery()
excelConnection.Close().
ALSO i wanted to ask how can i map importing data from the excel sheet to SQL with the primary key. Can anyone give me a syntax
10x in advance
|
|
|
|
|
Is Excel installed on the machine ?
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 )
|
|
|
|
|
yes of course excel is installed of my machine,may be the problem with dll files,i dont know.
|
|
|
|
|
Try enclosing the 'Excel 8.0;' in single quotes
The error occurs when accessing extended properties in the JET engine. Google your error message for heaps of info. 
The Fanatical All Black Supporter - Kea Kaha
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
