|
�
So, is that character above (U+FFFD) not showing because it is unicode, and this webpage is ASCII?
/\ |_ E X E GG
|
|
|
|
|
Hi,
I have a column that is calculated (from other columns in the DataSet):
myDataTable.Columns.Add("ItemSubTotal", typeof(decimal), "ItemPrice * ItemQuantity");
When I try and save the DataSet to file with this Parameter:
myDataAdapter.InsertCommand.Parameters.Add("@ItemSubTotal", OleDbType.Decimal, 100, "ItemSubTotal");
I get this error:
The column mapping from SourceColumn 'ItemSubTotal' failed because the DataColumn 'ItemSubTotal' is a computed column.
Is there a way to save a computed column?
Thanks,
Ron
|
|
|
|
|
No, because it's a Computed Column. There's nothing to save. When you query against that column, you'll get the result of the column. Why would you want to save it again? If you want to save the value, you'll have to save it into another column in your existing table, or a different one if you want.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
Hi again Dave,
Sorry new to programming...
I'm having difficulty finding the code to save the computed column values to the other column (2nd column not viewed as expression). Can you show me an example?
Thanks,
Ron
|
|
|
|
|
Hi everyone.
I am working on an application which will rely heavily upon the DirectoryServices namespace. Specifically, I will be using the ADSI provider to manipulate and configure IIS.
Lately I've become a little concerned with Windows version compatibility. The application will be used extensively on Windows 2000 Server, along with several Windows 2003 Server boxes. The problem is that on a number of MSDN pages, I see notes that indicate various features of the DirectoryServices ADSI provider require Windows 2003 Server.
However, my limited tests appear to indicate otherwise. So far, I've not had a problem with any of my Windows 2000 Server boxes.
Here is one such example -- http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/iis/adding_metabase_properties_to_a_collection_using_system_directoryservices.asp
The above page notes that the Virtual Directory sample requires Windows 2003 Server, however the sample compiles (after fixing the obvious source code errors) and runs without issue on at three Windows 2000 Server boxes I've tested.
So what is the issue here? Anyone run into this? Can I count on this work on Windows 2000 Server? Where can I find the definitive answer on this?
Thanks!
|
|
|
|
|
I haven't run into this, but if you want to make sure your app is going to work on all of your platforms, Test, Test, Test, Test, and Test some more, until YOU'RE happy with the functionality. Then hand it to a couple of beta testers and see if THEY'RE happy with the product on the platforms your suspicious of.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi, anyone know about that kind of error?
Thanks
|
|
|
|
|
It would help if you posted the code where the error occurs!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks David,
i close the Visual Studio and reopen,
everything's just fine then,
sounds weird though..
Thanks
But i have another question, i wanna apply column style to one of the columns in my table, i wanna hide one column but setting its width to zero, i have five datacolumn object, but i only have one gridcolumnstyle with mapping name set to one of the column name i wanna hide.
but the style doesn't apply, the column is not hidden.
how am i goin to hide it?
|
|
|
|
|
You hide the column by setting it's width to 0, but since you haven't supplied any code, I can't tell you what your doing wrong. So, here's an example:
private void HideColumnOfDataSet()
{
System.Data.DataTable points = new System.Data.DataTable("Points");
points.Columns.Add(new DataColumn("X", typeof(int)));
points.Columns.Add(new DataColumn("Y", typeof(int)));
points.Rows.Add(new object[]{1, 2});
points.Rows.Add(new object[]{3, 5});
dataGrid1.DataSource = points;
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = "Points";
dataGrid1.TableStyles.Add(tableStyle);
dataGrid1.TableStyles["Points"].GridColumnStyles["X"].Width = 0;
}
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i get null reference exception in this line
this.dataGrid1.TableStyles["Students"].GridColumnStyles["Password"].Width = 0;
how?
|
|
|
|
|
I can't tell without seeing the rest of your code in that block. Most likely, you're missing a 'new' somewhere.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks Dave,
found it,
i did it inside the initialize component(using designer)
and indeed the designer define the table style before adding column.
i replace the order, add column first, then it's fine.
Thanks
|
|
|
|
|
Accessing indexes requires that an object at that index (or with that index keyword, like the table style or column style name above) exists. If it doesn't, null is returned from the index property. When you try to call a method or access a property on null, you get a NullReferenceException .
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I sometimes see it in a perfectly valid line of code. I simply cut and re-paste the line and the compiler is then happy!
|
|
|
|
|
Hi,
How does one enumerate the groups a user belongs to using the WinNT:// provider (not LDAP) ??
TIA,
Matt
|
|
|
|
|
Well, in VBScript, it looks something like this:
strComputer = "." ' Use a '.' to denote the local machine.
Set colGroups = GetObject("WinNT://" & strComputer & "")
colGroups.Filter = Array("group")
For Each objGroup In colGroups
For Each objUser in objGroup.Members
If objUser.name = "username" Then
Wscript.Echo objGroup.Name
End If
Next
Next
You go through each group on the machine and check to see if the username exists in that group.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi
i want serialize and deserialize textbox properties for example font and backcolor,...
please help me and tell me what i do?
thanks
|
|
|
|
|
Read the XmlSerializer class documentation in the .NET Framework SDK. It includes a sample.
XML Serialization will, by default, serialize any public property or field, so serializing those properties is easy:
TextWriter writer = new XmlTextWriter("file.xml",
System.Text.Encoding.UTF8);
XmlSerializer serializer = new XmlSerializer(textBox1.GetType());
serializer.Serialize(writer, textBox1); See the documentation for more details.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
my code is
this is serialize of textbox:
XmlWriter xw = new XmlTextWriter(fs, System.Text.Encoding.ASCII);
xw.WriteStartElement("Form");
xw.WriteAttributeString("X", theText.Left.ToString());
xw.WriteAttributeString("Y", theText.Top.ToString());
xw.WriteAttributeString("Width", theText.Width.ToString());
xw.WriteAttributeString("Height", theText.Height.ToString());
xw.WriteAttributeString("Value", theText.Text);
xw.WriteAttributeString("Font", theText.Font.Tostring());
xw.WriteAttributeString("Backcolor", theText.Backcolor.Tostring());
xw.WriteEndElement();
XmlNodeReader reader = new XmlNodeReader(doc);reader.value is string but textbox.font or backcolor is Syste.Drawing
please tell me what i do?
thanks.
|
|
|
|
|
I'm not shore about the Font but with the Backcolor you can:
xw.WriteAttributeString("Backcolor", theText.BackColor.ToArgb().ToString());
and read it inn with
theText.BackColor = Color.FromArgb(Convert.ToInt32(reader.Value));
the font you might have to use
theText.Font.Name.ToString()
Hope it helps
Thomas
|
|
|
|
|
thanks for your help
but i should deserialize font and alignment of my textbox with reader.value ,too
please tell me what i do?
thanks.
|
|
|
|
|
You should be using TypeConverter s for the whole thing, otherwise use ToString . Many classes can't be reconstituted from their ToString representations. If you use XmlSerializer as I mentioned, this is all done for you. But, if you insist on doing things the hard way, you can get a TypeConverter reference for each type using something like this:
TypeConverter converter = TypeDescriptor.GetConverter(theText.Left);
xw.WriteAttributeString("X", converter.ConvertToString(theText.Left));
converter = TypeDescriptor.GetConverter(theText.Top);
xw.WriteAttributeString("Y", converter.ConvertToString(theText.Top));
xw.WriteEndElement();
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
the serialize code:
xw.WriteAttributeString("Font",theText.Font.Name.ToString());
and it is deserialize code,i use convector but it dosent work properly.
FontConverter ff=new FontConverter();
theTextBox.Font=(System.Drawing.Font )ff.ConvertFromString(reader.Value );
what i do?
thanks.
|
|
|
|
|