Click here to Skip to main content
15,558,089 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Prevent hacking of connection string over the internet Pin
Dave Kreskowiak7-Oct-21 9:11
mveDave Kreskowiak7-Oct-21 9:11 
AnswerRe: Prevent hacking of connection string over the internet Pin
Member 153296137-Oct-21 9:11
Member 153296137-Oct-21 9:11 
GeneralRe: Prevent hacking of connection string over the internet Pin
Member 1537744010-Oct-21 8:00
Member 1537744010-Oct-21 8:00 
GeneralRe: Prevent hacking of connection string over the internet Pin
Dave Kreskowiak10-Oct-21 8:10
mveDave Kreskowiak10-Oct-21 8:10 
GeneralRe: Prevent hacking of connection string over the internet Pin
Member 1532961311-Oct-21 2:10
Member 1532961311-Oct-21 2:10 
GeneralRe: Prevent hacking of connection string over the internet Pin
Member 1537744011-Oct-21 9:22
Member 1537744011-Oct-21 9:22 
GeneralRe: Prevent hacking of connection string over the internet Pin
Member 1532961311-Oct-21 10:56
Member 1532961311-Oct-21 10:56 
QuestionHow do I read XML File and put it in Datagridview and update it back to XML File Pin
TASK Live Charts25-Sep-21 9:00
TASK Live Charts25-Sep-21 9:00 
How do I read XML File and put it in Datagridview and how do I search the content of specific text and re-update the modified the text to all lines and update it back to XML File from Datagridview ?


Here is my XML File content.

<shares>
<country name="india" exchanges="NSE,BSE">
<symbol name="Wipro Technologies" nseid="WIPRO" bseid="12371">

<yahoowatchlist name="Sharesa">
<watchlistlist>
<watchlist name="Sharesa">
<watch symbol="DLF" exchange="NSE">
<watch symbol="ICICIBANK" exchange="NSE">
<watch symbol="INFY" exchange="NSE">
<watch symbol="NSEBANK" exchange="NSE">
<watch symbol="NSEI" exchange="NSE">
<watch symbol="RELIANCE" exchange="NSE">
<watch symbol="SBIN" exchange="NSE">


<mcxdirect>

<worldstockwatchlists>
<worldstockwatchlist name="watch-1">
<stock symbol="MSFT">
<stock symbol="GOOG">
<stock symbol="AAPL">
<stock symbol="INTC">
<stock symbol="^IXIC">
<stock symbol="^GSPC">


<currentworldstockwatch name="watch-1">
<forex>
<watch symbol="USDINR=X">
<watch symbol="EURUSD=X">
<watch symbol="USDJPY=X">
<watch symbol="USDCAD=X">
<watch symbol="USDCNY=X">
<watch symbol="USDCHF=X">
<watch symbol="USDSGD=X">

<fnodirect>

<symbolmapping>
<mapping symbol="BANKNIFTY30SEP2136000CE" name="36000CE" exchange="">
<mapping symbol="BANKNIFTY30SEP2136000PE" name="36000PE" exchange="">


<ncdexdirect>

<currency>

<directlist type="COMMODITY" active="Watch-1">
<directwatch name="Watch-1">
<symbol name="ALUMINIUM-1">
<symbol name="CRUDEOIL-1">
<symbol name="GOLD-1">
<symbol name="LEAD-1">
<symbol name="NATURALGAS-1">
<symbol name="NICKEL-1">
<symbol name="SILVER-1">
<symbol name="ZINC-1">


<directlist type="FNO" active="Watch-1">
<directwatch name="Watch-1">
<symbol name="BANKNIFTY">
<symbol name="BANKNIFTY-1">
<symbol name="NIFTY-1">



<directlist type="CD" active="Watch-1">
<directwatch name="Watch-1">
<symbol name="EURINR-1">
<symbol name="GBPINR-1">
<symbol name="JPYINR-1">
<symbol name="EURUSD-1">
<symbol name="USDJPY-1">
<symbol name="USDINR-1">




<directlist type="WO" active="Watch-1">
<directwatch name="Watch-1">
<symbol name="BANKNIFTY30SEP2136000CE">
<symbol name="BANKNIFTY30SEP2136000PE">






My Question :

How do I import above XML File to Datagridview ?

And also I would like to know, how do I edit the content of any child node text and re-update it to XML for all lines?

Example :

With this reference, I need to modify the text content for the following node

<symbolmapping>
<mapping symbol="BANKNIFTY30SEP2136000CE" name="36000CE" exchange="">
<mapping symbol="BANKNIFTY30SEP2136000PE" name="36000PE" exchange="">



I need to search 30SEP21 and replace 01OCT21 it to all lines. Please suggest me how d I do this as I am new to this.
AnswerRe: How do I read XML File and put it in Datagridview and update it back to XML File Pin
CHill607-Oct-21 7:48
mveCHill607-Oct-21 7:48 
QuestionVBA Calling a Sharepoint list Rest API failed. Pin
BEN CHEN 202119-Sep-21 7:48
BEN CHEN 202119-Sep-21 7:48 
AnswerRe: VBA Calling a Sharepoint list Rest API failed. Pin
Richard Deeming19-Sep-21 22:51
mveRichard Deeming19-Sep-21 22:51 
QuestionListDirectoryDetails Pin
Drno Strz18-Sep-21 9:07
Drno Strz18-Sep-21 9:07 
AnswerRe: ListDirectoryDetails Pin
RedDk18-Sep-21 14:55
RedDk18-Sep-21 14:55 
GeneralRe: ListDirectoryDetails Pin
Drno Strz18-Sep-21 22:33
Drno Strz18-Sep-21 22:33 
GeneralRe: ListDirectoryDetails Pin
Mycroft Holmes19-Sep-21 13:10
professionalMycroft Holmes19-Sep-21 13:10 
GeneralRe: ListDirectoryDetails Pin
Dave Kreskowiak19-Sep-21 13:39
mveDave Kreskowiak19-Sep-21 13:39 
Questionbuilding an IT helpdesk tool Pin
Mustafa M. Al-Nassah8-Sep-21 11:17
Mustafa M. Al-Nassah8-Sep-21 11:17 
AnswerRe: building an IT helpdesk tool Pin
CHill6016-Sep-21 23:11
mveCHill6016-Sep-21 23:11 
QuestionVB.Net and Google docs Pin
Malcolm Bacchus6-Sep-21 4:31
Malcolm Bacchus6-Sep-21 4:31 
AnswerRe: VB.Net and Google docs Pin
Richard MacCutchan6-Sep-21 6:47
mveRichard MacCutchan6-Sep-21 6:47 
QuestionNeed help with this question Pin
Member 153482515-Sep-21 23:18
Member 153482515-Sep-21 23:18 
GeneralRe: Need help with this question Pin
Richard MacCutchan5-Sep-21 23:33
mveRichard MacCutchan5-Sep-21 23:33 
GeneralRe: Need help with this question Pin
Member 153482515-Sep-21 23:40
Member 153482515-Sep-21 23:40 
GeneralRe: Need help with this question Pin
Richard MacCutchan5-Sep-21 23:45
mveRichard MacCutchan5-Sep-21 23:45 
GeneralRe: Need help with this question Pin
Member 153482516-Sep-21 0:55
Member 153482516-Sep-21 0:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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