|
Hi All,
I would like to take only Date part of DateTime variable?
Eg. 2008-09-18 12:00:01.000' i only needed 2008-09-18
Please advice
Thank you
Kibrom
|
|
|
|
|
DatTime has a ToShortDateString() method. You can also access the Year ,Month & Day properties directly.
All this you could have found out yourself by reading the actual documentation for the class.
|
|
|
|
|
Use the Date property of the DateTime structure.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
How we can import MS access database table's data into Sql server 2005 in ASP.net with C# (in Web application) .
Please send me response on my mail id anu.gaur.iec@gmail.com
Anu Gaur
|
|
|
|
|
Putting your email address in your post is not a good idea.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I am having a gridview. I want ot put the data from the gridview to the business object and store it in aarraylist. and then pass the array of objects to store data in the database.
I am not getting the value of the gridview column in the object . I am doing like this
for( i=0;i<gridview1.rows.count;i++)
{
classABC objectABC=new classABC ();
objectABC.ItemBaseId=Convert.ToString(GridView1.Rows[i].Cells[2].Text);
objectABC.Catalog = Convert.ToString(GridView1.Rows[i].Cells[3].Text);
objectABC.Series = Convert.ToString(GridView1.Rows[i].Cells[4].Text);
arr.Add(objbom);
}
Please tell me how to do this?
|
|
|
|
|
try the change shown
for( i=0;i<gridview1.rows.count;i++)>
{
classABC objectABC=new classABC ();
objectABC.ItemBaseId=Convert.ToString(GridView1.Rows[i].Cells[2].Text);
objectABC.Catalog = Convert.ToString(GridView1.Rows[i].Cells[3].Text);
objectABC.Series = Convert.ToString(GridView1.Rows[i].Cells[4].Text);
arr.Add(objectABC);
}
Bob
Ashfield Consultants Ltd
|
|
|
|
|
not getting what you are telling.
will you please elaborate it
|
|
|
|
|
You have
arr.Add(objbom);
but it should be
arr.Add(objectABC);
as objbom isn't even defined.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
ya I tried with that also.
But am not getting the value that are in the gridview cells.
the gridview value is coming null.
Am I doing some mistake while setting gridview text to the object?
|
|
|
|
|
I don't know. Have you tried debugging to see what values you are getting?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
|
Google is ur friend use it.
|
|
|
|
|
I am working in SQL Server/asp.net Database
How to using val() in sql?
mycode datatype is string
values as "MS12", "MW10", ...
My query is "Select * from FILE1 where val(substring(mycode,3,2))=10"
Sql say error as val is not recognised function name
Kindly tell your suggesions.
Thanking you
abglorie
|
|
|
|
|
Re: Please Dont Cross Post
|
|
|
|
|
How to using val() in sql?
mycode datatype is string
values as "MS12", "MW10", ...
My query is "Select * from FILE1 where val(substring(mycode,3,2))=10"
Sql say error as val is not recognised function name
Kindly tell your suggesions.
Thanking you
abglorie
|
|
|
|
|
which database you are working? Please specify
Abhishek Sur
|
|
|
|
|
sql2000 database is using
|
|
|
|
|
abglorie wrote: Sql say error as val is not recognised function name
Thats because it isn't. Bet you copied this from excel or Access. Just look up substring in sql help.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
write like this
Select * from FILE1 where Cast(substring(mycode,3,2) as int)=10
Abhishek Sur
|
|
|
|
|
Hi All,
I've created a tab container with tab panels. The page in which I created the tab container is a content page.When I run the application I am not able to view the tabs.If I create these tabs in normal pages I have no problem.
code is given below.
]]>
<asp:content contentplaceholderid="SiteContentPlaceHolder" runat="server" xmlns:asp="#unknown">
<asp:scriptmanager id="ScriptManager1" runat="server">
<ajaxtool:tabcontainer id="TabContainer1" runat="server" activetabindex="0" xmlns:ajaxtool="#unknown">
<ajaxtool:tabpanel id="TabUsers" runat="server" headertext="Users" font-underline="False">
<contenttemplate>
<asp:textbox id="TextBox1" runat="server">
<asp:button id="Button1" runat="server" text="Button">
<ajaxtool:tabpanel id="TabQuestionBank" runat="server" headertext="QuestionBank">
Font-Underline="False">
<contenttemplate>
<asp:label id="lblExperience" text="Experiencerfd" runat="server">
<ajaxtool:tabpanel id="TabPanel1" runat="server" headertext="Roles" font-underline="False">
<contenttemplate>
<asp:label id="Label2" text="Exfsdfsdf" runat="server">
|
Thanks for any one who is going to help me
|
|
|
|
|
Why do you have:
<form id="form1" runat="server">
and
<asp:scriptmanager id="ScriptManager1" runat="server">
In my opinion these to should bee on your MasterPage and not on the content page
I had a project where I used tabs on a content page without any problems...... Try to move this two and then run it again.....
Kind regards,
simsen
|
|
|
|
|
Hi,
i have created a new folder and define a class outside the app code folder but it is not visible on webpage.aspx.vb pages. will any one help me
KnightGuy
|
|
|
|
|
I think change your web site to web application. Then it will do.. I think.
You need to see if the file is included or not and in current namespace.
Abhishek Sur
modified on Thursday, September 18, 2008 6:14 AM
|
|
|
|
|
Check if the newly created class has any namespace
if it has namespace then include this namespace in your .vb class
by
using namespaceWholeName;
then try to access
<edited>
Might be yours is website and compiler will not compile you class files until these are not in App_Code folder thats the reason you can't access this class
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|