Part 2 of 5: Retrieving Data from SQL Server using C# and ADO.Net

[Junaid7671]

I do the same thing which you are doing in the video .It show the form data on form when i press show button.But form data is not insesrted in the database

[Dynamiite123]

I think you're going a bit to fast. It would be nice if you stopped and explained what you just did.

[shiva3927]

thank u sir

[imans111]

hello can anyone tell me how to fetch a image in database

[mooresorem]

Thank you so much for sharing your knowledge regarding C#. All your videos present the material in such an easy-to-understand, step-by-step format. Again, THANK YOU!!!

[Chidoryany26]

I like you to do YOUR VIDEOS IN SPANISH

ARE REALLY GOOD BUT I LIKE

[BablioBr]

@Chidoryany26 Maybe I could do the videos in Portuguese, but I do not know Spanish.. :]

[RiKKuXd28]

How can I retrieve data and display it in textboxes not dataset. How? (for exampling retrieving name from sql and saving it in a variable?)

Thanks

[skptumpa]

why show SQlException Unhandeled

[skptumpa]

why show SQlException Unhandeled

[Alexhoanghtd]

what about a stand alone program, but i want a sql database on it :-/ just use this thing? so what if I run this program in another computer, will it work?

[maintetoec]

is this work for pictures display?

[kingx2000]

How would it be if i want add a informacion to a textbox

[ChampikaNirosh]

I think dealing with enterprise level requirement is much easier with Rocket Framework. That allow you to develop form based application very fast.

Check it at CodePlex... or else just google for Rocket Framework for Windows

[fatcrewz]

Hey if i want to create connection string in separate class, how I can do that thanks.

[carlnathan]

the best and most straight through

[worktosser]

I gave you a thumbs up Bab. Your code screen was readable. I know that it is a quickie beginner tute, so I won't be too critical of the 'bad habit's part ;) - you did use parameter.add(). If you want to know what I mean by 'bad habit' I mean Table[0] vs. Table["name"]. But by all means keep bringing the knowledge on.

[karlinoDS]

Yes, I strongly agree. But I heard that ther will be 2 platform, WP7 and WMobile? I really want to be clear on that issue. They say that W mobile will be used in business then WP7 is for consumers.

BTW thanks for the tutorial, on VC# I am using VS2010, and it works well. I had previous training on VC# 2 years ago but I cant understand.

But with your way of teaching I easily catch up. again thanks

[karlinoDS]

Hello BabiliBr, Do you have a device application development tutorial. I want to learn about database programming in mobile devices (on windows mobile 6). Thanks

[BablioBr]

@karlinoDS If you are just getting started on mobile devices, I recommend checking out the Windows 7 for mobile phone. Thats what's hot now day. If you take time learning Windows Phone 6.5, you will fall behind. Google Windows Phone 7... You will not be disappointed. It's all Silverlight and XNA 4.0 :D

[ChampikaNirosh]

@karlinoDS I think dealing with enterprise level requirement is much easier with Rocket Framework. That allow you to develop form based application very fast.

Check it at CodePlex... or else just google for Rocket Framework for Windows

[adapass]

Hi bablio,

I am a beginner to c# programming. Accidentally i came across one of your tutorial in the google,. I have never seen such an excellent tutorial for c# in my career. I was quite amazed with the way you present each and every topic in c# with a sample windows application.

I would like to have a tutorial on 3 tier architecture in c# with a sample windows application which communicates with the sql database.

I am very eagerly waiting for that tutorial.

I hope you will post it.

[BablioBr]

@adapass I should definitely get something like that started.. I sounds like it would be very informative... Let see what I can come up with.. I working on a tutorial about Delegates and Events currently. Thank you for watching.

[james9anderson]

great job sir :)

[james9anderson]

great job sir :)

[snssamir]

simplest n best way of teaching... gr8 job ... thanks alot...

[vito6000]

Tus videos me ayudaron Thank you

[guitarfather]

You're good and your videos are helpful :)

[MsCodex11]

hi BablioBr,

Your videos are really great and helpfull

Plz can u upload a video's relating to data add, update, save, and delete using VB.net and Sql Server 2008

[Rasputin881122]

Really Good!!!

[gaganchahal13]

gr8 wrk ..keep it up

[qubec3]

cool cool vid

[ahsanabbas2000]

Hi Babliobr,

I am really thankful to you. Your tutorials are very helpful. Can you send me a tutorial please which shows how to match data from sql server using c-sharp forms.

[ahsanabbas2000]

I am a new developer at C-Sharp, I am learning through your tutorial and thanks for that it is very helpful. Currently I am stuck on an issue. I want to match value from the database. On form I have two field one is login id and the other is password I want to match it to my sql server table "security". In security table there are two columns loginid and password I want to match them with my forms field login and password. I just don't the syntax how to match them. If anyone can guide please.

[ahsanabbas2000]

I am a new developer at C-Sharp, I am learning through your tutorial and thanks for that it is very helpful. Currently I am stuck on an issue. I want to match value from the database. On form I have two field one is login id and the other is password I want to match it to my sql server table "security". In security table there are two columns loginid and password I want to match them with my forms field login and password. I just don't the syntax how to match them. If you can guide me please.

[SteveCrank]

you look like Mr.Bean :D :D

[AndreLopesBrasil]

youre the best!!!!

great tutorials

dont stop doing more tuto

thank youu

[niharika1986niharika]

Hi,

Thanks a lot for the video.

This video really helped me to develop one whole application for one of my projects.

[robdane1]

Another Great Video this really deserves 5 Star

[rajeshkota]

sorry 'm new to programming but, what does this ds.tables[0] will do? i tried to change it to 2 to see but its giving me an error. also you said something about returning values in ExecuteNonQuery. what is that? sorry if these doubts are silly.

[rajeshkota]

great video. can you sort related videos and make them as a play list please?

[spiderboy108]

great, thanks man!

[rhetherington123]

Best source of C# videos that I have found for beginners. Thank you for your contribution

[siryasir]

i am new to c sharp but watching fabio's lectures i feel pretty comfortable in programming stuff it's awesome!

[ralpyka]

Hi

First of all sorry for my english.

I viewed your videos, but I didn't found my answer.

How can I put a record to a string that I should be able to process it later?

[cuteo408]

BablioBr, you know would be great for the next one ? BindingNavigator (paging) !

Where you can show # of records per page. Nice tutorials !!

[avery1555]

Hey BabiliBr, when are the rest of the C# tutorials :D

[BablioBr]

What do you want the tutorial to be about?

[avery1555]

Well, I think this could be answered in a response actually, but it may be good for a video, but...

Whenever I use and define a string variable, and then use an if statement, such as...

If(stringvar = "test") then...

I get an error that sais "String cannot be converted to bool."

Just wondering how I do "if" statements with strings?

[xleo21]

it should be :

If(stringvar == "test)

in c# you must use ==

= is just for boolean

[kapafamily]

@BablioBr :

i have a question? what if you add the same name? i try to add the sam name but it will save. i want that it will not be save in my datagridview? hope you will give us tutorial?