i am having trouble filtering datatable
how can i do this WHERE theDate BETWEEN #1.1.2000# AND #1.1.2002#
this work
TestBindingSource.Filter = "theDate=#1.1.2000#";
Best regards Hlynur
http://www.xodus.net
i have a question
is it possible to read multiple records and update it to one record?
I have this code and i need to find all records that match my query and put them all in one record
<code>
UPDATE #tmpSearchTable
SET Monday = SchedulerEvents.Title+'<br/>x'
FROM...
I am trying to make an stored procedure that can read enum values
its no problem in asp.net http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemflagsattributeclasstopic.asp
is it possible in sql server 2000 if so can any body point me into the right...
I am using this code to power down my monitor on xp without sp2
const int MONITOR_ON = -1;
const int MONITOR_OFF = 2;
const int WM_SYSCOMMAND = 0x0112;
const int SC_MONITORPOWER = 0xF170;
const UInt32 ES_CONTINUOUS = 0x80000000;
System.Threading.Thread.Sleep(2000)...
im making an email system that can send the page you are on, the problem is i cant read the html content to send it.
does anybody have a solution for this.
Best regards Hlynur
http://www.xodus.net
I hava a datalist with
<asp:CheckBox id="SecPage" AutoPostBack="True" OnCheckedChanged="Check_Clicked" runat="server"></asp:CheckBox>
the problem is i cant find out in whats row the checkbox was fired
Best regards Hlynur
http://www.xodus.net
the problem is that my code is in the aspx.cs document and i need to print out a string in my aspx document.
i have a flash document witch needs a string from my code to work
<PARAM NAME="Movie" VALUE="charts/liner.swf?dataXML='<%# xmlDoc%>'">
can anybody please help me i am totaly blank...
i am having problem with datalist insite a nother datalist
i have a button insite the sub datalist and a record i need to edit inn EditItemTemplate
and when i try to use this code i get an error
Object reference not set to an instance of an object
does anybody know what i need to do
public...
i allways get this "error Specified argument was out of the range of valid values. Parameter name: index"
Line 53:<asp:Label Runat="server" ID="error"></asp:Label>
Line 54:</font><font face="Verdana" size="2">
Line 55:<asp:Label Runat="server" ID="No_Error"></asp:Label>...
double vsk = Convert.ToInt32(SumAllStr)*0.19;
i allways get Input string was not in a correct format.
but the string is 109000
can anybody tell me what i am doing wrong
Best regards Hlynur
http://www.xodus.net
i am having problem with <asp:datalist
i am trying to acces an asp:label insite a datalist footertemplate
when i try to SumAll.Text = "test" in my code i get an Object reference not set to an instance of an object ERROR when i try to run the website
can anybody help me
Best regards Hlynur...
foreach(DataListItem item in ListItemstest.Items)
{
how can i change the button.text
}
<asp:ListItems id="ListItemstest" Runat="server">
<ItemTemplate>
<asp:Button id="test" text="">
Best regards Hlynur
http://www.xodus.net
set @tempTable = 'SELECT sum(' + @tempTable + ') '
set @tempTable = @tempTable + 'FROM #ReturnStada '
set @tempTable = @tempTable + 'WHERE RoomType<>''Allotments left'''
set @tempTable = @tempTable + ' AND RoomType<>''Free rooms'''
execute sp_executesql @tempTable
can anybody help me to get...
I have a shop categories, and within these categories, I have subcategories,I want to display just 3 subcategories for each main category
I am using dataset with Relations
ds.Relations.Add("MenuRelation", ds.Tables["Shop_catagory"].Columns["catID"], ds.Tables["Products"].Columns["catagory"])...
is thera a way to make sql autogenerate script to alter tables
i have 2 db one desing db for my program and one db for the accual online program , and when i have alter the desing db i would like to run a script that alters the db witch is in use, with out destroing all the data that exist on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.