|
|
I want add a row to the table dynamically using JavaScript code. In one my application it works fine. But in this application it is prompting error to IE 'unknown runtime error.'.
I have use css style sheet in this project. I am not able to find the exact cause and solution of problem.
This is an classic asp. I request you all to please help me out to find the solution.
I am provide original code of the page:
-----------------------------------------------------------------------
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include virtual="dsp/include/includedb.asp"-->
<!--#include virtual="dsp/include/checkLogin.asp"-->
<%
dim rsItem, strSql, strItem
set rsItem = Server.CreateObject("ADODB.RecordSet")
strSql = "SELECT * FROM iteam_MSt WHERE status=true;"
rsItem.Open strSql, con, 1, 3
do until rsItem.EOF
strItem = strItem & "<option value='" & rsItem.Fields("iteam_ID") & "-" & rsItem.Fields("price") &"-" & rsItem.Fields("iteam_Code") &"'>" & rsItem.Fields("details") & "</option>" & vbCrLf
rsItem.MoveNext
loop
rsItem.Close
set rsItem = nothing
con.close
set con = nothing
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>New Purchase</title>
<link href="../include/dsp.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
var ct = 1;
function CmdAdd_onclick() {
var newTable,startTag,endTag;
newTable = "";
startTag = "";
endTag = "";
var trContents0, trContents1, trContents2, trContents3, trContents4, trContents5, trContents6;
ct = ct + 1;
//Creating a new table
startTag+= "<table width='100%' border='0' cellspacing='0' cellpadding='2'>"
startTag+="<tr>"
startTag+="<td width='2%'>No</td>"
startTag+="<td width='28%'>Product Name</td>"
startTag+="<td width='17%'>Product Code</td>"
startTag+="<td width='10%'>Price</td>"
startTag+="<td width='15%'>Quantity</td>"
startTag+="<td colspan='2'>Total Amount</td>"
startTag+="</tr>"
startTag+="<tr>"
startTag+="<td colspan='7'></td>"
startTag+="</tr>"
endTag = "<tr><td colspan='7'></td></tr>"
endTag +="<tr><td colspan='5'><div align='right'>Grand Total</div></td><td colspan='2'><input name='txtGrndTotal' type='text' id='txtGrndTotal' style='font-size:12px; border:0px;' value='' size='20' readonly='readonly' /></td></tr>"
endTag +="<tr><td colspan='7'></td></tr>"
endTag +="<tr><td colspan='7'><input type='submit' name='Submit' value='Create Final Bill' /></td></tr></table>"
newTable=startTag;
var opt;
//Get the row contents
trContents0=document.getElementsByName('txtno');
trContents1=document.getElementsByName('cmbProduct');
trContents2=document.getElementsByName('txtCode');
trContents3=document.getElementsByName('txtPrice');
trContents4=document.getElementsByName('txtQty');
trContents5=document.getElementsByName('txtTotAmnt');
//trContents6=document.getElementsByName('txtGrndTotal');
//opt=document.getElementById('LstProdNo');
if(trContents1.length > 0)
{
for(i=0;i<trContents1.length;i++)
{
if(trContents1(i).innerHTML)
{
// newTable+="<TR><TD style=\"WIDTH: 120px\" ><input name=\"txtno\" type=\"text\" readonly=\"readonly\" size=\"5\" value='" + trContents0(i).value + "'/>" +"</TD>";
// newTable+="<TD style=\"WIDTH: 120px\" ><select name=\"LstProdNo\" id=\"userid\">" + trContents1(i).innerHTML + "</select>" +"</TD>";
// newTable+="<TD style=\"WIDTH: 120px\" ><input name=\"TxtQty\" type=\"text\" id=\"username\" value='" + trContents2(i).value + "'/>" +"</TD>";
// newTable+="<TD style=\"WIDTH: 120px\" ><input name=\"TxtPrice\" type=\"text\" id=\"department\" value='" + trContents3(i).value + "'/>" +"</TD><TR>";
newTable+="<tr>"
newTable+="<td><input name=\"txtNo\" type=\"text\" id=\"txtNo\" style=\"font-size:12px; border:0px;\" size=\"4\" readonly=\"readonly\" value='" + trContents0(i).value + "'/></td>"
newTable+="<td><select name=\"cmbProduct\" id=\"cmbProduct\" style=\"font-size:12px;\">" + trContents1(i).innerHTML + "</select></td>"
newTable+="<td><input name=\"txtCode\" type=\"text\" id=\"txtCode\" style=\"font-size:12px; border:0px;\" readonly=\"readonly\" value='" + trContents2(i).value + "' /></td>"
newTable+="<td><input name=\"txtPrice\" type=\"text\" id=\"txtPrice\" style=\"font-size:12px; border:0px;\" size=\"5\" readonly=\"readonly\" value='" + trContents3(i).value + "' /></td>"
newTable+="<td><input name=\"txtQty\" type=\"text\" id=\"txtAmnt\" style=\"font-size:12px;\" size=\"5\" value='" + trContents4(i).value + "' /></td>"
newTable+="<td width=\"19%\"><input name=\"txtTotAmnt\" type=\"text\" id=\"txtTotAmnt\" style=\"font-size:12px; border:0px;\" size=\"10\" readonly=\"readonly\" value='" + trContents5(i).value + "'/></td>"
newTable+="<td width=\"9%\"> </td>"
newTable+="</tr>"
}
}
}
//Add the Latest row
/*newTable+="<TR><TD style=\"WIDTH: 120px\" ><input name=\"txtno\" type=\"text\" readonly=\"readonly\" size=\"5\" value='" + ct + "'/>" +"</TD>";
newTable+="<TD style=\"WIDTH: 120px\" ><select name=\"LstProdNo\" id=\"userid\">" + opt.innerHTML + "</select>" +"</TD>";
newTable+="<TD style=\"WIDTH: 120px\" ><input name=\"TxtQty\" type=\"text\" id=\"username\" value=\"0\" />" +"</TD>";
newTable+="<TD style=\"WIDTH: 120px\" ><input name=\"TxtPrice\" type=\"text\" id=\"department\" value=\"0\"/>" +"</TD><TR>";*/
newTable+="<tr>"
newTable+="<td><input name=\"txtNo\" type=\"text\" id=\"txtNo\" style=\"font-size:12px; border:0px;\" size=\"4\" readonly=\"readonly\" value='" + ct + "'></td>"
newTable+="<td><select name=\"cmbProduct\" id=\"cmbProduct\" style=\"font-size:12px;\">" + trContents1(0).innerHTML + "</select></td>"
newTable+="<td><input name=\"txtCode\" type=\"text\" id=\"txtCode\" style=\"font-size:12px; border:0px;\" readonly=\"readonly\" /></td>"
newTable+="<td><input name=\"txtPrice\" type=\"text\" id=\"txtPrice\" style=\"font-size:12px; border:0px;\" size=\"5\" readonly=\"readonly\" /></td>"
newTable+="<td><input name=\"txtQty\" type=\"text\" id=\"txtAmnt\" style=\"font-size:12px;\" size=\"5\" /></td>"
newTable+="<td width=\"19%\"><input name=\"txtTotAmnt\" type=\"text\" id=\"txtTotAmnt\" style=\"font-size:12px; border:0px;\" size=\"10\" readonly=\"readonly\" /></td>"
newTable+="<td width=\"9%\"><input type=\"button\" name=\"Button\" value=\"ADD Product\" onclick=\"CmdAdd_onclick();\"/></td>"
newTable+="</tr>"
newTable+=endTag;
//Update the Previous Table With New Table.
document.getElementById('mainTbl').insertAdjacentHTML;
document.getElementById('mainTbl').innerHTML=newTable;
}
</script>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" class="Head1">Buy Products</td>
</tr>
<tr>
<td class="smlTbLine1"></td>
</tr>
<tr>
<td><form id="form1" name="form1" method="post" action="">
<table width="100%" border="0" cellpadding="2" cellspacing="0" id="mainTbl">
<tr>
<td width="2%" class="reportHead3">No</td>
<td width="28%" class="reportHead3">Product Name </td>
<td width="17%" class="reportHead3">Product Code </td>
<td width="10%" class="reportHead3">Price</td>
<td width="15%" class="reportHead3">Quantity</td>
<td colspan="2" class="reportHead3">Total Amount </td>
</tr>
<tr>
<td colspan="7" class="smlTbLine"></td>
</tr>
<tr>
<td><input name="txtNo" type="text" id="txtNo" style="font-size:12px; border:0px;" value="1" size="4" readonly="readonly"/></td>
<td><select name="cmbProduct" id="cmbProduct" style="font-size:12px;">
<%=strItem%>
</select> </td>
<td><input name="txtCode" type="text" id="txtCode" style="font-size:12px; border:0px;" readonly="readonly" /></td>
<td><input name="txtPrice" type="text" id="txtPrice" style="font-size:12px; border:0px;" value="1" size="5" readonly="readonly" /></td>
<td><input name="txtQty" type="text" id="txtQty" style="font-size:12px;" size="5" /></td>
<td width="19%"><input name="txtTotAmnt" type="text" id="txtTotAmnt" style="font-size:12px; border:0px;" size="10" readonly="readonly" /></td>
<td width="9%"><input type="button" name="Button" value="ADD Product" onclick="CmdAdd_onclick();"/></td>
</tr>
<tr>
<td colspan="7" class="smlTbLine"></td>
</tr>
<tr>
<td colspan="5" class="reportHead3"><div align="right">Grand Total </div></td>
<td colspan="2"><input name="txtGrndTotal" type="text" id="txtGrndTotal" style="font-size:12px; border:0px;" value="" size="20" readonly="readonly" /></td>
</tr>
<tr>
<td colspan="7" class="smlTbLine"></td>
</tr>
<tr>
<td colspan="7"><input type="submit" name="Submit" value="Create Final Bill" /></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td class="smlTbLine1"></td>
</tr>
</table>
</body>
</html>
Kiran Sajanikar
Software Engineer
Pune.
|
|
|
|
|
Boil it down to the smallest possible amount of code necessary to reproduce the problem. The stuff you've posted has a fair bit of commented-out code, do-nothing code, and code that depends on your particular scenario (and so cannot be used to reproduce the problem by anyone here who might be interested in doing so.)
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
innerHTML does not work well with tables in IE. Firefox works well with it though. I am not sure whether innerHTML was intended to work with nested elements.
I found that out when I tried this:
table_ref = document.getElementById(table_name);
row_innerHTML = table_ref.rows[1].innerHTML;
new_row_ref = table_ref.insertRow(table_ref.rows.length);
new_row_ref.innerHTML = row_innerHTML;
The line in block letters produced a runtime error in IE.
So, I replaced it with:
table_ref = document.getElementById(table_name);
var table_row_ref = table_ref.rows[1];
new_row_ref = table_ref.insertRow(table_ref.rows.length);
cellcount = table_row_ref.cells.length;
for (cellindex = 0; cellindex < cellcount; ++cellindex)
{
new_col_ref = table_row_ref.cells[cellindex].cloneNode(true);
new_row_ref.appendChild(new_col_ref);
}
Instead of trying to use HTML code, you may also have to use insertRow(), insertColumn() etc. If you want to remove existing rows, use deleteRow() function.
modified 29-Aug-18 21:01pm.
|
|
|
|
|
see wheather any nonexisting control is referenced
|
|
|
|
|
Dear All
Please see code below:
<title>Untitled Page
function Upload_Click(){
document.getElementById('upload').click();
}
when click upload button, dialog will show up in Internet Explorer. But in firefox this dialog is not show. Who can help me? or suggest your idea for this case.
Thanks and best regards.
|
|
|
|
|
Firefox doesn't support triggering the click event for file input elements programatically. See here: http://www.quirksmode.org/dom/inputfile.html[^]
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
Hi all,
Well the project i developed, i am using reportviewer and rdlc files to display charts as an image. But my client is not very much happy about the look and feel of the images.
Can anyone suggest a good charting tool that i can use.
It should give me a nice look and feel on the images kinda 3d and stuff!
Can buy it  the client has approved!
Anyone whose used a charting tool thats good and suitable?
Any help is much appreciated!!
Thanks in advance!
I was born dumb!!
 Programming made me laugh !!!
--sid--
|
|
|
|
|
Dundas charts are very good.
|
|
|
|
|
Hi,
Can someone help me with this -
I've used ASP.NET Ajax in my forms, I've created delegates and bind them with their respective handlers by defining their
events. I've a main form over which I've taken some Iframes to show different forms. I am using Ajax timer on one of my
forms in an iframe, now everything goes fine till there is no popup i.e. the events are fired properly and the code written
in their resp. handlers to change label text property works fine and the changes can be seen without a page refresh.
The problem occurs when I try to fire the event from a popup window from an IFrame on some other Iframe. Major issue
is that the event get fired and the handler changes the text value but the changes can not be seen on the page, remember
that the form in which the changes should be shown is in some other Iframe.
May be this is happening due to the form in which label's text has to be changed didn't get refresh and the Ajax
timer used is not able to revert to the changes after the focus on the current window has been lost. I don't know why this
is happening but it has been a really hectic task to overcome this situation.
Can some one has some solution or can some one help me to know a way to refresh a page in some other iframe from a
popup opened from some different iframe on the same page.
Plz try to forget my mistakes in English and Thx in advance.... 
Leap before you look...
|
|
|
|
|
mooring guys......
im working with BizTalk 2006....i exposed an orchestration as a web-service.the problem is not here .
the problem that when i was calling the web service as http://localhost..... the browser gives me this "The webpage cannot be found"
but when i put my IP address it works well.... as in http://XXX.XX.XX.XX....
and if i put the local host IP address and the same browser message appears "The webpage cannot be found"
so im searching about what is killing my localhost......i uninstall the sharepoint and the same error occurs
so plz plz plz if any one have any idea.....
Regards
Ahmad Dalqamouny
|
|
|
|
|
Try looking at the IP address assigned to the web site on your local host.
1) Open IIS management console
2) Right-click site and select 'Properties'
3) On the 'Web Site' tab is IP Address set to '(All Unassigned') ??
If your web site is assigned to your specific IP address then localhost and 127.0.0.1 won't work because it will only respond to the specific IP address.
[Edit]
One other solution (if you must have the IP address specifically assigned) is to click the "Advanced" button next to the assigned IP address and under "Multiple Identities..." add a new entry with the values of 'All Unassigned', 80, and 'localhost'
|
|
|
|
|
hai i have designed a web form in visual studio2005.
everything in that aspx page desigend with in a table of fixedsize(990*560).
with in that table
i have included a <iframe>
whose coding i am giveing below
"<td style="width:744px;height:516px" valign="top">
<iframe id="frame1" name="frame1" style="width:744px;height:516px; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; position:absolute; top:108px; font-family:Arial; font-size:8pt; left: 25%;" scrolling="yes" runat="server"></iframe>
</td>"
its work fine in 1024*768 resolution but wheni have changed the resolution to
1280*768 . all the designed comes in size except the ifrmae.
can solve my problem that why the iframe is not coming in the appropriate place,while changing the screeen resolution.
Below i am giving u the complete page source code..
Plz help me out..
<br />
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %><br />
<br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head id="Head1" runat="server"><br />
<title>RWSS</title><br />
<style type="text/css"><br />
body <br />
{<br />
font-family:Verdana;<br />
font-size:8pt;<br />
margin-left:0;<br />
margin-right:0;<br />
margin-top:0;<br />
top:1;<br />
left:0;<br />
right:0;<br />
background-image:url('images/pattern.gif');<br />
}<br />
</style><br />
<br />
<br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<table cellpadding="0" cellspacing="0" width="994px" align="center" bgColor="#ffffff" border="0" ><br />
<tbody><br />
<tr><br />
<td valign="top" style="width:994px;height:106px;"><br />
<table style="height:106px;width:994px;background-color:#ffffff;border-width:0;background-image: url(images/top.GIF);" cellspacing="0" cellpadding="0" align="center"><br />
<tr><br />
<td valign="bottom" style="height: 34px"><br />
<div id="ddcolortabs" ><br />
<ul><br />
<li ><a title="Home" href="Default.aspx" target="_parent"><span>Home</span></a></li> <br />
<li><a title="Contact Us" href=""><span>Contact Us</span></a></li> <br />
<li><a title="Feedback" href=""><span>Feedback</span></a></li> <br />
<li><a title="Sitemap" href=""><span>SiteMap</span></a></li> <br />
<li><a title="FAQ" href=""><span>FAQ </span></a></li> <br />
</ul><br />
</div><br />
</td><br />
</tr><br />
</table><br />
</td><br />
</tr><br />
<tr><br />
<td style="width:250px;height:516px;background-color:#c1d3ff; position: relative;" align="left"><br />
<span style="font-size: 10pt"><strong> <span style="color: #330066; font-family: Arial Baltic"><br />
Menu</span></strong><span style="color: #330066"> </span></span><br />
<div style="overflow:scroll;width:248px;height:496px" ><br />
<asp:TreeView ID="TvMenu" runat="server" ExpandDepth="0" PopulateNodesFromClient="true" ShowLines="true" ShowExpandCollapse="true" ForeColor="MidnightBlue" Font-Size="9pt" BorderColor="ButtonFace" Font-Names="Arial" ></asp:TreeView><br />
</div><br />
</td><br />
<td style="width:744px;height:516px" valign="top"><br />
<iframe id="frame1" name="frame1" style="width:744px;height:516px; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; position:absolute; top:108px; font-family:Arial; font-size:8pt; left: 25%;" scrolling="yes" runat="server"><br />
</iframe><br />
<br />
</td><br />
<br />
</tr><br />
<tr><br />
<td bgcolor="#993333"style="height:20px;width:994px;" ></td><br />
</tr><br />
</tbody><br />
</table><br />
</div><br />
</form><br />
</body><br />
</html><br />
|
|
|
|
|
i want to create collapse menu such as
parent item is display, child item is hide,
i click into parent item, child item display
content items are got from database.
mene like this page(left menu of codeproject.com")
can you send mail for me? xuannien84@gmail.com
thanks.
|
|
|
|
|
Sorry, we do not email answers in this forum and we are here to assist with technology questions, not do your work for you.
Brad
Australian
The PHP MVP
- Christian Graus on "Best books for VBscript"
A big thick one, so you can whack yourself on the head with it.
|
|
|
|
|
I've been doing Flex and AS3 programming for about five months, but now I'm having to delve into Javascript with which I have no experience. I have what I think is a very basic Javascript question.
My basic terminology may not even be accurate, but I think I want to resize the 'document' as opposed to the window. For at least some browsers, I think you can say window.Resize(x,y) and it will resize the actual browser window. However, I want to resize not the window, but rather the scrollable area of the page, regardless of what text or other content the page actually contains. So if all the page contains is "Hello World", I want to be able to resize the scrollable area to some arbitrary size, so that maybe it could be scrolled down for several pages. Contrarily, I want to be able to set the width of the page to less (or greater) than the width of the browser window width, so that presumably there could be a blank area between the right edge of the page and the right edge of the browser window. I also want to be able to set the scroll position of the page, And also if possible the option to show or hide the scroll bars, regardless of the document size.
I spent three hours last night trying to find this information without success. I was trying to do the above on the onLoad event in the body tag (calling a javascript function defined in a previous script section.)
|
|
|
|
|
That doesn't make sense. The scrollable area is defined by the markup in the page, you can't set it because that would be inconsistent to what a browser is supposed to do, render the markup.
led mike
|
|
|
|
|
led mike wrote: That doesn't make sense. The scrollable area is defined by the markup in the page, you can't set it because that would be inconsistent to what a browser is supposed to do, render the markup.
Here's one area it makes sense.
I found out that flash (or whatever the correct collective term is for flash, flex actionscript shockwave etc) has very limited built in capabilities for displaying html - there is no built in browser control for displaying a web page in a flash document. So, what they do is a hack, accessing an iframe defined in the html wrapper, via a javascript function also defined in the html wrapper, and displaying that iframe on top of the flash program. However, if the flash program has its own scroll bar, the html wrapper doesn't know anything about it and the iframe will be displayed on top of it. So, I was wanting some method to resize the html "page" (or 'document') via a javascript call from flash, reducing the page width so the iframe wouldn't display on top of the flash scroll bar.
It occured to me though, that as far as the page height, just setting the correct y location of the iframe would automatically extend the height of the html wrapper to correspond to the height of the flash page.
I still need to be able to set the scroll position of the wrapper, so that if I have several iframes, I don't have to reposition each one individually.
|
|
|
|
|
Wow what a pile of garbage, and you are doing all this for what purpose? I mean why is it important or what feature or whatever is it intended to provide?
led mike
|
|
|
|
|
led mike wrote: Wow what a pile of garbage, and you are doing all this for what purpose? I mean why is it important or what feature or whatever is it intended to provide?
Ummmm... I want to have iframe capability in a flash program like iframes exist on an html page. I think the utility of being able to display some web page within another web page (or in a flash program) should be self evident. There are implementations of iframes I've seen for flex and actionscript that utilize the mechanisms I described, but the ones I've seen thus far seem to be lacking some functionality I'm looking for.
As far as the "garbage" comment, I don't really understand either, what technical hurdles could possibly exist that would cause Adobe to exclude this extremely important functionality from their platforms. However, their capabilities in many areas are dazzling, and that is why Microsoft created Silverlight, to try to compete with them.
|
|
|
|
|
Just to be clear, you can load another flash page into any other flash page without any problem, using something called SWFLoader. There's also something called URLLoader, but for some reason it doesn't allow you to load an html page. And it really makes no sense why this functionality would not exist. Maybe Microsoft threatened to destroy them if they included it, who knows.
|
|
|
|
|
Force Code wrote: And it really makes no sense why this functionality would not exist.
Ok, good luck
led mike
|
|
|
|
|
Just think of HTML as a bunch of nested boxes created from elements in the HTML. <html> is your document, <body> holds the stuff inside it; the box created for the former is the size of the window (client area) and the box created for the latter is the size needed to display whatever it contains. So if you force the size of <body> to be larger than <html>, you'll scroll (unless you disable scrolling...)
Of course, on older browsers things are a bit more weird, but... i find it's best to just ignore them.
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
Does this serve your purpose?
<html id="ht">
<body>
</body>
</html>
<script>
html = document.getElementById('ht');
html.style.height="200%";
</script>
modified 29-Aug-18 21:01pm.
|
|
|
|
|
My code is not working and I don't know why? The function works by itself and returns a xml array. When I run the code and type in the textbox nothing happens.
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" ServicePath="AutoComplete.asmx"
ServiceMethod="GetSuggested" MinimumPrefixLength="1" TargetControlID="TextBox1"
CompletionInterval="1" CompletionSetCount="3" EnableCaching="true" runat="server">
</cc1:AutoCompleteExtender>
Public Function GetSuggested(ByVal prefix As String) As String()
Dim sqlconn As New SqlConnection("Data Source=xxxx;Initial Catalog=xxxx;Integrated Security=True")
Dim dt As New DataTable()
Dim cmd As New SqlCommand("SELECT Name FROM OwnerDataSet WHERE Name Like '%" + prefix + "%'", sqlconn)
Dim adapt As New SqlDataAdapter(cmd)
Dim ds As New DataSet()
adapt.Fill(ds)
sqlconn.Open()
dt = ds.Tables(0)
Dim StringList As New List(Of String)()
For Each dr As DataRow In dt.Rows
StringList.Add(dr.Item(0).ToString())
Next
sqlconn.Close()
Return StringList.ToArray()
End Function
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
