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:
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
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
Dec 24, 2010
what is the exact difference between Sqlhelper.ExecuteReader and Sqlhelper.ExecuteXmlReaderand which on is faster
View 3 Replies
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
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
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
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
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
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
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
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
Sep 7, 2010
i got microsoft visual web developer and do not understand what a class is would.
View 6 Replies
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
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
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
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
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
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
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
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
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
Aug 17, 2010
what is the use of this...?
View 4 Replies
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
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