Is there any .NET or third party utility that can be embedded in the Sql server DB, that we can use to directly send out SMS message to one phone number from the SQL database? note that the phone number is also with the different country codes. I do prefer the way for handling this in the DB
View 9 RepliesI am trying to send a form to a MS SQL DB and I cannot. I created a new DB/table, the form, I added a SQLDataSource control and a button, I configured the SQLDataSource to insert the data but it's not working. Do I need some code-behind in order to work properly? How can I set the button to send the form when it's clicked? I have other issue:My Primary Key is called Student ID and is auto generated and it's also an identity. After I register a new student how can I display his Studend ID. When I click the register button I want to send the form and redirect the user to a page where he can see his ID. How can I do that?
View 9 Repliesi have a registration from which have a field email-id , which user select paid or free (for 15 days) registration . when user registration is going to expire then they get a automatic mail regarding registration. and i also want to send some particular msg to all user ., i want to take all email from data base . i am using asp.net c#
View 2 RepliesI have a Datatable and I want to send it in SqlServer as Parameter in stored procedure.
1. How i send datatable
2. How I use that datetable in sqlserver to read its data.
is it possible to send an automatic email to a certain user through sql express? im using sql express to handle my auction so i need to email the winner when endate =Now.
View 1 RepliesI want to send multivalued parameter to SQLdatasource via gridview control.
My slect query is like
SELECT * FROM FRUITS
WHERE FruitID IN(@FruitIDs)
how can i achieve that?
How can i send a string session array values to dataset? I have a session array where i stored textbox values. nowi want to send these values to dataset. how can i write the code in c# to send these values to dataset? I dnt want to save these values in database.
View 1 RepliesI've sucefully created a method to insert values through EF, but i've a question (maybe, a newbie question).
Should i send the values to be inserted as strings to the DAL, and then i create the object there or should i create the object in View Layer and then send him to DAL?
Example 1 (DAL):
[Code]....
Example 1 (View Layer, on a click button for example):
[Code]....
Or should i receive the strings in DAL like this: public bool NoticiasInsert(string tituloPT, string tituloEN, string descricaoPT, string descricaoEN)
Then i create the object cdcModel.noticias and set the fields there with the strings values.
What do you advice me to do? I know that both ways works, but i'm trying to develope with better patterns (i don't know if this is the exacly word, sorry my bad english)
cdcModel.noticias campos = new cdcModel.noticias();
campos.tituloPT = "a";
campos.tituloEN = "b";
campos.descricaoPT = "a";
campos.descricaoEN = "a";
if (DAL.NoticiasInsert(campos)
Is linq just for retrieving data or can you send data to the database using it?
View 3 Repliesi have an accordion panel that is loading its values from a datasource, which is working fine. let's say it loads the 50 states from the states table. now inside each accordion panel, when expanded, i want to load a gridview with details of that specific state. also, i want to pull all the cities into another gridview from the cities table with stateID=@stateID.
i know this should be simple, but how do i pass the value of the stateID to the datasource of cities gridview? what is the syntax?
the abbreviated code i have so far is:
<cc1:Accordion ID="Accordion1" runat="server" DataSourceID="StatesDataSource" >
<HeaderTemplate >
<asp:Literal ID="ltrHeader" runat="server" Text='<%# Eval("name") %>'></asp:Literal>
</HeaderTemplate>
[Code]....
I know how to send emails, but is it possible to send out text messages?
View 8 RepliesI'm needing to send around 500-2500 emails out at a time to internal email accounts. I'm wondering which was would be faster both for the mail server and for my client app. Should I send multiple emails with just different TO addresses, or just one with multiple BCC addresses? I tried testing this by sending a bunch to my own email and the multiple emails method work, but with the BCC and a single message I only get that single message in my inbox. Shouldn't I be getting as many copies as the number of times I put my address in the BCC line?
View 1 Repliescan i show facebook send dialog at send button click. mainly i want to send some group,page on one send click. so which will be suitable way.
View 1 RepliesI know how to send mail. but i cant send a mail with images inside. also i need to display the repeater control's content inside my mail. Embedded image procedure not works for me. plz provide some sample code or links. i'm looking for C# code.
View 7 RepliesI want to create B'day schedule ...as per birthdate i wnt to send sms ...by using asp.net.......how cna i do ds..?
View 1 Repliesi want to send a Email through outlook using vb.net
View 1 RepliesI am a .net developer. I am developing an application in which i need to send scheduled sms to users mobile number which is stored in database(SQl Server 2008) automatically.
I have already buy sms gateway. How can I do this. Is there any way to call a asp.net page automatically periodically.?
i have problem white Object datasource. i have a multi-tier Application that include common layer ,DAL Layer,business logic and persantation layerwhen i add a object datasource to my page, it bring me only common layer classes . but i want use bisuiness layer classes what do i do ?
View 1 RepliesI have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:
<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%$ ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%$ ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
i am trying to create connection using OLEDB connection in my app. but i am not able to create the connection as in datasource i want to use Server.mappath, but cudn't find the right method to use it. i am trying to make connection with Access database file. following is code i have tried:
string path = Server.MapPath("~/uploadaccess/Production.mdb");
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb")&";";
and also
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path&";");
and tried this
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb"));
and this is the error i am getting:
Operator '&' cannot be applied to operands of type 'string' and 'string'
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
i have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
to use a datasource from within another datasource..?
View 8 RepliesASP.net SQL datasource C# code behind
I want the webpage to show a message that there is no data selected,
Instead of showing blank details view
here is a picture of blank details view:
[URL=http://img28.imageshack.us/i/errorks.jpg/][IMG]http://img28.imageshack.us/img28/4328/errorks.jpg[/IMG][/URL]
What C# code do i need to use so that, whenever I enter that page, only an error message will show up
instead of the details view ..etc.
im explaining this base on a test page that i have hosted as i was trying to track down my problem, i have a hosted page which i have hosted on the internet on a hosting service provider. the page has a normal gridview that is linked to a SqlDataSource. and theSqlDataSource has sql statements for selecting data, updating and deleting. They all work fine locally and even if i host them locally through IIS. but on the hosting service they down work. only the select work, which means i can view my data on the gridview but i cant manipulate it, delete and updating dont wanna work, they dont do anything. and the worse part is that im not even getting an error from them, on the grid i have enabled the autogenerate edit button and the delete, how can i make the update and delete work, or what is it that makes them not to work. the code for my test page is below
[Code]....