|
You have to loop through the rows to format the data to JSON string.
Let's consider an example that your datatable contains two columns:
- FirstName
- LastName
then, the code might be:
Note: - Am not giving the exact code
protected function ConvertDataTableToJSON(byval dt as DataTable)
Dim strJSON as string
strJSON = "{"
for each row as DataRow in dt.Rows
strJSON = strJSON + "'firstName':" + "'" + row("FirstName") + "',"
strJSON = strJSON + "'lastName':" + "'" + row("LastName") + "',"
end for
strJSON = strJSON + "}"
return strJSON
end function
Hope this will be useful. Please refer the following link for JSON format:
http://en.wikipedia.org/wiki/JSON[^]
Thanks,
Rajdev KR
|
|
|
|
|
I have a gridview which i have to bind through javascript.
I am getting the datatable from the server side to client side by using ajax method.
I want to bind the returned datatable to the grid view through javascript.
Please help me on the same.
|
|
|
|
|
I already replied in your previous post  Hope that one helps.
Sincerely Samer Abu Rabie
Note: Please remember to rate this post to help others whom reading it.
|
|
|
|
|
I have a form text area on a webpage here http://run-mapper-kml.appspot.com/ that I want to send text data directly to.
The data is coming from an external source which is in a MS Access database and is sent live (eg: no physical file). I don’t want to send the data just to the url; I actually want it to populate the text area on the form, whereupon the user presses the command button to action the form’s contents.
I just want help on how to reference the actual text area on the form (everything else is taken care of). Can this be done?
PS: I am not an experienced web programmer or coder in any sense, but am willing to learn how to do this. I’m not even sure if I have posted this in the appropriate forum (mods feel free to move this post elsewhere)
This is my form on the webpage.
[code]
<form action="/" method="post" name="kml_Form">
<textarea cols="40" id="id_kml" name="kml" rows="20">{{ kml_data.kml }}</textarea>
<input name="key" value="{{ key }}" type="hidden" />
<input id="lat" name="lat" type="hidden" value="{{ lat }}" />
<input id="long" name="long" type="hidden" value="{{ long }}" />
<input id="zoom_level" name="zoom_level" type="hidden" value="{{ zoom_level }}" />
<input name="commit" type="submit" value="Show it on the map!" />
</form>
[/code]
|
|
|
|
|
Best way to do this is through ASP.NET. Any code done is ASP.NET will generate the necessary html response that the web browser will render.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Paul,
I don't know anything about ASP or any other web coding. I don't want to send the data to the url itself, but want it to drop straight into the form on the webpage. here's a link to my webpage to give you some idea of what I mean.
http://run-mapper-kml.appspot.com/
|
|
|
|
|
Your "Show it on the map!" button will need to have some server side code if you are taking data, working off an Access database, and posts back. Without any server side coding in ASP/ASP.NET, you really cannot do any kind of database access without it. Security is one of the reasons as well. You do not want a database's connection string or anything sensitive being exposed in the html.
Conceptually is it not difficult to have the button send data to be queried against the database and the results placed on the map to the right. If having the data being in the url is an issue, you could always use session variables to pass the data to be queried to the database.
You could always try to work it through javascript, but that exposes maybe a bit too much about your database on the client side.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Paul,
I think I have not explained myself very well, and this is coming across as much more complex than it needs to be. Try not to think of this all happening on the server side or from the web page at all, because it will in fact happen from the database side with a one-way communication involved. I don't need synchranous dialogue with the webpage - database, nor do I need open connections to and from the database, nor does the buttton need to do anything other than what it already does. Everything is already in place, take a look here http://run-mapper-kml.appspot.com/.
Think of it like this instead; ordinarily the user would simply paste the kml text into the form text area and push the button. The bit I want to do is to get rid of the pasting bit and send the text straight to the box. Now look at this:
stAppName = "C:\Program Files\Internet Explorer\iexplore.exe http://maps.google.co.uk/maps?f=q&hl=en&q=" & MyData
it is code (which works) from the database to simply call the url for googlemaps and send it some data, which will drop straight into the googlemaps search box, ready for a button to be pressed. As you can see their is no querying involved, there is no database access involved at all. Because all of this will happen from the other end, namely the database fron end, and not the web page.
I want to replace the code element above maps?f=q&hl=en&q=" with something that would work on my webpage. In other words I just want to know how to reference the actual form text area so that my code will look more like this:
stAppName = "C:\Program Files\Internet Explorer\iexplore.exe http://run-mapper-kml.appspot.com/code to link to the form & MyData
Does that make sense?
|
|
|
|
|
efandango wrote: Does that make sense?
Yes, it does make sense, but from what I've read/researched for your problem, it sounds like it cannot be done other than the way you have that does work.
http://maps.google.co.uk/maps?f=q&hl=en&q= does involve server side scripting to be done and there are reasons for that.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Paul,
Yes, I agree with you that the way googlemaps do their's would involve server side scripting in order to return a result (map); but bearing in mind that their's is also going to interrorgate the server for a map result.
But, where my version differs is that the 'Paste KML here' box in conjunction with the button has already got that covered. What I am trying to do is dend my data to the live form (instead of a user having to cut and paste it in), not neccesarily to the server itself where I may be expecting an instant return/result on what was sent.
Imagine for a moment that I didn't want to send anything sensible to the server side, instead consider that I just want to send some 'junk' text to a text area on a form, because essentialy speaking that is all I want to do, eg: send junk text. It is only when it is in the form and the crucial button is pressed that the junk text actually means something. So How would one send just text to a form on a webpage? (not specifically to the url)?
|
|
|
|
|
efandango wrote: How would one send just text to a form on a webpage? (not specifically to the url)?
By writing server side code. Duh.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Christian Graus wrote: By writing server side code
That's what I've been trying to tell him, and pretty much gave up.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
|
efandango wrote: Christian,
Ummm, you posted to the wrong guy. You should click on Reply on the message Christian posted.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Christian,
Go easy on me... I'm not a programmer in any sense. I'm just a guy that wants to send some text to a form on my website. I don't know how to go about writing server code to enable the form to receive data or even in which language to write it in.
is there some drop in code/snippet on the web that would enable a form to recieve text from an external source, where I can simply change the form/text area name or references? I can't be the only person that has ever required something so basic as this.
sorry if I have offended anyone.
|
|
|
|
|
I have developed a website but now in one of the page in website i developed i want to upload files from different location/areas/places/sites and uploaded different files to be viewed on another page in the same website and if required the uploaded pages will be downloaded and made required changes and re uploaded once again .If any one there to help me please help me out from this.
|
|
|
|
|
Why are you using VBScript ? Why not just chop your arms off and be done with it ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Your question is really not clear, tho i'll try to answer.
First of all, if you want to upload content via a webpage, use the Asp:FileUploader control. On the post back, you can use the FileUploader.Save method to save the file to the server.
Then, on a second page, you will have to use System.IO to get all the files in a directory, and print the list as the webpage output.
|
|
|
|
|
hi
how join vb code with scaner hardware
and save the picture which com from scaner into access database
please tell me that details because i am not profitional i am just student
|
|
|
|
|
You need to post in the appropriate forum. This forum is for web development, and what does your inquiry have to do with it?
njote wrote: join vb code with scaner hardware
njote wrote: am just student
This may be a very big undertaking for a student, not sure what level you are, but your instructor should be the one providing you with assistance in this.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Hi all,
In my web page, i am retrieving data for select element using Ajax. My webservice return me a collection of values as Ilist.
How to bind that collection to the select control, that DTO class has ID(bind to the value) and Name(bind to text).
Please suggest me or give me some like to learn how to do this.
Thank you
Know is Drop, Unknown is Ocean
|
|
|
|
|
Hi guys,
I'm looking for ideas for how to get a ¬ character used in a Javascript function call. We're currently using it as a delimiter in a JSON string, which is fine under an EN-gb language.
However, one of our en-IE clients has the problem that when the js file is loaded into IE7, the ¬ gets replaced with a ?. In the file, we split our JSON string using s.replace (/¬/g, '\n\r') , it gets swapped out in the file for /?/, causing an Unexpected Quantifier error.
For a variety of reasons, it would be really tricky to simply use a different delimiter (which is why we don't use a more normal | or , in the first place!), so I'm after any ideas as to how to "force" it through.
Setting the client browser to EN-gb doesn't do the job, is there perhaps a server setting that I need to be looking at? Additionally, the when viewed using alert(), the ¬ characters are correctly displayed...
C# has already designed away most of the tedium of C++.
|
|
|
|
|
hello..![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
im currently designing a personal site and i made a feedback page that has the following code:
<FORM ACTION="" METHOD="POST">
Your Name: <INPUT TYPE="text" NAME="Name">
Your Email: <INPUT TYPE="text" NAME="Email">
Your Comments: <TEXTAREA NAME="comments"></TEXTAREA>
<INPUT TYPE="SUBMIT" NAME="submit" VALUE="Send feedback">
</FORM>
My question is: Is there any way to send all these form fields to my personal e-mail (xxx@hotmail.com) using javascript or any other scripting language????
|
|
|
|
|
Hi,
eh sorry, but isn't it a bit complicated to send an email to you? You are using an ASP application, so why don't you use the values stored within the fields on your server. There you could send a mail to yourself if you like...
But if you still want to use javascript, have a look here: http://www.javascript-coder.com/javascript-form/javascript-email-form.phtml[^]
Regards,
Sebastian
|
|
|
|
|
You can send email in vb script by making cdo object. There are many articles on cdo object on web.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
