|
sorry, i din't refresh the page before giving the reply...
|
|
|
|
|
thank you both
but what if i change "user" to "user_1"
should I use "[user_1]"
thank in advance
|
|
|
|
|
no you dont have to use tat. If you are using SQL Server Management Studio
and creating tables it will automatically convert user to [user].
|
|
|
|
|
thanks  
|
|
|
|
|
Guys, I need help. I know the volume letter. How can I get a model of physical disk drive which consists a volume with a known to me name? I think, I have to use WMI, maybe Win32_DiskDrive, but how can I compare logical disk with physical disk?
|
|
|
|
|
Hello
Hope this help ...
I know it's far a bit from your answer ...
But I really tried to help you as much as I can ,,
1)
using System;
using System.Collections.Generic;
using System.Text;
using System.Management;
namespace ConsoleApplication31
{
class Program
{
static void Main(string[] args)
{
ManagementScope scope = new ManagementScope(@"\root\cimv2");
ObjectQuery query = new ObjectQuery("select * from Win32_DiskPartition");
ManagementObjectSearcher searcher = new
ManagementObjectSearcher(scope, query);
ManagementObjectCollection drives = searcher.Get();
foreach (ManagementObject current in drives)
{
Console.WriteLine("device id = " + current["deviceid"]);
ObjectQuery associators = new ObjectQuery("ASSOCIATORS OF {Win32_DiskPartition.DeviceID=\"" + current["deviceid"] + "\"} where assocclass=Win32_LogicalDiskToPartition");
searcher = new ManagementObjectSearcher(scope, associators);
ManagementObjectCollection disks = searcher.Get();
foreach (ManagementObject disk in disks)
{
Console.WriteLine("\tdevice id = " + disk["deviceid"]);
}
}
}
}
}
2) Another Example ...
using System;
using System.Collections.Generic;
using System.Text;
using System.Management;
namespace ConsoleApplication31
{
class Program
{
static void Main(string[] args)
{
ManagementScope scope = new ManagementScope(@"\root\cimv2");
ObjectQuery query = new ObjectQuery("select * from Win32_DiskPartition");
ManagementObjectSearcher searcher = new
ManagementObjectSearcher(scope, query);
ManagementObjectCollection drives = searcher.Get();
int dindex= 0;
foreach (ManagementObject current in drives)
{
dindex = int.Parse(current["DiskIndex"].ToString());
}
scope = new ManagementScope(@"\root\cimv2");
query = new ObjectQuery("select * from Win32_DiskDrive WHERE Index = " + dindex.ToString());
searcher = new
ManagementObjectSearcher(scope, query);
drives = searcher.Get();
foreach (ManagementObject current in drives)
{
Console.WriteLine(current["Model"].ToString());
}
}
}
}
I know nothing , I know nothing ...
|
|
|
|
|
Thank you very much for your examples. It was really helpful to me. I combined and modified your solutions and wrote this code:
string VolumeName = "C:";
ManagementScope scope = new ManagementScope(@"\root\cimv2");
ObjectQuery query = new ObjectQuery("ASSOCIATORS OF {Win32_LogicalDisk.DeviceID=\"" + VolumeName + "\"} where assocclass=Win32_LogicalDiskToPartition");
ManagementObjectSearcher searcher = new ManagementObjectSearcher(scope, query);
ManagementObjectCollection drives = searcher.Get();
foreach (ManagementObject current in drives)
{
scope = new ManagementScope(@"\root\cimv2");
query = new ObjectQuery("ASSOCIATORS OF {Win32_DiskPartition.DeviceID=\"" + current["DeviceID"].ToString() + "\"} where assocclass=Win32_DiskDriveToDiskPartition");
searcher = new ManagementObjectSearcher(scope, query);
drives = searcher.Get();
foreach (ManagementObject current2 in drives)
{
MessageBox.Show(current2["model"].ToString());
}
}
|
|
|
|
|
well done, you got my 5....
|
|
|
|
|
I want to create a structure where the elements are bitfields of arbitrary length - e.g. 12 bits followed by 4 bits which would be used as a union with an array but cannot see a neat with to do this.
Any suggestions?
Thanks.
Elaine ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi Elaine,
1.
you can manually create C-style unions in C# using explicit offsets, here is an example:
[StructLayout(LayoutKind.Explicit)]
struct unie {
[FieldOffset(0)]
public float f;
[FieldOffset(0)]
public byte b;
}
You would be taking full responsibility for the correctness of the offsets! (Mind x86/x64 if you are going to store pointers/references)
2.
I am unaware of a proper way to handle bit fields, other than doing it all with ANDs and SHIFTs. Struct/class properties can hide that stuff for the outside world.
3.
Maybe this Masks and flags using bit fields in .NET[^] can inspire you.
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|
|
Thanks Luc.
I've looked at 2 and 3, its' jsut that this would be so much simpler in C++ 
|
|
|
|
|
I've written a program in c#.net whcih uses a pre-designed sql database.
The problem is that I have added a SqlServerProject which attaches my database's mdf file to the local server and it works properly since when I run the program in the visual studio , it attaches the specified file , but the problem is that I don't know what to add to my SetupProject in order to attach the database to local server as the visual studio does as well as installing required files on the target machine?
|
|
|
|
|
The first thing you do is not cross post here.
only two letters away from being an asset
|
|
|
|
|
Export your Database as SQL Script from Sql Entirprise Manager
Add the Exported Sql Script to your Project Resource ( Project -> properties -> resouce )
Call The Script from your project in any place you want ....
and now the example :
SQL Script :
CREATE TABLE [dbo].[billsbody] (
[guid] [uniqueidentifier] NULL ,
[parentguid] [uniqueidentifier] NULL ,
[yarnguid] [uniqueidentifier] NULL ,
[qty] [float] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[billsheader] (
[number] [int] NULL ,
[billguid] [uniqueidentifier] NULL ,
[typeguid] [uniqueidentifier] NULL ,
[date] [datetime] NULL ,
[customer] [uniqueidentifier] NULL ,
[total] [float] NULL ,
[note] [varchar] (255) COLLATE Arabic_CI_AS NULL
) ON [PRIMARY]
C# Code :
public static void CreateNew()
{
SqlCmd = new SqlCommand();
SqlCmd.CommandText = "USE MASTER";
SqlCmd.Connection = clsConnect.SqlCon;
SqlCmd.ExecuteNonQuery();
SqlCmd = new SqlCommand();
SqlCmd.CommandText = "DROP DATABASE [jaloud-tex]";
SqlCmd.Connection = clsConnect.SqlCon;
SqlCmd.ExecuteNonQuery();
SqlCmd = new SqlCommand();
SqlCmd.CommandText = "CREATE DATABASE [jaloud-tex]";
SqlCmd.Connection = clsConnect.SqlCon;
SqlCmd.ExecuteNonQuery();
SqlCmd = new SqlCommand();
SqlCmd.CommandText = "USE [Stark-DB]";
SqlCmd.Connection = clsConnect.SqlCon;
SqlCmd.ExecuteNonQuery();
SqlCmd = new SqlCommand();
SqlCmd.CommandText = global::StarkProject.Properties.Resources.NewDB.ToString();
SqlCmd.Connection = clsConnect.SqlCon;
SqlCmd.ExecuteNonQuery();
}
I know nothing , I know nothing ...
|
|
|
|
|
Thanks Stark !
Let me ask this :
I have created a solution containing about 10 projects which some of them use a pre-designed sql database . I wanted to give a setup file to the user which must place all the required files including two files .mdf and a .ldf file (these are the database's files) and also attach the database to the localhost sql server. So I added a SqlServerProject which attaches the database to localhost server. This project works correctly on my computer when I run the solution in debugger of visual studio , but I don't know what to do , in order to add this functionality to my setup project . I know that when I right-click the SqlServerProject and click Deploy the project attaches the database. I want to know what to do with my Setup Project?!
|
|
|
|
|
Hi all I have a problem here and i'd appreciate any advice at all... I have like 20-something IF statements end else and else if (sample below)
if( something.Text != otherthing.Text )
{
if( MessageBox.Show("Really?") == DialogResult.OK )
{
}
else {
}
else Application.DoEvents();
...Except there's lots more if/else statements nested within one another. And it's very very time-consuming, confusing and after a while it just becomes too much to wrap my brain around. So I guess my question is... I vaigly remember somebody telling me to use Switch/Case things but I've tried reading about them on MSDN and I just can't seem to get my head around it can somebody please explain to me how the switch/case things would work.. In the most dumbest possible way? :P thanks for your time.
thanks lots 
jase
p.s. sorry if my message doesn't make much sense this time, i haven't slept in 48hours lol 
|
|
|
|
|
Hi,
I don't see how a switch might help you, retries means looping.
occasionally I put stuff like that inside a big loop, which provides automatic retries, until either something succeeds, or there is sufficient reason to abandon (in both cases use break or return).
Furthermore, it depends on what exactly you want to achieve, I sometimes use the if structures to set some bool flags, then when all decisions have been made, I execute what each bool flag stands for in straight code.
BTW: don't try recursion on this!
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|
|
I assume this whole method is being called over and over. Therefore, you don't need an else on the inside, just wait for it to run again. At worst, put your Application.DoEvents inside the other else.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
You can't return to an IF statement...
Well and about the switch, it's easy to use... you only have to watch the switch value, cause with it you're going to work in the 'case' statements... ex:
foreach (DataRow dr in ((DataTable)this.Dgv_Datos.DataSource).Rows)
{
switch (dr.RowState)
{
case DataRowState.Modified:
Regionalidades.Id_Regionalidad = Convert.ToInt32(dr["Id_Regionalidad"]);
Regionalidades.NombreRegionalidad = dr["NombreRegionalidad"].ToString();
Regionalidades.modificar(); }
break;
case DataRowState.Added:
Regionalidades.NombreRegionalidad = dr["NombreRegionalidad"].ToString();
Regionalidades.insertar(); }
break;
case DataRowState.Deleted:
Regionalidades.Id_Regionalidad = Convert.ToInt32(dr["Id_Regionalidad", DataRowVersion.Original].ToString());
Regionalidades.eliminar();
break;
}
}
If you see over there, i've used the DataRow 'dr' to verify the RowState (Added, Modified or Deleted) of a DataGridViewRow... well the Namespace Regionalidades is a reference for the class, so it doesn't matter in the code... well i hope it helps... 
|
|
|
|
|
Hi here is the 'new message'... i have a problem with datagridcomboboxcolumn... i think that i can't give to DataPropertyName the value of a string field in my table (only int), cause it displays me nothing T.T  so... the main problem, i think it is because the form with the datagridviewcomboboxcolumn is opened from an MDI parent... that's the problem because when i open the form just normally, the datagridviewcomboboxcolumn displays me the data... What Can i do??? i need help with that
|
|
|
|
|
I'm putting together a dialog mockup that has a panel inside a groupbox. The panel has its border turned on and extends below the bottom edge of the groupbox (in the fully working dialog the panel in question will be in a scrolling control). The problem is that the panel is being drawn over top of the groupboxes border, leaving a 'hole' in it. What's the simplest way to make the mockup look right?
It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies
|
|
|
|
|
if the Panel (or any other Control) is added to the GroupBox (see inside the designer.cs file to check), how could it extend beyond the GroupBox boundaries?
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|
|
The row of pixels that comprise the GB border is legal for child controls to paint on
<Crude ASCII Art Warning>
C is the groupbox border, A is the panel inside the groupbox. The panel extends another dozenish notional pixels below the edge of the groupbox, but that part is properly unpainted.
C AAAAAAAAAAAAAAAAAAAAAAAAAA C
C AAAAAAAAAAAAAAAAAAAAAAAAAA C
C AAAAAAAAAAAAAAAAAAAAAAAAAA C
C AAAAAAAAAAAAAAAAAAAAAAAAAA C
C AAAAAAAAAAAAAAAAAAAAAAAAAA C
CCCCCAAAAAAAAAAAAAAAAAAAAAAAAAACCCCC
It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies
|
|
|
|
|
Yep, I had noticed that, I was expecting you had a more serious complaint than a one-pixel row overlap (it is a mockup after all, isn't it?)
Couldn't you (1) reduce the Panel height and optionally (2) Anchor it to the GroupBox bottom?
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|
|
Luc Pattyn wrote: it is a mockup after all, isn't it?)
Which doesn't mean someone non-technical won't go "WTF Happened to that Border" when being shown the mockups. All things equal I prefer to avoid silly things for them to gripe about.
1) works as a bandaid, but since the dialog is a mockup and assured of changing size arbitrarily, and I need to keep a consistent spacing between the elements in the GB, hard coding a value doesn't really appeal unless it's the only option.
It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
