Thanks, Chip, for your response. As you say,objDS.Tables("Users")returns an object of type System.Data.DataTable but then what doesobjDS.Tablesdo? Doesn't it return an object of type System.Data.DataTable? If no, then what exactly does it do? Also the Add method is a member of which object...
The following ASPX code works fine....
Sub Page_Load(obj As Object,ea As EventArgs)
Dim objDS As New DataSet
Dim objDT As New DataTable("Users")
objDT.Columns.Add("ID",Type.GetType("System.Int32"))
objDT.Columns.Add("FName",Type.GetType("System.String"))...
Hey Dazzled,
You need not answer my follow-up query regarding Primary Key. I have got the solution. Omitted brackets in the "Dimming" line! It should have beenDim objDC As DataColumn[highlight red]()[/highlight]={objDS.Tables("Users").Columns("ID")}
instead ofDim objDC As...
Hello Dazzled,
One last question please regarding the same ASPX code - I added the following code (which is in red color) in order to define the column ID as a Primary Key:
<script language=VB>
Sub Page_Load(obj As Object,ea As EventArgs)
Dim objDS As New DataSet
Dim objDT As New...
Thanks, Dazzled, for your reply but to be very honest I was wondering how stupid I can be asking such a stupid question!
Getting back to ca8msm's question-actually your question is justified - why would one have to add records manually? The truth is I have just started with ASP.NET & presently...
The following ASPX code creates a dynamic DataSet which is then displayed in a DataGrid (using a DataView):
<script language=VB>
Sub Page_Load(obj As Object,ea As EventArgs)
Dim objDS As New DataSet
Dim objDT As New DataTable("Users")
objDT.Columns.Add("ID",System.Type.GetType("System.Int32"))...
Hello Lrnmore,
I tried out your idea regarding my 'duplicate' query. It works fine but there's a small problem. The problem is as soon as the empty textbox gets populated with the 1st mail address, a semi-colon (;) also gets appended at the end. I want the semi-colon to be appended if & only if...
Thanks, my dear friends, for all your suggestions & inputs but here's the simplest way to do it:
<script language="JavaScript">
var str="(mymail@server.com)"
str=str.substring(1,str.length-1)
</script>
No RegExp, no replace()! Just substring().....that's it!!!
Regards...
Suppose I have the following string :
(mymail@server.com)
Please note that above string is enclosed in braces. Using JavaScript, how do I get rid of the 2 brackets - ( & ) i.e. the string should be just
mymail@server.com
Thanks,
Arpan
Thanks, Adam, for your suggestion. It is working exactly as I wanted it to but there is a small hitch. Suppose from the drop-down list, I select the 1st option james@bond.com. The textbox value becomes
james@bond.com
Next I select the 2nd option which is matt@horne.com. The textbox value...
An HTML Form has a drop-down list in which the options are listed by retrieving records from a backend (for which I am using ASP). The options in the drop-down list are displayed as
LastName FirstName (e-mail address)
The value of each option is a whole number. This HTML Form also includes a...
Thanks, mate, for your suggestion. You hit the nail on the head. The DB was named BSI4103 earlier & I wasn't aware of this fact. Later I got it verified from my friend who had created the back-up.
Thanks once again,
Regards,
Arpan
This question pertains to SQL Server 2000 running on Win2K Pro. I have a database back-up named BSI4200.bkp is my C: drive. Please note that I haven't made the back-up on my machine; I got it from someone. Now to RESTORE this database, I am using the following code:
RESTORE DATABASE BSI4200...
Thanks wolf for your code. It works properly but still a problem exists. If "68" (as per the e.g. I had given) is the 1st number in either the 1st or the 2nd textbox, it does not get deleted from the 2nd textbox (though 68 is present in the 1st textbox). Any workaround to fix this...
Whatever number it is, it will appear only once in the 1st textbox. But it can appear any number of times in the 2nd textbox. Is such cases, all the "68"s should be deleted from the 2nd textbox.
"Fun" ones or the "funny" ones?? What do you mean by "fun" ones? Anyway w.r.t. your 2 doubts, the answers of both the doubts is yes i.e. the values will always be numeric & will always be seperated by a comma? Any other doubts?? I will be happy to clarify them...
An HTML Form has two textboxes. Suppose a user enters 23, 45, 68, 99 in the 1st textbox & in the 2nd textbox, he enters 54, 68, 78, 94. Note that in the 2 textboxes, 68 is common. What I want is under such circumstances, 68 should automatically get deleted from the 2nd textbox (as it is already...
Hi Jakob,
Thanks for your suggestion. There's no doubt that your idea is a good one but if I implement your idea, it would mean consuming a lot of unnecessary server resources. The reason is I am populating both the select lists dynamically from a database (for which I am using ASP). So...
An HTML Form has 2 select lists along with a checkbox. Assume that the 1st select list shows 3 options - Jan, Feb & Mar. The 2nd select list shows the remaining 9 months. Now what I want is when the checkbox is checked (i.e. using the onClick() event), all the 9 options in the 2nd select list...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.