Search DaniWeb - dataaccesslayer

Inserting data into a server database 14 Years Ago by Nishara … public DataTable dt; public String fullsql; public DataAccessLayer() { } public DataTable getTable(String sql)… public DataTable dt; public String fullsql; public DataAccessLayer() { } public DataTable getTable(String sql)… Re: Inserting data into a server database 14 Years Ago by Nishara …dataCmd; public string fullsql; private DataAccessLayer dal; public Form1() { InitializeComponent… * from Users"; dal = new DataAccessLayer(); UserTable = dal.getTable(fullsql); DataRow dtr… How to handle the error "Object reference not set to an instance of an object" 14 Years Ago by Nishara … As String Private Shared OrderedItemHandler As DataAccesslayer Private Shared OrderedItemTable As DataTable Public …"Select * From Ordered_Item" OrderedItemHandler = New DataAccesslayer OrderedItemHandler.fullSql = fullSql OrderedItemTable = OrderedItemHandler.GetTable(fullSql) GC… Nested datalist 12 Years Ago by babafemi …SelectMethod="SelectDocFos" TypeName="DataAccessLayer.DoctorateRepository" onselecting="FosObjectDataSource_Selecting1"…SelectMethod="FetchUserDoctorateDetails" TypeName="DataAccessLayer.DoctorateRepository"> <SelectParameters>… Fetching values from database to textboxes in c# 9 Years Ago by kool005 ….Close(); } } return null; } Business Logic: public DataTable editCustomer() { DataAccessLayer.DataManager objEditData = new DataAccessLayer.DataManager(); List<SqlParameter> param = new List<… Populate dropdownlist in formview 16 Years Ago by serkan sendur … | lastname | department(int) departments table : PKID | departmentName I created my dataaccesslayer using dataset designer and in the presentation layer i created… MS SQL 2005 Trigger : Transaction Scope and Parameters 15 Years Ago by wuz … remain: 1) Transaction Scope I handle complex Operations in my DataAccessLayer (C#,ASP.NET) with Transaction Scopes. For example: [code]private… Problem with ClickOnce deployment 14 Years Ago by G_Waddell … String Dim intUserID As Integer = 0 Dim objDB As New DataAccessLayer 'custom class for interacting with database Dim tblLoginResults As Data… How to use Ajax and JQuery together on same masterpage. 13 Years Ago by Ankur_tces … sqlCmd As SqlCommand Dim sqlDs As DataSet Dim acc As DataAccessLayer Dim rghts As ChkRights ' Dim vl_UsrId As Integer Public SqlCon… How to use ajax and jquery 13 Years Ago by Ankur_tces … sqlCmd As SqlCommand Dim sqlDs As DataSet Dim acc As DataAccessLayer Dim rghts As ChkRights ' Dim vl_UsrId As Integer Public SqlCon… Re: Business logic layer 14 Years Ago by DdoubleD … thread too... [code=csharp] class DataAccessLayer { public static DataTable GetAuthorTable() {…quot;Name"].ToString() == authorName) { DataAccessLayer.DeleteAuthor((int)dr["Id"]); break;… Re: Business logic layer 14 Years Ago by Mitja Bonca … did (just one example) for the DAL: [CODE]public class DataAccessLayer { public static DataSet GetAuthors(string AuthorsName) { using (SqlConnection sqlConn = new… Re: mixed mode in MS SQL 13 Years Ago by judithSampathwa … translate false , there is an The type initializer for 'Admin_Application.DataAccessLayer.DB' threw an exception. Type initalization exception hey please can… Re: Inserting data into a server database 14 Years Ago by sknake You need to specify Insert, Update, Delete, and Select queries for your data adapter. Re: Inserting data into a server database 14 Years Ago by sknake Upload a sample project demonstrating this behavior and i'll take a look at it. Re: How to handle the error "Object reference not set to an instance of an object" 14 Years Ago by Ramesh S The OrderedItemTable may not be initialized. I believe that you are instantiating OrderedItemTable in the following line in initialize() method. [code] OrderedItemTable = OrderedItemHandler.GetTable(fullSql) [/code] The above line may not return a DataTable and therefore OrderedItemTable is still not initialized. Therefore you … Re: Fetching values from database to textboxes in c# 9 Years Ago by johnrosswrock Try this.. SqlConnection Conn = new SqlConnection(Connection_String); SqlCommand Comm = new SqlCommand(Command, Conn); Conn.Open(); SqlDataReader srd = Comm.ExecuteReader(); if (srd.Read()) { textBox.Text = srd.GetValue(0).ToString(); } Conn.Close(); P.S:This just a example change it according to your … Re: Populate dropdownlist in formview 16 Years Ago by lance.stine This is a helpful thread. I thought that posting how you can save the value in the drop down list is appropriate. [CODE] 'VB 'Use ItemUpdating method to add the drop down's selected value 'before the data is saved Protected Sub FormView1_ItemUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewUpdateEventArgs) Handles … Re: Populate dropdownlist in formview 15 Years Ago by Daremo Thanks, great info on something that had me stumped before. Frank Re: MS SQL 2005 Trigger : Transaction Scope and Parameters 15 Years Ago by Ramy Mahrous [QUOTE]Is there an easy way to tell the trigger: If the action which causes you is rolled back -> role back you action? [/QUOTE] I think you determine that in the trigger you fire it after or before committing the action. read in triggers at MSDN.com second issue you can pass any values to trigger rather you should maintain the DB design to… Re: MS SQL 2005 Trigger : Transaction Scope and Parameters 15 Years Ago by wuz Thx, but 1) accessing the trigger sounds good, but cannot find any best practices in combination with transaction scope 2) "you can pass" you mean I cannot pass values to a trigger right? Sounds reasonable, but how can i achieve that the trigger inserts a certiain history comment. thx! Re: MS SQL 2005 Trigger : Transaction Scope and Parameters 15 Years Ago by Ramy Mahrous 1- I don't know really what happen if .NET SQLTransaction rolls back, but you can also develop a trigger to keep track on deleted items from Father, Mother, Brother tables. (I think this solution is a bit nice) 2- You can have a temp table in your database called current user, holds the user currently run the application and then whenever your … Re: Problem with ClickOnce deployment 14 Years Ago by G_Waddell The problem turned out not to be on the remote pc but rather in the way my SQL server was set up....... DOH! Re: Populate dropdownlist in formview 14 Years Ago by vyasdev2005 Thank You very much....It helps a lot........ Re: How to use ajax and jquery 13 Years Ago by robindell10 jQuery is a fast JavaScript Library.There are Very Best Features of jQuary is that HTML document traversing,event handling, animating, and Ajax interactions for rapid web development. jQuery is designed to change the way that you write JavaScript.This is also Client Side Script Language.Main achviment of the jQuary is It has two licnece MIT License… Re: How to use Ajax and JQuery together on same masterpage. 13 Years Ago by Andrey Luiz Oh man. Post the code on code-tag. Re: How to use Ajax and JQuery together on same masterpage. 13 Years Ago by Ankur_tces [QUOTE=;][/QUOTE] Now i have posted the code in code tag. Anyone can help me. Re: How to use Ajax and JQuery together on same masterpage. 13 Years Ago by Andrey Luiz Why not use only jQuery for do this? I can try. Re: How to use Ajax and JQuery together on same masterpage. 13 Years Ago by Ankur_tces But in my existing project I have already used the Ajaxpro2.dll on my Master page & thats working fine. So I can't remove it i must need that. along with ajax i have to use jquery. In my jquery script when instead of $ i have used 'jquery' keyword then jquery scripts are working fine but its effects are not working. Means when i write … Re: How to use Ajax and JQuery together on same masterpage. 13 Years Ago by Airshow Ankur, You will have to do some background reading. I would start here: [url]http://docs.jquery.com/Tutorials:Using_AjaxPro[/url] [B]Airshow[/B]