154 thoughts on “Demo Tables”

    1. hai sir gd evng,
      Am your sql server previous 11 am batch student please reply to these below questions sir.
      1.How you will give data in to particular position.
      2.suppose i have 1000 bytes can you insert in particular position.
      3. In one table we have 20 records if we want to show row numbers how will you do.
      4. Data type of auto generated column and how these auto generated columns generated.
      5. can we write two primary keys in table.if yes how?

  1. Sir I have interview on Friday in Mumbai. Sir please tell me that how to prepare for the interview on the basis of .NET, SQL SERVER 2005.

    Because this is my first time to face the interview as well as on the .NET OR SQL SERVER 2005 . Please suggest me something because I have two days left for the Interview. I can Prepare as per ur guidance. I am one of ur student n have completed SQL SERVER 2005 from u “DB11CLASS”. And I am now Attending ur “VB5CLASS”.

    Sir please suggest me becoz one of my friend working in the same company recommended me so i need ur suggestion so as to succeed in the interview.

    please sir help me out

    keep me suggested forever……………….

    KEEP SMILING FOREVER……………………

    1. Hi…….. sir
      I am u r .Net student
      sir please help me how to prepare screening test,that is conducted on 6 july.
      i am completed my b.tech in 2013.

  2. Sir I have an interview on saturday in wipro.
    Please tell me how to prepare for the interview.
    Which type of questions are given in analytical round.

  3. Sir
    i am learnig .net in cuurent batch.your way of teching and introducing concepts is excellent.can u please guide regarding types of certifications in .net and how to prepare for that(corse material etc)

  4. sir
    I have an interview on fri
    Please tell me how to prepare for the interview.
    Which type of questions are given in analytical round.

  5. Sir,
    My name is Anuradha, I am from Guntur , I came to Hyd in January , . I have completed my M.Sc Mathematics in 2005 from then i am working as a lecturer in Guntur Hinducollege, I want to change my profession because of some reasons as early as possible. So at first I started VB.Net Class by you , at that time i am working as a jr.Lecturer in Narayana College, SR.Nagar., My brother suggested me “first you complete one because you are non computer background” , So i completed VB.Net , Later i resigened in Narayana becuase the the timings are not available to learn A.S.P .net and C#.net , then I attended fasttrack batch of Mr.Sureshnaidu Sir for Asp and C#, but i want to learn more subject so i have taken break and i am going to nagaraj sirs Asp and C# .net classes, sir i want to get a job with 2+exp how to prepare and how to get job please suggest me sir,

  6. hii sir.
    now i am attending 2 ur vb.net cls.
    this sunday is my last cls for vb.net.if i take 5 months of gap for c# there will be any problem for me?coz my college is going 2 start from 23.so i cant come for c# classes.i will come after 5 months for coaching that 2 for ur class only.suggest me sir.

  7. hai sir, we r attending ur class in morning session,at that time your way of teaching is good.
    But, so many Students are not catching ur points while you are sitting on the chair, so plz stand and tell. Many students r like u in that way only(that is explain on the board).
    thanking u sir,
    this is your “students opinion”.

  8. sir i have a doubt.can u please clarify it..NET is a platform independent but the .NET development is possible only on windows but not on any other o.s.we can write programs also in windows only.so how can we say .NET is platform independent

  9. hi praveen
    if u have any doubts mail to sir at “m.bangarraju@gmail.com” he will definitely clarifies ur doubts,like u may specify the email adress or not while u r submitting a comment that’s why,and our sir also shows much interest in clarifying our doubts,so just do that u will definitely get a reply frm him,bye(i am also a student of sir)

  10. I am doing a project on .net Payroll management.i want code to generate payslip for all the employees in single click by using crystal report.I done for single payslip,but i want code generating payslips for all the employees in single click,plz sir tell me the process&code

  11. Hi sir,
    I had completed mca,also i had completed .Net Course,I have interested to dolab-coordinator or in small institute as a faculty for .NET.Please What can do this for solution?Please Suggestion to me..Sir
    Thank you sir

  12. Hello sir,
    Thank you for providing the content regarding various technologies on website. This is providing transparency over the subject.

  13. hello.. Friends
    i m using sql server 2005 , i have table contain a field named Currency Symble type varchar , i have to insert Currency Symbol into my data table ? how i have to insert Currency Symbols ..

  14. hai sir
    ur teaching is very good.i am ur evening sqlserver batch student completing sql server tommorrow. i am form different background but after ur classes i am cofortable in learning .net.u known me sir.but not with name.
    thank u sir

  15. respected sir
    how r u?
    i want to clarify a doubt based on asp.net
    i have two dropdownlist controls, in one dropdownlist countries will be displayed and in second dropdownlist states will be displayed based on selected country. but ,while displaying states the page was refreshing . how to stop page reloading (refreshing) while displaying states

  16. Hello Sir,

    I need a small favour from you.Actually when I was coming to your classes you gave this site address and told to download the SQL SERVER Ebook.I downloaded it and it was very useful.But I lost the link now.So please send the link to my mail Id so that It will be very helpful for me.Hope I get response soon from you.

    Thanks in advance sir.

  17. sir,
    i have doubt in sql server.ie
    What I want to do is to drop the Street,city,and postcode fields and add the following: fax,email,and phone.

    Is it possible to use the following command:

    Alter table customer
    Drop column street,city,postcode

    Or should I do as following:

    Alter table customer
    Drop column street

    Alter table customer
    Drop column city

    Alter table customer
    Drop column postcode

    And the same goes to adding the phone,fax,and email field.
    Thank You.

  18. Hi sir, I’m attending sql server classes in the evening batch i.e., 7:30pm. The classes are exemplary and more than this I cant say anything. and why I’m sending this post is, actually I came from bhimavaram(W.G.dist). I’m studying MCA there. I have to go july 20th to college. so, my request is, please complete the course as early as possible and that too considering all the people in the class. plzzzzzz

  19. good morning sir,
    july 20 i hve an interview in wipro.pls tell me sir how attend the interview n wht type of questions they were asked.i complete my .net course sir.pls tell me sir hw to attend the interview?

  20. hello sir
    you are only the second teacher i had ever seen by your teaching style.
    i had completed my B.E. & i am now a student of your batch of 6 pm & 7:30 pm batch.

    thanks

  21. hi sir,i am kumar one of u r student.i have one doubt.
    how to write union all using two strings but not two queries.

    Example.
    declare @a as varchar(1000)
    declare @b as varchar(1000)
    declare @c as varchar(2000)
    set @a=’select * from emp where dept no=10′
    set @b=’select * from emp where deptno=20′

    now i want to do union all the above two strings

    i wrote like this

    set @c=@a union all @b
    exec(@c)
    but it was giving an error like
    incorrect syntax near UNION.

    why i am asking this question is i have 500 lines of code in each string .so that i stores the query’s in strings and then i do the union all these strings.

    plese send replay me sir,now i am in onsite at bhuvaneshwar,Orissa.

  22. I’m not able to connect with SQL Server 2005. So please help me..
    Erro Message is

    TITLE: Connect to Server
    ——————————

    Cannot connect to Krishna.

    ——————————
    ADDITIONAL INFORMATION:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

    ——————————
    BUTTONS:

    OK
    ——————————

  23. hai sir
    hru sir
    i have one doubt plz answer me sir
    y should we decalre main block as static block.
    plz response me sir
    and i have another doubt sir that is in singleton model
    “how long the object will be reside in server ”
    plz give me answer sir
    i hope u will be answer me
    bye sir

  24. Hi sir i think u r fine.
    i am not a u r student but i did read u r story in website. present i did my b.tech i am a fresher but i have less percentage plz give me any suggestion sir bye sir

  25. Hi,sir
    how are u? this srinivas from hyd.Iam attending your class in evening sessions for C#.your teaching is so effective sir.But we are unable to write the notes.b’coz chairs are so cunjustive.so try to teach the notes slowly sir.it’s my humble request.By Sir
    your’s obediently’
    srinivas

  26. Sir I am from Orissa n contnuing ur c#.net morning 7.15 batch.I’ll pass out this year(in 2010) & Very much tense about da job openings in Hyderabad.Please intimate me about that to my mail.

  27. Hi Sir I have 2 questions on database part.
    1.How can I find out duplicate records from a table in oracle aswellas sql server?

    2.How can I find out last N records from a table in sql server aswellas oracle?

  28. Hi sir this is janardhan.i am completed my MCA in 2009 i have good knowldge on MS.NET.completed in Naresh,but i have low percentage in 10th,pls give me any suggestions to me.

  29. hi sir,

    this is a favorite student about you… .NET in NIT means that is becoming bangarraju…
    these ar not my words.. many students are saying with me like this….
    hats off with my regards….

    your’s obediantly,
    srinivas.malleboyina.
    9951852335.

    i want to be as a good student of u….

  30. hi sir,
    i never seen people teaching like u sir. your teachings are very involving in subject.u always try to make understand the concept.

  31. Hello Sir,
    I am getting an error in my site
    and i am unable to resolve it.
    if possible please can u help me out..
    Please reply…
    the error is..
    “The type initializer for ‘System.Data.SqlClient.SqlConnection threw an exception”

  32. hai sir….
    this is surya narayana reddy

    sir i want sql server2005 instalation process

    plz send me that document
    thankyou sir….
    bye

  33. Sir i am working on user controls concept and i am getting the following error:

    ‘ControlsProject.Address’ does not contain a definition for ‘textBox1_TextChanged’ and no extension method ‘textBox1_TextChanged’ accepting a first argument of type ‘ControlsProject.Address’ could be found (are you missing a using directive or an assembly reference?)

    Pls tell me the meaning of this error

  34. Dear Raju in my recent interview i have faced this questions and please answered for this

    1. Stored procedure Optimizing Techniques.?

    2. In a login page i have entered my credentials(user id & password) into my application and logined successfully.
    after this in different machine same application i have entered my same credentials after submitting ,user already exist
    message will be come. How to do it?

    3. How to count number of same strings in a text file?
    Ex: How many Raju there in file.

    4.How to handle critical section in c#?

    5.How to come intellisence automatically come in visual studio?

    6. How to perform Query Tuning?

    7.how to count number of visitors visited your website?

  35. Hello Sir,

    This is phani your last years student. I have downloaded the wpf sample from your site. How to run the app.Only AnimateRectangle page is coming how to change the startup object.

    Thank You,
    S.Phani kumar

  36. sir……
    i have one problem …..
    i want to add the values of two text boxs and i want to put the result value in third textbox………..then how to write this ……….

  37. Hi Sir,
    I was one of your students.
    You trained us very well. Now I am working as a software engineer in hitech city. In our company they are using MSBI. So I want to learn MSBI also.So, Could please suggest a good book for MSBI to read.
    (OR)
    Is there any other way to learn MSBI?
    I hope you will reply back to me. My email id is gbhanu56@gmail.com

    Thanks &Regards,
    Bhanu.G

  38. Hi sir, how r u? ur way of teaching is very exellant, sir, i need some guidance from guidance, actually i am 2007 Passout(MCA),i am not able to decide, how many yrs of exp. shall i keep in my resume, plz tell me how 2 prepare for project. don’ t ignore, plz give reply as early as possible

  39. Hi sir, I have one doubt regarding access specifier of main, why we should declare main() as static? and why we use public as access specifier to main() please tell me.

  40. i m your csharp8 batch student..
    thanks for giving me this kind of knowledge…your teaching style is really best.actually i don’t have word to express my things.
    currently i m working in EXA india pvt ltd. and all credits goes to only you.
    thanks a lot sir

  41. sir,im ur old student,i tried example which is given by u,i.e
    image save to DB and retrieving from DB i am saving image to DB successfully,but while retreiving the image ,i am getting error as “parameter is not valid”.
    i wrote the program as u given,and i tried diff ways also..pls help me sir,i need this task…Thank u in adv

  42. sir ,i am working in prayog labs.here they are giving student projects to develop.i hope this oprtunity to utilize.
    can u suggest me to do this job or not?

  43. Good Evening sir,

    Could u clarify my doubt… If i prepare an application for a client, then what files i supposed to give to them whether dll file or exe file?

  44. hello sir i have wiriten a stored procedure but it is very much slow in execution… sir please help me.. is this very wrong manner to write a sp??.
    what can i do for get result like that and fast?

    CREATE proc [dbo].[Sp_CategoryToVendorAnalysis]–10,”,”
    @CategoryId int,@fromDate varchar(50),@Todate varchar(50)

    as
    ——————————————————
    – Author: Anand Singh Sengar
    – CREATE date: 24-feb-2011
    – Description: get information For Category Analysis
    ——————————————————
    if(@fromDate=” and @Todate=”)
    begin
    set @fromDate=’2009-09-16 15:12:45.000′
    set @Todate=GETDATE()
    end

    —————-vendors and total products————————————–
    select x.displayname as [Vendor Name],isnull(subct.totsubcat,0)as [Sub-Categories],isnull(y.TotalProduct,0) as [Total Products],isnull(act.activeProduct,0) as [Active Products],isnull(Inact.INactiveProduct,0) as Inactive,isnull(totorder.TotOrd,0)[Total Or
    der],ISNULL(TotComplain.TotComplain,0)[Total Complain],(isnull(y.TotalProduct,0)-isnull(sold.sold,0)) as Unsold,isnull(sold.sold,0) as Sold,isnull(sold.Totalsoldamt,0) as [Sold Amount] from(

    ————————————–All Vendors——————————-
    select distinct a.DisplayName,p.VendorID from AdminUsers a,products p where a.AdminID=p.VendorID and CategoryID=@CategoryId and p.AddedOn>=@fromDate and p.AddedOn=@fromDate and p.AddedOn=@fromDate and AddedOn=@fromDate and AddedOn=@fromDate and AddedOn=@fromDate and AddedOn=@fromDate and o.OrderDate3
    and pp.ProductID=p.ProductID
    AND OD.Remark=1 and od.CategoryID=@CategoryId
    and od.orderid=o.orderid
    and o.IsPaymentReceived=1 AND o.IsCancelled=0 and o.OrderDate>=@fromDate and o.OrderDate=@fromDate and p.AddedOn<=@Todate
    group by p.vendorid

    ————————————————
    ) Sold on x.VendorID=sold.VendorID

  45. i have posted my sp above but i m not able to paste whole sp. i dont know why… so please give me ur mail id please ..
    thank you sir

  46. Hello Sir,

    I have started an institute in Bangalore and I would like to give publicity for my Institute.

    I would like to send message to all or some of the people who kept their resumes in Naukri for getting jobs on DWH technology.
    I went to Vodafone customer care. They said we can send a message to all the people in perticulor region.

    But I don’t want like that. I want to send the message to the people who kept their resumes in naukri website.

    Could you please let me know how can I do this ? whoom do I need to contact ?

  47. Dear Sir,

    currently we have a requirement to develop blackberry application(mobile device), sir my doubt is that should i develop blackberry apps using dotnet, because i heard there are certain limitations for this, and thinking that dotnet hope wont give me any trouble during application developement as the clients requirements will increase.sir plz help me and suggest shuld i go wid dotnet for bb appls…

  48. “Tarak Says:
    March 8th, 2011 at 11:32 pm
    Good Evening sir,

    Could u clarify my doubt… If i prepare an application for a client, then what files i supposed to give to them whether dll file or exe file?”
    ________________________________
    sir i m highly impressed that u r one of the student is asking such a kind of advanced(stupid)questions. plz give him a suitable answer sir…
    ________________________________

  49. Sir I have interview call next month . Sir please tell me that how to prepare for the interview on the basis of .NET, SQL SERVER 2008.

    Because this is my first time to face the interview as well as on the .NET OR SQL SERVER 2008 . Please suggest me something because I have few days left for the Interview. I can Prepare as per ur guidance. I am one of ur student.
    thaking you sir

  50. hai sir , this is chandra sekhar.
    Sir I have interview call next month . Sir please tell me that how to prepare for the interview on the basis of .NET, SQL SERVER 2008.

    Because this is my first time to face the interview as well as on the .NET OR SQL SERVER 2008 . Please suggest me something because I have few days left for the Interview. I can Prepare as per ur guidance. I am one of ur student.
    thaking you sir

  51. hello sir,
    while learning c# by you, i understand what the way to love our interested subject like you, you are totally involved in c# while teaching, which may develop student interest in subject.

    thanks

    your faithfully.

  52. hie sir,
    im radha, ur old student.
    plz sir i need ur help.
    can i knw how to convert double to 48bit binary number in csharp.
    plz help me sir. it is part of my project.
    thankin you,

  53. sir., im new to ‘.net’.,, while 1st time im practising the C# program in VS2010 in my personal PC, while compiling im getting an alert dialog box as ” A project with an output Type of Class Library cannot be started directly. In order to debug this project add an executable project to this solution which references the library project. Set the executable project as the startup project.”.

    wat to do sir..?

  54. sir,
    IIS server not getting install. i am using window7 ultimate . when i m going to Window feature On or off in control panel and make any change message displays “an error occurred, not every features changed”. please help me sir.

  55. hello sir,
    i am one of the dtudent of your csharplldb class, sir you have told in the class to submit the mail id so that u will mail the document related to the orm(model).so sir kindly mail me the document on my id

    thank you sir..
    keep smiling

  56. hello sir,
    i am one of the dtudent of your csharpll class, sir you have told in the class to submit the mail id so that u will mail the document related to the orm(model).so sir kindly mail me the document on my id

    thank you sir..
    keep smiling

  57. hello sir,
    iam one of the student of ur csharp class. Sir we are studying CSharp from your’s well known teaching , so that dont say’s that many times sorry for a single mistake sir. ur’s well defining teaching always help for us,
    thanking sir,

  58. sir,
    my name is pramod. I am one of the student of your c# class.sir please explain how intelligent the data Adapter to recognize whether it is insert or update or delete when we use update() method

  59. sir,
    i am your evening 6 o clock batch student.sir i got the job in a company in indore where i need to learn new things in .net so help me how can learn new technology in .net .becoz here nobody teach new things and in company they will never help me so what can i do to get rid of this problem….
    thanks…

  60. sir ,
    iam k.Durgaprasad iam one of the student of your c#.pls send me to c# matterials and Asp matterial .

    Thanks you sir

  61. Sir,
    I have completed Training in naresh technologies recently,

    How can I define an function inside C# application (exe) that can be used to receive the arguments from some other application while particular C# application (exe) is running or Active.

    thanks in Advance
    Sudhakar.P

  62. MySqlCommand command = con.CreateCommand(); command.CommandText = “SELECT image FROM image WHERE id=11″; con.Open(); byte[] imagedata=(byte[])(command.ExecuteScalar()); con.Close(); MemoryStream mem = new MemoryStream(imagedata); pictureBox1.Image = Image.FromStream(mem); i have some problem here thatparameter is not valid exception .Please tell me any one how to retrieve a image saved in database and tell me how to convert a pdf to format to store in database

  63. sir my name is vijay i have small dout how the startup object will set in c#.net. as per ur notes right click on the project and set the start up object but i had problem the class names are not coming in that sart up objects so pls tell me sir

  64. I have completed Training in naresh technologies and in my M.tech iam doing project IEEE. In my project i have metrics for code readability these are 1.code changes , how to change the code in c# .net for a good readability

  65. hello sir, i am student of naresh tech in .net,
    i want some inf about on c sharp and sql server,
    kindely provide me the material

    mail ID:polampallykranthi@gmail.com

  66. Sir, I need explanation of the below line,I dont know what is char, Is digit, Keychar, and
    convert to int 32 (e.keychar) and especially what is the no 8 indicates.
    i have written this code for my registration form of contact no for textbox 4 below keypress event.what is handled etc.

    private void txtPhone_KeyPress(object sender, KeyPressEventArgs e)
    {
    if (char.IsDigit(e.KeyChar) == false &&Convert.ToInt32(e.KeyChar) != 8)
    {
    MessageBox.Show(“Enter Numerics Only”);
    e.Handled = true;
    }
    }

  67. hi sir, the demo table link is not showing any thing …how to download this demo tables……..plz tell me sir….
    thanking u.

  68. hi sir this rathnam your old student in nareshit 2011 batch

    i was developed a .net windows apllication for cloth malls using vb.net with sqlserver2005. we are using single table for getting records and insert records at same time in client-server based error is raised

    Error Message

    ” Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding”

    please reply solution..
    thanking you sir

  69. sir i have a problem with sqlserver 2005
    error is

    “Timeout expired. the timeout period elapsed prior to completion of operation or the server is not responding”

    we are using front end :Vb.net
    Back end : sqlserver 2005

    please reply sir
    thanking you sir

  70. You actually make it seem really easy together with your presentation but I to find this topic to be really something which I think I would by no means understand. It sort of feels too complex and very wide for me. I’m looking forward to your next post, I’ll attempt to get the hold of it!

  71. sir , i have an doubt ……in delegates…..as u said thatit is a type safe function pointer……what do u mean by type safe..plz clarify me…..7.15 pm batch c#.

  72. hello sir,
    i am one of the student of your csharp ll class, sir you have told in the class to submit the mail id so that u will mail the document related to the orm(model).so sir kindly mail me the document on my id

    thank you sir..
    prathap

  73. hai sir gd evng,
    Am your sql server previous 11 am batch student please reply to these below questions sir.
    1.How you will give data in to particular position.
    2.suppose i have 1000 bytes can you insert in particular position.
    3. In one table we have 20 records if we want to show row numbers how will you do.
    4. Data type of auto generated column and how these auto generated columns generated.
    5. can we write two primary keys in table.if yes how?

Leave a Reply to Arul Jesuraj Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>