|
Hi everyone...
I'm using an SQL Server Compact Edition
I can do all the queries without a problem but I cannot create a table.
in the runtime, when it comes to create a table, the line of the "ExecutNonQuery" gives an error:
"There was an error parsing the query [Token line number=1, Token line offset = 14]..etc"
I now that this kind of error appears when your SQL command syntax is wrong
can anybody tell me what is my fault?
string CreCom = "CREATE TABLE " + TCkim + YilBox.Text + " (Aylar nvarchar (10), Statu nvarchar (20), Odeme nvarchar (20), Servis nvarchar (20), Kiyafet nvarchar (20), Kitap nvarchar (20), Tiyatro nvarchar (20), Sinema nvarchar (20), Yemek nvarchar (20), Muze nvarchar (20), Piknik nvarchar (20), Parti nvarchar (20), Diger nvarchar (20), Yoklama nvarchar (20), Aylik nvarchar (20), Odenen nvarchar (20), Kalan nvarchar (20))";
SqlCeCommand CreateCommand = new SqlCeCommand(CreCom, conn);
CreateCommand.ExecuteNonQuery();
note: SqlCeCommand is the "SqlCommand" for Compact Edition. Usage is all the same
|
|
|
|
|
BTW
my CreCom string is created as below in the runtime:
"CREATE TABLE 444442009 (Aylar nvarchar (10), Statu nvarchar (20), Odeme nvarchar (20), Servis nvarchar (20), Kiyafet nvarchar (20), Kitap nvarchar (20), Tiyatro nvarchar (20), Sinema nvarchar (20), Yemek nvarchar (20), Muze nvarchar (20), Piknik nvarchar (20), Parti nvarchar (20), Diger nvarchar (20), Yoklama nvarchar (20), Aylik nvarchar (20), Odenen nvarchar (20), Kalan nvarchar (20))"
is there something wrong?
|
|
|
|
|
well,
I just found out that when I put an "a" to the beginning of the table name, this problem is no more
but still, thank you all =)
|
|
|
|
|
a table name is an identifier, it cannot start with a digit. Similar to most programming languages.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
table A
Field: a(char(40)) b(char(40))
q -- ss
q -- fs
q -- ffr
q -- egg
w -- ffh
w -- gykk
e -- hrh
e -- kyk
e -- jjtj
the Purpose: field "a" as father node,field "b" as child node,field "a" should not be repeated!this is part of my code,but it can't meet my Requirements.
public void AddTree(TreeNode pNode)
{
DataSet ds=new DataSet();
DataView dvTree = new DataView(ds.Tables[0]);
foreach (DataRowView Row in dvTree)
{
if (pNode == null)
{ //add father node
TreeNode Node = treeView1.Nodes.Add(Row["a"].ToString());
}
else
{
TreeNode Node = pNode.Nodes.Add(Row["b"].ToString());
}
}
it only can show feild "a" on treeview,like this:
q
q
q
q
w
w
e
e
e it repeat the Field 'a',can someone help me ,thanks very much!!   always waiting online
|
|
|
|
|
Looking at the sample you've posted, pNode will always be null, hence the reason a is shown again and again. What you need to do is:
if (pNode == null)
{
pNode = treeView1.Nodes.Add(Row["a"].ToString());
}
else
{
TreeNode Node = pNode.Nodes.Add(Row["b"].ToString());
}
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
i want get the Results like
q(father node)
..ff(child node)
..grt
..trt
..hth
w
..trt
..fgh
..hth
e
..htj
..htr
..trt
..ht
which is your changed code shown:
q(father node)
..ff(child node)
..grt
..trt
..hth
..trt
..fgh
..hth
..htj
..htr
..trt
..ht
if do thisif (pNode == null){ //add father node pNode = treeView1.Nodes.Add(Row["a"].ToString());}else{ TreeNode Node = pNode.Nodes.Add(Row["b"].ToString());} pNode=null;
shown only father node like:
q
w
e
|
|
|
|
|
To be honest, your logic has more fundamental problems. You have two columns here which you are trying to work with, but the logic you have in the if/else only applies to one column level. What you could do is reimplement your logic like this:
foreach (DataRow dr in ds.Tables[0])
{
string colName = dr["a"].ToString();
TreeNode node = treeView1.Find(colName);
if (node == null)
{
node = treeView1.Nodes.Add(colName, colName);
}
node.Nodes.Add(dr["b"].ToString());
}What you are doing here is adding a node with a specific key into the treeview - and this key is the value of column a. You look for this node using the Find method and add it in if it doesn't exist. Finally, you add column b to the node.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
thanks for you,but when runing the code you have give me it shows:
"System.Windows.Forms.TreeView" does not contain a "Find" Definition?
|
|
|
|
|
i want get the Results like
q(father node)
..ff(child node)
..grt
..trt
..hth
w
..trt
..fgh
..hth
e
..htj
..htr
..trt
..ht
which is your changed code shown:
q(father node)
..ff(child node)
..grt
..trt
..hth
..trt
..fgh
..hth
..htj
..htr
..trt
..ht
if do this
if (pNode == null)
{ //add father node
pNode = treeView1.Nodes.Add(Row["a"].ToString());
}
else
{
TreeNode Node = pNode.Nodes.Add(Row["b"].ToString());
}
pNode=null;
shown only father node like:
q
w
e
|
|
|
|
|
table A
Field "stuage"
15 15 16 17 15 16 17 18 15 16 17 18
if do this:select * from A it show:15 15 16 17 15 16 17 18 15 16 17 18
but how can make it show:15 16 17 18,not repeat!
thanks
|
|
|
|
|
I suggest you buy a basic book on SQL and read it. And post SQL questions in the SQL forum in future.
Look up the SQL keyword 'distinct'
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I need the window form to hide itself when the user clicks [x] close button in the upper right corner.
Thus it will reside allocated and once user clicks to open it, it will just become visible again.
But upon main program termination it needs to be closed in any case.
[x] button click results in form deallocation.
Чесноков
|
|
|
|
|
HAndle the form closing event, set the flag on the event args to stop it closing, and hide it. Add your own flag that gets checked so you can close it in code.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Many thanks.
There is also CloseReason available in closing event.
In Borland Builder it was possible to define which forms should remain through out application life cycle.
Чесноков
|
|
|
|
|
Chesnokov Yuriy wrote: I need the window form to hide itself when the user clicks [x] close button in the upper right corner
Is that what the user needs and expects?
Chesnokov Yuriy wrote: upon main program termination
And clicking the [x] is one way the user expects to do that.
Chesnokov Yuriy wrote: [x] button click results in form deallocation.
No it doesn't. That's up to the Application.
|
|
|
|
|
1. Which is the country hosting the 2012 Olympic Games?
(a)Portugal
(b)India
(c)South Korea
(d)England
(d)England
2. What is the largest mammal in the world?
(a)Blue Whale
(b)Elephant
(c)Camel
(d)Rhino
3. Which is the smallest ocean in the world?
(a) Arabian Ocean
(b)Pacific Ocean
(c) Artic Ocean
(d) Indian Ocean
4. The longest river in the world is the?
(a)Amazon
(b) Mississippi River
(c)Neil
(d)Brahmputra
5. The highest mountain in the world is ?
(a) Lhotse
(b) Kanchenjunga
(c) Karakoram
(d) Everest
6. The biggest desert in the world is the
(a) Arabian(Arabia)
(b) Sahara (Africa)
(c) Gobi(China)
(d) Patagonian (Argentina)
7. The largest coffee growing country in the world is
(a) Indonesia
(b) Colombia
(c) Vietnam
(d) Brazil
(e) India
8. The biggest island of the world is
a. Greenland
b. New Guinea
c. Borneo
d. Madagascar -Baffin
9. The country which is the largest producer of rubber in the world is
(a) Malaysia
(b) Thailand
(c) Zaire Republic
(d) India
|
|
|
|
|
And what has this to do with anything?
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
This is not the correct forum for these kind of posts. Try Lounge instead.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
hello every1 , am new to programming. am doin my dissertation on cd database in C#. my software should retrieve information from a cd dat is manually put into cd drive. software should copy cd info like the artist , name, song , et into a database.
This is where am stuck. am havn problems copying the cd info successfully. now my deadline is in just 1month.
This code i thought was workin.now it isnt.
PLS I NEED HELP.. AM DESPERATE..
|
|
|
|
|
Can you show the code where you are copying the CD data. And pin point the problem you are facing.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
this is the code. it gives no errors. its just not getting the contents off the cd like the album name , artist, etc.
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using WMPLib;
using AxWMPLib;
namespace CdRomManagement
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void axWindowsMediaPlayer1_CdromMediaChange(object sender, AxWMPLib._WMPOCXEvents_CdromMediaChangeEvent e)
{
axWindowsMediaPlayer1.currentPlaylist = axWindowsMediaPlayer1.cdromCollection.Item(e.cdromNum).Playlist;
axWindowsMediaPlayer1.Ctlcontrols.stop();
this.textBox1.Text = "Name: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("Name") + Environment.NewLine;
this.textBox1.Text += "author: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("author") + Environment.NewLine;
this.textBox1.Text += "Title: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("Title") + Environment.NewLine;
this.textBox1.Text += "Album: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("Album") + Environment.NewLine;
this.textBox1.Text += "copyright: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("copyright") + Environment.NewLine;
this.textBox1.Text += "Artist: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("Artist") + Environment.NewLine;
this.textBox1.Text += "Genre: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("Genre").ToString() + Environment.NewLine;
this.textBox1.Text += "Bitrate: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("Bitrate") + Environment.NewLine;
this.textBox1.Text += "Abstract: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("Abstract") + Environment.NewLine;
this.textBox1.Text += "bitRate: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("bitRate") + Environment.NewLine;
this.textBox1.Text += "duration: " + axWindowsMediaPlayer1.currentMedia.getItemInfo("duration") + Environment.NewLine;
}
}
}
|
|
|
|
|
Don't flood the whole site. Post to the right forum and stick to it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
mimi8469 wrote: information from a cd dat
A CD and a DAT are two different formats. Which one did you mean ? Or are you just talking like a retard ?
mimi8469 wrote: now my deadline is in just 1month.
This code i thought was workin.now it isnt.
PLS I NEED HELP.. AM DESPERATE..
Why did you think it was working, and why is it not now ? I'd assume you used to connect to a database of CDs that no longer exists. Either way, it's kind of your problem. Posting a vague question like this isn't going to get you any help, you're basically asking us to redo your project, or you just plain have not thought about your post. Post some code, tell us what goes wrong, and then perhaps we can offer specific help.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
dat = that
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
