Answered by:
need help creating a DB connection in my DAL class file.

Question
-
User-2015678876 posted
Below is my class file.
using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; namespace AutoPilot { public sealed class TblZipCode { #region Fields private string zIP_CODE; private string pREF_CITY_STATE_NAME; private string sTATE_ABBREV; private string sTATE; private string sTATE_FIPS; private string cOUNTY_NAME; private string cOUNTY_FIPS; private string zIP_CLASS_CODE; private string cARRIER_ROUTE_RATE; #endregion #region Constructors /// <summary> /// Initializes a new instance of the TblZipCode class. /// </summary> public TblZipCode() { } /// <summary> /// Initializes a new instance of the TblZipCode class. /// </summary> public TblZipCode(string zIP_CODE, string pREF_CITY_STATE_NAME, string sTATE_ABBREV, string sTATE, string sTATE_FIPS, string cOUNTY_NAME, string cOUNTY_FIPS, string zIP_CLASS_CODE, string cARRIER_ROUTE_RATE) { this.zIP_CODE = zIP_CODE; this.pREF_CITY_STATE_NAME = pREF_CITY_STATE_NAME; this.sTATE_ABBREV = sTATE_ABBREV; this.sTATE = sTATE; this.sTATE_FIPS = sTATE_FIPS; this.cOUNTY_NAME = cOUNTY_NAME; this.cOUNTY_FIPS = cOUNTY_FIPS; this.zIP_CLASS_CODE = zIP_CLASS_CODE; this.cARRIER_ROUTE_RATE = cARRIER_ROUTE_RATE; } #endregion #region Properties /// <summary> /// Gets or sets the ZIP_CODE value. /// </summary> public string ZIP_CODE { get { return zIP_CODE; } set { zIP_CODE = value; } } /// <summary> /// Gets or sets the PREF_CITY_STATE_NAME value. /// </summary> public string PREF_CITY_STATE_NAME { get { return pREF_CITY_STATE_NAME; } set { pREF_CITY_STATE_NAME = value; } } /// <summary> /// Gets or sets the STATE_ABBREV value. /// </summary> public string STATE_ABBREV { get { return sTATE_ABBREV; } set { sTATE_ABBREV = value; } } /// <summary> /// Gets or sets the STATE value. /// </summary> public string STATE { get { return sTATE; } set { sTATE = value; } } /// <summary> /// Gets or sets the STATE_FIPS value. /// </summary> public string STATE_FIPS { get { return sTATE_FIPS; } set { sTATE_FIPS = value; } } /// <summary> /// Gets or sets the COUNTY_NAME value. /// </summary> public string COUNTY_NAME { get { return cOUNTY_NAME; } set { cOUNTY_NAME = value; } } /// <summary> /// Gets or sets the COUNTY_FIPS value. /// </summary> public string COUNTY_FIPS { get { return cOUNTY_FIPS; } set { cOUNTY_FIPS = value; } } /// <summary> /// Gets or sets the ZIP_CLASS_CODE value. /// </summary> public string ZIP_CLASS_CODE { get { return zIP_CLASS_CODE; } set { zIP_CLASS_CODE = value; } } /// <summary> /// Gets or sets the CARRIER_ROUTE_RATE value. /// </summary> public string CARRIER_ROUTE_RATE { get { return cARRIER_ROUTE_RATE; } set { cARRIER_ROUTE_RATE = value; } } #endregion #region Methods /// <summary> /// Saves a record to the tblZipCode table. /// </summary> public void Insert() { } /// <summary> /// Selects all records from the tblZipCode table. /// </summary> public static List<TblZipCode> SelectAll() { return tblZipCodeList; } } /// <summary> /// Creates a new instance of the tblZipCode class and populates it with data from the specified SqlDataReader. /// </summary> private static TblZipCode MakeTblZipCode(SqlDataReader dataReader) { TblZipCode tblZipCode = new TblZipCode(); if (dataReader.IsDBNull(0) == false) { tblZipCode.ZIP_CODE = dataReader.GetString(0); } if (dataReader.IsDBNull(1) == false) { tblZipCode.PREF_CITY_STATE_NAME = dataReader.GetString(1); } if (dataReader.IsDBNull(2) == false) { tblZipCode.STATE_ABBREV = dataReader.GetString(2); } if (dataReader.IsDBNull(3) == false) { tblZipCode.STATE = dataReader.GetString(3); } if (dataReader.IsDBNull(4) == false) { tblZipCode.STATE_FIPS = dataReader.GetString(4); } if (dataReader.IsDBNull(5) == false) { tblZipCode.COUNTY_NAME = dataReader.GetString(5); } if (dataReader.IsDBNull(6) == false) { tblZipCode.COUNTY_FIPS = dataReader.GetString(6); } if (dataReader.IsDBNull(7) == false) { tblZipCode.ZIP_CLASS_CODE = dataReader.GetString(7); } if (dataReader.IsDBNull(8) == false) { tblZipCode.CARRIER_ROUTE_RATE = dataReader.GetString(8); } return tblZipCode; } #endregion } }
Wednesday, February 17, 2010 5:01 PM
Answers
-
User48953143 posted
you need to make a class DALHelper that have a GetConnection Function.You Just need to call this function to get the connection.class is follwing
Imports System.Data
Imports System.Data.SqlClient
Public Class DALHelper
Shared Function GetConnection() As SqlConnection
Dim ConStr As String
ConStr = "data source=SererName;initial catalog=DataBaseName;user id=UserName of Sql Server Usualiy sa;password=That you set"
Return New SqlConnection(ConStr)
End Function
End Class
here is use of above class.you can use above class anywhere in codebehind file of your form or any one class.
Dim con As New SqlConnection
con = DALHelper.GetConnection()
Dim cmd As New SqlCommand("select * from Table", con)
Dim dr As SqlDataReader
con.Open()
dr = cmd.ExecuteReader()
While dr.HasRows
Dim Name As String = dr("ColName").ToString()
'' in the same way you gat all your data and save them in variable or in object of your own class
End While
con.Close()
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, February 18, 2010 7:01 AM