|
Please help me.I have declared my variables
***************************
Public Sub addTimesheet(ByVal IdNumber As String, ByVal ProjectName As String, ByVal ProjectMember As String, ByVal ClientSite As String, ByVal ProjectManager As String, ByVal Occupation As String, ByVal WeekNumber As Integer, ByVal Day As String, ByVal Hour As Integer, ByVal Description As String)
Dim Sql As String
Dim obj As Datalayer.Database = New Datalayer.Database
Sql = "insert into TimeSheet (Id_Number,Project_Member,Project_Name,Project_Manager,Hour,Day,Description,Client_Site,Occupation,Week_Number)" & _
" Values('" & IdNumber & "','" & ProjectName & "','" & ProjectMember & "','" & ClientSite & "','" & ProjectManager & "','" & Occupation & "', '" & WeekNumber & "','" & Day & "','" & Hour & "','" & Description & "')"
obj.Execute(Sql)
'addTimesheet = obj.GetDataset(Sql)
'obj.Close()
'Exit Sub
*******************************
Gives me this error
Conversion failed when converting the varchar value 'Select Project Manager' to data type int.(Pointing this query statement) lngRecords = cmdQuery.ExecuteNonQuery()
End Sub
******************
In my AddEntryButton
Dim Obj As Businesslayer.TimeSheet = New Businesslayer.TimeSheet
Obj.addTimesheet(txtIDNo.Text, cmbProjectName.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, cmbClientSite.SelectedItem.Text, cmbProjectManager.SelectedItem.Text, cmbOccupation.SelectedItem.Text, txtWeekNo.Text, cmbDays.SelectedItem.Text, txtHours.Text, txtDescription.Text)
*******************
What might be the Problem(explain it to me please)
oga m
|
|
|
|
|
Check the datatype of the data what you are sending from front end to the database.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Your code will fail with this sort of error whenever your strings contain a single-quote (e.g. "Fred's Project"). Try searching for "SQL Injection" or look at Parametorized SQL[^].
Regards
Andy
|
|
|
|
|
i want to display date in a datagrid column. To fill that datagrid i am filling data to a dataset and i am assigning that data set to datagrid.what my problem is that i am not able to display only date in that column.the time also is displaying with date.if i want to display time only then date also is coming along with time.
please help me to solve this problem
saravanan
|
|
|
|
|
use the ToShortDateString() method...
DateTime dt = new DateTime();
string str = dt.ToShortDateString();
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
if you are pulling the data from database, try to do the date formating in sql server like
CONVERT(VARCHAR,column name,101)
|
|
|
|
|
Saravanainit_2004@yahoo.com wrote: display date in datagrid instead of date and time
1. Use formatter for DateTime fields.
2. mydate.ToString("dd/mm/yyyy"), mytime.ToString("hh:mm tt")
mydate and mytime are variables of DateTime.
Use the TemplateField for DateTime fields in GridView and override RowDateBound method of GridView and use the FindControl to find the label in GridViewRow.Assign the formated date to that label. That's it. 
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
Try:
<%# Convert.ToDateTime(DataBinder.Eval(Container.DataItem, "YourDateTimeFieldHere")).ToString("MM/dd/yyyy") #>
Hope that helps.
Ben
-- modified at 21:10 Thursday 22nd March, 2007
|
|
|
|
|
Goto Prpoerty Builder and Use {d } in DataFormatting String..
|
|
|
|
|
In my code below I'm trying to have the user click on an image. Then pass that associated ID of that image (through XML it is associated).
Any help is welcomed:
<%@Page Language="VB" Debug="True" %>
<script runat="server">
Protected Sub Formview1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewPageEventArgs)
MsgBox(sender.ToString)
End Sub
Sub Get_Shape(ByVal Src As Object, ByVal Args As ImageMapEventArgs)
Response.Write("<b>'" & Args.PostBackValue & "'</b> was clicked")
Response.Write((Me.Formview1.FindControl("lblID").ToString() & " Label Value"))
End Sub
</script>
<html>
<body>
<form id="Form1" runat="server" method ="get">
<asp:FormView ID="Formview1" runat="server" DataSourceID="XmlDataSource1" AllowPaging="True"
OnPageIndexChanging="Formview1_PageIndexChanging">
<ItemTemplate>
ID:<b>
<asp:Label ID="lblID" Runat="server"
Text='<%# XPath("@ID") %>' /></b><br />
<asp:Image ID="img" runat ="server"
AlternateText ="Alt Text" ImageUrl ='<%# XPath("@Path">') />
<asp:ImageMap ID="ImageMap1" Runat="Server"
ImageUrl='<%# XPath("@Path") %>'
HotSpotMode="PostBack"
OnClick="Get_Shape">
<asp:RectangleHotSpot
AlternateText="Pass 'Rectangle'"
PostBackValue= "t"/>
</asp:ImageMap>
</ItemTemplate>
</asp:FormView>
<asp:XmlDataSource id="XmlDataSource1" runat="server" DataFile="~/XML/d2.xml" />
</form>
</body>
</html>
XML file
<?xml version='1.0'?>
<Dogs>
<dog ID="1" Name="Bella.jpg" Path="Images\Gang\Pictures\Thumb\Bella.JPG"/>
<dog ID="2" Name="BellaChristmas.jpg" Path="Images\Gang\Pictures\Thumb\BellaChristmas.JPG"/>
<dog ID="3" Name="DSCF7099.jpg" Path="Images\Gang\Pictures\Thumb\DSCF7099.JPG"/>
</Dogs>
|
|
|
|
|
hi all,
Im using FlowPlayer 1.15 for my project(its in ASP.NET 2.0).By using FlowPlayer, we're displaying FLV videos through a aspx page.please go through the steps i've taken for the same
1.I've added FlowPlayerThermo.swf in my project location
2.Also I've created a folder(say Videos) in my project location where i can store the FLV files.
3.In the Play.aspx page, i've written the code
-------------------------------------------
<b><OBJECT type="application/x-shockwave-flash" data="FlowPlayer.swf" width="320" height="263" id="FlowPlayer">
<param name="allowScriptAccess" value="sameDomain"/>
<PARAM name="movie" value="FlowPlayer.swf"/>
<PARAM name="quality" value="high"/>
<PARAM name="scale" value="noScale"/>
<PARAM name="wmode" value="transparent"/>
<PARAM name="flashvars" value="videoFile=<% = Session["flowFile"]%>"/>
</OBJECT></b>
-------------------------------------------
I'm passing location of the video in session variable(ie, Session["flowFile"] = "videos/mymovie.flv")
The Page Started working and displaying video also, but its showing an Error like this
" 'FlowPlayer' is undefined " . Please lemme know about this error.
NB: Please Note that i've used only FlowPlayerThermo.swf from the Downloaded File, Its also contains two javasvcript files (flowPlayer.js and swfobject.js), 3 HTML Files (FlowPlayer.html,FlowPlayerJs.html,FlowPlayerJs2.html) and One text file(javascript.txt)...Any suggestions will be appreciated !!
mex23
|
|
|
|
|
Do the flowplayer people not have a website ? You're more likely to find people who know what this control is, there.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
I have implemented Menu control ASP.NET 2.0. When I put dropdownlist or button control to the page, these controls are overlapping the menu.
Can any body help me out? Please...
|
|
|
|
|
this is the root of the problem. Drop down list control has higher priority.
so we cant send the control back to div control
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi,
with datetime.now.dayofweek , i will get sunday, monday etc. but i would like to know is there any way to format these output to 1,2,3 ..7.
please help me.
Thanks
Sebastian
|
|
|
|
|
You don't get the string "Sunday", you get the enum value DayOfWeek.Sunday. If you then convert the value to a string, you get "Sunday". If you want it as an integer, just convert it to an integer instead.
---
single minded; short sighted; long gone;
|
|
|
|
|
Thank You. Its working.
Sebastian
|
|
|
|
|
Hi there
I want to store images (pics) in a database.
What would the 'Type' be of the image file in the BD.
And what would the code be to capture the image and save that image to the DB
Thanks
|
|
|
|
|
|
Please help me.I have declared my variables
***************************
Public Sub addTimesheet(ByVal IdNumber As String, ByVal ProjectName As String, ByVal ProjectMember As String, ByVal ClientSite As String, ByVal ProjectManager As String, ByVal Occupation As String, ByVal WeekNumber As Integer, ByVal Day As String, ByVal Hour As Integer, ByVal Description As String)
Dim Sql As String
Dim obj As Datalayer.Database = New Datalayer.Database
Sql = "insert into TimeSheet (Id_Number,Project_Member,Project_Name,Project_Manager,Hour,Day,Description,Client_Site,Occupation,Week_Number)" & _
" Values('" & IdNumber & "','" & ProjectName & "','" & ProjectMember & "','" & ClientSite & "','" & ProjectManager & "','" & Occupation & "', '" & WeekNumber & "','" & Day & "','" & Hour & "','" & Description & "')"
obj.Execute(Sql)
'addTimesheet = obj.GetDataset(Sql)
'obj.Close()
'Exit Sub
*******************************
Gives me this error
Conversion failed when converting the varchar value 'Select Project Manager' to data type int.(Pointing this query statement) lngRecords = cmdQuery.ExecuteNonQuery()
End Sub
******************
In my AddEntryButton
Dim Obj As Businesslayer.TimeSheet = New Businesslayer.TimeSheet
Obj.addTimesheet(txtIDNo.Text, cmbProjectName.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, cmbClientSite.SelectedItem.Text, cmbProjectManager.SelectedItem.Text, cmbOccupation.SelectedItem.Text, txtWeekNo.Text, cmbDays.SelectedItem.Text, txtHours.Text, txtDescription.Text)
*******************
What might be the Problem(explain it to me please)
oga m
|
|
|
|
|
Can ypu please help me I'm still waiting for you reply
oga m
|
|
|
|
|
I have taken a datagrid which has paging with a link button column.
On click of the link button in the grid, i m passing values from the grid to another page thru session.So this is done on the datagrid_ItemCommand event.
Now the problem is..............................
when i click on page number 2 of the datagrid, instead of calling the pageindex change event ....the datagrid_ItemCommand event is called...as it is the property of this event (i.e itemCommand event is the first event of the datagrid to be called before any other event of grid).
Bcoz of this the values which i need to pass on the other page are not found and it gives an error saying...
"Specified argument was out of the range of valid values. Parameter name: index "
Can anyone tell me the way by which i can call the pageindex change event before the Itemcommand event....or any other way by which i can avoid this error...!
Thanking you in anticipation.
Riz
|
|
|
|
|
Do u want to get the selected index??If u r using ASP.NET 1.1 version then u can use e.item.cell[0].text and u can pass this value as
if (e.CommandName == "Select")
{
Response.Redirect("../FolderName/PageName.aspx?Caption=" + e.Item.Cells[0].Text);
}
If 2.0 version then use datakeys.
U dont need to use session here.
Hope I have understood ur problem??
|
|
|
|
|
What u said is fine but my problem is not that. My problem is with paging in the datagrid.
when i click on page number 2 of the datagrid, instead of calling the pageindex change event ....the datagrid_ItemCommand event is called...as it is the property of this event (i.e itemCommand event is the first event of the datagrid to be called before any other event of grid).
Bcoz of this the values which i need to pass on the other page are not found and it gives an error saying...
"Specified argument was out of the range of valid values. Parameter name: index "
Am pasting the code
Private Sub dgrSop_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles dgrSop.ItemCommand
dgrSop.CurrentPageIndex = 0
dgrSop.EditItemIndex = e.Item.ItemIndex
Dim id As Integer
Dim fName As String
Dim sId As String
sId = e.Item.Cells(0).Text
fName = e.Item.Cells(6).Text
Session("FName") = fName
If e.CommandName = "SopEdit" Or e.CommandName = "Del" Then
'id = dgrSop.DataKeys(e.Item.ItemIndex)
Select Case e.CommandName
Case "SopEdit"
Response.Redirect("FrmEditSop.aspx?SopID=" & sId)
Case "Del"
Dim cmddel As SqlCommand = New SqlCommand("ProcDelSOP", ConDel.Connection(Application("ipath")))
cmddel.CommandType = CommandType.StoredProcedure
cmddel.Parameters.Add("@SOPID", id)
cmddel.ExecuteNonQuery()
End Sub
Paging fails here.
Riz
|
|
|
|
|
Have you defined the correct method name in the HTML part of the datagrid in case of OnPageIndexChanged?
Best Regards,
Apurva Kaushal
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
