Follow Me via SMS for FREE

hi, If you want to receive free daily updates and notification from SSUET you can subscribe me for free
Write follow SSUETHelp and send it to 40404
And you can continue receiving Free Updates..

[RDBMS] Sessional Marks - Batch: CE-C-2010 - 5th Semester

. Friday 25 May 2012
0 comments

Download List of RDBMS final sessional marks of Section C batch 2010, 5th semester

Teacher:Sir Khalid

DOWNLOAD:
https://docs.google.com/open?id=0B_yd5IHVaMCRWjRlRDM4YWJYNVk

[Tutorial][VB.Net/MsSQL] How to connect and perform Insertion using MsSQL in VB.net Windows Application?

. Friday 11 May 2012
0 comments

To connect with MsSQL server you need to call some libraries which contains information regarding db connection and execution

1) Call these two libraries at top of the coding page
Imports System.Data
Imports System.Data.SqlClient



2) Now we have to initialize some of our server detail to initialize our connection with our database.

Add this code in your main class of your form and modify it according to your database details.

Dim connstring As String = "Data Source=.;Initial Catalog=sxeInventory;Integrated Security=True"
Dim conn As New SqlConnection(connstring)


Where Data Source=.; automatically gets the default server name and Initial Catalog=sxeInventory; refers to the name of database

3) Now inserting records from user controls i-e Textbox, ComboBox etc.

I assume a form having following fields


Now After creating your form, Double click on the button on which you want to perform insertion.

Modify Insert Query according to your columns  in database.

Try
            conn.Open() 'Opening the connection to perform SQL Queries

            'Performing an Insert Query to INSERT data into db using USER CONTROLS
            Dim command As New SqlCommand("INSERT INTO sxe_Products ([sxe_pName],[sxe_pDescription],[sxe_pCatId],[sxe_pPrice],[sxe_pCompanyID],[sxe_pDateAdded])" &
                                          "VALUES('" & Me.txt_pName.Text & "','" & Me.txt_pDesc.Text & "','" & Me.ComboBox2.SelectedValue & "'," &
                                          "'" & Me.txt_pPrice.Text & "','" & Me.ComboBox1.SelectedValue & "','" & DateTime.Now.ToString() & "')", conn)

            'Finally Executing Insert Query in a IF fuction!
            'If Successfully EXECUTED then show MSG.
            If (command.ExecuteNonQuery()) Then
                MsgBox("Product Successfully Added!", MsgBoxStyle.OkOnly, "Added")

                clearFields()

            End If

            conn.Close() 'Closing the Open DB Connection


        Catch ex As Exception
            'If exception occured it will be show in a MsgBox
            MsgBox(ex.Message)

        End Try


All set..  Run.! Hope it will work, For any issue feel free to ask me.. :)

[VB.net/MsSQL] Inventory System Project for RDBMS and Software Engineering

. Thursday 10 May 2012
4 comments

Inventory System Project for RDBMS and Software Engineering,

Source code is fully provided, I haven't completed it yet, I am sharing the source code because many of the student requested me for it.. so enjoyyy :D :P

I will write a proper tutorial to teach you guys about the coding..

Read the READ ME and Installation File Please to RUN the solution..

 

DOWNLOAD

SOLUTION/SOURCE CODE:
http://www.mediafire.com/?libgm86jp67abn0

DATABASE:
http://www.mediafire.com/?yu1ig8wbb2wnu51

Say Thanks :P

Source Code rights are reserved!

[VB.Net/MsSQL]Open Source Inventory System for Programming and RDBMS project.

. Saturday 5 May 2012
0 comments



Here is a snapshot of Inventory System I am working on for my project of RDBMS,
User can add, delete, update and Search products, Two type of user Types, 1) Admin 2) Sales Man
Admin will have all privileges to manipulate data, Other then Sales Man can just sell products and cannot change any info of any product.


After completing it in a day or two, I will upload the source code.. :) 

SSUET Student Portal Website Under developement - Update & Features

.
0 comments

This is a new conceptual website that i m working on for SSUET, Check it out and do tell me what do you think about it, It will consist of a User Portal from where students can download their notes, software, and can also submit their forms(admit card, marksheet etc) online, and student can also submit their assignment directly to their teachers online.. Daily update of attendance and class marks will be on the site.. 










RDBMS Project Detail Submission for CE5C-2010

.
0 comments

Last Submission date:May 07, 2012

RDBMS

Project Detail Submission

Project Name

Project Details

Members Name

Write with your roll number, for eg ( Shayan Abbas - CE-10-143)
Write One Name in a LINE

Note: Once Submitted, Then it could not be Changed! so fill Carefully :)