|
|
|
Hello,
I have a xml file:
<akis xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<element><sql:query>SELECT @Element</sql:query></element>
<rows><sql:query>EXEC sp_ForXML @Element,'XML'</sql:query></rows>
</akis>
and I need to get the results of that.Is there any way to get them not by running the stored procedure but from the xml itself?
thaks in advance,
akis
|
|
|
|
|
Yes, you can query the database direct and have XML returned. You need to use IIS Virtual Directory Management for SQL Server. In the start menu, under SQL Server, there is a link called Configure SQL XML Support in IIS - that should get you started.
|
|
|
|
|
Hi, Am a newbie in c#. am facing a strange problem. I have a tabcontrol and on the first tab page, i have two controls laid side by side. To the first control i have set the anchor as top & left, while to the next i have set it to top and right. When i run the application on windows 2000 prof,(my dev machine) all is fine, i can see the controls as they are supposed to be. But when i open the application in windows XP, the second control has lost its right anchor and it goes beyond the tabpage and tabcontrol boundaries. If i opne the designer in the windows XP machine and may few unrelated changes and save it, it then runs normally on windows XP, but fails to work properly on windows 2000 professional. Am not able to understand what i am doing wrong.
any help please?
|
|
|
|
|
|
Changes that are unrelated to the size or anchor property. just a change like default text.
|
|
|
|
|
It seems that any changes can fix the problem because any changes in the user interface re-generate the upper part of the code which mean if there are any problemm it will be fixed so review the auto generate part of the code sometimes setting some statements befor others can play important role in the application interface
in order to solve that problem try to justify that ancode by code and set that code in a Load event to fix that problem
try it and tell me the result
Mhmoud Rawas
------------
Software Eng.
|
|
|
|
|
The auto generated code is same on both the machines. I was unable to locate any difference in the two files.
|
|
|
|
|
Hy,
I want to select item(s) in a c# ListView from code. SelectedIndices and SelectedItems methods are read only.
Thanks,
Mihai
|
|
|
|
|
listView1.Items[0].Selected = true;
listView1.Items[3].Selected = true;
listView1.Select();
|
|
|
|
|
Hi
I am using the Microsoft.Jet.OLEDB to connect to an Excel workbook
I can use the following sql to insert data into the Excel sheet (I hope my syntax is correct. I do not have the compiler with me):
String sql = “Insert INTO [Sheet1$] (Lastname, Firstname1) Values ('XXX', ’YYY’)";
OleDbCommand cmdExcel = new OleDbCommand(sql, conn);
OleDbDataReader drExcel = cmdExcel.ExecuteReader();
The problem that I have, is that for that INSERT to work those column headers (eg Lastname, Firstname1) need to exist in the workbook. I want to create a new workbook using code and insert data without having column names to insert the data under. How would I change the INSERT sql to specify in which column to insert data in (eg in A, B, etc).?
Thanks.
Kobus
|
|
|
|
|
try to use
create table NewSheet ......
or
alter table [Sheet1$] add ......
them you can use insert statement
|
|
|
|
|
I can't insert date 29-Feb-2000 or 29-Feb-2004. please tell me why?
|
|
|
|
|
|
DataType missmacth in criteria expression
|
|
|
|
|
|
Yeah!! the point is i can insert 28-Feb-2004 but 29-Feb-2004 it error. I don't know why.
|
|
|
|
|
This is the code I have used to send a mail ..But using this some body didn't collect their mail .I think I need to put sender name and password when setting SMTP..But there is No place set it..
can any one please tell me to set user name and password of the mail sender?
MailMessage mailMsg = new MailMessage();
mailMsg .From = "pu12345@developeroffice.com";
mailMsg .To = "rasika12@yahoo.com";
mailMsg .Subject="newmail";
mailMsg .Body = "boday";
SmtpMail.SmtpServer="servername";
SmtpMail.Send(mailMsg);
thanks in advance..
|
|
|
|
|
|
this may return to your mail srever some mail servers don't accept unvalied users you should use a valied mail in from field
Mhmoud Rawas
------------
Software Eng.
|
|
|
|
|
my application works like this,i have a datagrid,a dropdownlist and a submit button,my
dropdownlist contains a list of intervals eg(100-999)(2100-2199),in order for the user to
add to the grid he has to choose an interval from the dropdown,and the id for the row he's
adding has to be in that particular interval.
i have a method/function that checks if the id is in the chosen interval
private void checkvalue(int value)
{
if(value>=100 && value<=999)
{
}
else
{
label.text ="value is not in the required interval"
}...
and the button clickevent
private void ButtSubmit_Click(object sender, System.EventArgs e)
{
checkvalue(num);
//adding to the grid
collection.add(num);
...
}
when i click my submit button ,and into the checkvalue callfunction,if the value is not in  the required interval ,it prints the text message but still continues to add the row to my grid
i want it to stop after it prints the message and exit without adding the row to my grid,what do
you suggest i do.i hope this is clear enough
thanks
|
|
|
|
|
|
I think you want your "checkvalue" method to return a boolean.
private bool CheckValue(int num)
{
return (value>=100 && Value<=999)
}
private void ButtSubmit_Click(object sender, System.EventArgs e)
{
if(CheckValue(num))
{
collection.Add(num);
}
else
{
label.Text ="value is not in the required interval"
}
}
|
|
|
|
|
I have seen a kind of navigation and i want to know the name of this. It was on the site "www.reinhard-mey.de".
Can anybody help us me? Give it the control also in c#?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
