I m new to the MS Access, I m prone to the SQL Server Only. Can u plz explain the difference b/w[B][COLOR="Red"] Datasheet View & Design View[/COLOR][/B]. I have some idea,pls check it whether me right pr wrong. In design view,we have to specify by own datatypes & column names. DataSheet View is Create table by entering data. tell me one thing more,where is the Datasheet icon.

Member Avatar
Member Avatar
+0 forum 2

hey frnds, Firstly I pick the records from the databse into the DataGridView, Then I want that If we made changes to the records in the GridView & Click on Update Button, Changes are Reflected into the Datbase .Plz do reply back the ..

Member Avatar
Member Avatar
+0 forum 8

Hey frns I want to record the time that the application takes. I want that when i click on Start Button in label time starts from 00:00:00, & when we click on cancel button time resets to zero. I include system.diagnostics.stopwatch I just know start,stop & Reset methods are there.But i do not know how to use it,Can somebody frd me the coding............

Member Avatar
Member Avatar
+0 forum 5

Can Somebody plz tell me how to give the form ,a footer & header. I want to write in Heaer-REPORT FIRST But i m not getting how to type the text in Header & Footer, plz reply. Bydefault the user is able to resize the form,I also want that the user is not able to resize the form.

Member Avatar
Member Avatar
+1 forum 4

I have two pictureBoxes & two Panels. On PictureBox1_Click, I want that Panel2 is Fadeout & Panel2 is Fadein. & on vice-versa on PictureBox2_Click. I write the foll. code-- But with that code form is also fade in & fade out. [code] Private Sub PictureBox1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PictureBox1.Click FormFade("out") FormFade("in") Me.Panel1.Visible = True Me.Panel2.Visible = False Me.Opacity = 99 End Sub Private Sub PictureBox2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PictureBox2.Click FormFade("out") FormFade("in") Me.Panel2.Visible = True Me.Panel1.Visible = False Me.Opacity = 99 End Sub Private Sub FormFade(ByVal FType As String) Select Case …

Member Avatar
+0 forum 0

Hello frnds, i add the languages in combobox on form load,I want that suppose i select Hindi from the combobox, All the Projects text is converted to hindi...& so on. Can somebody help me,as i have no idea!!!!!!

Member Avatar
+0 forum 0

Suppose mine textfile contains the foll. records-- Sunday, July 13, 20086:29:55 PM^^1^^ritu Sunday, July 13, 20086:29:55 PM^^2^^ritu Sunday, July 13, 20086:29:55 PM^^3^^ritu Sunday, July 13, 20086:29:55 PM^^4^^ritu Sunday, July 13, 20086:29:55 PM^^5^^ritu Ion Form_Load,I want that in Combobox only date is picked. My code is as follows- Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim sFilename As String Dim sFileReader As System.IO.StreamReader Dim sarr() As String Dim sInputLine As String sFilename = "C:\test.txt" If Dir(sFilename.ToString) <> "" Then sFileReader = System.IO.File.OpenText(sFilename) sInputLine = sFileReader.ReadLine() Do Until sInputLine Is Nothing sarr = Split(sInputLine, "^^") Me.ComboBox1.Items.Add(sarr(0)) sInputLine …

Member Avatar
Member Avatar
+0 forum 1

hey frnds i want to know that how to add Textbox entry into the dataGridView. Suppose I have DataGridView with two Columns- First Column--name Second Column--marks. On the Form-- I have a Combobox ,Two Textboxes ,Button,Gridview. User select roll from combobox,Suppoes he Select Rol number 1 ,I want that on button click Name & marks of Roll Number 1 are added to the DatatgridView.

Member Avatar
+0 forum 0

Hey frnd tell me that in Vb to scan a registry we define our own function. In Vb.Net to scan a registry we define our own function or using the inbuilt function,it can also be done?? Plz give me some steps from where to start??????????? I m not getting it,how to scan a registry........ I want to know how to have Registry keys into the combobox on the form_load automatically.

Member Avatar
+0 forum 0

I try the foll. code--- protected void Button1_Click(object sender, EventArgs e) { int i; for (i = 0; i <= ListBox1.Items.Count - 1; i++) { ListBox1.Items.Remove(ListBox1.SelectedValue.ToString()); } } But it's not working.

Member Avatar
Member Avatar
+0 forum 3

I have three labels & three textboxes on the form, I bind the data to the textboxes using DATA FORM WIZARD & Binding Navigator to naviagte thru the records. Suppose if i do any changes, I also want to update in the database. I drag one button on the form & write the foll. code-- [B]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Me.Bank1BindingSource.EndEdit() Me.Bank1TableAdapter.Update(Me.YogeshDataSet.bank1) End Sub[/B] [COLOR="Red"][B]ERROR IS THERE IN THE ABOVE CODING.[/B][/COLOR] Bank1 is the table name in the dataset & Yogesh is the database name dats y YogeshDataSet

Member Avatar
Member Avatar
+0 forum 1

Hey frnds, I know about Ctype?? Please forward me what is Directcast,Cz i hace faced this question in Interview.Difference B/w the aboce two???/

Member Avatar
Member Avatar
+0 forum 1

What is @@rowcount and with small code snippet explain the usage? Is the foll. code is rite-- Create procedure get_emp_count ( @emp_id int) As Select * from emp where emp_id =@emp_id If @@rowcount = 0 Begin Select 'no rows with emp_id= ' Select @emp_id End . Can u pls explain the above code.

Member Avatar
Member Avatar
+0 forum 1

I know only three differneces. [B]1)[/B] ADO wroks on Connected architecture, while ADO.Net on DisConnected Architecture. [B]2)[/B]ADO is used to create Client Side Cursors while ADo.net create both client as well as server. [B]3)[/B]In ADO,data is converted before transmitted whike in ADO.Net no transformation takes place. IF FRNDS U KNOW DIFFERENCES OTHER THAN THESE PLZ DO REPLY.

Member Avatar
+0 forum 0

steps i Follow- 1) Go to Control panel-->Admintrative Tools-->Double -click Data sources(ODBC)-->click Add button-->I choose SQL server(last option), Is it right or wrong option for connecting to SQL 2000.Then a new screen appears Create a New dataSource-->in name textbox,we can write anyname--Right or wrong. suppose i enter sonia, & my server name is .,so I enter . in server & click next button-->On the Next screen i have checked the option With Sql server authentication-->Login Id-sa, Password-->Blank-->Click next button-->Next-->Finish-->Then I click on button Test Data source-->Mesage Comes TESTS COMPLETED SUCCESSFULLY-->OK-->OK-->Ok. These steps we have to do or not for Connectivity …

Member Avatar
Member Avatar
+0 forum 29

In Vb we can connect to all the databases like SQL 2000/SQL 2005,Oracle,Access. Out of the given databses we can connect to which databases. Secondly,told me dat if I want to connect to SQL-any version(2000/2005), To connect to the database i go to Control Panel-->Admintrative Tools-->Data sources(ODBC)-->ODBC Data source Administrator Screen cones,4m which I click on ADD Button--> Now tell me to coonect to SQL,From CREATE NEW DATASOUCE, which option I have to choose. Plz Reply early,Its urgent.

Member Avatar
Member Avatar
+0 forum 7

[code=sql]CREATE TABLE Persons ( FirstName VARCHAR, [Last Name] Text, Gender int, [Date Of Birth] DateTime, MaritalStatus Integer, IsMarried Bit, PersonalIncome Money, HouseholdIncome Currency );[/code] Can u plz tell me where I have to write this Query in MS-Access to craete the Table.

Member Avatar
Member Avatar
+0 forum 4

[B]FIRST EXAMPLE--[/B]CREATE FUNCTION dbo.myFunction() RETURNS INT AS BEGIN DECLARE @myInt INT SET @myInt = 1 RETURN @myInt END select dbo.myFunction() as 'Simple Number' This Function is not returning any value,Error is coming [B]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.myFunction", or the name is ambiguous.[/B] [B][COLOR="Red"] SECOND EXAMPLE--[/COLOR][/B] create function dbo.add1(@num1 Int,@num2 Int) Returns INT as Begin Return(@num1+@num2) End select dbo.add1(10,20) as result Above function is working fine,but dbo is optional IF I write the above Function without dbo create function add1(@num1 Int,@num2 Int) Returns INT as Begin Return(@num1+@num2) End select add1(10,20) as result Then the …

Member Avatar
Member Avatar
+0 forum 2

HI, I have made a menu with two menu Items Colors Size. Colors will further have the submenu Items--> FillColor Exit FillColor will further have-->Red,Green,Blue Size --> Small , Large If i write the foll. code--> [B]Private Sub Form_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) If Button = 2 Then PopupMenu mnuColors End If End Sub[/B] When we right click on the form, it shows PopUpMenu FillColor Exit. [B]But as u right click on The form in the Client Area, Its hows ViewCode MenuEditor[/B] But I want a PopUpMenu that shows FillColor & small, Is …

Member Avatar
Member Avatar
+0 forum 14

Is Debug Window same as Code Window?? Code window--where we write the code. Debug window--????

Member Avatar
Member Avatar
+0 forum 4

I know how to connect to crystal Report Feature in Vb.net? Is there cryatal Report Feature in ASP.net also? If yes,steps are the sane as in Vb.net? If not, Plz Send me the step by step Procedure.

Member Avatar
+0 forum 0

The End.