.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Declaring the SqlConnection and SqlCommand objects in a webform without CodeBehind

Posted By:      Posted Date: September 11, 2010    Points: 0   Category :ASP.Net
Declaring the SqlConnection and SqlCommand objects in a webform without CodeBehindI am trying to query data from a MS SQL server with a C# web form without "CodeBehind". I want to write the information to a table in the web form's body.I am having trouble declaring the SqlConnection and SqlCommand objects that connect to the server.How do you use "using System;", "using System.Data;", "using System.Data.SqlClient" inside the script element of an .ASPX file?I know how to do it with JavaScript and ADO. (code below)---------------------------------------------------------------------------------------------------<html><head><table><%@ language="javascript" %><%var sqlstr = " ";var conn_str = " ";var AdOpenForwardOnly = 0;var adLockReadOnly = 1;var rs = new ActiveXObject("ADODB.Recordset");var conn = new ActiveXObject("ADODB.Connection");conn_str = "PROVIDER=SQLOLEDB;Server=my_server;" +"Database=db_myDatabase;User ID=myUserID;" +"Password=myPassword;"sqlstr = "SELECT * FROM [myTable]";conn.open(conn_str, "", "");rs.open(sqlstr, conn, AdOpenForwardOnly, adLockReadOnly);while(!rs.eof){Response.write("<tr><td>" + rs(0));Response.write("</td><td>"+ rs(1));Response.write("</td><td>"+ rs

View Complete Post

More Related Resource Links

Binding with objects using codebehind



How can I bind an object to a dropdown list or gridview ? I am writing an application where my code behind calls an instance  and bind the list to either dropdown or gridview.

For example:

.aspx page:  default.aspx

<asp:dropdownlist  id="dd1"   runat="server" />



Code Behind:  default.VB

Partial Class Services_Default

    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As   System.EventArgs) Handles Me.Load

      Dim objlist As New services()

         Dd1.datasource = objlist.GetServices()

         Dd1.datatextfield = ?

         DD1.datatextfieldvalue = ?



End sub


End Class



APP_CODE :  Service.VB

    Public Class Services

    Public Function GetServices()

    Dim mylist As New Arraylist()

    Dim myconn As New SqlConne

How to just define connection string, sqlconnection and sqlcommand once and use it over and over..

I'm curious if there is a way to in the web.config. or somewhere else, to set up "the basics" for executiting various sql queries and stored procedures throughout a website, with out having to keep identitifying the connectionstring, sql connection, command, etc.   I'm thinking back to my old ColdFusion days, where you would declare all this in the application.cfm, and then it was quickly and easily reused without needing to retype the info.   Any suggestions/samples on doing this in VS 2010?   

Do you have to instantiate all objects/controls on the webform in the behind code page?


Hello everyone.

I have a MSchart control in my webform called Chart1 which is part of the namespace:  System.Web.UI.DataVisualization.Charting.Chart 

I am developing a multi-user (simultaneous connection) to a webform that manipulates controls and displays data on the graph.  Anyhow, I am immediately calling the Chart by using the reference: Chart1.Series.etc.etc.  or Chart1.Series.Addpoints. etc.etc.

My main question is, do I need to do a System.Web.UI.DataVisualization.Charting.Chart Chart1 = new System.Web.UI.DataVisualization.Charting.Chart();  inside  my page_load so that each user gets their own object instance of the Chart1 object?

So that way, if a second user changes the XY data, while the first user just changes the axis, then when the first user re-loads the updated graph, he does not get wrong data (overwritten) by the second user during a cross-session usage?

So must I create an object instance for all users for the MSchart control?


ASP.NET 4.0: WebForm Routing (quick n dirty version)

One of the things we're adding in ASP.NET 4.0 is built-in support for using Routing together with WebForms. Now, I'm totally aware that this is possible to do already and that a number of people have posted ways of doing this with the Web Routing feature which shipped with ASP.NET 3.5 SP1. We're just adding some features to make it easier to do

Declaring a DropDownList in ASP .Net

A DropDownList is also commonly known as combo box. It can contain multiple data members, but unlike a normal list box the users can choose only one value from this control. Though the functionality of this DropDownList is much like a Single Row Select List Box, a DropDownList can save a lot of GUI space as it is rendered on a Single line and is expanded only when the user clicks on the Control

SqlCommand.ExecuteNonQuery() returns -1 when doing Insert / Update / Delete

Sometimes you end up with a return value of -1 when using the SqlClient.SqlCommand.ExecuteNonQuery method.

Why is that?

Well, the ExecuteNonQuery method is there for statements for changing data, ie. DELETE / UPDATE /INSERT, and the returned value are the number of rows affected by that statement.

When checking the documentation we can see that there are some conditions that return -1.

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command.

When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of

rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.

Need help with objects and arrays


I have an objuct that I declared like this:

    Class DailyStats
        Dim _day As String
        Dim _hour As String
        Dim _impressions As String
        Dim _clicks As String
        Property Day() As String
                Return _day
            End Get
            Set(ByVal value As String)
                _day = value
            End Set
        End Property
        Property Hour() As String
                Return _hour

How to check for null/empty strings on dynamic objects?


What is the proper way to check for null or empty strings on dynamic objects? This is the only solution I've found so far:

if (admin.PasswordHash.GetType() == typeof(DBNull) || admin.PasswordHash == string.Empty)

If the field is null, the object returned is DBNull.Value, but if the field is empty string, it's return as a System.String object. This makes it impossible to do regular "admin.PasswordHash == DBNull.Value" check, as that will fail whenever the field has been set to empty string. Is my example the right (and only) way to go?

how to serialize objects ??


Is there any way or process to serialize the the objects?? i am trying to store the instance of few control in viewstate but it shows error msg that it is not a serialized object. should i perform some steps to serialize the objects ???

how To Insert the single quotes in sqlcommand in asp.net


Hi all

    i am developed on simple user registeration application in that i gave  address field .when i am trying to enter something like this (1st main,b'lore) but wont take while inserting.

my query is

sqlcommand cmd=new sqlcommand("insert into registeration_form(name,address)values('"+txtname.text+"','"+txt_address+"')",con);

how can i pass the  quotes also to my query please if any one know reply me.


G Dinakaran

Class which contains an array of objects of type "Class2"



1  Partial Class _Default
2  Inherits System.Web.UI.Page

3 Public Function Ohjoy(ByVal X As Integer) As Integer
4 Dim theClass As New Class1 '= New Class1()
5    theClass.ReSize(0)
6    theClass.myBaby(0).GetName(0) = "Hello" 'Property Chars is read only'
7    Return 1
8 End Function
I have a first class named "Class1". I have a second class named "Class2" Class2, is a member of class 1,
and is implemented as an array of objects of type Class 2.

If I try and call the Accessor GetName() my hard coded value "Hello" in my accessor is not returned? Only
an alpha character like "T"

Also if I try and assigne a value using the setter GetName() it does not work, and the compiler gives me
an error message "property Chars is ReadOnly? Does anyone know what is wrong in my code? Line 6 above


Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
End Sub
End Class

Public Class Class1
    Dim bs As Integer
    Public myBaby() As Class2
    Public myB As Class2
    Public Function ReSize(By

VB webform in IronPython asp.net website


Hi, I tried to bring a previously done webform made in vb.net to an IronPython asp.net website with no luck. After seeing it didnt work, I tried to write the simplest codebehind vb.net webform to see if there was a problem with vb.net in an IronPython website and I got the following usual error "be sure that the defined class in this file matchs with the one in the attribute inherits and that it extends the right base page (page or control)" (sorry if the translation isnt the most accurate I get that message in spanish) but if I create a vb.net webform in the same website, with the sourcecode in the same file (with the vb.net code between script runat="server" tags in the same page) I get no problem. Do I have to configure something for both kind of sourcecode languages to run in such way in the same IronPython website, like configuring something in the webconfig file or is there some compatibility issue for doing that which can't be resolved?

I figured out that in some cases I can solve it by creating the app_folder and moving the vb files there, but if these files dont inherit other classes which are in the app_folder

Cutting Edge: Expando Objects in C# 4


The .NET Framework 4 introduces some new features that enable you to go beyond static types. We explore dynamically expando objects and demonstrate how they can be used like dynamically updatable dictionary objects.

Dino Esposito

MSDN Magazine July 2010

Cutting Edge: Pros and Cons of Data Transfer Objects


After a brief refresher on procedural and object based patterns for organizing the business logic layer, the author focuses on data transfer objects and the impact they have on the development of the software project.

Dino Esposito

MSDN Magazine August 2009

Test-Driven Design: Using Mocks And Tests To Design Role-Based Objects


Use Test-Driven Development with mock objects to design object oriented code in terms of roles and responsibilities, not categorization of objects into class hierarchies.

Isaiah Perumalla

MSDN Magazine June 2009

Basic Instincts: Inspecting COM Objects With Reflection


Reflection is useful for debugging and logging and otherwise providing the type information you need. Here you'll see how to use reflection on COM types.

Lucian Wischik

MSDN Magazine January 2009

Toolbox: Serializing objects, Scott Allen's blog, Site Performance, and more


Serialize and Deserialize Fixed Length and Delimited Files, Scott Allen's blog, inspecting Web Pages, and more.

Scott Mitchell

MSDN Magazine August 2008

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend