VS 2008 - Send A Bunch Of Looped Records From Database To JavaScript Array
Mar 21, 2012
I'm trying to send a bunch of looped records from database to javascript array in codebehind to add overlays to the googlemap markers. So farthe code below only provide me the first marker.
PHP Code:
private void BuildScript(DataTable tbl)
{
String Markers = "";
foreach (DataRow r in tbl.Rows)
{
Iam getting an array of list from database to client side(javascript array). Now my aim to place those values in a div one by one and that div should attach to the textbox similar to Autocomplete extender.
i have a array in javascript and need to send to server how i can send it in jquery and get them in controller . to send javascript array and get them in controller [c#]
I would to know how to pass variables. I have a variable in javascript but I dont know how to pass it to a textbox. I have read it is so easy using ajax, but I dont know how to use it. I believed this was just for not to have reload. Well, then how do I do it? I read I must use get and post, but I dont know how to use it.. for example I have the code:
function guardar() { var completo = "hola mundo"; }
How do I get the variable completo to pass it in a textbox?
I'm trying to delete a bunch of records in mysql. The record info to delete (userid, name) is stored in an arraylist. It seems to only delete the first record and gives an error ("Transaction has already been rolled back or is not pending.") afterwards. I have the transaction commit inside the loop which I think is the issue but not sure how to go further if I bring it outside of the loop. Here's the relevant bits of the code.
try { ArrayList alist = new ArrayList(); //alist gets populated with data like (12345,robot)(23456,car) here. MySqlConnection conn2 = new MySqlConnection(query_connection); conn2.Open(); MySqlCommand command2 = conn2.CreateCommand(); MySqlTransaction mytransaction; mytransaction = conn2.BeginTransaction(); command2.Transaction = mytransaction; for (int i = 0; i < alist.Count; i++) { string[] s = alist[i].ToString().Split(','); try { command2.CommandText = "DELETE from users_settings WHERE UserID=" + s[0].ToString(); command2.ExecuteNonQuery(); command2.CommandText = "DELETE from users WHERE ID=" + s[0].ToString(); command2.ExecuteNonQuery(); mytransaction.Commit(); } catch (Exception e){ mytransaction.Rollback(); } } } catch(Exception e){ }
I have 45 dropdown lists in my asp page. There are some methods that I can apply to all of these dropdowns. Is it possible to convert them into an array of dropdowns for ease of use?
I have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
I have create a web page having dynamically created text boxes if i select value in dropdown list,text boxes auto generates .but i want to save all text box values in SQL server database after clicking on submit button using ajax/JSON request
I used to work in the IT field, but because of an accident and meds I have lost a bunch of my memory. So, I'm in need of relational database help..I've got a web site I want to put up that will sell books. I'll be using SQL server 2008. I'll be using Pay Pal's Cart, etc, so I just have to put up some buttons on the web site, but I need to track, display, etc, the books and properties about the books such as Authors, Paper back or hard cover, first edition, or something else, etc,..I have a table for books obviously, but I'm wondering if I should break out the Authors out of that table? I mean I don't see why except that if I end up with some books that have the same author then there names will be stored more than once, but I will be doing a lot more queries than inserts. I've got Customers, Book Types which is if the book is a hard cover, softcover, first edition, etc,. I will relate the Books to the Book Types of course, but again, should I have an authors table? Hope this makes sense.. I am using Visual Studio 2008 Pro, and want to do my relations there, so I thought I'd do so in the IDE if possible? I can't remember, but I thought it was possible?
I now have two asp.net pages. When I click on a link on page A, I open the other one (let's call it page B). When I do this, I want to send some information from Page A to Page B in the form of an array of strings. This array is different depending on what link I follow on Page A.
I know I could send this information via the URL with the ?string1=bla1&string2=bla2 etc., but I don't want it that way, as it can get complicated if there are too many strings in the array.
I think there is something similar, like a POST in PHP, but how would that be in ASP?
I'm putting together a way to cull out bad emails from my table.
I have an email field, of course, and a 'fail' field (integer)
Each time I send out an email, I get a bunch of emails back that the email addresses were undeliverable, so I'd like to (manually), enter them all into an array (or whatever), and then run a stored procedure which updates the 'fail' field by 1
I'm looking for both on the SQL side (I have an sProc that does the deed one at a time - just need the logic to do it in a batch like this), and how to do it in the web page.....
I have a array of ArrayList as shown below:ArrayList[] m;My web service method takes this type as parameter.How can I send it to web service?When I do so the Web Service changes my array of ArrayList to Object[][]!
I'm looking for a way to define and send a JSON object array. I've figured out how to define a single JSON object, turn it into a string and send it, but what about an array of this type? Probably something simple I'm overlooking...
var myColumnSetting = { "ColumnName": name, "ColumnIndex": index } convert it to a string var myJSONText = JSON.stringify(myColumnSetting, false);
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
For some reason the following JSON string creates the correct number of records in the custom objects array, but does NOT populate the objects in the array with and values.
Every morning we send out an email with a text file attached. This is a manual process so I am automating it.I am using an internal mail web service. Its last two parameters are a byte array which is the file contents and a string which is the file name. I passed (...gbytes, "test.txt") and the only thing wrong with it is text.txt is XML. I want it to be text (csv is fine because there is actually four columns that come from a datatable).So I am assuming what's making it XML is this code:
Code: System.IO.MemoryStream stream = new System.IO.MemoryStream(); System.Runtime.Serialization.IFormatter formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); formatter.Serialize(stream, ds.Tables[0]); gbytes = stream.GetBuffer();
I am trying to search the Internet for how to convert a datatable to a byte array, but I can't find how to have it be text instead of XML. Also, another parameter our WS takes is a flag to say if it's XML, and I am setting this to false.
How can i send a string session array values to dataset? I have a session array where i stored textbox values. nowi want to send these values to dataset. how can i write the code in c# to send these values to dataset? I dnt want to save these values in database.
But simply nothing is getting pushed to the array. I can tell this as I am using the following ASP.NET to write the array to a text file:
<script runat="server"> protected void Page_Load(object sender, EventArgs e) { string path = Server.MapPath(".")+"/"+Request.Form["file_name"] + ".txt"; if (!File.Exists(path)) { using (StreamWriter sw = File.CreateText(path)) { sw.WriteLine(Request.Form["seatsArray"]); sw.WriteLine(""); } } using (StreamReader sr = File.OpenText(path)) { string s = ""; while ((s = sr.ReadLine()) != null) { Response.Write(s); } } } </script>
The name of the text file is correct according to what the user put in the form "file_name". As you can see I made seatsArray a hidden form object so thats what the ASP.NET is trying to call.
Is something in the javascript in the wrong order or something? Because I just can't get it to fill up that text file.