|
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
|
|
|
|
|
What is "e" in this command
Mohinder Singh
|
|
|
|
|
hi dear i am using asp.net 1.1. i want to combine three fields that i am getting from stored procedure and want the cell to be hyperlink.and when i click i want to pass this as varible in response.redirect tag.How to do it please tell me i need this very urgently.
Thanks in advance
Regards
Mohinder Singh
|
|
|
|
|
Can i get the events that take place on the web form.Can i get the id of the control which is clicked on the web form.I am working on the ASp.Net 2003.
Mohinder Singh
|
|
|
|
|
Probably using Request.Params["__EVENTTARGET"] you can get the control name which caused the postback.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi All,
I want to use an unmanaged dll with in an aspx page (with c#). I try the below code that I am sure it works with a console program.
<br />
<br />
[DllImport("myapi.dll", CharSet = CharSet.Auto)]<br />
public static extern IntPtr function1(); <br />
.<br />
.<br />
.<br />
function1(); <br />
<br />
How could I use this dll with asp.net. Or do you have any advice to integrate a type of any other project with asp.net to use this dll. Also I need a second adwice on working with an exe, in an aspx page.
thax a lot.
karanba
|
|
|
|
|
Hi all,
I want to encrypt and decrypt some data in Database.I got i code to the same but if the input string length is 16 then it encrypts in double length, I mean when I input string of length 16 : XYZXYZXYZXYZXYZ1 then the output is is of length 32.
Please help me.
Thanks in advance...
|
|
|
|
|
|
The problem is that If I input string of length 6 then the encrypted string must be of length 6 only....
Hope u got the problem...
|
|
|
|
|
Why? Is this a limitation on your DB field size?
You'll find that any encryption that is at all hard to break will increase the length of your unencrypted string. Otherwise you're just going to be using a simple letter replacement cipher that any bright 3 year old could break.
|
|
|
|
|
Hi Paddy,
Ya I know this but I will have to change almost all the field size of Database which I want to avoid.If it is possible then please tell me the solution.
Thanks.
|
|
|
|
|
If you want to encrypt items in this way, then you shouldn't be too pushed to write a simple letter substitution encryption - I'm sure you can find something like this on the net. But i'd really question the value of doing this, all it's going to do is slightly slow your application down, without providing any real protection...
|
|
|
|
|
Presently i am working with the R3 wsdl by using the network credntial we are connected to the sap wsdl is there any way to connect r3 without using the networkcredentials and sap.net connector
|
|
|
|
|
How to implement the follwing function like microsoft live spaces with web parts?
1. drag and drop web parts with no postback?
2. if user modified the page layout or edited some contents, need to show a message to tell user the page has be changed, this time need not to save the changes. of course, the user can continue modify the page, at last the user can save all changes.
Thanks.
netspirit
|
|
|
|
|
|
hi friends
select distinct(cname),names,address,phone from post_add
this my code.here i used distinct in one column but it is showed the following output.
this the rusult
ijjklokjlCHR3
sara CHR1
sara CHR2
how to solve error
regards
saravanan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
