|
I use WebMatrix 3. I've got an ASP.NET Web Pages site that draws fractals, it uses a SQL Compact database and works fine locally.
But after I published it to the Azure Cloud and tried it, I get an error in the Database.cshtml that it doesn't work. Error: Failed to find or load the registered .Net Framework Data Provider.
The URL is: http://aljo-fractals.azurewebsites.net Click on the option Database and you'll get to see the error.
I guess I need to add a framework to use the database, where do I get that?
This must be easy to fix, but how...
|
|
|
|
|
Hi,
I have developed an ASP.net VB application on 1.1 in which we insert certain data into a particular table which is on sybase.
My table structure:
CREATE TABLE dbo.at_ip_disbursement
(
doc_id numeric(7,0) IDENTITY,
doc_type varchar(30) NOT NULL,
rim_no int NOT NULL,
item_type varchar(80) NULL,
customer_name varchar(80) NOT NULL,
rsm_name varchar(80) NOT NULL,
branch_no int NULL,
business_unit varchar(30) NOT NULL,
input_dt datetime NOT NULL,
Category varchar(30) NULL,
deferral_details nvarchar(600) NULL,
days_deferred int NULL,
Deff_Expdt datetime NOT NULL,
Deferred_Dt datetime NULL,
rm_comments nvarchar(600) NULL,
creator_id varchar(10) NULL,
modifier_id varchar(10) NULL,
status char(1) NOT NULL,
App_Authority nvarchar(600) NULL
)
LOCK ALLPAGES
go
IF OBJECT_ID('dbo.at_ip_disbursement') IS NOT NULL
PRINT '<<< CREATED TABLE dbo.at_ip_disbursement >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE dbo.at_ip_disbursement >>>'
go
Now the piece of code where the insert takes place:
Public Shared Function AddDisbursement(ByVal DocType As String, ByVal Rim As Int32, ByVal CustomerName As String, ByVal RSMName As String, ByVal BranchNo As Int32, ByVal Business As String, ByVal InputDate As String, ByVal Category As String, ByVal DeferralDetails As String, ByVal DeferredDays As String, ByVal DefExpDate As String, ByVal DefDate As String, ByVal RMComments As String, ByVal CreatorId As String, ByVal App_Authority As String, ByVal Item As String) As String
Dim logger As SKLogger = New SKLogger
Dim connMosaic As String = System.Web.HttpContext.Current.Session("connStr").ToString()
Dim cmdText As String
cmdText = "INSERT INTO at_ip_disbursement(" & _
"doc_type, " & _
"rim_no, " & _
"customer_name, " & _
"rsm_name, " & _
"branch_no, " & _
"business_unit, " & _
"input_dt, " & _
"Category, " & _
"deferral_details, " & _
"days_deferred, " & _
"Deff_Expdt, " & _
"Deferred_Dt, " & _
"rm_comments, " & _
"creator_id, " & _
"status, " & _
"App_Authority, " & _
"item_type) " & _
"VALUES (" & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"?," & _
"'A'," & _
"?," & _
"?)"
Dim conn As OdbcConnection = New OdbcConnection(connMosaic)
Dim cmd As OdbcCommand = New OdbcCommand(cmdText, conn)
cmd.Parameters.Add("@DocType", OdbcType.VarChar).Value = DocType
cmd.Parameters.Add("@Rim", OdbcType.Int).Value = Rim
cmd.Parameters.Add("@CustomerName", OdbcType.VarChar).Value = CustomerName
cmd.Parameters.Add("@RSMName", OdbcType.VarChar).Value = RSMName
cmd.Parameters.Add("@BranchNo", OdbcType.Int).Value = BranchNo
cmd.Parameters.Add("@Business", OdbcType.VarChar).Value = Business
cmd.Parameters.Add("@InputDate", OdbcType.Date).Value = InputDate
cmd.Parameters.Add("@Category", OdbcType.VarChar).Value = Category
cmd.Parameters.Add("@DeferralDetails", OdbcType.VarChar).Value = GetNull(DeferralDetails)
cmd.Parameters.Add("@DeferredDays", OdbcType.Int).Value = DeferredDays
cmd.Parameters.Add("@DefExpDate", OdbcType.Date).Value = DefExpDate
cmd.Parameters.Add("@DefDate", OdbcType.Date).Value = GetNull(DefDate)
cmd.Parameters.Add("@RMComments", OdbcType.VarChar).Value = GetNull(RMComments)
cmd.Parameters.Add("@CreatorId", OdbcType.VarChar).Value = GetNull(CreatorId)
cmd.Parameters.Add("@App_Authority", OdbcType.VarChar, 1200).Value = GetNull(App_Authority)
cmd.Parameters.Add("@Item", OdbcType.VarChar).Value = GetNull(Item)
Try
conn.Open()
cmd.ExecuteNonQuery()
Catch ex As Exception
logger.LogException("AddDisbursement", ex.ToString())
AddDisbursement = ex.Message
Finally
cmd.Dispose()
conn.Close()
End Try
'Return True
End Function
Now through javascript i allow user to input only 500 Characters(which works perfectly). Once the user submits data (say for example 400 characters) which is under the field "App_Authority" i get the following error:
ERROR [HY000] [INTERSOLV][ODBC SQL Server driver][SQL Server]ct_param(): user api layer: external error: A data length of 399 exceeds the maximum length allowed for CHAR data.
The same happens when i try to insert data into fields "RMComments" and "DeferralDetails"
Kindly advise me.
Thanks in Advance
|
|
|
|
|
<<tash18>> wrote: cmd.Parameters.Add("@App_Authority", OdbcType.VarChar, 1200).Value = GetNull(App_Authority)
Above is varchar, but in the table, you made it nvarchar,
It's a mismatch, that involves unicode I think, in which one is double the space of the other,
varchar is a 8bit codepage
[edit]
adjust your column in the table to take 1200 or whatever the value is suppose to be or vice versus
App_Authority varchar(1200) NULL
|
|
|
|
|
I need to add hot keys to my ASP.net MVC3 application. please give me any ideas on the best way to implement this in MVC?
for eg:
go to home page of my application when Ctrl + Q is used
to log_out when Ctrl + K is used
|
|
|
|
|
JQuery hotkeys is probably the best way to do that, but please don't override common functions like ctrl-Q which the user has an expectation for already. If you change the behavior of that key, users won't like it.
http://plugins.jquery.com/hotkeys/[^]
|
|
|
|
|
hi Jasmine,
thanks you jasmine i am trying whit you idea.
Regards,
jsm
|
|
|
|
|
i have two datatables dt1 and dt2.The first one has 3 columns and the second one has 1 column .i want to merge them together.As of now the join is happeneing top-down way,i want it sideways .
|
|
|
|
|
I posted my real answer on Facebook. However, what you need to do here is go back to basics and learn some SQL. Your question is like, Day 2 of a basic SQL class. I don't even know how to answer it other than to give you the ANSI join syntax, which is freely available on Google. So, I don't understand why you are asking people on here to help you? You need to learn the basics of the language first, so you can ask intelligent questions.
http://www.w3schools.com/sql/[^]
select <columns list>
from <table>
join <table2> on <table.column> <operator> <table.column>
That's tripping you up? Please explain why.
|
|
|
|
|
This worked
var res =(from tb1 in dt1.AsEnumerable()
join tb2 in dt2.AsEnumerable() on tb1["A"] equals tb2["AA"]
Gridview.Datasource = res;
Gridview.DataBind();
anyways thank you
|
|
|
|
|
In your question you did not say you wanted Linq style stuff, didn't even say you were using c#. Look at your answer and your question and ask yourself if it's possible to go from one to the other.
|
|
|
|
|
Anyway i shall strive to frame my question better the next time around,thank you jasmine.i have another question for you.suppose i have the row index of a gridview (that i obtain on clicking the first cell in that row) how do i obtain the value of 3rd cell in that very row.If my question was ambiguous pardon me.
|
|
|
|
|
Keep in mind that I get an email copy of your comments even if you delete them later. I'm just trying to help you get better answers. Whenever you post a question, please read it carefully before posting, to make sure you've given the information needed to answer the question completely.
When working with GridView object, it can be tricky to get values from the data - much better to get those from the underlying dataset itself. But, you can sometimes get it this way...
(because it's zero-indexed, this would be the third cell from the left)
myGridView.Rows[myRowIndex].Cells[2];
The problem is, the object living at that reference is a "TableCell" object, and you'll have to extract the data value out of there somehow. Remember, the GridView is the VISUAL object, not the data object. The best way to find data when the user clicks on a row in a GridView is to use the primary key and go back to the original DataSet which is bound to the control.
|
|
|
|
|
I have a web application. I want to know user doing in this?
And I can save it by session.
Can you tell your opinion?
|
|
|
|
|
Your question is not quite clear. Please rephrase and elaborate on what are you trying to do.
|
|
|
|
|
I want to record all users' activities on websites such as manipulation 1 log file
|
|
|
|
|
Quote: I want to know user doing in this?
And I can save it by session.
What does it mean?
|
|
|
|
|
I want to record all users' activities on websites such as manipulation 1 log file
|
|
|
|
|
So wots problem
Create a database table to store activities
at every operation store the activity along with date time, user, and any other things u require.
|
|
|
|
|
|
|
|
Use FormsAuthentication and then just store whatever you want into the Session.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Thank you!
|
|
|
|
|
No problem.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
How do I clear the server cache in asp.net? I have found out that there are two kinds of cache. There is the browser cache and the server cache. I have done some searching but I have yet to find a clear, step-by-step guide for clearing the server cache using asp.net (or not).
I am working on an ASP.NET c# application that uses a 3rd party CMS. I have reason to believe that a bug I am having must have something to do with the cache on the server side. As an admin of the CMS, I have used some controls that individual users can see but they should not. The customer service has suggested I need to clear the server cache.
I can remote to the server. Do I need to clear the cache from there?
I did a search on google. So far, the only information I have is confirmation that there is such a thing as a cache on the server that differes from the client cache on the browser. The first results from Google are from wikipedia and instruct users of using a url addition to clear the cache on the server. I am not sure if that will work for what I need to do.
I wish I could find some sort of ASP.NET C# sample code that will clear the server cache.
|
|
|
|
|