Click here to Skip to main content
15,392,442 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Prevent hacking of connection string over the internet Pin
Dave Kreskowiak7-Oct-21 8:11
mveDave Kreskowiak7-Oct-21 8:11 
AnswerRe: Prevent hacking of connection string over the internet Pin
Member 153296137-Oct-21 8:11
MemberMember 153296137-Oct-21 8:11 
GeneralRe: Prevent hacking of connection string over the internet Pin
Member 1537744010-Oct-21 7:00
MemberMember 1537744010-Oct-21 7:00 
GeneralRe: Prevent hacking of connection string over the internet Pin
Dave Kreskowiak10-Oct-21 7:10
mveDave Kreskowiak10-Oct-21 7:10 
GeneralRe: Prevent hacking of connection string over the internet Pin
Member 1532961311-Oct-21 1:10
MemberMember 1532961311-Oct-21 1:10 
GeneralRe: Prevent hacking of connection string over the internet Pin
Member 1537744011-Oct-21 8:22
MemberMember 1537744011-Oct-21 8:22 
GeneralRe: Prevent hacking of connection string over the internet Pin
Member 1532961311-Oct-21 9:56
MemberMember 1532961311-Oct-21 9: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 8:00
MemberTASK Live Charts25-Sep-21 8: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 6:48
mveCHill607-Oct-21 6:48 
QuestionVBA Calling a Sharepoint list Rest API failed. Pin
BEN CHEN 202119-Sep-21 6:48
MemberBEN CHEN 202119-Sep-21 6:48 
AnswerRe: VBA Calling a Sharepoint list Rest API failed. Pin
Richard Deeming19-Sep-21 21:51
mveRichard Deeming19-Sep-21 21:51 
QuestionListDirectoryDetails Pin
Drno Strz18-Sep-21 8:07
MemberDrno Strz18-Sep-21 8:07 
AnswerRe: ListDirectoryDetails Pin
RedDk18-Sep-21 13:55
MemberRedDk18-Sep-21 13:55 
GeneralRe: ListDirectoryDetails Pin
Drno Strz18-Sep-21 21:33
MemberDrno Strz18-Sep-21 21:33 
GeneralRe: ListDirectoryDetails Pin
Mycroft Holmes19-Sep-21 12:10
professionalMycroft Holmes19-Sep-21 12:10 
GeneralRe: ListDirectoryDetails Pin
Dave Kreskowiak19-Sep-21 12:39
mveDave Kreskowiak19-Sep-21 12:39 
Questionbuilding an IT helpdesk tool Pin
Mustafa M. Al-Nassah8-Sep-21 10:17
MemberMustafa M. Al-Nassah8-Sep-21 10:17 
AnswerRe: building an IT helpdesk tool Pin
CHill6016-Sep-21 22:11
mveCHill6016-Sep-21 22:11 
QuestionVB.Net and Google docs Pin
Malcolm Bacchus6-Sep-21 3:31
MemberMalcolm Bacchus6-Sep-21 3:31 
AnswerRe: VB.Net and Google docs Pin
Richard MacCutchan6-Sep-21 5:47
mveRichard MacCutchan6-Sep-21 5:47 
QuestionNeed help with this question Pin
Member 153482515-Sep-21 22:18
MemberMember 153482515-Sep-21 22:18 
GeneralRe: Need help with this question Pin
Richard MacCutchan5-Sep-21 22:33
mveRichard MacCutchan5-Sep-21 22:33 
GeneralRe: Need help with this question Pin
Member 153482515-Sep-21 22:40
MemberMember 153482515-Sep-21 22:40 
GeneralRe: Need help with this question Pin
Richard MacCutchan5-Sep-21 22:45
mveRichard MacCutchan5-Sep-21 22:45 
GeneralRe: Need help with this question Pin
Member 153482515-Sep-21 23:55
MemberMember 153482515-Sep-21 23: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.