Sql delete statement - ASP.NET Discussion Boards

aarif moh shaikh12-Sep-14 20:59

12-Sep-14 20:59

Yes, I am agree with Rechard.

Before making Project see your Interest which you have lots of information about it.. Because less information about your project will not be complete successfully.

IBM DB2 for As400 OLE DB Provider

giocot23-Aug-14 0:55

giocot

23-Aug-14 0:55

Hi to everybody
premised that I am new of this environment (VISUAL Studio/ASP), I was trying to follow the example at http://www.codeproject.com/Articles/794899/Linking-ASP-NET-MVC-with-DB-Table to this page, but I immediately find a problem during the configuration of the connection; the problem is that when I try of "to insert" the "Provider OLE DB" it doesn't pick up me him, in the sense that, in the list it doesn't make me see nothing and if click on data link i receive the message "reference to an object not planned on an object instance"
If I go on component of. NET Framework sees all the elements that begin with DB2 and iDB2 (DB2Command, DB2Connecction... iDB2Command, iDB2COnnection etc. etc.)

can someone point out me as to resolve this problem?
Thanks in advance

Re: IBM DB2 for As400 OLE DB Provider

jkirkerx24-Aug-14 10:32

jkirkerx

24-Aug-14 10:32

I really can't answer your question here, but did you check your firewall or network connection to your database server?
If your computer can't see the server, then Visual Studio won't be able to either.

Is your server discoverable? you may have to check your servers firewall as well.

modified 26-Aug-14 16:46pm.

Moving duplicated 'return View("Index");' statments out of several multi exception catch blocks into a single block of code outside of the try/catch conditions

Stephen Holdorf22-Aug-14 14:49

Stephen Holdorf

22-Aug-14 14:49

This is very hard to explain and probably even more difficult to solve. What I am doing is removing all error logging from the MVC controllers into a single log statment in the Global.asax Application_Error event. This is the problem I am faced with. To do this I am using a method like below in a controller I refactored:

try
{

tg.updateUpproverDetails(app.RequestID, reg["RoleId"], reg["ServiceId"], reg["RegionId"], reg["MTFSiteName"]);

ViewBag.RegionId = new SelectList(uRegions, "RegionID", "RegionName", reg["RegionId"]);

ViewBag.ServiceId = new SelectList(uServices, "MTFServiceID", "MTFServiceName", reg["ServiceId"]);
ViewBag.RoleId = new SelectList(uRoles, "ABACUSUserRoleID", "UserRole", reg["RoleId"]);

List<string> mtflist = new List<string>();

string[] yu = reg["MTFSiteName"].Split(',');

if (yu != null)
{
foreach (var x in yu.ToList<string>())
{
mtflist.Add(x);
}
}

ViewBag.MtfId = new MultiSelectList(uMtfs, "MTFSiteID", "MTFSiteName", mtflist);

return View(app);

}
catch (Exception e)
{
e.Data["ErrorMsg"] = "General Unhandled Exception";
e.Data["Location"] = "UpdateUpproverDetails procedure in AdminController";

if (e is DataException)
{
e.Data["ErrorMsg"] = "Data Exception";
e.Data["Location"] = "UpdateUpproverDetails procedure in AdminController";
}
else if (e is NullReferenceException)
{
e.Data["ErrorMsg"] = "Null Reference Exception";
e.Data["Location"] = "UpdateUpproverDetails procedure in AdminController";
}
throw e;
}

As you can see if no exceptions occur then the 'return View(app);' does it post and displays ther view. If however; there is an except it is trapped in a single catch block and re-thrown to the Global.asax Application_Error event for loggin. Now this works.

Now for the problem controller's try/catch block. Below is the following code:

try
{
response = client.GetAsync("Registration?user=" + Username).Result;

responseBodyAsText = response.Content.ReadAsStringAsync().Result;

if (responseBodyAsText.Equals("true"))
{
usercred.Newpassword = "";
usercred.Currentpassword = Password;
usercred.Username = Username;

return View("Change", usercred);

}

else
{

/////LOGIN USER
string passurl = System.Web.HttpUtility.UrlEncode(Password);
response = client.GetAsync("Registration?username=" + Username + "&password=" + passurl + "&edi=" + "" + "&isEdi=" + false).Result;
responseBodyAsText = response.Content.ReadAsStringAsync().Result;
statuses = JObject.Parse(responseBodyAsText);

DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(UserCred));

using (var ms = new MemoryStream(Encoding.Unicode.GetBytes(statuses.ToString())))
{
usercred = (UserCred)serializer.ReadObject(ms);
}

}

}
catch (ArgumentOutOfRangeException e)
{
ViewBag.result = "NotAuthenticated";
log.Info("The size specified is less than or equal to zero. Login/Password for user failed " + e.ToString());
return View("Index");
}

catch (ObjectDisposedException e)
{
ViewBag.result = "NotAuthenticated";
log.Info("The current instance has been disposed. Login/Password for user failed " + e.ToString());
return View("Index");
}

catch (InvalidOperationException e)
{
ViewBag.result = "NotAuthenticated";
log.Info("An operation has already been started on the current instance. Login/Password for user failed " + e.ToString());
return View("Index");
}

catch (ArgumentNullException e)
{
ViewBag.result = "NotAuthenticated";
log.Info("Login/Password for user failed " + e.ToString());
return View("Index");
}
catch (Exception e)
{
ViewBag.result = "NotAuthenticated";
log.Info("Login/Password for user failed " + e.ToString());
throw;
}
}

Session["userData"] = usercred;
Session.Add("Authenticated", "True");

return RedirectToAction("Index", "Home", usercred);

}

Here you can see that in each catch statment the logging is done, not in the Application_Error event, but in the catch statment itself. Also in each catch statment a specific 'return View("Index");' is called and a return RedirectToAction("Index, "Home") is called at the bottom.

I tried the following and the exception is never thrown. Can anyone help?

catch (Exception e)
{
ViewBag.result = "NotAuthenticated";

return View("Index")

throw e;
}

Session["userData"] = usercred;
Session.Add("Authenticated", "True");

return RedirectToAction("Index", "Home", usercred);

}

}

Re: Moving duplicated 'return View("Index");' statments out of several multi exception catch blocks into a single block of code outside of the try/catch conditions

onelopez22-Aug-14 16:21

onelopez

22-Aug-14 16:21

The problem is in the order of your code

catch (Exception e)
{
ViewBag.result = "NotAuthenticated";
 
return View("Index"); // This terminates the current method
 
throw e; // Therefore, this never occurs
}

Change to this: (for testing purposes only)

catch (Exception e)
{
ViewBag.result = "NotAuthenticated";

throw e; // Throw it
 
return View("Index"); // This piece will not execute.

}

One on one chat application

Otekpo Emmanuel21-Aug-14 22:39

Otekpo Emmanuel

21-Aug-14 22:39

Hello everybody, how is the day going? I was over looking this to be a simple task but after involving my self, i found is not easy. I'm working on chat application and I'm done with the group chat. Now I want to implement private chat between two particular users. That is, John and Patel can chat privately in the private chat window and this is where am stuck. I need the technique to achieve this. I am not using signalR either ling to sql. Am using stored procedure. Any way to play around this please e.g sample code, steps, or videos.

Re: One on one chat application

Anurag Gandhi22-Aug-14 3:32

Anurag Gandhi

22-Aug-14 3:32

Why you don't want to use SignalR? I think it is the good fit for your need. You may get sample application also on internet.
Otherwise, you may consider the older approach like long polling but you may need to do some hard work for it.

Life is a computer program and everyone is the programmer of his own life.

Sql delete statement

Otekpo Emmanuel21-Aug-14 5:20

Otekpo Emmanuel

21-Aug-14 5:20

Good day everybody! Please, I need your help in this stuff. How can i reset the id column in sql database which has auto increment property, to restart from 1 after hitting the delete button using asp.net and vb as code behind. I used the truncate statement but I didn't like this idea because everything was deleted. I specified the number of records to be deleted using the top statement with the delete statement.

Re: Sql delete statement

ZurdoDev21-Aug-14 7:36

ZurdoDev

21-Aug-14 7:36

This is a repost and you were answered on how to do it.

However, this sounds like an absolute terrible idea. You say you just deleted some records and now want to reseed the identity field? Bad, bad idea. Do not do it.

There are only 10 types of people in the world, those who understand binary and those who don't.

Re: Sql delete statement

Anurag Gandhi22-Aug-14 3:35

Anurag Gandhi

22-Aug-14 3:35

First of all, it is Asp.Net forum. You should post your question to the right forum.
Secondly, it is not a good idea to reset identity column in a live application. Consider using Guid instead of Identity column.

Life is a computer program and everyone is the programmer of his own life.

Sql delete statement

Otekpo Emmanuel21-Aug-14 4:16

Otekpo Emmanuel

21-Aug-14 4:16

Good day everybody! Please, I need your help in this stuff. How can i reset the id column in sql database which has auto increment, to restart from 1 after hitting the delete button using asp.net and vb as code behind. I used th truncate statement but I didn't like this idea because I specified the number of records to be deleted using the top statement.

Re: Sql delete statement

Richard Deeming21-Aug-14 4:20

Richard Deeming

21-Aug-14 4:20

Use DBCC CHECKIDENT('table-name', RESEED, 1).
http://msdn.microsoft.com/en-gb/library/ms176057.aspx[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Sql delete statement

PIEBALDconsult21-Aug-14 4:23

PIEBALDconsult

21-Aug-14 4:23

If you feel the need to do that, then maybe you don't understand IDs.

Issues on the IIS Deployment on an ASP.NET 4.5

Vimalsoft(Pty) Ltd21-Aug-14 1:43

Vimalsoft(Pty) Ltd

21-Aug-14 1:43

Good Day All

i have an asp.net 4.5 application. i have hosted it on IIS 7.5 in Windows Server 2008. My application has different folders within it and some are for JS and some are for CSS and etc.. and they are inside a directory named "Shared" in my problem and most of the things especially the css , images etc they are reference like this

<link href="../Shared/assets/css/bootstrap.css" rel="stylesheet"/>

HTML

<link rel="apple-touch-icon" sizes="57x57" href="../Shared/assets/ico/apple-touch-icon-57x57.png">

now when i host this Project i have issues with CSS and images because they are not retrieved. i use Fiddler to check what is happening and i realised that after i hosted the application now Fiddler reports a 404 error on the following path

http://myiisreserver/Shared/assets/css/bootstrap.css

there are many of them , this is just an Example. now you can see it it can see the server , but instead of adding my Application or website name , it add the Directory within my application. So basically it should look like this

http://myiisreserver/MyWebapplication/Shared/assets/css/bootstrap.css

What could be the Problem.

Thanks

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa[at]dotnetfunda.com
http://www.Dotnetfunda.com

Re: Issues on the IIS Deployment on an ASP.NET 4.5

ZurdoDev21-Aug-14 8:04

ZurdoDev

21-Aug-14 8:04

The problem is you are using relative urls by using the ../ notation and now that you have deployed it your root appears to be different. You may just have IIS setup wrong as far as what an application is or you may need to change your links.

There are only 10 types of people in the world, those who understand binary and those who don't.

Re: Issues on the IIS Deployment on an ASP.NET 4.5

jkirkerx21-Aug-14 9:30

jkirkerx

21-Aug-14 9:30

The double dots means go back 1 folder level

So if your root is /
and your calling webpage is /about/default.aspx then the double dots apply ../images/header.jpg

If your root is /
and your calling webpage is /default.aspx, the the double dots don't apply /images/header.jpg

Best thing is to take out the dots, and test, to make sure it has nothing to do with the dots first, like the previous post says, confirm your web server is setup right. Then think about the dots when your web app works.

In my beginning, I didn't use the dots, but started using the dots after running test on them and seeing how they actually work.

[EDIT]

Here is some information on the history or use of the double dots so that you can better understand the meaning in various operating systems and URL's
http://en.wikipedia.org/wiki/Path_%28computing%29[^]

This Link is pretty good here
http://teaching.idallen.com/cst8207/12f/notes/160_pathnames.html[^]

I think this one fits the bill here
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005700000009000000.htm[^]

modified 21-Aug-14 15:47pm.

Re: Issues on the IIS Deployment on an ASP.NET 4.5

Vimalsoft(Pty) Ltd21-Aug-14 9:38

Vimalsoft(Pty) Ltd

21-Aug-14 9:38

Thanks for your reply . the funny thing is that i hosted this same deployment in the Paid Domain and it works, So now what i did i created another website in IIS at the Level of "Default" website and i change the Default website port to 8083 so it does not conflict with my other website and i changed the new website to use port 80 and run the site with the ../share path and it worked. it buffles me.

When i used Fiddler , i see it was expecting my website to be in wwwroot folder but when i setup the web application in IIS the virtual Directory was in another drive. so i moved also the files to wwwroot.

Thanks again

Re: Issues on the IIS Deployment on an ASP.NET 4.5

jkirkerx21-Aug-14 10:03

jkirkerx

21-Aug-14 10:03

When I encode a website or web application, I always assume that the root of the project is /
So everything is based off of /

Not sure if I can offer any help or insight on this, I went through that a decade ago, and have always used a systematic way of setting up servers and projects since then.

When I setup a website in IIS, I don't use the default IIS folder, I set everything up on a drive letter like Z
Z:\internet
We use an independent disk drive for websites, which is solid state.

In IIS, We set the Physical Path to let's say
Z:\internet\artisan-plaster.com
Z:\internet\website.com
Right Click website-> Manage Website -> Advanced Settings -> Physical Path

And then run our power shell or just cmd security scripts to that individual physical locations above to set IIS Anonymous and App Pool security for the folders in the project, and RW/RO folder attributes.

Re: Issues on the IIS Deployment on an ASP.NET 4.5

Vimalsoft(Pty) Ltd21-Aug-14 10:27

Vimalsoft(Pty) Ltd

21-Aug-14 10:27

Its ok , everyone needs help at some point. for now my issue is resolved

Thanks

String compare

byka20-Aug-14 8:01

byka

20-Aug-14 8:01

Could you help me.. I need function to compare 2 string and print (show) the difference between 2

Re: String compare

Richard Deeming20-Aug-14 9:14

Richard Deeming

20-Aug-14 9:14

Have a look at DiffPlex[^].

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: String compare

Snehasish_Nandy21-Aug-14 0:57

Snehasish_Nandy

21-Aug-14 0:57

http://www.mathertel.de/Diff/[^]

Re: String compare

Sibeesh KV29-Sep-14 1:29

Sibeesh KV

29-Sep-14 1:29

There are lot of techniques , please read here : http://stackoverflow.com/questions/208094/how-to-find-difference-between-two-strings[^]

Please up vote if it helped you Smile | :)

Thanks And Regards
Sibeesh

asp.net ValidatorCalloutExtender unhandled exception error

murali_utr20-Aug-14 3:00

murali_utr

20-Aug-14 3:00

XML

Unhandled exception at line 79, column 1 in http://localhost:49456/about_us.aspx?_TSM_HiddenField_=ToolkitScriptManager_HiddenField&_TSM_CombinedScripts_=;;AjaxControlToolkit,+Version=1.0.20229.20821,+Culture=neutral,+PublicKeyToken=28f01b0e84b6d53e:en-US:c5c982cc-4942-4683-9b48-c2c58277700f:e2e86ef9:9ea3f0e2:9e8e87e9:1df13a87:4c9865be:ba594826:757f92c2

0x800a139e - JavaScript runtime error: Sys.ArgumentNullException: Value cannot be null.


above error occured for the following code

<td style="text-align:left" class="content">
<asp:TextBox ID="txtName" Width="225px" AutoPostBack ="true" runat="server"
ValidationGroup="valEnquiry" CausesValidation="True" TabIndex="1"></asp:TextBox>
<br />
<asp:RequiredFieldValidator ID="RFName" runat="server" ValidationGroup="valEnquiry" ControlToValidate="txtName" ErrorMessage="Please Enter Your Name" ForeColor="Red"></asp:RequiredFieldValidator>
<cc1:ValidatorCalloutExtender
ID="val_reqDTT"
runat="server"
TargetControlID="RFName">
</cc1:ValidatorCalloutExtender>
</td>

Have A Nice Day!
Murali.M

Blog

Re: asp.net ValidatorCalloutExtender unhandled exception error

Richard MacCutchan20-Aug-14 3:11

Richard MacCutchan

20-Aug-14 3:11

The message is telling you where the error occurs, and what type of error it was. However we cannot guess what your Javascript code is trying to do.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.