|
SQL server 2005 had two login modes, "Windows Authentication mode" and "SQL Server and Windows Authentication mode". So that means that you should be able to log in with the Windows Credentials for the user you installed with. Try that and see what you come up with.
Hogan
|
|
|
|
|
It works...
|
|
|
|
|
1) This is not the appropriate forum, the SQL or even General forum would be better than C# for this question
2) DON'T use urgent in the subject. It may be urgent to you, but not to everyone else. People volunteer to answer questions, saying urgent is like demanding a response. It's rude!
only two letters away from being an asset
|
|
|
|
|
I want to compare between two dates.
One date is System Date mm/dd/yyyy format
Other one is User i/p Date in SAME FORMAT.
I want to check whether the User I/P date is greater/less/euqal than the system date.
How can I compare between them
|
|
|
|
|
I don't know what you mean by:
simworld wrote: Other one is User i/p Date
Anyway, you can compare dates as following
myDate1 > myDate2 or myDate1 <= myDate2, etc
|
|
|
|
|
I want to say..
I have a table that contains columns with date value(System date).
In a form a Text box (User i/p)that takes only date in a mm/dd/yyyy format
if user date will be greater/less/equal than the system date,then certain event will occur.
I want the C# code syntax that will compare those date.
i think this give u clear view what my question is??
|
|
|
|
|
The date comparison examples I gave before would be how you compare dates.
I'm guessing what you mean is that you want to make sure that the user enters a valid date and compare that to another date.
To do this you can implement code similar to this:
DateTime systemDate = DateTime.Today;<br />
DateTime userInputDate;<br />
bool bValidDate = DateTime.TryParse(textBox.Text, out userInputDate);<br />
if (!bValidDate)<br />
{<br />
MessageBox.Show(textBox.Text + " is not a valid date!");<br />
}<br />
else<br />
{<br />
if (systemDate < userInputDate)<br />
{<br />
}<br />
}
|
|
|
|
|
Use a DateTimePicker, not a TextBox.
|
|
|
|
|
Convert userIPDate to DateTime
DateTime DateNow = DateTime.Now.Date;
return DateNow.CompareTo(userIPDate); will return -1 if DateNow is less than, 1 if greater than and 0 if equal to.
|
|
|
|
|
The best way I have found is to subtract one DateTime from another, creating a TimeSpan object. Then use the result of the TimeSpan object to do your testing. Hope this helps!
DateTime dt1 = DateTime.Now;
DateTime dt2 = DateTime.Now.AddDays(1);
//Compare
TimeSpan ts = dt1 - dt2;
if (ts.TotalMinutes < 50)
{
//do good stuff here
}
Hogan
|
|
|
|
|
thank u very much to all of u ,for helping me.
|
|
|
|
|
Hi,
I want to read a table html string and create a DataTable class object from that table html. Would anyone show me how to do that in C#.NET 2.0 ?
For example : I have
string tableHtml = " value 2 ";
Now I want to create,
DataTable myTable = .....
Regards.
|
|
|
|
|
|
hi all
i Creat BackUp DataBase by Code using C#.Net from sqlserver 2005 .
but when i wount to restart this Backup From computer device to sqlserver 2005
the problem occure (the problem is the name of mdf and ldf for the file is the same ... ).
who ican convert the name of the mdf and ldf by C#.Net Code ?
thanks for any body hellp me
Thaer
|
|
|
|
|
You can't, not trivially. The backup format is supported by SQL Server, there's no methods you can call to unpack it, unless it's really a zip, or unless you can control SQL Server to do it via interop.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
How can i read properties of a file(microsoft office) using ifilter. I can read the text in file as there are lot of such examples but no examples where i could read property( which are on summary tab of file property) using only c# any help will be highly appreciated
|
|
|
|
|
Try this[^] article form information on using IFilter. While he doesn't deal in the article specifically with summary info, it's fairly easy to then follow this up with a read of this[^] article which should give you more detail.
|
|
|
|
|
private System.Windows.Forms.GroupBox grpbox;
XPathDocument dom;
XmlDocument doc;
XPathNavigator nav;
XPathExpression expr;
XPathNodeIterator iterator;
int cnt=0;
Label lbl;
TextBox txt;
OpenFileDialog dlg;
TreeNode newTreeNode;
//int cnt = e.Node.GetNodeCount(false);
//string filename;
private void Form1_Load(object sender, System.EventArgs e)
{
//label1.Text = "File Path";
//label1.SetBounds(8, 8, 50, 20);
//filename = Application.StartupPath + "\\Sample.xml";
//textBox1.Text= filename;
//textBox1.SetBounds(64, 8, 256, 20);
button1.Text = "Populate the TreeView with XML";
button1.SetBounds(8, 20, 200, 20);
treeXml.Height = 600;
treeXml.Width = 400;
grpbox = new GroupBox();
grpbox.Height = 600;
grpbox.Width = 400;
grpbox.SetBounds(500, 2, 700, 600);
grpbox.Visible = true;
grpbox.Dock.Equals(Right);
grpbox.Show();
this.Controls.Add(grpbox);
//dom = new XPathDocument(dlg.FileName);
}
private void ConvertXmlNodeToTreeNode(XmlNode xmlNode,
TreeNodeCollection treeNodes)
{
TreeNode newTreeNode = treeNodes.Add(xmlNode.Name);
switch (xmlNode.NodeType)
{
case XmlNodeType.ProcessingInstruction:
case XmlNodeType.XmlDeclaration:
newTreeNode.Text = "<?" + xmlNode.Name + " " +
xmlNode.Value + "?>";
break;
case XmlNodeType.Element:
if (xmlNode.Name.ToLower().Equals("node") == true)
{
newTreeNode.Text = "<" + xmlNode.Attributes["label"].Value.ToString() + ">";
}
else
newTreeNode.Text = "<" + xmlNode.Name + ">";
break;
case XmlNodeType.Attribute:
newTreeNode.Text = xmlNode.Name;
// newTreeNode.Text = "ATTRIBUTE: " + xmlNode.Name;
break;
case XmlNodeType.Text:
case XmlNodeType.CDATA:
newTreeNode.Text = xmlNode.Value;
break;
case XmlNodeType.Comment:
newTreeNode.Text = "<!--" + xmlNode.Value + "-->";
break;
}
if (xmlNode.Attributes != null)
{
foreach (XmlAttribute attribute in xmlNode.Attributes)
{
ConvertXmlNodeToTreeNode(attribute, newTreeNode.Nodes);
}
}
foreach (XmlNode childNode in xmlNode.ChildNodes)
{
ConvertXmlNodeToTreeNode(childNode, newTreeNode.Nodes);
}
}
private void treeXml_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
{
cnt = e.Node.GetNodeCount(false);
grpbox.Controls.Clear();
for (int i = 0; i < cnt; i++)
{
Label lbl = new Label();
TextBox txt = new TextBox();
lbl.Text = e.Node.Text;
lbl.Left = 200;
lbl.Top = 200 * i;
txt.Left = 250;
txt.Top = 200 * i;
lbl.Show();
txt.Show();
grpbox.Controls.Add(txt);
grpbox.Controls.Add(lbl);
}
}
private void button1_Click(object sender, System.EventArgs e)
{
XmlDocument doc = new XmlDocument();
OpenFileDialog dlg = new OpenFileDialog();
treeXml.Nodes.Clear();
dlg.Title = "Open XML File";
dlg.Filter = "xml files (*.xml)|*.xml|All files (*.*)|*.*" ;
if (dlg.ShowDialog() == DialogResult.OK)
{
//imgPhoto.Image = new Bitmap(dlg.OpenFile());
doc.Load(dlg.OpenFile());
}
dlg.Dispose();
ConvertXmlNodeToTreeNode(doc, treeXml.Nodes);
treeXml.Nodes[0].ExpandAll();
}
// insert --- its not working
private void button2_Click(object sender, System.EventArgs e )
{
nav = doc.CreateNavigator();
expr = nav.Compile(dlg.FileName);
iterator = nav.Select(expr);
try
{
while (iterator.MoveNext())
{
XPathNavigator nav2 = iterator.Current.Clone();
}
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
//XPathDocument dom=new XPathDocument();
try
{
XmlTextReader reader = new XmlTextReader(dlg.FileName);
//XmlDocument dom = new XmlDocument();
doc.Load(reader);
reader.Close();
XmlNode currNode;
XmlDocumentFragment docFrag = doc.CreateDocumentFragment();
for(int i=0;i< cnt;i++)
{
docFrag.InnerXml="<" + lbl.Text + ">" +
"<" + txt.Text + ">" ;
}
// insert the availability node into the document
currNode = doc.DocumentElement;
currNode.InsertAfter(docFrag, currNode.LastChild);
//save the output to a file
doc.Save(dlg.FileName);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Console.WriteLine ("Exception: {0}", ex.ToString());
this.DialogResult = DialogResult.Cancel;
}
}
private void button2_Click_1(object sender, System.EventArgs e)
{
}
private void button3_Click(object sender, System.EventArgs e)
{
}
}
}
|
|
|
|
|
What do you mean by "not working"?
What happens? (And "nothing" never happens...)
Do you get any error message?
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
no i am not getting the logic how to do it? an confustion in a code....
|
|
|
|
|
Well, if you don't explain what it is that you are trying to do with the code, it's even more confusing for someone who hasn't written it...
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
i just want to insert a new node in the treeview and xml file both , where i can insert name and values from textbox.... will u help in for code?
|
|
|
|
|
i have textbox in which i can fill the values which should be updated into the treenode...?
|
|
|
|
|
Simple example:
string someText = yourTextBox.Text;
TreeNode aNode = new TreeNode();
aNode.Name = "some name here";
aNode.Text = someText;
yourTreeCtrl.Nodes.Add(aNode);
You could get more browsing the MSDN articles[^], couldn't you?
SkyWalker
|
|
|
|
|
When Im trying to work with Webparts im receiving this error...help me friends.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Hi,Im Razana
|
|
|
|