C# - Substitute For Microsoft Data Access ApplicationBlocks Obsolete SqlHelper Class?

Dec 16, 2010

It looks that the old SqlHelper class from the Microsoft Enterprise Library has been mostly replaced by the Database class which is included in the new Enterprise Library version 5.

I have a very simple and trivial example:
using Microsoft.ApplicationBlocks.Data;
private void PopulateCheckBoxGroup()
{
const string strConnTxt = "Server=(local);Database=DataBindTests;Integrated Security=True;";
const string strlSql = "select Technology from PreferredTechnology where ParentId = 1";
CheckBoxList1.DataSource = SqlHelper.ExecuteReader(strConnTxt, CommandType.Text, strlSql);
CheckBoxList1.DataTextField = "Technology";
CheckBoxList1.DataBind();
}

View 1 Replies


Similar Messages:

WCF / ASMX :: Microsoft.Web.Services3.SoapContext.Security' Is Obsolete

Aug 25, 2010

I am developing a webservice using asp.net 2.0 and WSE3.0 and I hit some problem retrieving the mustUnderstand from the soapRequest envelope returned to us(We are acting as the service provider).

A soapRequest will be returned to us as shown below:

[Code]....

View 1 Replies

DataSource Controls :: Create A Class Like SqlHelper.cs?

Apr 9, 2010

string connectionString = (string)
ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand("INSERT_PERSON",connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@Name",SqlDbType.NVarChar,50));
command.Parameters["@Name"].Value = txtName.Text;
command.Parameters.Add(new SqlParameter("@Age",SqlDbType.NVarChar,10));
command.Parameters["@Age"].Value = txtAge.Text;
connection.Open();
command.ExecuteNonQuery();
connection.Close();

Above is my code.

I has more than 100 methods like this, so every time i'm opening the connection and close it, this will take too much of time, what i think is instead of this i would like to create the class for Connection open, that class will check whether the connection is closed or Broken then Open it(like SqlHelper.cs) so without big change on my methods, how to create that class and how to access that class from my methods.

View 5 Replies

ADO.NET :: Difference Between Sqlhelper.ExecuteReader And Sqlhelper.ExecuteXmlReader?

Dec 24, 2010

what is the exact difference between Sqlhelper.ExecuteReader and Sqlhelper.ExecuteXmlReaderand which on is faster

View 3 Replies

Access :: Data Access Class / Helper Class For Access Databases?

Mar 15, 2011

recommend a data access class / helper class for Access databases, similar to the sqlhelper class found in the (Data Access Application Block)?

View 6 Replies

C# - How To Access A Private Data Members Of Base Class In The Derived Class

Aug 20, 2010

Since we can access the private data member of base class in the derived class with the help of friend function. How can we do the same in C# asp.net? I mean whats the alternative of friend function in C# asp.net

View 2 Replies

Usefulness Of Microsoft Data Access Application?

Jan 23, 2010

I am planning to start learning asp.net mvc. And also I want to learn Microsoft's Data Access application block. But I dont want to waste time in MDAC block if theres a better option to go for, or if MVC provides any good feature than MDAC. As I have heard MVC architecture automatically generates code.

View 2 Replies

Forms Data Controls :: Substitute Data In A Grid View Column For An Image?

Jun 17, 2010

I have a GridView control in my aspx page with a column that represents logging levels. Instead of displaying the word, e.g"Info", "Debug", "Error", etc. I want to display an image from a file. It seems like I may be able to do this with a template but I have been unable to find any examples of exactly how I would do this.

If "Info" then display "images/info.gif
If "Error" then display "images/error.gif
etc.

Here is my code snippet

[Code]....

View 13 Replies

Forms Data Controls :: Empty Item Template Substitute In Datalist?

Jan 6, 2010

I want to show a message when there's no data in my datalist. I found the following, but, I get an error on the bool. If you have another way to do this, great, but, I'd also like to try to do it this way as a learning experience.

<asp:DataList id="DataList3" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
<asp:HyperLink ID="ID" runat="server" target="_parent" NavigateUrl='<%# "Employment_detail.aspx?"%>'
Text='<%# Bind("WJTTL") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:Label ID="lblEmpty"
Text="Nothing here." runat="server" Visible="true">
%>Visible='<%#bool.Parse((SqlDataSource1.Items.Count==0).ToString())%>'> </asp:Label>
</FooterTemplate>
</asp:DataList>

View 1 Replies

DataSource Controls :: Display Data According To Sql Command From Microsoft Access

Apr 15, 2010

I have a problem and I could not solve it. Hope you can write a sample code for me. I have a Microsoft Access database, and in asp.net website, i draw a grid view on the design page. I also configure the source data access. It works, but display all the data in the database. i want to display all the data which is related to John. sql = "select username, customer_name, phone from db where username = John" how do i configure the data grid view?

View 3 Replies

Access :: Update Images Table In Microsoft Access DB Using File Uploader?

Jan 6, 2011

I have 4 file uploader in my form to upload 4 images in the DB for each article submitted. My issue when I want update/edit my article with some new pictures and I want delete or update the old pictures with the replacement with the new one.

How I can implement it? I am using ASP.NET based on VB.NOT .... NOT C#

View 1 Replies

Forms Data Controls :: Using Visaual Basic 2008 And Microsoft Access 2007

Apr 14, 2010

I want to create a search button and put the results in a data grid.

Select Company_Name,Contact_Name,Contact_Number From ClientSystem WHERE Company_Name=txtSearch.Text

View 2 Replies

Define Class Of Microsoft Visual Web Developer

Sep 7, 2010

i got microsoft visual web developer and do not understand what a class is would.

View 6 Replies

Substitute For Php Rawurlencode In .net?

Jul 13, 2010

I have a php running code to send mms but when i converted whole code into asp.net i didnt get any substitute for rawurlencode in asp.net.

View 2 Replies

Web Forms :: Import Microsoft.VisualBasic.CompilerServices In Class File?

Nov 25, 2010

I want to use some features of namespace Microsoft.VisualBasic.CompilerServices but I am unable to get CompilerServices Class in Microsoft.VisualBasic. whenever I write imports Microsoft.VisualBasic. intelesences does not show me CompilerServices tell me sutable reason to resolve this. I am using vs3.5, even though visual studio allow me to import Microsoft.VisualBasic but using only this my requirement will not fullfill.

View 3 Replies

Web Forms :: Operator Class Of Microsoft.VisualBasic Assambly Not Recognized?

Oct 20, 2010

I am trying to use Operator class to ConcatenateObject in my Class file of ClassLibrary. I have imported namespace of Microsoft.Visualbasic but still Operator class is not recognized. [URL] If I am trying to use add reference of Microsoft.VisualBasic.dll system say that it is already automatically adeed.

View 6 Replies

How To Access Label In Parent Class Of Code Behind Class

May 24, 2010

I have a class (name PageBase) that is inhariting System .Web.UI .Page and all my .aspx page behind classes are inhariting this class. This way I have put some common things in PageBase class.

For showing errors I want to put showMessage funtion in PageBase as well so that I may have not put it in every page and it will easy to manage this way.

Probem is that how PageBase class will access a control which is in aspx page in its child class (child class of PageBase) .

I dont want to pass control as argument to function in parent class, is ther any other way ?

View 7 Replies

C# - How To Make A Generic Data Access Class

Aug 5, 2010

ASP.net C# 3.5 Framework, working in Visual Studio 2008 currently.

What I want is a Generic Data Access Class. I have seen several of them but what I want is to see one that I pass the Connection String and the SQL statement and it will return a List of Objects or when only one item an Object or when no response needed a boolean to let me know if it succeeded?

View 3 Replies

Access :: How To Convert The C# Code To Access Sql To C# Code To Access Microsoft Access

Aug 12, 2010

I have a code to link to sql can anyone give me the same code for microsoft access....

try
{
int videoID = Convert.ToInt32(Request.QueryString["ID"]);
SqlConnection conn = new SqlConnection("server=WEBDESIGN-PC;database=Credentials;uid=sa;pwd=Azeem;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM videopath WHERE videoID=" + videoID, conn);
SqlDataReader dtr = cmd.ExecuteReader();
dtr.Read();
FlashVideo1.VideoURL = Convert.ToString(dtr["Filepath"]);
Label1.Text = Convert.ToString(dtr["Filename"]);
conn.Close();
}
catch (Exception ex)
{
Label1.Text = Convert.ToString(ex);
}
finally
{
}

View 2 Replies

Substitute To Updatepanel And Timer Control?

Jan 19, 2010

is there any other method that is similar to updatepanel and timer control in asp.net? I need to auto refresh a "section" of the page silently like what updatpanel and timer do.

View 3 Replies

How To Access The Instance Variables Of One Class To Be Used In Another Class

Sep 15, 2010

Suppose we declare and define the variable in one class let say FirstClass and we want to use that variable in another class let say SecondClass which is outside of FirstClass .how to do this?

View 2 Replies

Tool To Generate Data Access Class In VS 2008?

Mar 3, 2010

i am developing an web application using vs 2008..( i am new to vs 2008)

Is there any .net tool to generate data access layer or common classes ?

View 2 Replies

SQL Server :: SqlHelper.ExecuteNonQuery?

Aug 17, 2010

what is the use of this...?

View 4 Replies

How To Acess Microsoft Access Remotely

May 28, 2010

I am writing an application on my PC to insert record on a Microsoft Access database on another pc that has static ip address remotely.I can ping the remote address of the PC that I want to access without problems. The access database is in the folder c:inetpubwwwrootdb.mdb.

I have the code below but when I run it I am getting the following error:

error on ther server the object model couldnšt be found

OleDbException 0x800a2011
<%@ LANGUAGE = VB Debug="true" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Net.Mail" %>
<%@ Import Namespace= "System.Web.UI.WebControls.Menu" %>
<%@ Import Namespace="System.Data" %>
<script Runat="Server" language="VB">
public sub button_click(s as object,e as EventArgs)
dim ssql as string
dim strconn,objconn,rs,dbcomm
Dim ds As New DataSet
Dim da As OleDbDataAdapter = New OleDbDataAdapter
objconn=new oledbconnection("Provider=MS Remote; Remote Server=http://196.45.161.123; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\db.mdb;Persist Security Info=False")
objconn.open ()
dbcomm=New Oledbcommand("employee",objconn)
dbcomm.commandtext="insert into employee values ('mostafa',7,'tanzania')"
dbcomm.Connection = objconn
dbcomm.ExecuteNonQuery()
objconn.close ()
end sub
</script>
<html>
<Head>
</HEAD>
<BODY BGCOLOR="White" TOPMARGIN="10" LEFTMARGIN="10">
<form Runat="Server">
<asp:textbox id="t1" Runat="Server" text="type" />
<asp:button id="b1" Runat="Server" onclick="button_click" text="clickme" />
</form>
</BODY>
</HTML>

View 1 Replies

Forms Data Controls :: Access A Method Of Entity Class From A FormView?

Feb 24, 2010

I have a Customer database table with a text field named customerPicture with the name of the JPG file.

I have made a Customer Entity class with the LinQ to SQL Designer.

I also have a FormView displaying Customer instance binding with a LinqDataSource.

My problem is:

I want to make some modifications when some control want to bind the customerPicture field.

For example, when my FromView want to show the field customerPicture I want to return not only the JPG file name, I want to modify this string to add the complete file path and perhaps resample the image to a determinate width and height.

I know that is posible to defeine a partial class named Customer to implement certains partial methods, like OnCustomerPictureChanged(), but I dont know how to do this.

If I make, in this Customer partial class, a new method, for example getResamplePicturePath(), how could I invoke it from a FormView?

View 10 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved