Search results for query: *

  1. jmjyiannis

    multi-multi-multiple Insert with subquery???

    Solution: Just in case that anyone is in the same position in which I was..... the Solution comes from a multiple insert-select subquery: cmdSelect = New SqlCommand("insert into attendedLessons (LessonID,StudentID,TeacherID,CourseID) (select distinct lessonID, studentid, PersonID...
  2. jmjyiannis

    multi-multi-multiple Insert with subquery???

    although I know all this procedure..... thank you for your response. I appreciate it a lot.:):):) Simply, I was wondering only about the syntax. how to input the variables e.t.c.
  3. jmjyiannis

    multi-multi-multiple Insert with subquery???

    sql server 2000
  4. jmjyiannis

    multi-multi-multiple Insert with subquery???

    and how should I create the stored procedure? I mean.... Which should be its syntax? Thank you for your reply!
  5. jmjyiannis

    multi-multi-multiple Insert with subquery???

    Hello, experts, friends and masters. I get into the point! I have a huge (for me) problem. I have some tables in a database. Lessons, Students, Teachers, Courses and AttendedLessons. The last table (attendedLessons) has the following collumns: AttendedLessonID LessonID, StudentID, Mark...
  6. jmjyiannis

    encoding change for Greeks!

    Hi and thank you for your support kulrom. I don't want to try something like the function which you describe because I think that as you can see here (http://www.microsoft.com/globaldev/getWR/steps/wrg_codepage.mspx#EFAA) the modification of the encoding of a VB page might be easier than you...
  7. jmjyiannis

    encoding change for Greeks!

    please Help me!!!!! I need to have Greek encoding in a vb project which stores strings (nvarchar) and textareas (ntext) in SQL database. Although I have solved the problem with the collation of Greeks in DB, the VB.NET converts the input content to latin encoding. for example, the Greek 'Δ'...
  8. jmjyiannis

    collation change to Greek

    Hello Experts, I have a problem. I have a sql database that is with collation of latin (particularly, SQL_Latin1_General_CP1_CI_AS) but I want to have greek language in the database. trying to change the collation to Greek_BIN, the SQL query (ALTER DATABASE <databasename> COLLATE Greek_BIN)...
  9. jmjyiannis

    SQL Server does not exist or access denied

    Finally, the problem was that the connection string was unable to connect the database with .NET out of the ASP.NET environment. the connection string should have been..... "Data Source=127.0.0.1;Initial Catalog=dissertation_FLS;integrated security=SSPI;" instead of...
  10. jmjyiannis

    SQL Server does not exist or access denied

    So, first of all the SQL server and .net are in the same mashine. It is has win 2000 server for OSystem. Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=E511-EKE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=E511-EKE;Use...
  11. jmjyiannis

    SQL Server does not exist or access denied

    The connection string that I have is: server=e511-eke;Integrated Security=SSPI;database=FLS; and the authentication of the SQL server is "windows only"This used to work fine. But not in this mashine.
  12. jmjyiannis

    SQL Server does not exist or access denied

    the Authentication that I have is SSPI. changed that option but still.... SQL Server does not exist or access denied
  13. jmjyiannis

    SQL Server does not exist or access denied

    Good morning everyone. I have installed .NET and SQL Server 2000 but when I try to run any project, it stops and shows the message "SQL Server does not exist or access denied". However, the .NET connects with the SQL SERVER because I can see all the tables or the stored procedures of the...
  14. jmjyiannis

    store html code in a SQL database through ASP.NET

    Thank you Master. I found it after your suggestion about thiese methods. respect yiannis:)
  15. jmjyiannis

    store html code in a SQL database through ASP.NET

    Hello experts! Please somebody help me!!! My problem is that I have a textarea (like this one that we use to write our posts) and I want the html code that it creates, to be stored in a database. I use ASP.NET - VB and SQL Server. My problem is that the .net takes the generated code and stores...
  16. jmjyiannis

    reference not set to an instance of an object in Datagrid

    Daragrid and Links Hello Experts! I want to construct a Datagrid and for each item of the table created in this datagrid to have a link. Let's say a Datagrid <asp: Datagrid id="dgCustomers" runat="server" </Datagrid> But for each Customer I want to have a Link based on his id. Where...
Back
Top