Database

FirstPrevNext

Ms Access hitesh.kalra26-Apr-09 21:59 hitesh.kalra 26-Apr-09 21:59  I am creating a phonebook in c# .net my database is Ms access. There are no duplicates allowed in two columns mobile no and landline no but if I left blank those columns two times it gives an error that "no duplicates are allowed". Please give me such code to allow null but not duplicates are allowed because this is not compulsory every person has mobile or landline. thanx in advance. Re: Ms Access Eddy Vluggen27-Apr-09 23:30 Eddy Vluggen 27-Apr-09 23:30  Open the table in MS Access in the design-view, and set Index to "Yes (No Duplicates)". Set Required to "No" and Allow zero length to "Yes". That should do the trick I are troll Re: Ms Access hitesh.kalra29-Apr-09 21:32 hitesh.kalra 29-Apr-09 21:32  It is not working because Unique required only one null value. So I run the form first time it takes one blank column but when next time I run the form it given an error of the duplicate records. run time exception Mangesh Tomar26-Apr-09 17:59 Mangesh Tomar 26-Apr-09 17:59  hi in my project i convert excel file in xml and then upload the file in data base . here i use SQL Server 2005. In my excel file consist one record D'Souza when such name comes program throw run time exception as Incorrect syntax near 'Souza i use following query for insert a record string istr = "insert into sheet1(Personnel_Area,EE_Grp,Employee_Group,ESgrp,Employee_Subgroup,Cost_ctr,Cos t_Center,PSubarea,Personnel_Subarea,Peres_no,Personel_Number,Designation,D esigna,Pos,Age_of_Employee,Birthdate,Complete_name)values('" + Convert.ToString(dataGridView1.Rows[i].Cells[0].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[1].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[2].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[3].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[4].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[5].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[6].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[7].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[8].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[9].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[10].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[11].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[12].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[13].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[14].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[17].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[18].Value.ToString()) + "')"; need a help Re: run time exception riced27-Apr-09 4:14 riced 27-Apr-09 4:14  You seem to be quoting your values using single quote (i.e. ') character. So the ' in D'Souza is taken to be the end of the value. Have a look at how Transact-SQL deals with quoted strings and the use of single (i.e.') and double (i.e. ") quotes. Regards David R Reg:Extract View information in Sql server Member 400849226-Apr-09 17:55 Member 4008492 26-Apr-09 17:55  Hi, I have a view. i want to get the columns in a view along with its database and servername. For example, Employee table resides in CSCEmp server's Emp database. I have a view in CSCDet server that will have a column "EmpName" of [CSCEmp's] Employee table. When i list view information, i want to display like view view'sserver Columnname column'sServer EMPView CSCDet EmpName CSCEmp Is there a way to do like this. Thanks. Re: Reg:Extract View information in Sql server Mycroft Holmes27-Apr-09 19:09 Mycroft Holmes 27-Apr-09 19:09  Look into the information schema views (under system views in management studio) or sysobjects in 2k. These will give you all the information about SQLs internal structures. Never underestimate the power of human stupidity RAH How to centrally place a Database to share among internal windows form application and also to web application? Aghosh Babu26-Apr-09 17:41 Aghosh Babu 26-Apr-09 17:41  Hi, as i said. i have a windows form application within the internal organisation users and a web appplication hosted with some hosting company for external users. Both application need to share a common databse? how to share and where to place the databse? Also is this the same case to share database among different users within the company using windows forms application? Re: How to centrally place a Database to share among internal windows form application and also to web application? Mycroft Holmes27-Apr-09 19:12 Mycroft Holmes 27-Apr-09 19:12  So you have asked this question 8 times including in the Lounge - I'm bloody sure there were some excellent answers in there, go away and do some work. Never underestimate the power of human stupidity RAH Re: How to centrally place a Database to share among internal windows form application and also to web application? Aghosh Babu27-Apr-09 19:42 Aghosh Babu 27-Apr-09 19:42  oh its really great to know that some one is hear just to count the questions and for any other --- Else.. I thought i can get some codes without doing any work at all..lol...according to your valuable stupid sugestion i will do my work lol....!If you dont know the answer better dont reply to people..and i am bloody sure that i asked the question only twice, one in C# forum and other in database forum... C# forum people suggested me to ask there lol... read the posts before comment (do your work first )... Re: How to centrally place a Database to share among internal windows form application and also to web application? Mycroft Holmes27-Apr-09 20:01 Mycroft Holmes 27-Apr-09 20:01  Oops My apologies - I did not read follow the links to the questions. Never underestimate the power of human stupidity RAH [T-SQL] How to retrieve records from start index and count Hristiyan24-Apr-09 10:31 Hristiyan 24-Apr-09 10:31  I'm searching for logic which will help me to retrieve table records based on "start index" parameter and parameter which specifies the returned records count. Example: dbo.Records num 1 2 3 4 5 SELECT num FROM dbo.Records will return 5 records. I cant find a function or something other which will help me retrieve the following logic input params : @startIndex = 2 , @recordsCount = 2 so when i perform the select statement to retrieve the 2 records (3 and 4) If there is no answer with an exact function, is there a wordaraund ? Please help. Regards Hris. Re: [T-SQL] How to retrieve records from start index and count David Mujica24-Apr-09 10:55 David Mujica 24-Apr-09 10:55  try this ... select top @recordsCount num from dbo.records where num >= @startIndex You may also be able to use something like this ... select num <br /> from dbo.records <br /> where (num >= @startIndex) and (num <= @startIndex + @recordCount) I haven't tested it, but it is probably close. How to get size of Image Stored in Database? sumit703424-Apr-09 1:57 sumit7034 24-Apr-09 1:57  Hii I am storing images in my sql server 2005 database. Is there any sql query or any other way to get the size of the image stored in my table? Thanks in Advance Re: How to get size of Image Stored in Database? sumit703424-Apr-09 2:07 sumit7034 24-Apr-09 2:07  SELECT DATALENGTH(imagecolumn) FROM sometable Need SQL query correction ! soulidentities23-Apr-09 22:44 soulidentities 23-Apr-09 22:44  Hi ppl Take a look a simple query. String sql = (@" SELECT Ins_ID, Ins_Nm FROM Institution_Profile WHERE Ins_ID = '{0}' ", combobox.Text); If the query above works perfect without no erro then why the below query is not working. String sql = (@" SELECT Ins_ID, Ins_Nm FROM '{0}' WHERE Ins_ID = '{1}' ", tableName.text, Ins_ID.Text); Anybody ans this pls Thanks Re: Need SQL query correction ! Henry Minute24-Apr-09 0:27 Henry Minute 24-Apr-09 0:27  It might be that you have made a typo. Try changing tableName.text, Ins_ID.Text to tableName.Text, Ins_ID.Text. But on the other hand it could be anything. If you ask a question about an error, tell people what the error is and which part of the posted code gives the error, otherwise most members will ignore you. Also please don't use text speak in your posts. We older folks don't understand it and once again you are cutting down the number of people willing to help you. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” Re: Need SQL query correction ! i.j.russell24-Apr-09 1:58 i.j.russell 24-Apr-09 1:58  Remove the single quotes from the tablename: FROM '{0}' becomes FROM {0}. Re: Need SQL query correction ! soulidentities24-Apr-09 3:49 soulidentities 24-Apr-09 3:49  Fantastic....Worked Thanks dude Re: Need SQL query correction ! Colin Angus Mackay24-Apr-09 7:32 Colin Angus Mackay 24-Apr-09 7:32  This continues to be vulnerable to SQL Injection attacks. *Developer Day Scotland - Free community conference Delegate Registration Open Re: Need SQL query correction ! i.j.russell24-Apr-09 9:56 i.j.russell 24-Apr-09 9:56  To paraphrase dialog from the film 'Riddick': The CPer in me says that he has only just started learning SQL and nobody has given the little bit of help that he needs to continue with his project. However, the pedant in me says that I should tar and feather him for not following established best practice at all times; Ignorance of the Law is not a defence. Re: Need SQL query correction ! Colin Angus Mackay24-Apr-09 7:31 Colin Angus Mackay 24-Apr-09 7:31  You should be using parameterised queries rather than injecting values into a SQL Statement. This is easy for data elements like the ID value, but slightly more difficult, yet doable, for the table name. As it stands your code is vulnerable to attack. *Developer Day Scotland - Free community conference Delegate Registration Open Need to retrive attribute Name Satish - Developer23-Apr-09 20:59 Satish - Developer 23-Apr-09 20:59  How to retrive attribute Name <names> <zipcode zc="*"> <rule rll="%LEIN"> Here the thing is in some Names tag the attribute of Rule is RL or RLL. <rule rll="%LEIN"> <rule rl="LE%"> I am getting error at bold line below. Bcz, i mentioned direcly RLL. If RL exists as attirbute then getting error. how to get attribute name? XmlNodeList NameList = doc.GetElementsByTagName("Names"); foreach (XmlNode node in NameList) { XmlElement nameElement = (XmlElement)node; foreach (XmlNode xnode in nameElement) { XmlElement childElement = (XmlElement)xnode; if (childElement.Name.ToLower() == "rule") { if (childElement.HasAttributes) strrule = childElement.Attributes["RLL"].InnerText.ToLower(); } } } G. Satish Don't want to give stored proc to client? devvvy23-Apr-09 20:51 devvvy 23-Apr-09 20:51  Don't want to give stored proc to client? What are your options if there is one? Thanks dev Re: Don't want to give stored proc to client? Ashfield23-Apr-09 20:58 Ashfield 23-Apr-09 20:58  devvvy wrote: Don't want to give stored proc to client Then don't Have you considerd encrypting it? Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Last Visit: 31-Dec-99 18:00     Last Update: 29-May-24 21:58 Refresh ᐊ Prev1...860861862863864865866867868869 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.