|
thank you sir.....am trying to check around it right away but plz...are there any tips as to where to actually look around?
Thanks once more
well da dataset displays da correct number of rows and records
|
|
|
|
|
Public Shared Function GetListofCheckinByIDandcurrentMonth(ByVal thecusid As Integer, ByVal thedate As String, ByVal thedateend As String) As List(Of checkin)
Dim thechecklist As List(Of checkin) = New List(Of checkin)
Using myConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString)
Dim cmd As SqlCommand = New SqlCommand("Select Check_id, Cus_id, check_in, check_out, check_note from tbl_customer_check_in where Cus_id =@cusid and check_in between @datestart and @dateend ", myConnection)
cmd.Parameters.AddWithValue("@cusid", thecusid)
cmd.Parameters.AddWithValue("@datestart", thedate)
cmd.Parameters.AddWithValue("@dateend", thedateend)
Dim thechecked As New checkin 'Temp Product to add to our ProductList
myConnection.Open()
Dim reader As IDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
Return GetCheckinCollectionFromReader(reader)
End Using
Return thechecklist
End Function
Protected Shared Function GetCheckinFromReader(ByVal Reader As IDataReader) As checkin
Return New checkin(CInt(Reader("check_id")), _
CInt(Reader("cus_id")), _
CDate(Reader("check_in")), _
CDate(Reader("check_out")), _
Reader("check_note").ToString)
End Function
Protected Shared Function GetCheckinCollectionFromReader(ByVal Reader As IDataReader) As List(Of checkin)
Dim Check As New List(Of checkin)
While (Reader.Read)
Check.Add(GetCheckinFromReader(Reader))
End While
Return Check
End Function
|
|
|
|
|
None of this code matters. If you're getting a null, it's null in your DB, I assume. Are you claiming it's not ?
What if you step through the code, is the value from the reader null, or just your ugly. VB6 style cast is returning null ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
maybe you check with something like
IF CDate(Reader("check_in")) = DBNUll.Value Then
else
'do something with the value
end if
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Can we read serial port using javascript.
ARINDAM
|
|
|
|
|
Hell, no, are you insane ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
|
Is it possible to bind two data source into single grid view? I m doing the shopping cart. in my shopping cart gridview, i already call Cart and Food table together in 1 sqldatasource.. Now i need to call another table that are Cart and SetFood table.. so.. can i have 2 data source? or can i have 2 select command in one datasource?? How to bind this 2 data to single gridview? Your idea and suggestions are really appreciated... thx
|
|
|
|
|
No. You need to return one table that combines the two data sources.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi Everyone,
I am developing an application in which I need to implement SMS polling and voting feature.
Suggest me some reliable SMS gateway providers whose Web Services I can consume in my application. I need to store the results back in to the database, so I need to receive the SMS also and store the result with Sender's detail.
Also suggest me that as a developer which things I need to take care of while developing such application...
Any suggestion would be helpful..
Regards,
-SIFAR.
|
|
|
|
|
Sifar - 0 wrote: Also suggest me that as a developer which things I need to take care of while developing such application...
This is a bit vague. How do you mean ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
It was a bit unclear...
Which protocol APIs would be preferred for bulk SMS application
Awaiting for suggestion..
Regards,
-SIFAR.
|
|
|
|
|
Plz google out stufffs First b4 u post here.Thanks
http://www.scampers.org/steve/sms/libraries.htm
|
|
|
|
|
< Hi All,
I'm working on a ajax enabled project.It was running fine in live server.But recently after eanbling ssl to the live server it is giving a config error like,
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Error Line:
<add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
WRN: Assembly binding logging is turned OFF.
Can anyone please help me regarding this?
Thanx in advance...  
|
|
|
|
|
|
Well, in the first instance, it's not urgent at all. I checked with everyone in the building.
Second, what can you tell us about your ability to read, your reading of this error message, and what you've done to make sure that it's not a reasonable error ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
My subject line is the actual question!
Thanks
Tina
|
|
|
|
|
Sorry...i was just able to add a new class and or page in VB to a C# project...which clearly suggest that it's possible.
The questions is passing data between pages that are written in VB.Net and C# both would also be pretty simple!!! Has anyone done somethign like that before?
|
|
|
|
|
HI Tina ,
Yes i have. Thats possible in .Net
Regards
Anil Pal
|
|
|
|
|
I think the big question is, why would you want to? Makes it hard from a maintenance point of view if things aren't consistent...
|
|
|
|
|
Yes, but you need to alter your web.config like this:
<codesubdirectories>
<add directoryname="VB_Code">
<add directoryname="CS_Code">
Now create two folders in your App_Code, VB_Code and CS_Code. It's even possible to call up a VB function from C# code and I believe, vice-versa. I'm using VS 2005. Hope this helps
|
|
|
|
|
Hi All,
I'm new to ASP, so I just find a code and see how to workaround. I'm stuck on a simple thing.
In an excel file there is a column name, Tel, stand for telephone number. You can enter numbers or text there in cells.
The values are display on label as follows.
<br />
<asp:TemplateField HeaderText="Telephone"><br />
<ItemTemplate><br />
<span id='TelIdPrefix<%# Eval("UserId")%>'><br />
<asp:Label ID="Label131" runat="server" Text='<%#Eval("Tel")%>'></asp:Label><br />
</span><br />
</ItemTemplate><br />
</asp:TemplateField><br />
What happen here is, if the cell format is different, only one type(maximum number of elements in same type) is display. Say there are 3 text formats and 4 number format. Only the numbers are display.
Please give me a hint to sort out this.
Thanks 
I appreciate your help all the time...
CodingLover
|
|
|
|
|
As you are talking about excel. So r u trying to transfer data from GridView and while exporting u r facing problem or What?
Regards
Anil Pal
|
|
|
|
|
Actually what I want to need is change the column cell format to text. In that case, even cell values are numbers of text/string, all the elements are text.
So basically what I want to do is, format the cell format in a specific column into text format.
Can you help me on this, please.
Thanks
I appreciate your help all the time...
CodingLover
|
|
|
|
|
DataGridView1.Rows(3).Frozen = True
DataGridView1.Rows(3).Cells(2).ReadOnly = True
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
